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.

Note: 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:

1. Navigate to the Manage Subledger Transaction Objects page.

2. Select a Receivables event class: Adjustment, Bills Receivable, Chargeback, Credit Memo, Debit Memo, Invoice, Miscellaneous Receipt, Receipt.

3. Click the View Source Assignments button.

4. 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.