Oracle Subledger Accounting is an intermediate step in the accounting flow between subledger applications, such as Oracle US Federal Financials, Oracle Payables, and Oracle General Ledger. Subledger Accounting stores a complete and balanced subledger journal entry in a common data model for each business event that requires accounting.
Subledger Accounting uses the predefined data that Oracle US Federal Financials provides for setting up accounting in Federal Financials. The Create Accounting process in Subledger Accounting accepts the default accounting information without change and transfers the final accounting to General Ledger.
To ensure that Subledger Accounting creates accurate accounting entries for each business event, you must complete several tasks.
Mark the budget fiscal year (BFY) accounting flexfield segment in the Federal Financial Options window. The segment has a value set containing values for fiscal years. Ensure that you map these values to the year values of General Ledger periods. Subledger Accounting uses this setup as a source while creating accounting entries.
Select one account in the Define USSGL Accounts window as Anticipated Account. Additionally, ensure that the chart of accounts contains a natural account value that is identical to this account value. You must mark the natural account as a parent account and setup one summary account that contains this parent natural account. The summary account should be selected in the Federal Financial Options window.
Assign transaction types, receipt methods and receivable activities to transaction categories in the Transactions Category Mapping window. Subledger Accounting uses this setup as a source while creating accounting entries.
Set up the following in Oracle Payables:
While setting up the payables options, ensure that you select Prorate Expense for the Discount Method option. Payables automatically prorates any discounts across all the invoice distributions. Payables assigns the discount to the charge account unless the invoice is matched to a purchase order with Accrue on Receipt enabled, in which case it is assigned to the price variance account.
Enable the Prorate Across Overdue Invoice option. When you enable this option, Payables uses the natural (charge) account from the account you enter here when it builds expense accounts for an interest invoice.
Set up the following in Oracle Cost Management:
While setting up the purchasing options, set the Accrue Expense Items and Accrue Inventory Items option to At Receipt. This sets the Accrue on Receipt flag for the purchase order shipment, which ensures that the purchase order is liquidated by a receipt. If you want the purchase order to be liquidated by an invoice, then you must uncheck this flag.
Set up the following in Oracle Receivables:
Define transaction types, receipt methods and receivable activities that will be mapped to transaction categories in the Transactions Category Mapping window.
Related Topics
Entering the Budget Fiscal Year
Setting Up Payables Options
Defining USSGL Accounts
Setting up Purchasing Options
Recording an Invoice
Define Transaction Types
To define transactions category mapping, navigate to the Transactions Category Mapping window.
The following table describes selected fields on the Transactions Category Mapping window.
| Field Name | Description |
|---|---|
| Attribute Type | Attribute type mapped to transaction categories.
Note: Attribute types include Receipt Method, Receivable Activity and Transaction Type. |
| Operating Unit | Operating unit of the record.
Note: The list of values includes operating units assigned to the MO: Security profile. This field is disabled for attribute type of receipt method. |
| Receipt Method | Receivables receipt method.
Note: This field is displayed only when Attribute Type is Receipt Method Predefined Subledger Account Setup for Receipt and Miscellaneous Receipt event classes refers to the Mapping of Receipt Method to the following Transaction Categories:
|
| Receivable Activity | Receivables receivable activity
Note: This field is displayed only when Attribute Type is Receivable Activity
|
| Transaction Type | Receivables transaction type
Note: This field is displayed only when Attribute Type is Transaction Type Predefined Subledger Account Setup for Debit Memo, Credit Memo and Invoice event classes refers to the Mapping of Receivable Activity to the following Transaction Categories:
|
| Transaction Category | Transaction category used in Subledger Accounting sources. |