Invalid ICX, JG, JAI, AND OKL Objects After Patching

After applying AP patches one or all of the following objects are invalid:ICX_PO_VENDOR_SITES_V JG_AP_TAX_LINES_SUMMARY_V JG_PO_TAX_LINES_SUMMARY_V JG_PO_REQ_TAX_LINES_SUMMARY_V JG_PO_REL_TAX_LINES_SUMMARY_V JAI_AP_IA_TRIGGER_PKG JAI_AP_IDA_TRIGGER_PKG OKL_PAY_INVOICES_DISB_PVT
The following error messages are received when trying to recompile the invalids:
Errors for ICX_PO_VENDOR_SITES_V ORA-00904: "BANK_NUMBER": invalid identifier
Errors for JG_AP_TAX_LINES_SUMMARY_V'; ORA-00904: "POVS"."AP_TAX_ROUNDING_RULE": invalid identifier Errors for JG_PO_REL_TAX_LINES_SUMMARY_V ORA-00904: "POVS"."AP_TAX_ROUNDING_RULE": invalid identifier Errors for JG_PO_REL_TAX_LINES_SUMMARY_V ORA-00904: "POVS"."AP_TAX_ROUNDING_RULE": invalid identifier Errors for JG_PO_REQ_TAX_LINES_SUMMARY_ ORA-00904: "PRVS"."AP_TAX_ROUNDING_RULE": invalid identifier Errors for JG_PO_TAX_LINES_SUMMARY_V ORA-00904: "POVS"."AP_TAX_ROUNDING_RULE": invalid identifier
Errors for PACKAGE BODY JAI_AP_IA_TRIGGER_PKG: LINE/COL ERROR -------- ----------------------------------------------------------------- 86/7 PL/SQL: Statement ignored 86/28 PLS-00302: component 'CHECK_TOLERANCE_HOLD' must be declared
Errors for PACKAGE BODY JAI_AP_IDA_TRIGGER_PKG: LINE/COL ERROR -------- ----------------------------------------------------------------- 103/7 PL/SQL: Statement ignored 103/28 PLS-00302: component 'CHECK_TOLERANCE_HOLD' must be declared
Errors for PACKAGE BODY OKL_PAY_INVOICES_DISB_PVT: LINE/COL ERROR -------- ----------------------------------------------------------------- 675/10 PL/SQL: SQL Statement ignored 678/46 PL/SQL: ORA-00904: "PVS"."PAYMENT_METHOD_LOOKUP_CODE": invalid identifier 795/3 PL/SQL: Statement ignored 795/10 PLS-00364: loop index variable 'CUR_VENDOR_DTLS' use is invalid


This is because Various Payables and other patches have caused these objects to become invalid.

Follow the step below that pertains to the invalid package that is your issue:
1. Drop ICX_PO_VENDOR_SITES_V, this is an obsolete object.

2. To resolve JG_AP_TAX_LINES_SUMMARY_V
a) Download and review the readme for Patch 7641584: UNABLE TO VALIDAT AN INVALID
OBJECT JG_AP_TAX_LINES_SUMMARY_V .

3. To resolve JG_PO_REL_TAX_LINES_SUMMARY_V, JG_PO_REQ_TAX_LINES_SUMMARY_V, and JG_PO_TAX_LINES_SUMMARY_V:
Download and review the readme for Patch 82019111OFF:7757644:12.0.4:12.0.4:INVALID JG OBJECTS.

4. For invalid packages; JAI_AP_IA_TRIGGER_PKG and JAI_AP_IDA_TRIGGER_PKG
Download and review the readme for Patch 7659470:1OFF:7612034:12.0.5:R12:ORA-4088: ERROR DURING EXECUTION OF TRIGGER 'AP

5. If JAI_AP_IDA_TRIGGER_PKG remains invalid after Patch 7659470, perform the following:
a) Download and review the readme for Patch 6708042

6) To resolve OKL_PAY_INVOICES_DISB_PVT
a) Download and review the readme for Patch 7662017: APPLICATION OF Patch 7596239 HAS CREATED 8 INVALID OBJECTS

How to Clean up the UNIX Environment After Install Fails

Complete the following steps to clean up after an 11i install has failed:

1. The first step to cleaning up an 11i install is to make sure that all the Application processes are shutdown. Here is a list of processes that need to be shut down. Processes should be shut down in this order.

SCRIPT PARAMETERS
------ ----------
Concurrent Manager Process (adcmctl.sh) {startstop} Forms Metrics Server (adfmsctl.sh) stop
Forms Server Listener (adfractl.sh) stop (As Applmgr)
Forms Server Listener (adfroctl.sh) stop
Reports Server (adrepctl.sh) stop
WebDB 2.2 Listener (adwlnctl.sh) stop
WebDB 2.5 Listener (adwdbctl.sh) stop
TCF Server (adtcfctl.sh) stop
Forms Metrics Client (adfmcctl.sh) stop
APACHE Listener (adapcctl.sh) stop
Net8 RPC Listener (adalnctl.sh) stop APPS_ Net8
Database Listener (addlnctl.sh) stop
Database (addbctl.sh) stop

2. Verify that the processes are shut down by using a ps -ef and grep for the process. For example

After the processes are shut down you can proceed with the following steps:

3. Delete the oraInst.loc file. This file will be recreated when Rapidwiz starts again.

4. Delete the oraInventory directory

5. All the files in the APPL_TOP and ORACLE_BASE directories can be removed. If a similar file structure is used for the next install confirm the base directories exist with the correct owner and group

6. If you are changing the directories' structures, delete the config.txt and create a new one. If the directories are the same you may reuse the existing config.txt file.