APXINWKB Funds Check on Payables Invoice Workbench for a Project Related Invoice Errors with APP-SQLAP-10000: User-Defined Exception occurred in AP_FUNDS_CONTROL_PKG.Funds_Check<-Funds_Check_Processor with parameters (invoice_id = xxxx)
(Doc ID 2653993.1)
Last updated on AUGUST 06, 2023
Applies to:
Oracle Project Costing - Version 12.2.5 and laterInformation in this document applies to any platform.
Symptoms
The users get the below error while performing 'Check Funds' on a Project-related Payables invoice:
APP-SQLAP-10000: User-Defined Exception occurred in
AP_FUNDS_CONTROL_PKG.Funds_Check<-Funds_Check_Processor with parameters (invoice_id = xxxx)
AP_FUNDS_CONTROL_PKG.Funds_Check<-Funds_Check_Processor with parameters (invoice_id = xxxx)
The fnd_log_messages shows the below error details:
pa.plsql.PA_FUNDS_CONTROL_PKG LOG:CREATE_PROJ_ENCUMBRANCE_EVENTS : EXCEPTION ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
pa.plsql.PA_FUNDS_CONTROL_PKG LOG:CREATE_PROJ_ENCUMBRANCE_EVENTS : End ;Value of x_return_code F
pa.plsql.PA_FUNDS_CONTROL_PKG LOG:End of Procedure PA_FUNDS_CONTROL_PKG1.CREATE_PROJ_ENCUMBRANCE_EVENTS
psa.plsql.psavbcxb.psa_bc_xla_pvt.pa_gms_integration_api Error in pa_gms_integration_api
psa.plsql.psavbcxb.psa_bc_xla_pvt.Budgetary_Control Unexpected ErrorUser-Defined Exception
psa.plsql.psavbcxb.psa_bc_xla_pvt.Budgetary_Control ERROR: Unexpected Error in budgetary_control Procedure
pa.plsql.PA_FUNDS_CONTROL_PKG LOG:CREATE_PROJ_ENCUMBRANCE_EVENTS : End ;Value of x_return_code F
pa.plsql.PA_FUNDS_CONTROL_PKG LOG:End of Procedure PA_FUNDS_CONTROL_PKG1.CREATE_PROJ_ENCUMBRANCE_EVENTS
psa.plsql.psavbcxb.psa_bc_xla_pvt.pa_gms_integration_api Error in pa_gms_integration_api
psa.plsql.psavbcxb.psa_bc_xla_pvt.Budgetary_Control Unexpected ErrorUser-Defined Exception
psa.plsql.psavbcxb.psa_bc_xla_pvt.Budgetary_Control ERROR: Unexpected Error in budgetary_control Procedure
STEPS TO REPRODUCE:
1. From a Payables responsibility > Invoices > Create a project related invoice > use 'Funds Check' functionality
2. Get error on the form
Changes
None
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 |