My Oracle Support Banner

R12.1.x After Applying Patches Errors for Package Body QP_MODIFIERS_ISETUP_IMP "PLS-00394: wrong number of values in the INTO list of a FETCH statement" (Doc ID 2816002.1)

Last updated on OCTOBER 26, 2021

Applies to:

Oracle Advanced Pricing - Version 12.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Pricing Engine

After application of patches ( <patch 30501426>, <patch 20658570>, <patch 29911248> )
invalid package : QP_MODIFIERS_ISETUP_IMP is shown.

When attempting to manually compile invalid package QP_MODIFIERS_ISETUP_IMP,
the following error is shown.

ERROR

SQL> alter package QP_MODIFIERS_ISETUP_IMP compile body ;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY QP_MODIFIERS_ISETUP_IMP:

LINE/COL ERROR
-------- -----------------------------------------------------------------
640/6 PL/SQL: SQL Statement ignored
640/6 PLS-00394: wrong number of values in the INTO list of a FETCH
  statement


The issue can be reproduced at will with the following steps:
1. Apply patches 30501426, 20658570, 29911248
2. Check for invalid packages
3. Attempt to manually compile invalid package QP_MODIFIERS_ISETUP_IMP


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
References


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