My Oracle Support Banner

PARGDR:PRC: Generate Draft Revenue for a Range of Projects Errors in Log for Working Capital Fund(WCF) Project: Cursor 1: ORA-20001 (Doc ID 3011511.1)

Last updated on OCTOBER 06, 2024

Applies to:

Oracle Project Billing - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

When running PARGDR: PRC: Generate Draft Revenue for a Range of Projects the following errors appear in the log:

Cursor 1: ORA-20001: Exception in get_participation_percent extension : OR
...error during event api processing project.
...
...
PA: Error in main.

 

The Events Summary form displays a Revenue Rejection Reason = No Funding/Hard Limit for each of the events listed.


Steps to reproduce:
1. Create Working Capital Fund (WCF) project and task.
2. Create 2 Intragovernmental Transactions (IGT) orders in the Requesting Agency (RA) $100 and $200 respectively, use the project from step1.
3. Approve and send the order to Servicing Agency (SA).
4. Process the order in SA and associate the project created in step 1.
5. Update the agreement, complete the baseline and funding on both orders from step 2.
6. Push both orders from SA to RA.
7. Now the 2 IGT orders are in an open status.
8. Add cost to the project created in step 1.
9. Interface the cost to Projects if a Payable invoice is used.
10. Run PRC: Generate Draft Revenue for a Range of Projects.

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.