Applying TDS Patch There Shouldn’t Be Any Invalid Objects In Apps Schema Starting With JAI%

Last updated on OCTOBER 15, 2017

Applies to:

Goal

Applying TDS patch there shouldn’t be any invalid objects in apps schema starting with JAI%

As a Prerequisite step to apply TDS patch(26254475, there shouldn’t be any invalid objects in apps schema starting with JAI%,but we have following objects invalid with object name start with JAI.
Please let us know why these objects invalid and how to proceed to apply TDS patch.


SQL> select owner,object_name,object_type,status from dba_objects where object_name like 'JAI%' and status='INVALID' and owner='APPS';

OWNER OBJECT_NAME OBJECT_TYPE STATUS
---------- ---------------------------------------- ------------------- -------
APPS JAIN_LOC_ERRS_INS PROCEDURE INVALID
APPS JAI_AP_ORG_TAN_V VIEW INVALID
APPS JAI_AR_CASH_RECEIPTS_ARIUD TRIGGER INVALID
APPS JAI_CMN_VENDOR_CUST_NAME_V VIEW INVALID
APPS JAI_STFORMS_PRC_PKG PACKAGE BODY INVALID

Prerequisites for TDS patch 26254475

1. India GST functional patch--COMPLETED
2. Patch 19287293:R12.FND.B (This is only for R12.1.3)--COMPLETED
3. Make sure that (above) revised Co-existence is applied and there are no INVALID JAI objects in Database
Query:
SELECT * FROM dba_objects WHERE status='INVALID'
  AND object_name LIKE 'JAI%'; -- This should not return any rows in case of NO invalids

we stuck with this third pre-requisite step to apply TDS patch.
 

Solution