Receipts Fail Create Accounting with Error - Please Update the Accounting Class for This Line for Receipts Reversed After Upgrade (Doc ID 1493772.1)

Last updated on FEBRUARY 21, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Upgraded Miscellaneous Receipts fail to create accounting with this Subledger Accounting program report. Completes with the following error:

The accounting class for line number 5 is invalid. Please update the accounting class for this line.

1. In 11i, MRC was used and the Miscellaneous Receipt was created and data posted
2. Upgrade to R12
3. While in R12, reverse Miscellaneous Receipt
4. Create accounting failing to process reversal event

Error only occurs on 11i Miscellaneous Receipts created before the upgrade to R12

In the primary ledger (ledger_id = 1744) accounting class code for Receivables lines is: RECEIVABLE -> accounting successfully generated
In the MRC ledger (ledger_id = 2225) accounting class code for Receivables lines is: REC -> accounting FAILS (records marked in yellow in the Excel)

This occurs with standard receipts, as well as Miscellaneous Receipts.
Also, this issue can affect more than Gain/Loss Accounts. For example:  For one customer, it affected REV.

Changes

Upgraded to R12 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms