Oracle Fusion Cloud/EBS Knowledge Sharing Blog

The Order to Cash flow is the complete process of entering an order into the system (Sales Order), delivery the good(s) (Shipping), and then producing the Invoice for the goods.  O2C Flow: Modules Involved O2C Process Steps Receive Sales Order Book Sales Order Pick Release Ship Confirm Sales Returns Sales Invoice Receipt Reconciliation Book Sales Order : Booking of the Sales order is done through Order Management and as the order progresses, users can track the status of the order. Pick Release : Moving stock from Sub Inventory to Staging Area.  Pick Release finds and releases the order and creates a move order request. The process of transacting move orders creates a reservation against the source sub inventory. Ship Confirm : Moving stock from staging to customer address.  Ship confirm is the process of confirming that items have shipped. Shipping Execution confirms that the delivery lines associated with the delivery have shipped. Sales Returns : if are ...

What is P2P? The Procure to Pay cycle is vital to an organization as in this process the organization buys and receive goods or services from its vendors and makes necessary payments. Procure to Pay refers to recording the journey of transactions from requisitioning and procuring goods and services from suppliers to receiving them at their destination. The supplier invoices are raised for the purchases, and payments are recorded and reconciled against bank statement, concluding the process. Though the Procure to Pay process originates in the Procurement business area, it is an integral and essential part of the payables business function as well. Starting from collating requisitions into the purchase order to the final payment against goods or services procured, both procurement and accounts payables team members have a keen interest in ensuring that every process is well optimized for savings, efficiency and building value. P2P Process: Modules involved Financials: AP, FA, CM, GL ...

I am going to explain about Customer Numbering in this post.  When we create customers in Oracle, system automatically creates the customer number. Customer number is the unique number assigned for each customer when it is created. We can also set our custom sequence for the customer number in Oracle. How to set Customer Numbering for Party, Account and Site levels? Best practice is to have 1XX series for Party, 2XX series for Account and 3XX series for Site. Generally clients have same series across application, we can still have customer numbering generated at LE/Ledger level(this is very unlikely). This can be achieved by selecting determining type while defining document sequence. Clients generally go for same series across application. Task: Manage Document Sequences BILLING_ACCOUNT_NUMBER = Customer Account Number PARTY_SITE_NUMBER = Customer Site Number REGISTRY_ID = Customer Party/Registry Number BILLING_ACCOUNT_SITE_USE_NUM = Site Uses Number How to ove...

Name Description Bad Debt Provision Report Provides information for reviewing bad debt exposure and provisioning based on percent collectible assigned to the customer. Includes transaction number, balance due amount, and bad debt provision amount in the ledger currency. Invoices Posted to Suspense Report Provides a list of all transactions that have revenue amounts posted to suspense accounts as a result of running the Import AutoInvoice process. Includes information on transaction class, customer, transaction date, and transaction amount by business unit. Potential Reconciling Items Report Provides a list of journal items that may potentially post to incorrect general ledger accounts. Includes customer account number, payment number, transaction number, and credit and debit amounts by reporting level, reporting context, accounting date, and balancing segment. Billing His...

Name Description Import Payables Invoices Report Report from the process that creates Payables invoices from invoice data in the open interface tables. Payables Credit Memo Matching Report Lists credit memos and debit memos for suppliers along with the invoices to which the credit memos and debit memos are matched. Payables Invoice Aging Report Lists unpaid invoices according to the specified aging periods. Supplier Balance Aging Report List the unpaid supplier invoices according to the specified aging periods. Payables Invoice Audit by Voucher Number Listing Lists invoices with assigned sequential voucher numbers. Payables Invoice Audit Listing Lists invoices for review and audit based on a specified amount for a given supplier and range of invoice creation dates. Payables Invoice Register Provides de...