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

Last updated on JUNE 27, 2023

Applies to:

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

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