Applying TDS Patch There Shouldn’t Be Any Invalid Objects In Apps Schema Starting With JAI%
(Doc ID 2280248.1)
Last updated on JULY 15, 2022
Applies to:
Oracle Financials for India - Version 12.1.3 and laterInformation in this document applies to any platform.
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
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
Goal |
Solution |