PA_DEDUCTIONS_PUB, PA_DEDUCTIONS_W, and PA_DCTN_APRV_NOTIFICATION Invalid After Upgrade to 12.1.3 (Doc ID 1230836.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Foundation - Version 12.1.3 and later
Information in this document applies to any platform.
Checked for currency on 30-AUG-2012


Symptoms

After upgrading to 12.1.3 the package PA_DCTN_APRV_NOTIFICATION, PA_DEDUCTIONS_W, and PA_DEDUCTIONS_PUB are invalid. 

  Errors for PACKAGE BODY PA_DCTN_APRV_NOTIFICATION: 

   

  LINE/COL ERROR 

  -------- ----------------------------------------------------------------- 

  846/21   PL/SQL: Item ignored 

  846/35   PLS-00302: component 'CUR_DCTN_HDR_INFO' must be declared 

  863/8    PL/SQL: SQL Statement ignored 

  863/22   PLS-00320: the declaration of the type of this expression is 

          incomplete or malformed 

  866/8    PL/SQL: Statement ignored 

  867/30   PLS-00320: the declaration of the type of this expression is 

          incomplete or malformed 

   

  Errors for PACKAGE PA_DEDUCTIONS_W: 

   

  LINE/COL ERROR 

  -------- ----------------------------------------------------------------- 

  3/1      PL/SQL: Declaration ignored 

  3/63     PLS-00302: component 'G_DCTN_HDRID' must be declared 

  4/3      PL/SQL: Declaration ignored 

  4/55     PLS-00302: component 'G_DCTN_HDRID' must be declared 

  6/3      PL/SQL: Declaration ignored 

  6/65     PLS-00302: component 'G_DCTN_TXNID' must be declared 

  7/3      PL/SQL: Declaration ignored 

  7/55     PLS-00302: component 'G_DCTN_TXNID' must be declared 

  9/3      PL/SQL: Declaration ignored 

  9/65     PLS-00302: component 'G_DCTN_HDRTBL' must be declared 

  31/3     PL/SQL: Declaration ignored 

  31/55    PLS-00302: component 'G_DCTN_HDRTBL' must be declared 

  54/3     PL/SQL: Declaration ignored 

  54/65    PLS-00302: component 'G_DCTN_TXNTBL' must be declared 

  75/3     PL/SQL: Declaration ignored 

  75/55    PLS-00302: component 'G_DCTN_TXNTBL' must be declared 

   

  Errors for PACKAGE PA_DEDUCTIONS_PUB: 

   

  LINE/COL ERROR 

  -------- ----------------------------------------------------------------- 

  17/22    PL/SQL: Declaration ignored 

  17/36    PLS-00302: component 'G_DCTN_HDRTBL' must be declared 

  18/22    PL/SQL: Declaration ignored 

  18/36    PLS-00302: component 'G_DCTN_TXNTBL' must be declared 

   

  Errors for PACKAGE BODY PA_DEDUCTIONS_PUB: 

   

  LINE/COL ERROR 

  -------- ----------------------------------------------------------------- 

  0/0      PL/SQL: Compilation unit analysis terminated 

  1/14     PLS-00304: cannot compile body of 'PA_DEDUCTIONS_PUB' without its 

          specification 

  1/14     PLS-00905: object APPS.PA_DEDUCTIONS_PUB is invalid 

   

  Errors for PACKAGE BODY PA_DEDUCTIONS_W: 

   

  LINE/COL ERROR 

  -------- ----------------------------------------------------------------- 

  0/0      PL/SQL: Compilation unit analysis terminated 

  1/14     PLS-00304: cannot compile body of 'PA_DEDUCTIONS_W' without its 

          specification 

  1/14     PLS-00905: object APPS.PA_DEDUCTIONS_W is invalid 

   

Changes

Upgraded to 12.1.3.

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