My Oracle Support Banner

R12:AP: Invoice Workflow Approval History Gives APP-SQLAP-10000: ORA-06502: PL/SQL: numeric or value error: (Doc ID 2452499.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Invoice workbench has invoices which are 'Initiated' in approval status.

Click in Reports-> View Invoice Workflow Approval History and the following error appears.

ERROR
-----------------------
APP-SQLAP-10000: ORA-06502: PL/SQL: numeric or value error:
NULL index table key value occurred in
AP_WORKFLOW_PKG.Get_All_Approvers <-APXIAWHS
with parameters (&PARAMETERS)
while performing the following operation:
set variables from workflow

  (OK button)






Changes

 

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


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