Introduction:
R12.2 is being modernized with many new functionalities and changes in architecture. We, as a DBA, rely on SYS and SYSTEM passwords for any activities like patching/cloning and upgrading. This has been modernized, and Oracle introduced the EBS_SYSTEM schema, which holds all EBS objects that SYS and SYSTEM owned.
Oracle E-Business Suite DBA’s/DBA’s and EBS Architect are the intended audiences for this blog.
How to adapt to EBS_SYSTEM?
EBS patch AD-TXK Delta 13 code level introduces the EBS_SYSTEM schema for the R12.2 version. You will need to apply the below patches
- R12.AD.C.Delta 13 (32394134)
- R12.TXK.C.Delta 13(32392507)
What are the use/benefits of this schema?
Access to public database APIs
Oracle E-business code is updated to map to public Oracle database dictionary objects and APIs.
Least Privileges Model for Database Object Access
EBS run time accounts are constrained even further, and unnecessary privileges are revoked from EBS application accounts.
Separation of Duties for Administrators
This is a must for highly secured environments where the role of DBA and EBS DBA are separated using this feature. EBS_SYSTEM now runs all actions which need SYS and SYSTEM privileges. EBS DBA no longer needed SYS and SYSTEM credentials.
EBS_SYSTEM and SYSTEM password must match equally until you complete AD-TXK Delta 13. Once EBS is updated with this latest patch set, you can change and have unique passwords for EBS_SYSTEM and SYSTEM.
Database Service Names for Application Tier Database Connections
Connection to the EBS application tier is now performed using Oracle Database service names.
Support for Oracle Database Unified Auditing
EBS customers will be able to utilize Unified Auditing, the latest method for auditing on the Oracle database. With this, audit data is combined into a single audit trail.
Streamline Database Directory Objects
APPS schema will no longer have the ability to create database directory objects, and the EBS_SYSTEM user now creates Database directory objects.
Interoperability across Oracle Database Releases
Database upgrades will be made more accessible by EBS only referencing public database views and APIs. I will try to share the technical steps of implementing EBS_SYSTEM soon.
