My Oracle Support Banner

R12 - Error ORA-20979, ORA-06502 in ‘Validate Payables Invoices’ Request Submitted using ERP Integration Service (submitESSJobRequest method) (Doc ID 2304577.1)

Last updated on OCTOBER 29, 2019

Applies to:

Oracle Fusion Payables Cloud Service - Version and later
Information in this document applies to any platform.


While Submitting ‘Validate Payables Invoices’ Request using ERP Integration Service (submitESSJobRequest method) ends in error:

ERROR:ESS-01708 Database job for request xxxxx ended with error: SQL execution error. JobName: FUSION_RUNTIME.ESS49$JB_xxxxx
--- SQL Execution Error ---
ErrorCode: 20979
ErrorMsg: [ORA-20979: Request xxxxx encountered ERROR: ORA-06502: PL/SQL: numeric or value error: character to number conversion error while executing BEGIN AP_APPROVAL_PKG.INVOKE_BATCH_APPROVAL_ESS(:errbuf, :retcode, :at(1), :at(2), :at(3), :at(4), :at(5), :at(6), :at(7), :at(8), :at(9), :at(10), :at(11), :at(12), :at(13)
xxxxx is the request id number.


 Upgrade to R12 and use the payload created for R11


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

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