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

Last updated on AUGUST 24, 2016

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.

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