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

Last updated on JANUARY 03, 2023

Applies to:

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 <>,
 including Procurement  Patch 18911810:R12.PRC_PF.B -Oracle Procurement Recommended Patch Collection (July 2014)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.