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