Transactions Workbench: Line Level Balances Are Not Being Correctly Populated for Transactions
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.
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
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.
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