Friday, July 24, 2015

Invoicing Rules

Invoicing and accounting rules let you create invoices that span several accounting periods. 

Accounting rules determine the accounting period or periods in which the revenue distributions for an invoice line are recorded. You can assign a different accounting rule to each invoice line.

Accounting rules of Fixed Duration span a predefined number of periods. Accouning rules of Variable Duration let you define the number of periods during invoice entry.

Invoicing rules determine the accounting period in which the receivable amount is recorded. You can only assign one invoicing rule to an invoice.

Receivables provides the following invoicing rules:
  • Bill In Advance: Use this rule to recognize your receivable immediately 
  • Bill In Arrears: Use this rule if you want to record the receivable at the end of the revenue recognition schedule.
With Cash Basis Accounting, you only recognize revenue when payment is received. Invoices with rules are therefore not applicable for this method of accounting.


You can assign invoicing and accounting rules to transactions that you import into Receivables using AutoInvoice and to invoices that you create manually in the Transactions window.

Tuesday, July 21, 2015

Sub Ledger Accounting

Oracle Subledger Accounting (SLA) is a rule-based accounting engine that centralizes journal entry creation across the E-Business Suite. Acting as an intermediate step between a subledger application (such as Oracle Cash Management or Oracle Accounts Payable), and the Oracle General Ledger, Oracle Subledger Accounting creates journal entries for subledger transactions and transfers them to Oracle General Ledger.

Thursday, July 16, 2015

Cash Management

Oracle Cash Management helps you manage your enterprise liquidity and cash positions.
  • Manage and control your cash cycle
  • Upload and reconcile bank statements
  • Forecast your cash needs
  • Transfer funds between bank accounts
  • Manage Bank, Bank Branch and Bank Account information

Per new Bank Account Model, Banks and Bank Branches are created as Trading Community Architecture (TCA) parties (as opposed to Payables owning them in previous releases). Bank Accounts reside within Cash Management application and we can define in which applications this bank account can be used.

Reconciliation Flow:

Step 1. Receive Bank Statement --&gt Manually or automatically (via Bank Statement Open Interface). Each bank statement can refer to one or more payments, receipts, open interface, misc transactions and consists of one header and multiple bank statement lines. Bank statement line status can be - Reconciled, Unreconciled, Error, External.

Step 2. Load and Verify Bank Statement --> 

Step 3. Perform Reconciliation --> 

Step 4. Review --> 

Step 5. Create JEs and Post to GL

Cash Management and External Systems:

You can include cash flows from external systems using the External Cashflow Open Interface.

Reconciliation Open Interface can find external transactions available for clearing and reconciliation. 

Open interface view --> CE_999_Interface_V