Transaction Workbench Data Issue. The ACCTD_AMOUNT is Not Rounded When Splitting Revenue from Lines Form After Transaction is Posted (Doc ID 1454935.1)

Last updated on MARCH 04, 2014

Applies to:

Oracle Receivables - Version 11.5.10.0 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

Posting Invoice. 

When access Distributions, via the Lines Form, and changing Line from 100 percent to 3 lines of 33.33, 33.33 and 33.34 the ACCTD_AMOUNT values are off by pennies and will not process.

Invoice percentage changed via Distributions form in Lines Table is not rounding correctly.

After Posting Transaction Changed the Accounting for the 1st Revenue Lines with the following steps

Query Invoice
Click on Lines
Click on Line 1
Click on Distributions

Add 4 rows 1 to offset the 1st rows the other 3 to split the amount.

Change CCID and split to 3 rows
33.33   9999.11   16114.57
33.33   9999.11   16114.57
33.34 10002.11   16119.40

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