Receipts Workbench Issue: Datafix: Receipt Unapplication Leads To FRM-40734: Internal Error PLSQL (Doc ID 2036782.1)

Last updated on JANUARY 14, 2016

Applies to:

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

Symptoms

Issue:
======
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)

ANALYSIS
=========
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)

Fix Approach
============
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
receivable_application_id.
Check the output of the following SQL Statement:

Select     *
From     ar_mc_cash_basis_dists_all
Where     receivable_application_id  = &l_receivable_application_id;

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