My Oracle Support Banner

Error While Funds Check in AP invoice: APP-SQLAP-10000 ORA-06502 (Doc ID 2653993.1)

Last updated on MARCH 30, 2020

Applies to:

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

Goal

Why user get below error while Check Funds on Payables invoice?

     APP-SQLAP-10000: User-Defined Exception occurred in
     AP_FUNDS_CONTROL_PKG.Funds_Check<-Funds_Check_Processor with parameters (invoice_id = xxxx)

Also in the debug file can be seen 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

Solution

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
Goal
Solution


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