We have applied below patches and one new invalid got generated.
Hi Team,
We have applied below patches and one new invalid got generated.
1- The below 15 patches already applied ( all the patches requested in original action plan )
1. 9337544
2. 9837933
3. 9034923
4. 7669765
5. 9049887
6. 7640730
7. 9095267
8. 8369023
9. 9141138
10. 8712954
11. 9381398
12. 8770459
13. 8774651
14. 13636268
15. 17971181
2- The new patch new to be appliued due to new below invalid 9856095
But new inavlid remains same ...
SQL> alter PACKAGE APPS.JE_FR_JELINES_RPT_PKG compile body;
Warning: Package Body altered with compilation errors.
SQL> sho error
Errors for PACKAGE BODY APPS.JE_FR_JELINES_RPT_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
2590/6 PL/SQL: Statement ignored
2590/6 PLS-00201: identifier 'XLA_RPT_UTIL_QRY_PKG.GET_CUSTOM_QUERY' must be declared
SQL> select OWNER,OBJECT_NAME,OBJECT_TYPE,CREATED,LAST_DDL_TIME,STATUS from all_objects where OBJECT_NAME like 'JE_FR_JELINES_RPT_PKG';