ASO_QUOTE_LINES_PVT Invalid After Applying Service Patch
(Doc ID 2319103.1)
Last updated on FEBRUARY 06, 2022
Applies to:
Oracle Order Capture - Version 12.1.3 to 12.1.3 [Release 12.1]Oracle Teleservice - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Symptoms
After applying the following patches:
. 26475583:R12.CS.B - 12.1.3:BUG FIXES FOR CS:JULY'17 RUP (or one of its latest replacements)
. 16365623:R12.CSF.B - NEED GLOBAL VARIABLE TO BE SET IN CASE OF RESCHEDULING
the following objects remain invalid:
Errors:
1. Errors for PACKAGE BODY APPS.ASO_QUOTE_CUHK:
LINE/COL ERROR
-------- -----------------------------------------------------------------
536/11 PLS-00323: subprogram or cursor 'CREATE_ORDER_PRE' is declared in a package specification and must be defined in the package body
2. Errors for PACKAGE BODY APPS.ASO_QUOTE_LINES_PVT:
(a)
LINE/COL ERROR
-------- -----------------------------------------------------------------
1657/19 PL/SQL: Statement ignored
1657/33 PLS-00302: component 'VALIDATE_DURATION' must be declared
2245/19 PL/SQL: Statement ignored
2245/33 PLS-00302: component 'VALIDATE_DURATION' must be declared
After applying a patch recommended for that error, a different error occurs:
(b)
LINE/COL ERROR
-------- -----------------------------------------------------------------
136/1 PL/SQL: Statement ignored
136/1 PLS-00306: wrong number or types of arguments in call to 'INSERT_ROW'
6811/8 PL/SQL: Statement ignored
6811/8 PLS-00306: wrong number or types of arguments in call to 'UPDATE_ROW'
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 |