My Oracle Support Banner

CA_BI_INTFC Abends With Unique Constraint At CA_LIMITS.CheckRRT.RRTSPLIT (Doc ID 1565463.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

The Contracts to Billing process, CA_BI_INTFC, fails with the following error when running for as-incurred project transactions:

Error:
-- 10.07.28 Process 9955191 ABENDED at Step CA_LIMITS.CheckRRT.RRTSPLIT (Action SQL) -- RC = 805
ROLLBACK
/
-- 10.07.28 SQL Error: ORA-00001: unique constraint (SYSADM.PS_CA_BI_PC_TA24) violated


Replication steps: (contracts installation option is set to use split limit)
1. Add a contract with rate price type
2. Associate with a project/activity, assign retainage id and billing limit
3. Add transactions to the project/activity that will add up to over the limit.
4. Process the BIL to billing
5. PC_BI_TO_PC will generate BRT
6. Release the retainage on the bill plan
7. CA_BI_INTFC will process the BRT and try to generate some of the RRT and change the BRT amount that is over the limit to OLT
8. PC_BI_TO_PC will insert some more RRT, BRT, RAJ and OLT rows into proj resource
9. Amend the contract and increase the limit
10. Perform limit checking -- it will change the OLT back to BRT.
11. Run CA_BI_INTFC- abend at Step CA_LIMITS.CheckRRT.RRTSPLIT

 

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.