Transactions Workbench: Invoice Applied to Deposit Created 3 Adjustments Only One Is Used To Calculate The Balance of Invoice

(Doc ID 1584245.1)

Last updated on OCTOBER 05, 2017

Applies to:

Oracle Receivables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
Deposit was a migrated Transaction that was generated prior to the implementation of ccid_change_flag

Symptoms

Invoice that is applied to a Deposit Generates three (3) Adjustments.  Only one (1) is applied to the Invoice Balance.

Steps to Reproduce:
Responsibility: Receivables Manager
Navigation:    

1. Generate Deposit :  Transactions > Transactions
    Enter in Deposit Type Transaction for 1000.00 and Save.
2. Post Transaction to General Ledger.
3. Access Deposit via Transactions > Transactions Form > Query Deposit
    Click on Distributions Button at bottom of Form.
    Change the CCID of the Revenue Line to a new value and Save.
4. Post Transaction to General Ledger.

The deposit will show three (3) Revenue Lines with the changes that were made.

Changes

The following query will show the record details:

From the script above you will see that the ccid_change_flag will have two (2) records with 'N' Value and one (1) record with 'Y' value.
The 'N' Values are what it use to be and the offset accounting Entry and the 'Y' flag will be the current value.

When the invoice is applied to a Deposit that does not have these flags populated, it will generate one (1) adjustment record under the Invoice for each of the Revenue Rows of the Deposit that has either null or 'Y'. 

Since the migrated deposit did not have these flags populated, it generated three (3) rows.

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