EBS System Schema Migration Violation Errors 'REFERENCES TO SYS.<TABLE_NAME> OR SYS.<VIEW_NAME>' For Objects LA_CHANGECENTER_API , LA_FUNCTION_LIST (Doc ID 2895855.1)

Last updated on OCTOBER 10, 2023

Applies to:

Symptoms

On : EBS (Oracle E-Business Suite) 12.2 version, Patch Application Issues

As part of migrating EBS Release 12.2 to use the new EBS System Schema, run SYSTEM Schema Migration Compliance Checker report - ADSYSCC.sql. It shows following errors.

DOC> ******************************************************************************************************************
DOC> SECTION-2.6 REFERENCES TO SYS.<TABLE_NAME> OR SYS.<VIEW_NAME>
DOC> ******************************************************************************************************************
DOC> This section identifies the following:
DOC> -EBS objects that reference SYS.<TABLE_NAME> or SYS.<VIEW_NAME> which are considered to be private database system objects
DOC>
DOC> - P1: If the query returns any rows that include EBS objects, then the EBS System Schema Migration is not complete.
DOC> - Fix: EBS objects should be updated to remove the dependency on SYS.<TABLE_NAME> or SYS.<VIEW_NAME> in accordance with Oracle database guidelines and standards.
OWNER OBJECT_NAME OBJECT_TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE RECOMMENDATION
-------------------- ------------------------------ --------------- -------------------- ------------------------------ --------------- ---------------------------------------------------------------------------
APPS LA_CHANGECENTER_API PACKAGE BODY SYS OBJ$ TABLE Replace SYS.OBJ$ with SYS.DBA_OBJECTS
APPS LA_CHANGECENTER_API PACKAGE BODY SYS USER$ TABLE Replace SYS.USER$ with SYS.DBA_USERS
APPS LA_FUNCTION_LIST VIEW SYS OBJ$ TABLE Replace SYS.OBJ$ with SYS.DBA_OBJECTS
APPS LA_FUNCTION_LIST VIEW SYS USER$ TABLE Replace SYS.USER$ with SYS.DBA_USERS

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. While migrating EBS Release 12.2 to use the new EBS System Schema, run SYSTEM Schema Migration Compliance Checker report - ADSYSCC.sql.

2. Review the report output.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete EBS migration to the new security architecture.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.