Error PLS-00394: WRONG NUMBER OF VALUES IN THE INTO LIST OF A FETCH STATEMENT For PACKAGE QP_MODIFIERS_ISETUP_IMP And/Or Package QP_PREQ_PUB (Doc ID 1554755.1)

Last updated on MARCH 14, 2024

Applies to:

Oracle Advanced Pricing - Version 12.1.3 and later
Information in this document applies to any platform.
Patch 16462621
Patch 16590629
QP Invalid objects
QP Invalid packages
Continuous Price Breaks

Symptoms

Errors for PACKAGE BODY QP_MODIFIERS_ISETUP_IMP

ERROR
Error message upon manually compile the package.

PLS-00394: wrong number of values in the INTO list of a FETCH statement

and/or

Errors for PACKAGE BODY QP_PREQ_PUB

ERROR

Error message upon manually compile the package.

LINE/COL ERROR
-------- -----------------------------------------------------------------
2263/11 PL/SQL: Statement ignored
2263/11 PLS-00306: wrong number or types of arguments in call to 'INSERT_LDETS2'
2655/13 PL/SQL: Statement ignored
2655/13 PLS-00306: wrong number or types of arguments in call to 'INSERT_LDETS2'
11389/5 PL/SQL: SQL Statement ignored
11484/7 PL/SQL: ORA-00904: "OLDFREELINE"."SERVICE_PERIOD": invalid identifier
11987/11 PL/SQL: Statement ignored
11988/63 PLS-00364: loop index variable 'FREEGOOD' use is invalid
12019/9 PL/SQL: Statement ignored
12019/51 PLS-00364: loop index variable 'FREEGOOD' use is invalid
12024/9 PL/SQL: Statement ignored
12024/41 PLS-00364: loop index variable 'FREEGOOD' use is invalid
12035/9 PL/SQL: Statement ignored
12035/18 PLS-00364: loop index variable 'FREEGOOD' use is invalid
12172/7 PL/SQL: SQL Statement ignored
12173/46 PL/SQL: ORA-00904: "SERVICE_PERIOD": invalid identifier
12905/5 PL/SQL: SQL Statement ignored
12938/5 PL/SQL: ORA-00904: "SERVICE_PERIOD": invalid identifier
12947/5 PL/SQL: SQL Statement ignored
12997/5 PL/SQL: ORA-00904: "B"."SERVICE_PERIOD": invalid identifier

STEPS TO REPRODUCE
1. Run diagnostics: appscheck for Advanced Pricing or manually compile this package(s).

Changes

Applied Advanced Pricing Patch

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

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

Error PLS-00394: WRONG NUMBER OF VALUES IN THE INTO LIST OF A FETCH STATEMENT For PACKAGE QP_MODIFIERS_ISETUP_IMP And/Or Package QP_PREQ_PUB (Doc ID 1554755.1)

Applies to:

Symptoms

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!