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 SEPTEMBER 06, 2017

Applies to:

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

Symptoms

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.

Changes

 Upgrade to R12 and use the payload created for R11

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