Step-by-Step Guide: Installing Oracle Enterprise Command Center (ECC) and Integrating with Oracle E-Business Suite (EBS) R12.2

Oracle Enterprise Command Center (ECC) provides a dashboard-driven user experience for Oracle E-Business Suite (EBS), helping users make data-driven decisions. This guide provides a step-by-step command line guide for installing ECC and integrating it with Oracle EBS R12.2.

Prerequisites

1. Supported Oracle EBS Version: Oracle EBS R12.2.4 and above is required.

2. Database Version: Oracle Database 12c (12.1.0.2) or later is recommended.

3. Operating System: Linux (Red Hat Enterprise Linux or Oracle Linux).

4. Memory and CPU Requirements: ECC requires a dedicated CPU and at least 8GB of RAM for smooth operation.

   
   

Step 1: Prepare for ECC Installation

1. Verify Oracle EBS and Database Compatibility

Ensure your Oracle EBS and database versions meet the compatibility requirements.

• Check EBS Version:

  
  

  SELECT release_name FROM apps.fnd_product_groups;

• Check Database Version:

  
  

  SELECT * FROM v$version WHERE banner LIKE 'Oracle%';

2. Download the ECC Installation Media

Download the required ECC installation files from My Oracle Support. The latest ECC release is available under patch 28840850.

• Reference: My Oracle Support - ECC Patches

Step 2: Install and Configure Oracle ECC on EBS

1. Install ECC Files in EBS Environment

Unzip and install the ECC patches in the Oracle EBS environment.

1. Transfer the ECC Files to the EBS Server:

   
   

   scp ECC_PATCH.zip oracle@ebs_server:/u01/EBSapps/patches

2. Unzip the Patch:

   
   

   cd /u01/EBSapps/patches unzip ECC_PATCH.zip

3. Apply the ECC Patch Using ADOP: Start an ADOP patching cycle to apply the ECC patch.

   
   

   cd $PATCH_TOP/<patch_number>/etc/adop/patch adop phase=prepare adop phase=apply patches=<patch_number> adop phase=finalize adop phase=cleanup

   
   

2. Set Up ECC for EBS Integration

1. Run the ECC Loader to Initialize ECC Data: Run the ECC data loader to populate initial data into ECC.

   
   

   cd $ECC_TOP/bin ./ecc_loader.sh

2. Verify ECC Installation: Ensure ECC components are installed correctly by checking the ECC instance status.

   
   

   curl -u <username>:<password> http://<ecc_host>:<port>/ecc/api/v1/status

   
   

Step 3: Configure ECC Node in Oracle EBS

1. Log in to Oracle EBS as SYSADMIN: Open the System Administrator responsibility.

2. Create a Node for ECC:

   • Navigate to System Administrator > Oracle Applications Manager > Nodes.

   • Add a new node for the ECC host and ensure it’s marked as a “Web Node.”

3. Update Profile Options:

   • Set the profile option ECM: ECC Host to the ECC server’s hostname.

   • Set the profile option ECM: ECC Port to the ECC server’s port.

4. Bounce Apache: Restart Apache for the changes to take effect.

   
   

   $ADMIN_SCRIPTS_HOME/adapcctl.sh stop $ADMIN_SCRIPTS_HOME/adapcctl.sh start

   
   

Step 4: Enable ECC Dashboards in Oracle EBS

1. Apply Data Load for ECC Dashboards: For each ECC-enabled product in EBS, apply a data load using the ECC Loader.

   
   

   cd $ECC_TOP/bin ./ecc_loader.sh -p <product_short_code>

   Example:

   ./ecc_loader.sh -p INV

2. Verify ECC Dashboards: Access ECC dashboards within Oracle EBS to verify the data load.

   • Go to Inventory Responsibility > ECC Dashboard (for Inventory, as an example).

   • Ensure data is displayed on the dashboard.

   
   

Step 5: Test the ECC Integration with Oracle EBS

1. Access ECC Through EBS: Log into Oracle EBS and navigate to an ECC-integrated module.

   • Example path: Inventory > ECC Dashboard

2. Verify Dashboard Data: Ensure that the ECC dashboard is displaying accurate, up-to-date information from EBS.

3. Troubleshoot ECC Issues: If there are issues with data loading or display:

   • Check ECC Loader Logs:

     
     

     tail -f $ECC_TOP/logs/ecc_loader.log

   • Verify API Status:

     
     

     curl -u <username>:<password> http://<ecc_host>:<port>/ecc/api/v1/status

Step 6: Set Up Scheduled Data Refresh for ECC

1. Configure ECC Loader for Scheduled Runs: Set up a cron job to refresh ECC data periodically.

   
   

   crontab -e

2. Add a Cron Job for ECC Data Refresh:

   
   

   # Daily ECC Data Refresh at midnight 0 0 * /u01/EBSapps/appl/ecc/12.2/bin/ecc_loader.sh -p <product_short_code> >> /u01/EBSapps/appl/ecc/logs/ecc_refresh.log 2>&1

3. Verify Scheduled Data Refresh: Check the log files periodically to ensure data is being refreshed as expected.

   
   

Conclusion

This step-by-step guide walks you through installing and integrating Oracle Enterprise Command Center with Oracle EBS R12.2. By following the above steps, you should have a fully functional ECC instance that enhances EBS with powerful dashboards and analytics capabilities.