My Oracle Support Banner

CA_BP_SCHEDULE is Showing Incorrect Amounts When Adding new events That Total To 0. Example: Event Amount of +5000 and -5000 (Doc ID 2396775.1)

Last updated on MAY 17, 2018

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, Functionality

ACTUAL BEHAVIOR
---------------
The CA_BP_SCHEDULE is showing incorrect amounts when adding new events in the following scenario. The prior events and bill plan are in progress status at the time of adding these new events.
 
EXPECTED BEHAVIOR
-----------------------
The CA_BP_SCHEDULE should show correct amounts for all events in the reported scenario.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a Contract. Add 4 amount based contract lines.
2. Do Amount Allocation, Contract line 1 - 4 with amount of $1000, $2000, $3000, $4000
3. Assign a single milestone bill plan to all 4 contract lines.
4. Add 2 events for the bill plan. The first event is $5000 and 2nd event is $5000. Make both the events "Ready"
5. Activate the Contract
6. Run CA_BI_INTFC
7. The Events and Bill Plan will be "In Progress" status
8. Create 2 additional events. One for $-5000 and other for $5000 and save.
9. Review the the CA_BP_SCHEDULE shows incorrect amounts for these new events for "REV" and "UAR.



CONTRACT_NUM,CONTRACT_LINE_NUM,BILL_PLAN_ID,BPLAN_LN_NBR,EVENT_OCCURRENCE,DST_USE,DST_SEQ_NUM,SEQ_NUM,CHG_ID,CA_PERCENTAGE,AMOUNT, CURRENCY_CD
VJTST2 4 B101 4 3 REV 0 0 0 10000 USD
VJTST2 3 B101 3 3 REV 0 0 0 -5000 USD
VJTST2 2 B101 2 3 REV 0 0 0 -5000 USD
VJTST2 1 B101 1 3 REV 0 0 0 -5000 USD
VJTST2 2 B101 2 3 UAR 1 0 0 -5000 USD
VJTST2 4 B101 4 3 UAR 0 0 0 10000 USD
VJTST2 3 B101 3 3 UAR 0 0 0 -5000 USD
VJTST2 1 B101 1 3 UAR 0 0 0 -5000 USD
VJTST2 3 B101 3 4 UAR 0 0 0 5000 USD
VJTST2 4 B101 4 4 UAR 0 0 0 -10000 USD
VJTST2 2 B101 2 4 UAR 1 0 0 5000 USD
VJTST2 1 B101 1 4 UAR 0 0 0 5000 USD
VJTST2 1 B101 1 4 REV 0 0 0 5000 USD
VJTST2 2 B101 2 4 REV 0 0 0 5000 USD
VJTST2 3 B101 3 4 REV 0 0 0 5000 USD
VJTST2 4 B101 4 4 REV 0 0 0 -10000 USD


Should create rows just like the prior events where the amounts are proportionately distributed.

CONTRACT_NUM,CONTRACT_LINE_NUM,BILL_PLAN_ID,BPLAN_LN_NBR,EVENT_OCCURRENCE,DST_USE,DST_SEQ_NUM,SEQ_NUM,CHG_ID,CA_PERCENTAGE,AMOUNT, CURRENCY_CD
VJTST2 4 B101 4 1 REV 0 0 0 2000 USD
VJTST2 1 B101 1 1 UAR 0 0 0 500 USD
VJTST2 2 B101 2 1 REV 0 0 0 1000 USD
VJTST2 1 B101 1 1 REV 0 0 0 500 USD
VJTST2 3 B101 3 1 REV 0 0 0 1500 USD
VJTST2 3 B101 3 1 UAR 0 0 0 1500 USD
VJTST2 4 B101 4 1 UAR 0 0 0 2000 USD
VJTST2 2 B101 2 1 UAR 1 0 0 1000 USD
VJTST2 1 B101 1 2 REV 0 0 0 500 USD
VJTST2 2 B101 2 2 REV 0 0 0 1000 USD
VJTST2 3 B101 3 2 REV 0 0 0 1500 USD
VJTST2 4 B101 4 2 REV 0 0 0 2000 USD
VJTST2 2 B101 2 2 UAR 1 0 0 1000 USD
VJTST2 4 B101 4 2 UAR 0 0 0 2000 USD
VJTST2 3 B101 3 2 UAR 0 0 0 1500 USD
VJTST2 1 B101 1 2 UAR 0 0 0 500 USD


Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.