My Oracle Support Banner

G-Invoicing: Order Modifications Are Not Integrating Into Oracle When the 'PA: Enable Budget Integration and Budgetary Control Feature’ Profile Options Is Set to True. (Doc ID 3050856.1)

Last updated on OCTOBER 01, 2024

Applies to:

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

Symptoms

The customer is currently unable to integrate modifications from G-Invoicing into Oracle when the purpose of the modification is to add a new schedule.  After modifying an order to add a new schedule and then executing the concurrent request in Oracle to integrate the modification, the modification does not integrate into Oracle and triggers the following errors:

User-Defined Exception Error encountered while autocreating IGT Order or Modification.
Warning: Your Budgetary Control action completed with exceptions. Please run check funds action to view the errors.



Steps to Reproduce

-----------------------

1. In G-Invoice an order is created
2. Interfacing Initial Order into Oracle > program Intergovernmental Order Interface Program is triggered
3. In E Business Suites (EBS) the order is created
4. In G-Invoicing > Modify Order to Add New Schedule
5. Attempt to Pull Modification into Oracle by running the Intergovernmental Order Interface Program
6. Error occurs with the above errors


The fnd_log_messages shows:

 

pa_gms_integration_api invoked
Invoke PA Integration API if PA is enabled
 l_partial_resv_flag -> Y
 Statement prepared -> BEGIN IF PA_BUDGET_FUND_PKG.IS_PA_BC_ENABLED() THEN :1 := 1; END IF; END;
 l_pa_enabled -> 1
"LOG:CREATE_PROJ_ENCUMBRANCE_EVENTS : EXCEPTION ORA-06503: PL/SQL: Function returned without value
ORA-06512: at ""APPS.PA_FC_AUDIT_UTIL"", line 39"
LOG:CREATE_PROJ_ENCUMBRANCE_EVENTS : End ;Value of x_return_code F
LOG:End of Procedure PA_FUNDS_CONTROL_PKG1.CREATE_PROJ_ENCUMBRANCE_EVENTS
Error in pa_gms_integration_api
Unexpected ErrorUser-Defined Exception
ERROR: Unexpected Error in budgetary_control Procedure

 

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.