ASO_QUOTE_LINES_PVT Invalid After Applying Service Patch

(Doc ID 2319103.1)

Last updated on OCTOBER 26, 2017

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms