My Oracle Support Banner

Transactions Workbench: Line Level Balances Are Not Being Correctly Populated for Transactions (Doc ID 1633149.1)

Last updated on SEPTEMBER 07, 2023

Applies to:

Oracle Receivables - Version 12 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.

Symptoms

In R12:

Line level balances are not being correctly populated for transactions.

You are attempting to apply a Receipt to an Invoice and receive the following error:

You cannot  apply more then Original

Reviewed the data for the invoice and found the following:

CT_ID INV_RULE_ID CR_FROM
================================
6068 ARXTWMAI

You are using Line Level Balances.

CTL_ID LINE_TYPE EXT_AMT AMT_ORIG AMT_REM
=================================================
59132 LINE 2000000 2000000 2000000
59134 TAX 200000

As seen above, the amounts are populated only for LINE_TYPE = 'LINE,' but not for LINE_TYPE = 'TAX.'

As a result the receipt is not getting applied to the invoice.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
 Still Have Questions?
References

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