POXPOEPO.pll Having Multiple Failures During Patching (Doc ID 2019684.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

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

Symptoms

Find when Upgrade to 12.1.3  and applied additional patching , then  POXPOEPO.pll is failing with the below error :

ERROR
-----------------------
Compilation errors on PO_HDR_SPECIAL_C:
PL/SQL ERROR 306 at line 1907, column 8
wrong number or types of arguments in call to 'ONLINE_REBUILD_ACCOUNTS'
PL/SQL ERROR 0 at line 1907, column 8
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library.

Compiling package body APP_CUSTOM...
Compilation error on package body APP_CUSTOM:
PL/SQL ERROR 201 at line 160, column 9
identifier 'SIC_CATALOG_OUT.CANCEL_BUTTON' must be declared
PL/SQL ERROR 0 at line 160, column 9
Statement ignored
Compiling package body MOAC_HANDLE...
Compilation error on package body MOAC_HANDLE:
PL/SQL ERROR 201 at line 45, column 11
identifier 'PO_HEADERS_C6.DEFAULT_ROW' must be declared
PL/SQL ERROR 0 at line 45, column 11
Statement ignored
PL/SQL ERROR 201 at line 51, column 11
identifier 'PO_HEADERS_C7.VAL_MENU_PATH' must be declared
PL/SQL ERROR 0 at line 51, column 11
Statement ignored
PL/SQL ERROR 201 at line 54, column 11
identifier 'PO_HDR_SPECIAL_C.DEFINE_SPECIAL_MENU' must be declared
PL/SQL ERROR 0 at line 54, column 11
Statement ignored
PL/SQL ERROR 201 at line 56, column 11
identifier 'PO_HDR_SPECIAL_C.SET_SPECIAL_MENU_OPTIONS' must be declared
PL/SQL ERROR 0 at line 56, column 11
Statement ignored
PL/SQL ERROR 201 at line 58, column 11
identifier 'PO_LINES_C8.GET_PRICE_BREAK_CODE' must be declared
PL/SQL ERROR 0 at line 58, column 11
Statement ignored

 

Compiling POST-DATABASE-COMMIT trigger on form...
Compilation error on POST-DATABASE-COMMIT trigger on form:
PL/SQL ERROR 302 at line 16, column 26
component 'SET_REBUILD_ACCOUNT_MENU' must be declared
PL/SQL ERROR 0 at line 16, column 9
Statement ignored
PL/SQL ERROR 306 at line 38, column 8
wrong number or types of arguments in call to 'REBUILD_ACCOUNTS'
PL/SQL ERROR 0 at line 38, column 8
Statement ignored

Compiling ON-CLEAR-DETAILS trigger on form.

 

Changes

 Upgraded to 12.1.3 and applied patches per <<Doc ID 954704.1>>,
 including Procurement  Patch 18911810:R12.PRC_PF.B -Oracle Procurement Recommended Patch Collection (July 2014)

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