Hi Erman,
We are upgrading R12.1.3 instance to R12.2.8
We are running the report in existing R12.1.3 version.We would like to know if below sections 47,90,91 gets fixed automatically after applying online enablement patch or do we need to take any manual action?
DOC> **********************************************************************
DOC> SECTION-47 [minimal]
DOC> **********************************************************************
DOC> "Latest version of the package APPS_DDL must be installed in each EBS schema."
DOC>
DOC> - P2: If the latest package version is not installed then dynamic SQL executed in the schema might fail.
DOC> - Fix: Create the APPS_DDL spec and body in the listed schemas by
DOC> running the installation scripts.
DOC> sqlplus <username>/<password> @$AD_TOP/patch/115/sql/adaddls.pls
DOC> sqlplus <username>/<password> @$AD_TOP/patch/115/sql/adaddlb.pls
DOC>#
OWNER OBJECT_NAME OBJECT_TYPE SCHEMA_VERSION APPS_VERSION STATUS
-------------------- --------------- --------------- -------------------- -------------------- ----------
AP APPS_DDL PACKAGE 120.0 115.1 VALID
APPS_DDL PACKAGE BODY 120.0 115.0 VALID
APPLSYS APPS_DDL PACKAGE 120.0 115.1 VALID
APPS_DDL PACKAGE BODY 120.0 115.0 VALID
AR APPS_DDL PACKAGE 120.0 115.1 VALID
APPS_DDL PACKAGE BODY 120.115.1 VALID
APPS_DDL PACKAGE BODY 120.0 115.0 VALID
ZX APPS_DDL PACKAGE 120.0 115.1 VALID
APPS_DDL PACKAGE BODY 120.0 115.0 VALID
320 rows selected.
DOC> **********************************************************************
DOC> SECTION-90 [full]
DOC> **********************************************************************
DOC> "Revoke unnecessary grants granted on SYS.DUAL by SYS."
DOC>
DOC> - Please execute ADFIXUSER.sql if one or more records exist.
DOC>#
Count
----------
10
1 row selected.
Elapsed: 00:00:00.07
DOC> **********************************************************************
DOC> SECTION-91 [full] Bugs 26137712 and 26314055 , jwsmith
DOC> **********************************************************************
DOC> "Revoke unnecessary grants granted on DBMS_SYS_SQL."
DOC>
DOC> - If a record exists from below sql, please connect to sqlplus via apps and run
DOC> - the following sql script: $AD_TOP/patch/115/sql/adrevokegrants.sql.
DOC> - Example - sqlplus apps/apps @adrevokegrants.sql
DOC> - Then run the select again and verify 0 rows are returned.
DOC> -
DOC> - If you are in pre EBR Enablement Stage or pre Oracle E-Business Suite
DOC> - Release 12.2 level, please run "exec sys.ad_grants.cleanup;"
DOC> - manually from sqlplus as APPS user.
DOC>#
COUNT(1)
----------
1
1 row selected.
Thank you
Locked
