My Oracle Support Banner

GMS: Generate Draft Invoices for a Single Award Errors With Cursor=521 ORA-01086 Savepoint 'AWARD_BILLING_BEGIN' (Doc ID 2883785.1)

Last updated on JULY 19, 2022

Applies to:

Oracle Grants Accounting - Version 12.2.11 and later
Information in this document applies to any platform.

Symptoms

There are unbilled expenditures for one award.  Unable to generate the invoice by running GMS: Generate Draft Invoices for a Single Award.

Log file shows the error.

Calling Get GL-PA Dates and Periods API

 PA-GL API Return Code :

 setting glob vars

 Calling Delete unapproved/unreleased invoices ...
 Calling check spf from paidpr..

 Call Convert APIreturn stat...
.... Before execute update.
.... After execute update.
.... Before execute update.
.... After execute update. cursor=521, ORA-01086: savepoint 'AWARD_BILLING_BEGIN' never established in this s
Event API returns error with the following message:
OK

Leaving paiapi()Error during Draft Invoice Generation. Module paiapi returned failure
Error during Draft Invoice Generation. Module paigop returned failure

Replication steps:

1. > Grants responsibility > Other > Requests > Run.

2. Enter the process name, GMS: Generate Draft Invoices for a Single Award.

3. Submit the process.  Review the log file.

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.