My Oracle Support Banner

PA_GMS_INTEGRATION API Fails With An Undefined Error In Invoice Workbench In Payables (Doc ID 2613112.1)

Last updated on FEBRUARY 27, 2020

Applies to:

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

Symptoms

When performing funds check in the Invoice Workbench in Payables

Form Error -

APP-SQLAPP-100000: User-Defined Exception occurred in AP_FUNDS_CHECK_CONTROL_PKG.Funds_Check<-Funds_Check_Processor<-APXINWKB <- INV_SUM_FOLDER_BLOCK_UTIL with parameters (invoice_id = <invoice_id>) while performing the following operation:

fnd_log_messages shows
LOG: IS_PO_BASED_INVOICE - ExceptionORA-06502: PL/SQL: numeric or value error: character to number conversion error
LOG: IS_PO_BASED_INVOICE - ExceptionORA-06502: PL/SQL: numeric or value error: character to number conversion error
LOG: IS_PO_BASED_INVOICE - ExceptionORA-06502: PL/SQL: numeric or value error: character to number conversion error
LOG: CREATE_AP_PO_RECORD - EXceptionORA-06502: PL/SQL: numeric or value error: character to number conversion error
LOG: CREATE_AP_PO_RECORD - EXceptionORA-06502: PL/SQL: numeric or value error: character to number conversion error
LOG:CREATE_AP_PO_RECORD - EXceptionORA-06502: PL/SQL: numeric or value error: character to number conversion error
LOG: CREATE_BACKING_PO_APVAR_REC - ExceptionORA-06502: PL/SQL: numeric or value error: character to number conversion error
LOG: CREATE_BACKING_PO_APVAR_REC - ExceptionORA-06502: PL/SQL: numeric or value error: character to number conversion error
LOG:CREATE_BACKING_PO_APVAR_REC - ExceptionORA-06502: PL/SQL: numeric or value error: character to number conversion error
LOG: CREATE_PROJ_ENCUMBRANCE_EVENTS : EXCEPTION ORA-06502: PL/SQL: numeric or value error: character to number conversion error
LOG: CREATE_PROJ_ENCUMBRANCE_EVENTS : EXCEPTION ORA-06502: PL/SQL: numeric or value error: character to number conversion error
LOG:CREATE_PROJ_ENCUMBRANCE_EVENTS : EXCEPTION ORA-06502: PL/SQL: numeric or value error: character to number conversion error
Error in pa_gms_integration_api
Unexpected ErrorUser-Defined Exception
ERROR: Unexpected Error in budgetary_control Procedure
PA_GMS_TIEBACK_API Invoked
Invoke PA Tieback API if PA is enabled
l_prepare_stmt -> BEGIN IF PA_BUDGET_FUND_PKG.IS_PA_BC_ENABLED() THEN :1 := 1; END IF; END;
...
Call to Private API PSA_BC_XLA_PVT.Budgetary_control successful
Call PSA_BC_XLA_PUB.Budgetary_Control successl_return_code =l_packet_id =-1
Call PSA_BC_XLA_PUB.Budgetary_Control not successl_return_status =U
APP-SQLAP-10000: User-Defined Exception occurred in

Changes

 

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