My Oracle Support Banner

ECA: Contract Amendment Process CA_CHG_CTRL ABENDED at Step CA_CHG_CTRL.ZeroAmt.Step02 (Doc ID 2594421.1)

Last updated on NOVEMBER 17, 2019

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

When Performing Contract Amendments, the following error is received

-- 13:42:25.788 ...(CA_CHG_CTRL.ZeroAmt.Step02) (SQL)
INSERT INTO PS_CA_BP_SCHEDULE (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, DONE_FLAG, EFFDT_USED) SELECT DISTINCT
A.CONTRACT_NUM, A.CONTRACT_LINE_NUM, A.BILL_PLAN_ID, A.BPLAN_LN_NBR,
A.EVENT_OCCURRENCE, A.DST_USE, A.DST_SEQ_NUM, A.SEQ_NUM, CHG_ORD_ID,
A.CA_PERCENTAGE, ROUND(((((10406.51) / ( 10406.51))) * ( 1)), :1),
A.CURRENCY_CD, 'N', A.EFFDT_USED FROM PS_CA_CH_BPS_TAO A WHERE
(A.PROCESS_INSTANCE = 9754361 AND A.CONTRACT_NUM = 'XXXXX' AND
A.CONTRACT_LINE_NUM = 0 AND A.BILL_PLAN_ID = 'B108' AND A.BPLAN_LN_NBR = 1
AND A.EVENT_OCCURRENCE = 1 AND A.DST_USE = 'REV' AND A.DST_SEQ_NUM = 0 AND
A.SEQ_NUM = 0 AND A.CHG_ORD_ID = '0000000040') AND A.CURRENCY_CD = :2
/
-- 13:42:25.828 Process 9754361 ABENDED at Step CA_CHG_CTRL.ZeroAmt.Step02 (Action SQL) -- RC = 805
ROLLBACK
/
-- 13:42:25.842 SQL Error: ORA-00001: unique constraint (SYSADM.PS_CA_BP_SCHEDULE) violated

Replication Steps:

1. Create a Contract and add a rate based contract line.
2. Add non inclusive prepaids let say for the purchase amount of $1000. Associate Milestone bill plan to this prepaid line and process it all the way through billing
3. Amend the contract again and make the purchase amount to 0. Process the amendment.
5. Amend the contract and make the purchase amount to $50. Process the amendment.
6. Amend the contract and make the purchase amount to 0. Process the amendment.
7. Amend the contract and make the purchase amount to $50. Process the amendment.
8. The Contract Amendment CA_CHG_CTRL fails with the above abend.
 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.