{"id":16054,"date":"2023-06-02T21:54:36","date_gmt":"2023-06-02T21:54:36","guid":{"rendered":"https:\/\/rax-prod-wp-aws.com\/blogs\/configuration-of-oracle-e-business-suite-enterprise-command-centers-ecc\/"},"modified":"2026-11-04T15:35:35","modified_gmt":"2026-11-04T15:35:35","slug":"configuration-of-oracle-e-business-suite-enterprise-command-centers-ecc","status":"publish","type":"blogs","link":"https:\/\/www.rackspace.com\/de\/blogs\/configuration-of-oracle-e-business-suite-enterprise-command-centers-ecc\/","title":{"rendered":"Configuration of Oracle E-Business Suite Enterprise Command Centers (ECC)"},"content":{"rendered":"

ECC is a set of tightly-integrated, information-rich dashboards which helps users to identify and act on priority transactions without custom operational reporting.<\/p>\n

Also, Its middleware technology made up of an interactive JavaScript front end and a Java back end engine.<\/p>\n

ECC setup consist of 5 major component<\/h3>\n
    \n
  1. Database Setup for ECC<\/li>\n
  2. Install WebLogic Server for ECC<\/li>\n
  3. ECC domain Setup<\/li>\n
  4. Setup of EBS JNDI<\/li>\n
  5. Integration of ECC with EBS<\/li>\n<\/ol>\n

    Pre – requisites<\/h3>\n
      \n
    • Download & Install the quick Install package.<\/li>\n
    • Apply relevant product command center patches on EBS Instance.<\/li>\n
    • Create a separate user for ECC components Installation (optional)<\/li>\n<\/ul>\n

      Configuration Setup Steps of ECC<\/h3>\n

      1. SET UP THE DATABASE<\/h4>\n

      (a) Navigate to the $ECC_BASE\/Oracle\/quickInstall\/ directory and open the EccConfig.properties file with a text editor. (b) cd $ECC_BASE\/Oracle\/quickInstall .\/createEnvFile.sh (c) .\/envSetup.sh -> Select option 1 <\/code><\/p>\n

      \"Oracle-ECC-Install-1\"<\/p>\n

      \"Oracle-ECC-Install-2\"<\/p>\n

      \"Oracle-ECC-Install-3\"<\/p>\n

      Validation of DB setup<\/h3>\n
        \n
      • (a) cd $ECC_BASE\/Oracle\/quickInstall\/env source ecc.env<\/code><\/li>\n
      • (b) sqlplus <ECC_DB_USER>@<EBS DB Connect String><\/code><\/li>\n<\/ul>\n

        sqlplus $ECC_DB_USER@\\\"$ECC_DB_CONNECTION\\\"<\/code> sqlplus ECC@\\\"testebs04.testecc.com:1522\/ebs_TESTEDEV\\\"<\/code><\/p>\n

        SQL> select name,open_mode,user from v$database;<\/code><\/p>\n

        NAME OPEN_MODE USER<\/p>\n

        DEVCDB READ WRITE ECC<\/p>\n

        2. INSTALL WEBLOGIC SERVER<\/h4>\n

        \"Oracle-ECC-Install-code1\"<\/p>\n

        sh $ECC_BASE\/Oracle\/quickInstall\/envSetup.sh select Install WebLogic Server - Select 2<\/code><\/p>\n

        \"Oracle-ECC-Install-4\"<\/p>\n

        \"Oracle-ECC-Install-5\"<\/p>\n

        \"Oracle-ECC-Install-6\"<\/p>\n

        3. CREATE ECC DOMAIN<\/h4>\n
          \n
        • (a) prompts ECC db password<\/li>\n
        • (b) prompts domain admin password and configures that password for the current installation. (It must contain a special character)<\/li>\n<\/ul>\n

          \"Oracle-ECC-Install-7\"<\/p>\n

          \"Oracle-ECC-Install-8\"<\/p>\n

          \"Oracle-ECC-Install-9\"<\/p>\n

          \"Oracle-ECC-Install-10\"<\/p>\n

          4. CREATE EBS JNDI<\/h4>\n
            \n
          • (a) On EBS server go to $FND_SECURE\/SID.dbc<\/li>\n
          • (b) Make a note fully qualified domain name of the target Oracle Enterprise Command Center Framework host system & dbc file from source<\/li>\n
          • (c) java oracle.apps.fnd.security.AdminDesktop apps\/<apps_password> CREATE NODE_NAME=<fully_qualified_domain_name_of_target_ECC_host_system> DBC=<full_local_DBC_file_path<\/code><\/li>\n<\/ul>\n

            \"Oracle-ECC-Install-11\"<\/p>\n

            [appldev@testebs04 ~]$ java oracle.apps.fnd.security.AdminDesktop apps\/apps CREATE NODE_NAME=testebs04.testecc.com DBC=\/u01\/ebs\/R122\/TESTEDEV\/fs1\/inst\/apps\/TESTEDEV_testebs04\/appl\/fnd\/12.0.0\/secure\/TESTEDEV.dbc<\/code> Committing changes CREATE executed successfully - TESTEDEV_TESTEBS04.TESTECC.COM.dbc<\/code><\/p>\n

              \n
            • (d) Rename copied dbc file as connection.dbc on server copy this file to the $ECC_BASE\/Oracle\/quickInstall & rename as connection.dbc<\/li>\n
            • (e)Run the envSetup.sh script from the $ECC_BASE\/Oracle\/quickInstall directory.Choose Option 4 – Create EBS JNDI<\/li>\n<\/ul>\n

              \"Oracle-ECC-Install-12\"<\/p>\n

              NOTE:<\/strong> Find user (ECC_discovery) password should be 9 non repeated characters long.<\/p>\n

              \"Oracle-ECC-Install-13\"<\/p>\n

                \n<\/ul>\n

                \"Oracle-ECC-Install-14\"<\/p>\n

                  \n
                • (f) Perform JNDI validation from the ECC domain admin console.<\/li>\n
                • URL: http:\/\/<ECC_HOST_NAME>:<ECC_ADMIN_PORT>\/console<\/li>\n
                • Navigate to Services > Data Sources.<\/li>\n
                • Choose the ebsdb JNDI config. the right pane.<\/li>\n
                • Navigate to the Monitoring tab and select the Testing subtab.<\/li>\n
                • Click on the managed server and Select Test Data Source button. The following message should appear: Success Test of ebsdb on server was successful.<\/em><\/li>\n<\/ul>\n

                  \"Oracle-ECC-Install-15\"<\/p>\n

                  5. INTEGRATE ECC WITH EBS<\/h4>\n
                    \n
                  • (a) Run the envSetup.sh script. select option 5, Integrate ECC With EBS.<\/li>\n<\/ul>\n

                    \"Oracle-ECC-Install-16\"<\/p>\n

                    \"Oracle-ECC-Install-17\"<\/p>\n

                    \"Oracle-ECC-Install-18\"<\/p>\n

                    \"Oracle-ECC-Install-19\"<\/p>\n

                    \"Oracle-ECC-Install-20\"<\/p>\n

                      \n
                    • (b) Go to DOMAIN_HOME\/servers\/\/data\/ldap\/ldapfils and remove the EmbeddedLDAP.lok lock file<\/li>\n
                    • (c) Delete the *.dat file under DOMAIN_HOME\/servers\/\/data \/store\/default and DOMAIN_HOME\/servers\/\/data \/store\/diagnostics\/<\/li>\n
                    • (d)Remove the contents under DOMAIN_HOME\/servers\/\/ tmp and DOMAIN_HOME\/servers\/\/ cache<\/li>\n
                    • Now start the server <\/code><\/li>\n<\/ul>\n

                      (6) LOG IN TO ORACLE E-BUSINESS SUITE AS A SYSTEM ADMINISTRATOR.<\/h4>\n
                        \n
                      • (a)Navigate to System Administration: Oracle Applications Manager > AutoConfig.<\/li>\n
                      • b) Select the application tier context file, and choose Edit Parameters.<\/li>\n
                      • (c) Search for the s_ecc_conf_comment variable by selecting OA_VAR in the search list of values and entering s_ecc_conf_comment in the search text box. Then choose the Go button.<\/li>\n
                      • (d) Remove the number sign (#) from the Value field for the s_ecc_conf_comment variable to ensure that this variable is not commented. Then choose the Save button.<\/li>\n
                      • (e) Enter a reason for the update, such as Enabling Oracle Enterprise Command Center Framework. Then choose the OK button.<\/li>\n
                      • (f) Similarly, search for the following variables and set their values as appropriate for your installation:<\/li>\n
                      • (g)s_ecc_protocol,s_ecc_web_host,s_ecc_managed_server_port, s_ecc_conf_update:<\/li>\n<\/ul>\n

                        [appldev@testebs04 scripts]$ grep s_ecc $CONTEXT_FILE<\/p>\n

                        grep -i s_ohs_instance_loc $CONTEXT_FILE grep -i s_ohs_component $CONTEXT_FILE grep -i s_ohs_instance_loc $CONTEXT_FILE grep -i s_ohs_component $CONTEXT_FILE <\/code><\/p>\n

                        (7) IMPORT ENTERPRISE COMMAND CENTER APPLICATIONS<\/h4>\n
                          \n
                        • (a) source EBSapps.env run (On EBS node)<\/code><\/li>\n
                        • (b) cd $FND_TOP\/bin<\/code> Perl patchEccFiles.pl<\/code> [appldev@testebs04 bin]$ perl patchEccFiles.pl <\/code><\/li>\n<\/ul>\n

                          \"Oracle-ECC-Install-21\"<\/p>\n

                          Conclusion<\/h3>\n

                          ECC provides information discovery along with visualization and exploration capabilities embedded within Oracle E-Business Suite user interfaces also it\u2019s dashboard users identify and act on top priorities without the need for custom operational reporting, and use information-driven navigation.<\/p>\n","protected":false},"excerpt":{"rendered":"

                          Configuration of Oracle E-Business Suite Enterprise Command Centers (ECC)<\/p>\n","protected":false},"author":2,"featured_media":16407,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","format":"standard","meta":{"content-type":"","nid":"25700","content_type":"blog","created_by":"11058","authored_on":"2023-06-30T03:24:36+05:30","field_article_industries":"","tag_category":"Technical","field_blog_author_text":"by Love Uniyal, Oracle Applications Database Administrator, Rackspace Technology","seo_description":"A practical guide to configuring Oracle E-Business Suite Enterprise Command Centers (ECC), enhancing data visualization and operational efficiency.","field_featured_image":"\/wp-content\/uploads\/2026\/blog_technical_images\/25700-insights_image-oracle-technical-blog-1-insights.jpg","insights_image":"\/wp-content\/uploads\/2026\/blog_technical_images\/25700-insights_image-oracle-technical-blog-1-insights.jpg","field_partners":"","rxt_platforms":"Oracle","product":"","publisheddate":"2023-06-02T21:54:36","rxt_solutions":"","opengraph_tag":"","x_tag":"","teaser_flag":"Technical Blog","seo_titile":"E-Business Suite ECC Configuration: A Practical Guide","field_topics":"","field_slug":"configuration-of-oracle-e-business-suite-enterprise-command-centers-ecc\/","footnotes":""},"categories":[],"tags":[204],"class_list":["post-16054","blogs","type-blogs","status-publish","format-standard","has-post-thumbnail","hentry","tag-technical"],"_links":{"self":[{"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/blogs\/16054","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/blogs"}],"about":[{"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/types\/blogs"}],"author":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/comments?post=16054"}],"version-history":[{"count":2,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/blogs\/16054\/revisions"}],"predecessor-version":[{"id":16056,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/blogs\/16054\/revisions\/16056"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/media\/16407"}],"wp:attachment":[{"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/media?parent=16054"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/categories?post=16054"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/tags?post=16054"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}