ECA - If A Prepaid Amount is Amended Repeatedly, There May Be A Rounding Error In The Amount In CA_BP_XREF That Is Sent To Billing

(Doc ID 2390153.1)

Last updated on APRIL 23, 2018

Applies to:

PeopleSoft Enterprise FIN Contracts - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

After a prepaid has several amendments to change the amount, an incorrect amount will be generated in the CA_BP_XREF table and therefore CA_BI_INTFC will send the wrong amount to Billing.


The issue can be reproduced at will with the following steps:

  1. Add a contract with a rate-based line and an as-incurred billing plan. Assign a PC BU/Project/Activity to the contract line
  2. Create a prepaid for 5,000.00 for the contract with an immediate bill plan. Complete amount allocation and activate the contract.
  3. Run CA_BI_INTFC for Other Billing Methods to bill the prepaid. Complete the billing cycle.
  4. Amend the contract and increase the amount of the prepaid to 7,250.00.
  5. Verify the immediate bill plan is 'In Progress'. Run CA_BI_INTFC for Other Billing Methods and go through the billing cycle.
  6. Amend the contract to reduce the prepaid to 7,104.00.
  7. Run CA_BI_INTFC for Other Billing Methods and complete the billing cycle.
  8. Amend the contract to reduce the prepaid to 7,000.00.
  9. Run CA_BI_INTFC for Other Billing Methods and complete the billing cycle.
  10. Amend the contract to reduce the prepaid to 6,500.00.
  11. Run CA_BI_INTFC for Other Billing Methods. This time, CA_BI_INTFC sent -499.99 to Billing when it should have sent -500.00




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