Oracle Receivables provides predefined data for Oracle Subledger Accounting that you can use to integrate the two applications. When you run the Create Accounting program to create draft or final subledger accounting, the program uses the predefined data to determine how to create the accounting. Receivables predefines setup for Subledger Accounting so that the Create Accounting program accepts the default accounting information from AutoAccounting without change. Subledger Accounting transfers the final accounting to Oracle General Ledger.
You can optionally define your own subledger accounting rules to overwrite the default accounts from the accounting events.
Note: You must use an Oracle Receivables responsibility to query predefined data that is associated with the Receivables application.
The following sections describe the data that Receivables predefines in Subledger Accounting:
Oracle Receivables predefines one application in Oracle Subledger Accounting named Receivables. Most of the data that Oracle Receivables predefines for Oracle Subledger Accounting is associated with the Receivables application.
The following table shows the attribute values that Oracle Receivables predefines for the Receivables application. The first column lists the fields and the second column lists the values for each field.
Field | Value |
---|---|
Application Name | Receivables |
Drilldown 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 |
The following table lists the setup information that Oracle Receivables predefines for the event entities.
Application | Entity Name | Description | Gapless Event Processing |
---|---|---|---|
Receivables | Adjustments | Adjustments | No |
Receivables | Bills Receivable | Bills Receivable | No |
Receivables | Receipts | Receipts | No |
Receivables | Transactions | Transactions | No |
Oracle Receivables predefines event classes and event types for each event entity that belongs to the Receivables application.
The following table lists the event classes and event types that Oracle Receivables predefines for the Receivables application.
Entity | Event Class Name |
---|---|
Adjustments | Adjustment |
Bills Receivable | Bills Receivable |
Receipts | Miscellaneous Receipt |
Receipts | Receipt |
Transactions | Chargeback |
Transactions | Credit Memo |
Transactions | Debit Memo |
Transactions | Deposit |
Transactions | Guarantee |
Transactions | Invoice |
Oracle Receivables predefines the following process categories:
Adjustments
Bills Receivable
Miscellaneous Receipts
Standard Receipts
Third Party Merge
Transactions
Accounting event class options define attributes of an event class. Oracle Receivables defines the accounting event class options for each predefined event class.
The following table lists the accounting event class options that Oracle 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 |
Deposit | Transactions | Sales Invoices | AR_TRX_INF_V | Actual |
Guarantee | Transactions | Sales Invoices | AR_TRX_INF_V | Actual |
Invoice | Transactions | Sales Invoices | AR_TRX_INF_V | Actual |
Oracle Receivables predefines sources, source assignments, and accounting attribute assignments for Oracle Subledger Accounting.
You can use the Accounting Methods Builder to review the sources, source assignments, and accounting attribute assignments. You must access the Accounting Methods Builder using an Oracle Receivables responsibility if you want to review the sources, source assignments, and accounting attribute assignments associated with the Receivables application.
Note: You cannot make changes to predefined sources, source assignments, or accounting attribute assignments. However, you can define your own custom sources.
If you choose to define your own journal line types or application accounting definitions, then you can override the default accounting attribute assignments.
Oracle Receivables provides numerous predefined sources. When you use the Sources window to review the predefined sources, you can optionally export the queried sources from the application to a Microsoft Excel spreadsheet.
To export a list of sources:
From an Oracle Receivables responsibility, navigate to the Sources window.
Query the records you want to export.
Place your cursor in the multi-row block that contains the records to be exported.
Choose Export from the File menu.
See: Exporting Records to a File, Oracle Applications User's Guide.
Oracle Receivables predefines journal line types for each predefined event class. Oracle Receivables specifies conditions for the use of each journal line type.
The following table lists the journal line types that Oracle Receivables predefines for the Receivables application.
Event Class | Name | Balance Type | Side |
---|---|---|---|
Adjustment | Adjustment | Actual | Credit |
Adjustment | Adjustment Bills Receivable Endorsement | Actual | Credit |
Adjustment | Adjustment Charge | Actual | Credit |
Adjustment | Adjustment Default Receivable | Actual | Credit |
Adjustment | Adjustment Deferred Tax | Actual | Credit |
Adjustment | Adjustment Charge Non-Recoverable Tax | Actual | Credit |
Adjustment | Adjustment Non-Recoverable Tax | Actual | Credit |
Adjustment | Adjustment Tax | Actual | Credit |
Bills Receivable | Bills Receivable Deferred Tax | Actual | Credit |
Bills Receivable | Bills Receivable Factoring | Actual | Credit |
Bills Receivable | Bills Receivable Receivable | Actual | Credit |
Bills Receivable | Bills Receivable Remittance | Actual | Credit |
Bills Receivable | Bills Receivable Tax | Actual | Credit |
Bills Receivable | Bills Receivable Unpaid | Actual | Credit |
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 Receviable | Actual | Credit |
Credit Memo | Credit Memo Deferred Revenue | Actual | Credit |
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 |
Deposit | Deposit Default Receivable | Actual | Debit |
Deposit | Deposit Offset | Actual | Credit |
Guarantee | Guarantee Default Receivable | Actual | Debit |
Guarantee | Guarantee Revenue | Actual | Credit |
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 |
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 Claim Investigation 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 Non-Recoverable 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 Factored Bills Receivable | 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 Remitted Bills Receivable | 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 Non Recoverable 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 |
Oracle Receivables predefines account derivation rules. When Oracle Subledger Accounting uses the predefined account derivation rules that Oracle Receivables provides, it accepts the default accounting that Oracle Receivables generates using AutoAccounting without change.
You can optionally define your own account derivation rules for an Accounting Flexfield or for a segment. In this case, Oracle Subledger Accounting overrides the default accounts that Oracle Receivables generates, or individual segment values in the default accounts, when it creates the draft or final subledger accounting.
The name account derivation rules that Oracle Receivables predefines for the Receivables application are as follows:
Credit Memo Distribution GL Account
Collection Bank Charges Account
Bills Under Collection Account
Bills Under Discount Account
Collection Bank Account Cash Account
Collection Endorsement Account
Discount Endorsement 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
Oracle Receivables predefines journal lines definitions that group the predefined journal line types and account derivation rules within each of the predefined event types. Oracle Receivables assigns each predefined journal lines definition to all event types within an event class.
The following table lists the journal lines definitions that Oracle Receivables predefines for the Receivables application.
Event Class | Journal Lines Definition Name | Journal Line Types |
---|---|---|
Adjustment | Adjustments - Default Accrual | Adjustment, Adjustment Bills Receivable Endorsement, Adjustment Charge, Adjustment Charge Non-Recoverable Tax, Adjustment Default Receivable, Adjustment Deferred Tax, Adjustment Non-Recoverable Tax, Adjustment Tax |
Bills Receivable | Receivables Bills Journal Lines Definition | Bills Receivable Deferred Tax, Bills Receivable Factoring, Bills Receivable Receivable, Bills Receivable Remittance, Bills Receivable Tax, Bills Receivable Unpaid |
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 Receviable |
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 |
Deposit | Deposits - Default Accrual | Deposit Default Receivable, Deposit Offset |
Guarantee | Guarantees - Default Accrual | Guarantee Default Receivable, Guarantee Revenue |
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 Claim Investigation 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 Non-Recoverable Tax, Receipt Exchange Gain Loss, Receipt Factored Bills Receivable, Receipt Factored Cash, Receipt On Account Application, Receipt Payment Netting Application, Receipt Prepayment Application, Receipt Refund Application, Receipt Remitted Bills Receivable, Receipt Remitted Cash, Receipt Short Term Debt, Receipt Tax, Receipt Unapplied Cash, Receipt Unearned Discount, Receipt Unearned Discount on Non Recoverable Tax, Receipt Unidentified Cash, Receipt Write-Off Application, Unapplied Cash |
Receipt | Receipt - Basis Journal Lines Definition | 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 Claim Investigation Application, 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 Bills Receivable, Receipt Factored Cash, Receipt On Account Application, Receipt Payment Netting Application, Receipt Prepayment Application, Receipt Refund Application, Receipt Remitted Bills Receivable, 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 |
Oracle Receivables predefines the Receivables Default Accrual and the Receivables Default Cash Basis Accounting Definition application accounting definitions.
The following table lists the assignments for the Receivables Default Accrual application accounting definition that Oracle Receivables predefines for the Receivables application.
Event Class Assignments | Event Type Assignments | Create Accounting | Journal Line Definition Assignments |
---|---|---|---|
Adjustment | All | Yes | Adjustments - Default Accrual |
Bills Receivable | All | Yes | Receivables Bills Journal Lines Definition |
Chargeback | All | Yes | Chargebacks - Default Accrual |
Credit Memo | All | Yes | Credit Memos - Default Accrual |
Debit Memo | All | Yes | Debit Memos - Default Accrual |
Deposit | All | Yes | Deposits - Default Accrual |
Guarantee | All | Yes | Guarantees - Default Accrual |
Invoice | All | Yes | Invoices - Default Accrual |
Miscellaneous Receipt | All | Yes | Miscellaneous Receipts |
Receipt | All | Yes | Receipts - Default Accrual |
The following table lists the assignments for the Receivables Default Cash Basis Accounting Definition application accounting definition that Oracle Receivables predefines for the Receivables application.
Event Class Assignments | Event Type Assignments | Create Accounting | Journal Line Definition Assignments |
---|---|---|---|
Adjustment | All | No | |
Bills Receivable | All | No | |
Chargeback | All | No | |
Credit Memo | All | No | |
Debit Memo | All | No | |
Deposit | All | No | |
Guarantee | All | No | |
Invoice | All | No | |
Miscellaneous Receipt | All | Yes | Miscellaneous Receipts |
Receipt | All | Yes | Receipt - Basis Journal Lines Definition |
Oracle Subledger Accounting provides predefined subledger accounting methods that group the predefined application accounting definitions for subledger applications. You can optionally create your own subledger accounting methods.
Oracle Receivables assigns the predefined Receivables Default Accrual application accounting definition to the predefined Standard Accrual subledger accounting method, and the Receivables Default Cash Basis Accounting Definition application accounting definition to the predefined Standard Cash subledger accounting method.
You can assign these subledger accounting methods to your ledgers.