How To Resolve Errors for PACKAGE BODY QP_PREQ_GRP and QP_PREQ_PUB After Application of Patch 30501426:R12.QP.B ?
(Doc ID 2803760.1)
Last updated on SEPTEMBER 08, 2021
Applies to:
Oracle Advanced Pricing - Version 12.1 to 12.1.3 [Release 12.1]Information in this document applies to any platform.
Goal
How can one resolve errors shown after applying patch 30501426:R12.QP.B?
Customer is getting the below error(s) and Package is Invalid,
QP_PREQ_GRP QPXGPREB.pls 120.70.12010000.175
BODY INVALID
Errors for PACKAGE BODY QP_PREQ_GRP
PL/SQL: ORA-00904: "INCLUDE_IN_SET": invalid identifier
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00904: "INCLUDE_IN_SET": invalid identifier
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00904: "INCLUDE_IN_SET": invalid identifier
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00904: "INCLUDE_IN_SET": invalid identifier
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00904: "INCLUDE_IN_SET": invalid identifier
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00904: "INCLUDE_IN_SET": invalid identifier
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00904: "B"."INCLUDE_IN_SET": invalid identifier
PL/SQL: SQL Statement ignored
PLS-00364: loop index variable 'L_DETS' use is invalid
PL/SQL: Statement ignored
PLS-00364: loop index variable 'L_DETS' use is invalid
PL/SQL: Statement ignored
PLS-00364: loop index variable 'L_DETS' use is invalid
PL/SQL: Statement ignored
QP_PREQ_PUB QPXPPRES.pls 120.3.12010000.4
SPEC VALID
QP_PREQ_PUB QPXPPREB.pls 120.27.12010000.38
BODY INVALID
Errors for PACKAGE BODY QP_PREQ_PUB
PLS-00306: número o tipos de argumentos erróneos al llamar a 'INSERT_LDETS2'
PL/SQL: Statement ignored
PLS-00306: número o tipos de argumentos erróneos al llamar a 'INSERT_LDETS2'
PL/SQL: Statement ignored
Solution
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
| Goal |
| Solution |
| References |