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.
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.
On : 9.2 version, Billing
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.
Expectation is to send unit price of 388.2985 ( 335 * 1.1591 ) rather than 388.3.
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.
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