Predefined Receivables Data in Subledger Accounting
Oracle Receivables provides predefined data for Oracle Subledger Accounting that you can use to integrate the two applications.
When you run Create Receivables Accounting, the program accepts the default accounting information from AutoAccounting without change and uses the predefined data to create accounting in the subledger. Subledger Accounting transfers the final accounting to General Ledger.
You can optionally define your own subledger accounting rules to overwrite the default accounts from the accounting events.
Receivables predefines one application in Subledger Accounting named Receivables. Most of the data that Receivables predefines for Subledger Accounting is associated with the Receivables application.
This table shows the attribute values that Receivables predefines for the Receivables application:
Field |
Value |
---|---|
Application Name |
Receivables |
Drill-down Procedure |
AR_DRILLDOWN_PUB_PKG.DRILLDOWN |
Use Security |
Yes |
Policy Function |
XLA_SECURITY_POLICY_PKG.MO_POLICY |
Journal Source |
Receivables |
Third Party Control Account Type |
Customer |
Subject to Validation |
No |
Calculate Reporting Currency Amounts |
Yes |
This table lists the setup information that Receivables predefines for the event entities:
Application |
Entity Name |
Description |
Gapless Event Processing |
---|---|---|---|
Receivables |
Adjustments |
Adjustments |
No |
Receivables |
Receipts |
Receipts |
No |
Receivables |
Transactions |
Transactions |
No |
Receivables predefines process categories for the Receivables application. These process categories are:
-
Adjustments
-
Miscellaneous Receipts
-
Standard Receipts
-
Third Party Merge
-
Transactions
Additional considerations for Receivables predefined data for subledger accounting include:
-
Event Classes and Event Class Options
-
Sources, Source Assignments, and Accounting Attribute Assignments
-
Journal Line Rules
-
Account Rules
-
Journal Entry Rule Set
-
Accounting Method
Event Classes and Event Class Options
Receivables predefines event classes for each event entity that belongs to the Receivables application.
This table lists the event classes that Receivables predefines for the Receivables application:
Entity |
Event Class Name |
---|---|
Adjustments |
Adjustment |
Receipts |
Miscellaneous Receipt |
Receipts |
Receipt |
Transactions |
Chargeback |
Transactions |
Credit Memo |
Transactions |
Debit Memo |
Transactions |
Invoice |
Accounting event class options define attributes of an event class. Receivables defines the accounting event class options for each predefined event class.
This table lists the accounting event class options that Receivables predefines for the Receivables application:
Event Class |
Process Category |
Default Journal Category |
Transaction View |
Balance Types |
---|---|---|---|---|
Adjustment |
Adjustments |
Adjustment |
AR_ADJ_INF_V |
Actual |
Bills Receivable |
Bills Receivable |
Bills Receivable |
AR_TRX_INF_V |
Actual |
Miscellaneous Receipt |
Miscellaneous Receipts |
Misc Receipts |
AR_CR_INF_V |
Actual |
Receipt |
Standard Receipts |
Receipts |
AR_CR_INF_V |
Actual |
Chargeback |
Transactions |
Chargebacks |
AR_TRX_INF_V |
Actual |
Credit Memo |
Transactions |
Credit Memos |
AR_TRX_INF_V |
Actual |
Debit Memo |
Transactions |
Debit Memos |
AR_TRX_INF_V |
Actual |
Invoice |
Transactions |
Sales Invoices |
AR_TRX_INF_V |
Actual |
Sources, Source Assignments, and Accounting Attribute Assignments
Receivables predefines sources, source assignments, and accounting attribute assignments for Subledger Accounting.
You can't make changes to predefined sources, source assignments, or accounting attribute assignments. However, you can define your own sources.
If you choose to define your own journal line rules or accounting methods, you can override the default accounting attribute assignments.
Use the Manage Subledger Transaction Objects task in Oracle Subledger Accounting to retrieve a list of Receivables sources for an event class:
-
Navigate to the Manage Subledger Transaction Objects page.
-
Select a Receivables event class: Adjustment, Bills Receivable, Chargeback, Credit Memo, Debit Memo, Invoice, Miscellaneous Receipt, Receipt.
-
Click the View Source Assignments button.
-
In the View Source Assignments page, review the available sources for the event class.
Journal Line Rules
Receivables predefines journal line rules for each predefined event class. Receivables specifies conditions for the use of each journal line rule.
This table lists the journal line rules that Receivables predefines for the Receivables application:
Event Class |
Name |
Balance Type |
Side |
---|---|---|---|
Adjustment |
Adjustment |
Actual |
Credit |
Adjustment |
Adjustment Charge |
Actual |
Credit |
Adjustment |
Adjustment Default Receivable |
Actual |
Credit |
Adjustment |
Adjustment Deferred Tax |
Actual |
Credit |
Adjustment |
Adjustment Charge Nonrecoverable Tax |
Actual |
Credit |
Adjustment |
Adjustment Nonrecoverable Tax |
Actual |
Credit |
Adjustment |
Adjustment Tax |
Actual |
Credit |
Adjustment |
Adjustment Transaction Creation Date |
Actual |
N/A |
Adjustment |
Adjustment Transaction Created By |
Actual |
N/A |
Adjustment |
Adjustment Transaction Last Updated Date |
Actual |
N/A |
Adjustment |
Adjustment Transaction Last Updated By |
Actual |
N/A |
Chargeback |
Chargeback Default Receivable |
Actual |
Debit |
Chargeback |
Chargeback Revenue |
Actual |
Credit |
Credit Memo |
Credit Memo Default Deferred Tax Application |
Actual |
Credit |
Credit Memo |
Credit Memo Default Application |
Actual |
Credit |
Credit Memo |
Credit Memo Default Tax Application |
Actual |
Credit |
Credit Memo |
Credit Memo Refund Application |
Actual |
Credit |
Credit Memo |
Credit Memo Charges |
Actual |
Credit |
Credit Memo |
Credit Memo Default Receivable |
Actual |
Debit |
Credit Memo |
Credit Memo Default Revenue |
Actual |
Credit |
Credit Memo |
Credit Memo Default Tax |
Actual |
Credit |
Credit Memo |
Credit Memo Rounding |
Actual |
Credit |
Credit Memo |
Credit Memo Unbilled Receivable |
Actual |
Credit |
Credit Memo |
Credit Memo Deferred Revenue |
Actual |
Credit |
Credit Memo |
Credit Memo Product Type |
Actual |
N/A |
Credit Memo |
Credit Memo Transaction Creation Date |
Actual |
N/A |
Credit Memo |
Credit Memo Transaction Created By |
Actual |
N/A |
Credit Memo |
Credit Memo Transaction Last Updated Date |
Actual |
N/A |
Credit Memo |
Credit Memo Transaction Last Updated By |
Actual |
N/A |
Debit Memo |
Debit Memo Charges |
Actual |
Credit |
Debit Memo |
Debit Memo Default Receivable |
Actual |
Debit |
Debit Memo |
Debit Memo Freight |
Actual |
Credit |
Debit Memo |
Debit Memo Revenue |
Actual |
Credit |
Debit Memo |
Debit Memo Rounding |
Actual |
Credit |
Debit Memo |
Debit Memo Tax |
Actual |
Credit |
Debit Memo |
Debit Memo Unbilled Receivable |
Actual |
Debit |
Debit Memo |
Debit Memo Deferred Revenue |
Actual |
Credit |
Debit Memo |
Debit Memo Product Type |
Actual |
N/A |
Debit Memo |
Debit Memo Transaction Creation Date |
Actual |
N/A |
Debit Memo |
Debit Memo Transaction Created By |
Actual |
N/A |
Debit Memo |
Debit Memo Transaction Last Updated Date |
Actual |
N/A |
Debit Memo |
Debit Memo Transaction Last Updated By |
Actual |
N/A |
Invoice |
Invoice Charges |
Actual |
Credit |
Invoice |
Invoice Default Receivable |
Actual |
Debit |
Invoice |
Invoice Freight |
Actual |
Credit |
Invoice |
Invoice Revenue |
Actual |
Credit |
Invoice |
Invoice Rounding |
Actual |
Credit |
Invoice |
Invoice Tax |
Actual |
Credit |
Invoice |
Invoice Unbilled Receivable |
Actual |
Credit |
Invoice |
Invoice Deferred Revenue |
Actual |
Credit |
Invoice |
Invoice Product Type |
Actual |
N/A |
Invoice |
Invoice Transaction Creation Date |
Actual |
N/A |
Invoice |
Invoice Transaction Created By |
Actual |
N/A |
Invoice |
Invoice Transaction Last Updated Date |
Actual |
N/A |
Invoice |
Invoice Transaction Last Updated By |
Actual |
N/A |
Miscellaneous Receipt |
Miscellaneous Receipt Bank Charges |
Actual |
Credit |
Miscellaneous Receipt |
Miscellaneous Receipt Cleared Cash |
Actual |
Credit |
Miscellaneous Receipt |
Miscellaneous Receipt Confirmed Cash |
Actual |
Credit |
Miscellaneous Receipt |
Miscellaneous Receipt Short Term Debt |
Actual |
Credit |
Miscellaneous Receipt |
Miscellaneous Receipt Factored Cash |
Actual |
Credit |
Miscellaneous Receipt |
Miscellaneous Receipt Miscellaneous Cash |
Actual |
Credit |
Miscellaneous Receipt |
Miscellaneous Receipt Remitted Cash |
Actual |
Credit |
Miscellaneous Receipt |
Miscellaneous Receipt Tax |
Actual |
Credit |
Receipt |
Receipt On Account Application |
Actual |
Credit |
Receipt |
Receipt Application to Freight |
Actual |
Credit |
Receipt |
Receipt Application to Revenue |
Actual |
Credit |
Receipt |
Receipt Application to Rounding |
Actual |
Credit |
Receipt |
Receipt Application to Suspense Revenue |
Actual |
Credit |
Receipt |
Receipt Application to Tax |
Actual |
Credit |
Receipt |
Receipt Application to Unbilled Revenue |
Actual |
Credit |
Receipt |
Receipt Application to Earned Revenue |
Actual |
Credit |
Receipt |
Receipt Bank Charges |
Actual |
Credit |
Receipt |
Receipt Cleared Cash |
Actual |
Credit |
Receipt |
Receipt Credit Card Chargeback Application |
Actual |
Credit |
Receipt |
Receipt Chargeback Application |
Actual |
Credit |
Receipt |
Receipt Confirmed Cash |
Actual |
Credit |
Receipt |
Receipt Currency Rounding |
Actual |
Credit |
Receipt |
Receipt Short Term Debt |
Actual |
Credit |
Receipt |
Receipt Default Application |
Actual |
Credit |
Receipt |
Receipt Deferred Tax |
Actual |
Credit |
Receipt |
Receipt Earned Discount |
Actual |
Credit |
Receipt |
Receipt Earned Discount on Freight |
Actual |
Debit |
Receipt |
Receipt Earned Discount Nonrecoverable Tax |
Actual |
Credit |
Receipt |
Receipt Earned Discount on Revenue |
Actual |
Debit |
Receipt |
Receipt Earned Discount on Tax |
Actual |
Debit |
Receipt |
Receipt Exchange Gain |
Actual |
Credit |
Receipt |
Receipt Exchange Gain Loss |
Actual |
Gain/Loss |
Receipt |
Receipt Exchange Loss |
Actual |
Credit |
Receipt |
Receipt Factored Cash |
Actual |
Credit |
Receipt |
Receipt Payment Netting Application |
Actual |
Credit |
Receipt |
Receipt Prepayment Application |
Actual |
Credit |
Receipt |
Receipt Refund Application |
Actual |
Credit |
Receipt |
Receipt Remitted Cash |
Actual |
Credit |
Receipt |
Receipt Tax |
Actual |
Credit |
Receipt |
Receipt Unapplied Cash |
Actual |
Debit |
Receipt |
Unapplied Cash |
Actual |
Debit |
Receipt |
Receipt Unapplied for Gain Loss lines |
Actual |
Debit |
Receipt |
Receipt Unearned Discount |
Actual |
Credit |
Receipt |
Receipt Unearned Discount on Freight |
Actual |
Debit |
Receipt |
Receipt Unearned Discount on Nonrecoverable Tax |
Actual |
Credit |
Receipt |
Receipt Unearned Discount on Revenue |
Actual |
Debit |
Receipt |
Receipt Unearned Discount on Tax |
Actual |
Debit |
Receipt |
Receipt Unidentified Cash |
Actual |
Credit |
Receipt |
Receipt Write-Off Application |
Actual |
Credit |
Receipt |
Receipt Reversed Unapplied for Unidentified Receipt |
Actual |
Debit |
Receipt |
Receipt Reversed Unidentified Balance Line |
Actual |
Debit |
Receipt |
Receipt Unapplied for Unidentified Receipt |
Actual |
Debit |
Receipt |
Receipt Unidentified Balance Line |
Actual |
Debit |
Receipt |
Receipt Unapplied Reversed Cash |
Actual |
Debit |
Receipt |
Receipt Bill To Site Receivable Account |
Actual |
N/A |
Receipt |
Receipt Bill To Site Clearing Account |
Actual |
N/A |
Receipt |
Receipt Bill To Site Freight Account |
Actual |
N/A |
Receipt |
Receipt Bill To Site Revenue Account |
Actual |
N/A |
Receipt |
Receipt Bill To Site Tax Account |
Actual |
N/A |
Receipt |
Receipt Bill To Site Unbilled Receivable |
Actual |
N/A |
Receipt |
Receipt Bill To Site Unearned Account |
Actual |
N/A |
Receipt |
Receipt Creation Date |
Actual |
N/A |
Receipt |
Receipt Created By |
Actual |
N/A |
Receipt |
Receipt Last Updated Date |
Actual |
N/A |
Receipt |
Receipt Last Updated By |
Actual |
N/A |
Account Rules
Receivables predefines account rules. When Subledger Accounting uses the predefined account rules that Receivables provides, it accepts the default accounting that Receivables generates using AutoAccounting without change.
You can optionally define your own account rules for an Accounting Flexfield or for a segment. In this case, Subledger Accounting overrides the default accounts that Receivables generates, or individual segment values in the default accounts, when it creates the draft or final subledger accounting.
The account rules that Receivables predefines for the Receivables application are as follows:
-
Credit Memo Distribution GL Account
-
Collection Bank Charges Account
-
Collection Bank Account Cash Account
-
Collection Bank Factoring Charges Account
-
Distribution GL Account
-
Remit Bank Unapplied Account
-
System Gain GL Account
-
System Loss GL Account
-
Transaction Distribution GL Account
-
Transaction Distribution GL Account with reference
Journal Entry Rule Sets
Receivables predefines journal entry rule sets that group the predefined journal line rules and account rules within each of the predefined event types. Receivables assigns each predefined journal entry rule set to all event types within an event class.
This table lists the journal entry rule sets that Receivables predefines for the Receivables application:
Event Class |
Journal Entry Rule Set Name |
Journal Line Rules |
---|---|---|
Adjustment |
Adjustments - Default Accrual |
Adjustment, Adjustment Charge, Adjustment Charge Nonrecoverable Tax, Adjustment Default Receivable, Adjustment Deferred Tax, Adjustment Nonrecoverable Tax, Adjustment Tax |
Chargeback |
Chargebacks - Default Accrual |
Chargeback Default Receivable, Chargeback Revenue |
Credit Memo |
Credit Memos - Default Accrual |
Credit Memo Charges, Credit Memo Default Application, Credit Memo Default Deferred Tax Application, Credit Memo Default Receivable, Credit Memo Default Revenue, Credit Memo Default Tax, Credit Memo Default Tax Application, Credit Memo Deferred Revenue, Credit Memo Refund Application, Credit Memo Rounding, Credit Memo Unbilled Receivable |
Debit Memo |
Debit Memos - Default Accrual |
Debit Memo Charges, Debit Memo Default Receivable, Debit Memo Deferred Revenue, Debit Memo Freight, Debit Memo Revenue, Debit Memo Rounding, Debit Memo Tax, Debit Memo Unbilled Receivable |
Invoice |
Invoices - Default Accrual |
Invoice Charges, Invoice Default Receivable, Invoice Deferred Revenue, Invoice Freight, Invoice Revenue, Invoice Rounding, Invoice Tax, Invoice Unbilled Receivable |
Miscellaneous Receipt |
Miscellaneous Receipts |
Miscellaneous Receipt Bank Charges, Miscellaneous Receipt Cleared Cash, Miscellaneous Receipt Confirmed Cash, Miscellaneous Receipt Factored Cash, Miscellaneous Receipt Miscellaneous Cash, Miscellaneous Receipt Remitted Cash, Miscellaneous Receipt Short Term Debt, Miscellaneous Receipt Tax |
Receipt |
Receipts - Default Accrual |
Receipt Bank Charges, Receipt Chargeback Application, Receipt Cleared Cash, Receipt Confirmed Cash, Receipt Credit Card Chargeback Application, Receipt Currency Rounding, Receipt Default Application, Receipt Deferred Tax, Receipt Earned Discount, Receipt Earned Discount Nonrecoverable Tax, Receipt Exchange Gain Loss, Receipt Factored Cash, Receipt On Account Application, Receipt Payment Netting Application, Receipt Prepayment Application, Receipt Refund Application, Receipt Remitted Cash, Receipt Short Term Debt, Receipt Tax, Receipt Unapplied Cash, Receipt Unearned Discount, Receipt Unearned Discount on Nonrecoverable Tax, Receipt Unidentified Cash, Receipt Write-Off Application, Unapplied Cash |
Receipt |
Receipt - Basis Journal Entry Rule Set |
Receipt Application to Earned Revenue, Receipt Application to Freight, Receipt Application to Revenue, Receipt Application to Rounding, Receipt Application to Suspense Revenue, Receipt Application to Tax, Receipt Application to Unbilled Revenue, Receipt Bank Charges, Receipt Cleared Cash, Receipt Confirmed Cash, Receipt Currency Rounding, Receipt Earned Discount, Receipt Earned Discount on Freight, Receipt Earned Discount on Revenue, Receipt Earned Discount on Tax, Receipt Exchange Gain Loss, Receipt Factored Cash, Receipt On Account Application, Receipt Payment Netting Application, Receipt Prepayment Application, Receipt Refund Application, Receipt Remitted Cash, Receipt Short Term Debt, Receipt Unapplied Cash, Receipt Unapplied for Gain Loss lines, Receipt Unearned Discount, Receipt Unearned Discount on Freight, Receipt Unearned Discount on Revenue, Receipt Unearned Discount on Tax, Receipt Unidentified Cash, Receipt Write-Off Application, Unapplied Cash |
Accounting Method
Receivables provides the predefined Receivables Default Accrual accounting method.
Subledger Accounting provides the predefined Standard Accrual subledger accounting method that groups the predefined accounting methods for subledger applications. You can optionally create your own subledger accounting method.
Receivables assigns the predefined Receivables Default Accrual accounting method to the predefined Standard Accrual subledger accounting method. You can assign this subledger accounting method to your ledgers.
This table lists the assignments for the Receivables Default Accrual accounting method that Receivables predefines for the Receivables application:
Event Class Assignments |
Event Type Assignments |
Create Accounting |
Journal Entry Rule Set Assignments |
---|---|---|---|
Adjustment |
All |
Yes |
Adjustments - Default Accrual |
Chargeback |
All |
Yes |
Chargebacks - Default Accrual |
Credit Memo |
All |
Yes |
Credit Memos - Default Accrual |
Debit Memo |
All |
Yes |
Debit Memos - Default Accrual |
Invoice |
All |
Yes |
Invoices - Default Accrual |
Miscellaneous Receipt |
All |
Yes |
Miscellaneous Receipts |
Receipt |
All |
Yes |
Receipts - Default Accrual |
You can copy the predefined Receivables Default Accrual accounting method and update the accounting method with new attributes, according to your business requirements.
The following steps provide general guidelines for copying and updating the predefined Receivables Default Accrual accounting method:
-
Create a mapping set for the new attribute values.
-
Create an accounting rule based on the mapping set.
-
Duplicate the predefined journal entry rule set you want and assign the new accounting rule.
-
Duplicate the predefined accounting method assigned to your ledger.
-
In the new accounting method, assign an end date to the applicable predefined journal entry rule set assignment and assign the new journal entry rule set.
-
Activate the new accounting method. This sets the journal entry rule sets to Active.
-
Assign the new accounting method to your ledger.