PeopleSoft Enterprise Contracts: Credit and Rebill in Billing causing incorrect data in PS_CA_BP_SCHEDULE (Doc ID 662004.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Contracts - Version 8.9 to 9 [Release 8.9 to 9]
Information in this document applies to any platform.
***Checked for relevance on 27-Dec-2013***

Symptoms

Create an amount-based contract with billing plan (method Milestone). Create two events: event 1 for amount 1000 and event 2 for 9000. Set Event 1 to Ready and leave Event 2 on Pending.

Activate the contract. Run CA_BI_INTFC and BIIF001. A bill will be created for 1000 USD. Do a credit and rebill. Open the Rebill Bill and reduce the amount from 1000 to 500 USD. Set the Rebill Bill to Ready. Open the Credit Bill and set this to Ready.

Run Finalization and then run "Update Contract/Projects Data". Open the Billing Plan and add a 3rd event with amount 2000. Change the amount for Event 2 to 7000. Set Event 3 to Ready. Event 2 should remain Pending. Save the page.

Run a query on PS_CA_BP_SCHEDULE. Notice that the amount for Event 3 is 2500 which is incorrect. It should be 2000. On the table PS_CA_BP_EVENTS the amount for Event 3 is 2000 which is correct.

Perhaps this is a regression caused by incident 1693937001. A patch was delivered in FMS ESA 8.9 bundle #20 to make the amounts billed on record PS_CA_BP_XREF be in sync with the amounts on PS_CA_BP_SCHEDULE.

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