Hi,

We hope this message finds you well. We wanted to update you regarding your recent query. Please be assured that we are actively working on it and making every effort to provide you with a thorough and accurate response.

We appreciate your patience and understanding as we ensure all details are addressed properly. If you have any additional information or concerns in the meantime, feel free to reach out.

Thank you for your continued trust in us.

Thanks & Regards,

Training Operations Team

To use Oracle ECC with custom table data you first must create custom extensions and here is how you can go about that:

Steps:

Identify Data Requirements:

• Determine the custom table(s) and column(s) that should be included in ECC.
• Establish the connection of the data with existing ECC dashboards.

Define a Data Set:

• Follow them to the EBS’s ECC Developer Responsibility.
• Proceed to the Data Load Configuration page.
• Furnish new datasets which involve the custom tables or applicable views.
• Integrate the custom data with the ECC Infrastructure with SQL queries or views.

Create a View for Custom Data:

• In case the standard EBS tables do not provide meaningful data, create a database view to bind with the custom table alongside.

Extend Metadata:

• Use the ECC Configuration XML to modify ECC metadata files.
• Use the ECC Developer Tool to upload and register your customized metadata, such as:
  Datasets: Create particular information sources.
  Attributes: Define which columns should be visible in the dashboard.
  Filters: Specify filters for the custom data.

Data Load:

• Use the concurrent requirement ECC data load to load your custom data set.
• Check to see if the custom data was successfully integrated into the ECC dashboard.

Modify or add dashboards through OAF personalizations or develop entirely new dashboards to exhibit the custom data.

Limiting Data Access According to User Groups
Oracle Enterprise Command Center (ECC) provides robust data security and role-based access control (RBAC), similar to Oracle E-Business Suite (EBS). Follow these steps to configure data access restrictions:

Procedure

Step 1: Establish Security Rules in EBS

1. Utilize EBS responsibilities, security rules, and value sets to define restrictions on data-level access.
2. Assign specific responsibilities to user groups. ECC inherits these security protocols directly from EBS.

Step 2: Configure ECC Role-Based Security

1. Use Enterprise Command Center Roles in ECC, which correspond to EBS responsibilities.
2. Assign these roles to individual users or user groups within ECC.

Step 3: Limit Data at the Data Set Level

1. Integrate security predicates into custom data sets or modify existing ones.
2. Use SQL-based security filters to dynamically restrict data access based on the following criteria:
   • User responsibility.
   • Profile options.
   • Organization or business unit.

Step 4: Implement Data Filters in ECC Metadata XML

1. Define security filters using WHERE clauses or bind variables in the ECC metadata XML.
2. Example configuration:

<dataSet>
    <name>CustomDataSet</name>
    <dataSource>CustomView</dataSource>
    <filters>
        <filter name="OrganizationFilter" value=":USER_ORG_ID"/>
    </filters>
</dataSet>
 

Step 5: Test and Confirm

1. Assign various roles or responsibilities to test users.
2. Verify that each user group can only access the data they are authorized to view in ECC.

Thank you for detailed answer.  It helps

Hi,

We hope we were able to help you with this query and all your questions were cleared. For now, we are closing off the query with your consent.

Thanks & Regards

Training Operations Team