My Oracle Support Banner

EPC9.2: PC_CA_TO_PC Fails with Unique Constraint at the Step PC_CA_TO_PC.30000000.ReadVie (Doc ID 2798350.1)

Last updated on AUGUST 10, 2021

Applies to:

PeopleSoft Enterprise FIN Contracts - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

The PC_CA_TO_PC Fails with Unique Constraint at the step PC_CA_TO_PC.30000000.ReadView.
This step concatenates several fields to populate PS_PC_RES_CA_TAO.RESOURCE_ID_TMP and creates duplicate resource ids.

Duplicates created when concatenating several fields CONTRACT_NUM, CONTRACT_LINE_NUM and EVENT.

Fields Delimited by dash'-' Fields concatenated for RESOURCE_ID_TMP
00006897-4-366-0-R5-1- -REV- >> 0000689743660R51 REV
00006897-43-66-0-R5-1- -REV- >> 0000689743660R51 REV
 

ORA-00001: unique constraint (EMDBO.PS_PC_RES_CA_TAO) violated


Replication Steps:
1. Create a contract.
2. Add 11 amount based lines.
3. Select an existing project and an activity or create new ones to Contract Terms for line 1.
4. Select the same project and activity to Contract Terms for line 11.
5. Add the revenue distribution accounting for all contract lines.
6. Allocate the amount.
7. Assign a milestone billing plan for the line 1 and one for line 11.
8. Add 11 events for the line 1 bill plan.
9. Put event 11 to Ready.
10. Add 11 events for the line 1 bill plan 11.
11. Put the event 1 to Ready.
12. Associate a revenue plan wit line 1 and 11.
13. Create 11 revenue events and put the last one to Ready.
14. Activate the contract.
15. Process fixed amount revenue.
16. Run PC_CA_TO_PC. Process fails at the step PC_CA_TO_PC.30000000.ReadView with Unique Constraint error

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
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.