CA_BI_INTFC is Sending Incorrect Unit Price Value To Billing. This is Causing Inconsistencies On Bill Line With Respect To Gross Extended Amount vs Unit Price * Quantity Because of Rounding Errors.

(Doc ID 2318510.1)

Last updated on NOVEMBER 13, 2017

Applies to:

PeopleSoft Enterprise FIN Contracts - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Billing

ACTUAL BEHAVIOR
---------------
Rounding errors on Bill line where the bill is created from contracts. This occurs where the rate has to be translated into the Billing currency.

Rate from GBP to EUR = 1.1591
PC BU and transaction current is GBP
Contract Currency is EUR
TLX for 7.5 quantity with employee BIL rate = 335 GBP
CA_BI_INTFC is sending BIL row with unit price = 388.3, qty = 7.5 and gross extended amount as 2912.24. But when unit price * qty = 2912.25 which is 1 cent off.


EXPECTED BEHAVIOR
-----------------------
Expectation is to send unit price of 388.2985 ( 335 * 1.1591 ) rather than 388.3.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a Rate based contract line where contract currency is EUR
2. Associate a Project / Activity whose project currency is GBP.
3. Create a TLX for quantity 7.5 MHR. Based on employee bill rate of 335 GBP, the target BIL rows will be created with unit_rate 335 GBP
4. When CA_BI_INTFC is run, BIL rows will be sent to billing with following details
CA_BI_INTFC is sending BIL row with unit price = 388.2985, qty = 7.5 and gross extended amount as 2912.24.

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