Error While Applying The Patch 20784036 for OPM Outside Processing (Doc ID 2072170.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Process Manufacturing Systems - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Patch Application Issues

When attempting to apply the Outside Processing Project patch 20784036:R12.GMA.C, the following errors appear in the patch application log file:

The following Oracle Forms objects did not generate successfully:

au resource POXBWVRP.pll
au resource POXOPROC.pll
au resource POXPOEPO.pll
au resource POXPOPOL.pll
au resource POXPOVP2.pll
au resource POXRQVR2.pll

adwork001.log contains the following:

ERROR generating library "resource/POXBWVRP.plx" from input file
/u01/oracle/AMIF/fs1/EBSapps/appl/au/12.0.0/resource/POXBWVRP.pll

Results of library generation:
(from file /u01/oracle/AMIF/fs1/EBSapps/appl/au/12.0.0/resource/POXBWVRP.err
AD Worker has deleted the original .err file)
-------------------------------------------------------------------------
Compilation errors on REQ_LINES2:
PL/SQL ERROR 302 at line 576, column 16
component 'PO_OPM_OSP_DETAILS' must be declared
PL/SQL ERROR 0 at line 576, column 1
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library.

adwork002.log contains the following:

ERROR generating library "resource/POXOPROC.plx" from input file
/u01/oracle/AMIF/fs1/EBSapps/appl/au/12.0.0/resource/POXOPROC.pll

Results of library generation:
(from file /u01/oracle/AMIF/fs1/EBSapps/appl/au/12.0.0/resource/POXOPROC.err
AD Worker has deleted the original .err file)
-------------------------------------------------------------------------
Compilation errors on OUTSIDE_PROC_C3:
PL/SQL ERROR 306 at line 68, column 12
wrong number or types of arguments in call to 'GET_RESOURCE_DEFAULTS'
PL/SQL ERROR 0 at line 68, column 12
Statement ignored

All prerequisites have been applied.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply prerequisite patches
2. Apply patch 20784036

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use Outside Processing.

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