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 JUNE 05, 2024

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.