Skip Headers

Oracle Receivables Reference Guide
Release 12.1
Part Number E13512-04
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Predefined Setup for Oracle Subledger Accounting

Data that Oracle Receivables Predefines for Oracle Subledger Accounting

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:

Applications

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.

Predefined Receivables Application
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

Event Entities

The following table lists the setup information that Oracle Receivables predefines for the event entities.

Predefined 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

Event Classes and Event Types

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.

Predefined Event Classes and Event Types 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

Process Categories

Oracle Receivables predefines the following process categories:

Accounting Event Class Options

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.

Predefined Accounting Event Class Options 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

Sources, Source Assignments, and Accounting Attribute Assignments

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:

  1. From an Oracle Receivables responsibility, navigate to the Sources window.

  2. Query the records you want to export.

  3. Place your cursor in the multi-row block that contains the records to be exported.

  4. Choose Export from the File menu.

See: Exporting Records to a File, Oracle Applications User's Guide.

Journal Line Types

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.

Predefined Journal Line Types 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

Account Derivation Rules

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:

Journal Lines Definitions

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.

Predefined Journal Lines Definitions 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

Application Accounting Definitions

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.

Assignments for the Predefined Receivables Default Accrual Application Accounting Definition
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.

Assignments for the Predefined Receivables Default Cash Basis Accounting Definition Application Accounting Definition
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

Subledger Accounting Methods

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.