R12: AP: Invoice Validation ORA-01403 : no data found AP.PLSQL.AP_APPROVAL_PKG.Batch_Approval Exception: User-Defined Exception

(Doc ID 549630.1)

Last updated on APRIL 18, 2017

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.
APXAPRVL.rdf

Symptoms

Invoice validation ends in error and FND Debug log shows ORA-1403

Here is an example extract from FND Debug log file.


+++++++++++++++++++++++++++++++++++++
ZX.PLSQL.ZX_VALID_INIT_PARAMS_PKG.GET_TAX_SUBSCRIBER Call on-the-fly upgrade since transaction does not exist in repository for trx id: 176973
ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly.BEGIN ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly(+)
ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly p_upg_trx_info_rec.application_id: 200
ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_ap.BEGIN ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_ap(+)
ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_ap Inserting data into zx_lines_det_factors and zx_lines_summary
ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_ap Inserting data into zx_lines and zx_rec_nrec_dist
ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_ap.END ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_ap(+)
ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly x_return_status: S
ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly.END ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly(-)
ZX.PLSQL.ZX_VALID_INIT_PARAMS_PKG.GET_TAX_SUBSCRIBER "Data is expected to be in eBTax repository for this call. Please CHECK your sequence of calls to eBTax ORA-01403 : no data found
ORA-01403 : no data found"
AP.PLSQL.AP_ETAX_SERVICES_PKG.Distribute Handle errors returned by API
AP.PLSQL.AP_ETAX_UTILITY_PKG.Return_Error_Messages Get error message from eTax API
AP.PLSQL.AP_ETAX_UTILITY_PKG.Return_Error_Messages Get error message from stack
fnd.plsql.FND_FILE.PUT_LINE User-Defined Exception
fnd.plsql.FND_FILE.PUT_LINE Exception: User-Defined Exception
AP.PLSQL.AP_APPROVAL_PKG.Batch_Approval Exception: User-Defined Exception
++++++++++++++++++++++++++++++++++++

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms