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:

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

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