Applying The Latest Version Of apgdfalb.pls From Patch 14496779 Returns The Error 'PLS-00394: wrong number of values in the INTO list of a FETCH statement'

(Doc ID 1496314.1)

Last updated on SEPTEMBER 14, 2017

Applies to:

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

Symptoms

 1) Originally when running the script ap_inv_event_status_code_sel.sql from GDF patch 14195137 and Note 742429.1. It gives the following error:
 
  ERROR at line 1:
  ORA-04063: package body "APPS.AP_ACCTG_DATA_FIX_PKG" has errors
  ORA-06508: PL/SQL: could not find program unit being called:
  "APPS.AP_ACCTG_DATA_FIX_PKG"
  ORA-06512: at line 353

2) When compiling manually the latest versions of apgdfals.pls and apgdfalb.pls from patch 14496779
       patch/115/sql apgdfals.pls  120.0.12010000.16
       patch/115/sql apgdfalb.pls  120.0.12010000.53
 
  The compilation returns error:
 
  SQL> show errors
  Errors for PACKAGE BODY AP_ACCTG_DATA_FIX_PKG:
 
  LINE/COL ERROR
  -------- -----------------------------------------------------------------
  3899/3   PL/SQL: SQL Statement ignored
  3899/3   PLS-00394: wrong number of values in the INTO list of a FETCH statement

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