My Oracle Support Banner

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

Last updated on JULY 22, 2020

Applies to:

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


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

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

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

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


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

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