R12: PAXCARVW.fmx Not Generated Successfully After Applied Patches (Doc ID 1964535.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On 12.1.3:

After applied Patch 14320908 and its pre-requisites, form PAXCARVW.fmx did not generate successfully:

=======================================
The following Oracle Forms objects did not generate successfully:
pa forms/US PAXCARVW.fmx
=======================================

Compiling package body SPLIT_ASSET_LINE...
Compilation error on package body SPLIT_ASSET_LINE:
PL/SQL ERROR 905 at line 23, column 35
object APPS.PAAPIMP_PKG is invalid
PL/SQL ERROR 0 at line 23, column 20
Item ignored
PL/SQL ERROR 320 at line 120, column 8
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 120, column 5
Statement ignored
PL/SQL ERROR 320 at line 219, column 7
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 219, column 4
Statement ignored
PL/SQL ERROR 320 at line 323, column 8
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 323, column 5
Statement ignored

Also, the following packages are invalid:

OBJECT_NAME     OBJECT_TYPE         OWNER     STATUS
-----------------------------------------------------------
PA_FAXFACE         PACKAGE BODY     APPS     INVALID
PA_TRANSACTIONS     PACKAGE BODY     APPS     INVALID
PA_TRX_IMPORT         PACKAGE BODY     APPS     INVALID
PAAPIMP_PKG         PACKAGE     APPS     INVALID
PAAPIMP_PKG         PACKAGE BODY     APPS     INVALID
PA_MC_CURRENCY_PKG     PACKAGE BODY     APPS     INVALID
PA_PURGE_COSTING     PACKAGE BODY     APPS     INVALID
PA_AP_INTEGRATION     PACKAGE BODY     APPS     INVALID
PA_ASSET_ALLOCATION_PVT PACKAGE BODY     APPS     INVALID
PA_DATAFIXES_UTIL     PACKAGE BODY     APPS     INVALID


When trying to recompile each package above, see errors for each package compilation error:

==============================================================
SQL> ALTER PACKAGE PAAPIMP_PKG COMPILE;
ALTER PACKAGE PAAPIMP_PKG COMPILE BODY;
Warning: Package altered with compilation errors.
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY PAAPIMP_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0      PL/SQL: Compilation unit analysis terminated
1/14     PLS-00304: cannot compile body of 'PAAPIMP_PKG' without its
       specification
1/14     PLS-00905: object APPS.PAAPIMP_PKG is invalid
==============================================================
SQL> ALTER PACKAGE PA_FAXFACE COMPILE;
ALTER PACKAGE PA_FAXFACE COMPILE BODY;
Warning: Package altered with compilation errors.
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY PA_FAXFACE:
LINE/COL ERROR
-------- -----------------------------------------------------------------
41/21    PL/SQL: Item ignored
41/36    PLS-00905: object APPS.PAAPIMP_PKG is invalid
726/6    PL/SQL: Statement ignored
726/9    PLS-00320: the declaration of the type of this expression is
       incomplete or malformed
1151/2   PL/SQL: Statement ignored
1151/5   PLS-00320: the declaration of the type of this expression is
       incomplete or malformed
1194/2   PL/SQL: Statement ignored
LINE/COL ERROR
-------- -----------------------------------------------------------------
1194/5   PLS-00320: the declaration of the type of this expression is
       incomplete or malformed
1393/6   PL/SQL: Statement ignored
1393/9   PLS-00320: the declaration of the type of this expression is
       incomplete or malformed

3417/8   PL/SQL: Statement ignored
3417/11  PLS-00320: the declaration of the type of this expression is
       incomplete or malformed
==============================================================
SQL> ALTER PACKAGE PA_TRANSACTIONS COMPILE;
ALTER PACKAGE PA_TRANSACTIONS COMPILE BODY;
Warning: Package altered with compilation errors.
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY PA_TRANSACTIONS:
LINE/COL ERROR
-------- -----------------------------------------------------------------
449/5    PL/SQL: Statement ignored
449/44   PLS-00382: expression is of wrong type
==============================================================
SQL> ALTER PACKAGE PA_TRX_IMPORT COMPILE;
ALTER PACKAGE PA_TRX_IMPORT COMPILE BODY;
Warning: Package altered with compilation errors.
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY PA_TRX_IMPORT:
LINE/COL ERROR
-------- -----------------------------------------------------------------
7825/16  PL/SQL: Statement ignored
7825/76  PLS-00905: object APPS.PAAPIMP_PKG is invalid
7826/9   PL/SQL: Statement ignored
7826/42  PLS-00905: object APPS.PAAPIMP_PKG is invalid
==============================================================
SQL> ALTER PACKAGE PA_MC_CURRENCY_PKG COMPILE;
ALTER PACKAGE PA_MC_CURRENCY_PKG COMPILE BODY;
Warning: Package altered with compilation errors.
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY PA_MC_CURRENCY_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
1606/4   PL/SQL: Statement ignored
1606/19  PLS-00905: object APPS.PAAPIMP_PKG is invalid
1607/6   PL/SQL: Statement ignored
1607/6   PLS-00905: object APPS.PAAPIMP_PKG is invalid
1608/6   PL/SQL: Statement ignored
1608/6   PLS-00905: object APPS.PAAPIMP_PKG is invalid
1609/6   PL/SQL: Statement ignored
1609/6   PLS-00905: object APPS.PAAPIMP_PKG is invalid
1611/2   PL/SQL: Statement ignored
1611/29  PLS-00905: object APPS.PAAPIMP_PKG is invalid
1612/2   PL/SQL: Statement ignored

 

 

Changes

Applied Patch 14320908 and its pre-requisites

 

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