My Oracle Support Banner

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

Last updated on AUGUST 14, 2018

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

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
Changes
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.