Error On CA_LIMITS.InsPRsc1.InsRows (Doc ID 1560063.1)

Last updated on MARCH 09, 2017

Applies to:

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

Symptoms

On : 9.1 version, CA_LIMIT Process Integration

When attempting to run the process CA_BI, it gets errored out on CA_LIMITS.InsPRsc1.InsRows

ERROR
-----------------------
Process 12985 ABENDED at Step CA_LIMITS.InsPRsc1.InsRows (SQL) -- RC = 805


ENVIRONMENT
---------------
Application & Version: 9.1
Bundle/Patch: 25
Environment: Production

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Create a new Project
2.Create an Activity
3.Create a new 'Government' Contract
4.Add a Fixed Fee Rate based contract line.
5.Go to the Detail tab and go to the Contract Terms page to add Limits and Fee rate
6.link the new project to the contract and associate the BIL_REV Rate Plan (simply generates BIL and REV rows for each ACT cost row posted to the contract line)
7. Go to Billing Plans and assign an As Incurred Billing Plan
8. Go to Revenue Plans and assign an As Incurred Revenue Plan
9. Activate the contract
10. Add an ACT Analysis Type cost transaction to the project
11. Run the PC_WRAPPER (Process Transaction)
12. Run the CA_BI_INTFC


Cause

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 hundreds of Community platforms