Oracle Fusion Cloud/EBS Knowledge Sharing Blog

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...

There are many tables in each module of Oracle Fusion Financials. I have listed here a few important tables for your reference. Accounts Payables AP_INVOICES_ALL contains records for invoices you enter. There is one row for each invoice youenter. An invoice can have one or more invoice distribution lines. AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface. An invoice can have one or more invoice lines. AP_INVOICES_INTERFACE stores header information about invoices that you create or load for import AP_TERMS_B stores header information about payment terms you define. You need one row for each type of terms you use to create scheduled payments for invoices. AP_PAYMENT_SCHEDULES_ALL contains information about scheduled payments for an invoice AP_DISTRIBUTION_SETS_ALL contains information about Distribution Sets you define to distribute invoices automatically. AP_INVOICE_DISTRIBUTIONS_ALL holds the distribut...

A receipt write-off is a receipt activity that cancels a small unapplied amount remaining on a receipt which your organization considers to be immaterial. For ex: For a transaction amount $ 999 customer has sent the payment for $1000. So $1 is in unaplied which customer does not want to get as refund and unapplied. So this can be written off. There are two methods available to create these receipt write-offs: Manual - a write-off is created from the Accounts Receivables Work Area Automatic - A write-off would be automatically created by running the Create Automatic Receipt Write-offs Program. It would look at the approval limits that are assigned to the user of running the process. Setups Setup write off limits at System Options Setup write off limits for user Create Receivable Activity for Receipt Write Off Process Create Transaction $999 Customer paid $1000 –Apply $999 write off $1 Setup write off limits at system options Setup write off limits for user Create Receivables activity fo...