My Oracle Support Banner

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

Last updated on AUGUST 21, 2018

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

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


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.