Unexpected Error When Using the Create Agreement Option on the G-Invoicing Dashboard: java.sql.SQLException: ORA-01086: savepoint 'CREATE_AUTO_AGREEMENT', ORA-06512: at "APPS.PA_IGT_AUTO_AGREEMENT_PVT", line 1053 (Doc ID 2894987.1)

Last updated on NOVEMBER 08, 2022

Applies to:

Symptoms

Unexpected error received when creating agreement from ECC G-Invoicing dashboard after fixing a customer account setup issue:

Steps to Reproduce:

1. Customer account is either not setup in Oracle, or the site is not setup for the customer account for the operating unit (OU).
2. Using the Project Super User responsibility, run the 'Intragovernmental Orders Interface Program' concurrent request to pull the order from G-Invoicing.
3. Order is pulled in, but a rejection message is received stating that the customer doesn’t exist and the agreement is not created.
4. Customer account is either setup, or the site is added to the existing customer for the OU.
5. Using the Project Super User responsibility, open the G-Invoicing dashboard.
6. Select the order, click on the 'Options' and click on 'Create Agreement'.
7. An error page is returned (see above)
8. Run the 'Intragovernmental Orders Interface Program' concurrent request to pull the order from G-Invoicing again and then run the incremental load for ECC, the error message changes to “The term ID is missing”, even though agreement type that was setup for G-Invoicing has been assigned default terms
9. Using the option to create the agreement results in the same error message reported above. The only difference is the error message has changed from missing customer to missing terms id.

Changes

Setup was incorrect

Cause

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