cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Oracle EBS Cloud Environment

Oracle are now delivering EBS via their cloud platform is there a recommended approach to collect the necessary FNMS EBS data the same way as we would on an instance in an internal estate.

(1) Solution

The EBS Data is obtained by connecting to the local DB Instance and running a set of SQL Scripts via the agent, the same as when obtaining the LMS data.

A beacon can make a "remote" connection to an Oracle Database by providing a TNSNAMES.ORA file, the correct version of Oracle ODAC client drivers on the Beacon, and Logon credentials to the Oracle DB that have permissions to all of the tables and views used by the LMS Scripts.

In your case of EBS hosted in the Cloud, that type of connection is likely not allowed.

Therefore, you need some other way to get the list of Oracle Users who have access to each EBS application and use a Business Adapter to allocate them to your EBS Application Licenses.  There may be a way to export this data from your EBS Administrator Console, or there may be an API that Oracle has created to obtain this data.

View solution in original post

(1) Reply

The EBS Data is obtained by connecting to the local DB Instance and running a set of SQL Scripts via the agent, the same as when obtaining the LMS data.

A beacon can make a "remote" connection to an Oracle Database by providing a TNSNAMES.ORA file, the correct version of Oracle ODAC client drivers on the Beacon, and Logon credentials to the Oracle DB that have permissions to all of the tables and views used by the LMS Scripts.

In your case of EBS hosted in the Cloud, that type of connection is likely not allowed.

Therefore, you need some other way to get the list of Oracle Users who have access to each EBS application and use a Business Adapter to allocate them to your EBS Application Licenses.  There may be a way to export this data from your EBS Administrator Console, or there may be an API that Oracle has created to obtain this data.