Receipts Workbench Issue: Datafix: Receipt Unapplication Leads To FRM-40734: Internal Error PLSQL
Last updated on JANUARY 14, 2016
Applies to:Oracle Receivables - Version 12 and later
Information in this document applies to any platform.
Cash Basis Distributions object contains the primary and secondary object data in the Object . As a
result, user is not able to unapply the receipt application which are upgraded from 11i.
AR_CASH_BASIS_DISTS_ALL - This table stores distribution information for Cash Basis accounting.
Oracle Receivables loads this table when you post to your general ledger. This table
shows the distribution of receipt amounts over the revenue accounts of an invoice. If you do not
specify an invoice line for a receipt, Oracle Receivables first automatically prorates the receipt to
pay off all invoice lines, and then prorates tax, freight, and receivables charges. One record is
created for each distribution.
Reporting Currency Data should be inserted into Object AR_MC_CASH_BASIS_DISTS_ALL (Not AR_CASH_BASIS_DISTS_ALL)
AR_CASH_BASIS_DISTS_ALL Table is having the records of the primary and the secondary ledger as well.
The Reporting Currency Data should be inserted into Object AR_MC_CASH_BASIS_DISTS_ALL (Not AR_CASH_BASIS_DISTS_ALL)
1. Update AMOUNT and ACCTD_AMOUNT to 0 in the AR_CASH_BASIS_DISTS_ALL Table for the secondary ledger record.
2. Update the amount fields in the xla_distributions_links and the xla_ae_lines Tables
Note: That there exists data in ar_mc_cash_basis_dists_all Table for the corresponding
Check the output of the following SQL Statement:
Where receivable_application_id = &l_receivable_application_id;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms