My Oracle Support Banner

Failed Patch Error PLS-00394: "Wrong Number Of Values In The INTO List Of A FET" (Doc ID 2705070.1)

Last updated on AUGUST 29, 2020

Applies to:

Oracle Advanced Pricing - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

After application of <Patch 31170816> :R12.QP.C , find object QP_MODIFIERS_ISETUP_IMP is invalid and
upon trying to recompile, the following error occurs.

ERROR

Errors for PACKAGE BODY QP_MODIFIERS_ISETUP_IMP

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


STEPS
The issue can be reproduced at will with the following steps:
1. compile PACKAGE BODY QP_MODIFIERS_ISETUP_IMP


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
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.