Table of Contents
Updated article version
Please find the updated version of this article for ECC v11 and ECC r12.2.13 here.
Introduction
This post describes Oracle Enterprise Command Center Framework (ECC) installation and configuration steps. It is not meant to replace MOS Doc ID 2495053.1, which is very good and detailed. We want to share our experience including faced errors and solutions.
And good news for those who like to see ECC in action. You can try it yourself in our demo environment. Just log in and choose Payables manager or Receivables manager responsibility and navigate to the command center menu entry.
Please also try Blitz Report which is the fastest way to export Oracle EBS data into Excel.
For upgrade instructions from ECC V2 to V3 please refer to this post.
For upgrade instructions from ECC V3 to V4 please refer to this post.
For ECC TLS/https with EBS configuration please refer to this post.
This video shows an example of following this post to configure a new ECC installation.
References:
Following sources have been used to get information about ECC:
https://www.oracle.com/a/ocom/docs/applications/ebusiness/ebs-enterprise-command-center-quick-start-guide.pdf
Installing Oracle Enterprise Command Center Framework, Release 12.2 V2 (Doc ID 2495053.1)
Extending Oracle Enterprise Command Centers, Release 12.2 V2 (Doc ID 2527150.1)
https://www.itconvergenceinsights.com/enterprise-command-center-ecc-for-e-business-suite-12.2-0
https://www.intelpub.com.ar/getting-to-work-enterprise-command-center-ecc-for-e-business-suite-12-2/
https://www.intelpub.com.ar/using-enterprise-command-center-ecc-for-e-business-suite-12-2/
Operating System configuration
Supported OS versions:
Oracle Linux 7 or Red Hat Enterprise Linux 7 (64-bit)
It is recommended to use a standalone server for the ECC installation though it is possible to perform installation on a EBS apps server.
Required OS resources
MOS Doc ID 2495053.1 provides table describing OS resources requirements. We started with minimal resources assignment as it can be easily changed for a virtual machine.
Number of users | Number of records | Number of Cores | Required Memory |
50 | 2 million | 2 | 5 GB |
Firewall settings
If you protect your servers using firewall, access to certain ports on the ECC server needs to be provided. If you are using OEL 7, firewall-cmd and switched to drop zone by default then following commands will allow connections from the EBS server to the admin and managed Weblogic servers ports:
firewall-cmd --permanent --zone=drop --add-rich-rule="rule family="ipv4" \ source address="192.168.1.2/32" \ port protocol="tcp" port="7775" accept" firewall-cmd --permanent --zone=drop --add-rich-rule="rule family="ipv4" \ source address="192.168.1.2/32" \ port protocol="tcp" port="7776" accept" firewall-cmd --reload |
If you prefer to create new or modify existing zone instead of allowing separate ports you can use the following commands. The first command is required only if you are creating a new zone. Please replace ecc_zone to a required name of a zone and 192.168.1.2/32 to source IP address in your network.
firewall-cmd --permanent --new-zone=ecc_zone firewall-cmd --permanent --zone=ecc_zone --add-source=192.168.1.2/32 firewall-cmd --permanent --zone=ecc_zone --add-port=7775/tcp firewall-cmd --permanent --zone=ecc_zone --add-port=7776/tcp firewall-cmd --reload firewall-cmd --zone=ecc_zone --list-all |
Please adjust zone name and a source address according to your environment.
If you decide to create ECC schema in EBS database, you will need to allow access from ECC server to EBS database port. Example of iptables command to achieve that which needs to be executed on the EBS server:
iptables -A INPUT -s 192.168.1.3/32 -p tcp -m state --state NEW -m tcp --dport 1521 -j ACCEPT |
Cloud firewall configuration
If your servers are hosted on the cloud, then your hosting provider may provide additional web based firewall management. So even though you didn’t setup any firewall on the OS level, connections may be blocked by the cloud firewall. Please login to your cloud account and make sure that all required ports are open.
Network configuration
Configure hostname
[root@ecc ~]# hostname ecc.localdomain |
Ensure that it’s resolved into an IP address either by DNS or by adding an alias into /etc/hosts file.
Also make sure that ECC server can reach EBS server via hostname. Example of /etc/hosts file:
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 127.0.0.1 ecc.localdomain ecc 192.168.1.2 demo.enginatics.com demo |
Create OS users and groups
Our ECC installation is owned by oracle user and oinstall group:
groupadd oinstall
useradd -g oinstall oracle |
Install additional OS packages
If you performed minimal Oracle Linux installation like I did, some required packages may be missing. Please install them using the following commands:
#psmisc provides fuser yum install psmisc #bind-utils provides host command yum install bind-utils |
Download and install quick install package
Create directory for ECC installation root. Example: /u01. It will be referred as $ECC_BASE
Download patch 28779983 from MOS
Unzip patch into a stage directory
unzip p28779983_R12_GENERIC.zip |
Copy the .bsx file to the $ECC_BASE directory. Add executable permissions to it
chmod +x *.bsx |
From $ECC_BASE directory, execute installer:
for f in *.bsx; do sh $f; done |
Installer creates two directories:
insta_client: The SQL*Plus client directory
Oracle: Oracle Enterprise Command Center Framework quick install scripts and software
EBS 12.2.8 required patches
EBS patches need to be applied before configuring ECC. Below list of patches is specific for our EBS 12.2.8 instance as we have already applied some of the patches listed as required. First two patches: ATG consolidated patch and adapter patch are mandatory. Other patches depend on the products with Enterprise Command Centers that you want to use and installed languages.
You can refer to the following post to check if a EBS patch is applied.
Patches must be applied in the order below and shouldn’t be merged. I merged command center patches though after applying first two patches separately.
Please note that patch list is unique for every EBS instance and below patches shouldn’t be applied in your system blindly!
[-]28780020:R12.ATG_PF.C ATG consolidated patch for 12.2.8 release [-]28780241:R12.ATG_PF.C. adapter patch [-]28780031:R12.FIN_PF.C Financials consolidated patch. [-]28816408:R12.CC_PF.C //Customer Relationship Management consolidated patch [-]28779987:R12.PRC_PF.C // Procurement consolidated patch [-]29008305:R12.PJ_PF.C // Projects consolidated patch [-]28780037:R12.SCM_PF.C //Supply Chain Management consolidated patch [-]29760524:R12.BOM.D // Supply Chain Management Command Centers required patch [-]29551366:R12.FA.C // Oracle Assets Command Center required patch [-]29622411:R12.PO.D // Oracle Contract Lifecycle Management for Public Sector Command Center [-]29550207:R12.EAM.C // Oracle Enterprise Asset Management Command Center [-]29551003:R12.ICX.D // Oracle iProcurement [-]29551335:R12.AP.C // Oracle Payables Command Center [-]28969483:R12.OKL.C // Oracle Lease and Finance Management Command Center [+]12.2.3 [+]R12.AD.C.delta.7 [+]19060002 //R12.FIN_PF.C.Delta.5 [+]19245366 //R12.ATG_PF.C.Delta.5 Release [+]R12.TXK.C.delta.7 [+]18106421:R12.XLA.C – Import AAD With Overwrite Option for FAH Customers (bug 18106421) [+]26922723:R12.FA.C - ALLOW FULL RETIREMENT OVERLAPPING ADJ WHEN AMORTIZED ADJUSTMENTS IN PRIOR [+]27193501:R12.FA.C - CONTRACT ID IS BLANKED OUT AFTER PERFORMING UNPLANNED DEPRECIATION [+]26962903:R12.FA.C - ALLOW CONTRACT ID UPDT SEPARATE FROM FINANCIAL ATTRIB UPDT FOR FULLY [-]27673594:R12.FA.C - TRANSFER INTO PARTIAL UNIT DISTRIBUTIONS IN ADDITION PERIOD YIELDS [-]27839335:R12.FA.C - ERROR WHEN PERFORMING MULTIPLE COST AND UNIT ADJUSTMENT IN PERIOD OF [-]26437073:R12.AR.C - NOT ABLE TO APPLY AR PATCH 19663965:R12.AR.C [-]28528332:R12.OKL.C - WHEN APPLYING 12.2 UNIFIED PATCH, XLIFFLOADER.CLASS FAILED FOR ESA [+]25467949:R12.OKS.C – USAGE LIMIT AND CONSOLIDATION BASED BILLING (bug 25467949) [+]25609551:R12.OKS.C – USAGE LIMITAND CONSOLIDATION BASED BILLING PART 2 (bug 25609551) [+]25741450:R12.OKS.C – UNABLE TO ADD ASSET (COUNTER LINE) TO EXISTING USAGE ON AN ACTIVE [+]23229913:R12.OKS.C - 12.1.3 -> 12.2.0 UPGRADE DRIVER WORKER FAILED OKSPDFSD.LDT [+]25780023:R12.OKS.C - CONSOLIDATED GROUP BILLING IS NOT CONSIDER THE ROUND UP AMOUNT [+]20515032:R12.OKS.C - OKS_ACTIVATE_CONTRACT_PUB.ACTIVATE_CONTRACT RETURN STATUS=W WHILE [+]25962587:R12.OKC.C - INVALID VALUE FOR THE COLUMN LINE_RENEWAL_TYPE WHILE CALL OKS TERMINATION [+]26814339:R12.OKS.C - COUNTER BILLING AMOUNT FOR USAGE CONTRACTS IN PREVIEW MODE IS ALWAYS [+]27667083:R12.OKS.C - E.TST1228:OKSHTMLUI:BILLING IS COMPLETED WITH WARNING WHEN CONSOLIDATION [-]29359390:R12.ONT.C // Oracle Order Management Command Center with Order Management Release 12.2.4 [-]29602948:R12.GMO.C // Oracle Process Manufacturing Command Center [-]29556032:R12.AR.C // Oracle Receivables Command Center [-]29592222:R12.OKS.C // Oracle Service Contracts Command Center [-]17361679:R12.ONT.C // Incremental load of data performance related patch [-]19766498:R12.HZ.C // Incremental load of data performance related patch [-]27073573:R12.INV.C // Incremental load of data performance related patch [-]29419432:R12.JTT.C Patch for working in Arabic with ECC [-]29179916 Customer Relationship Management help [-]29179895 Financials online help [-]29179889 procurement online help [-]29179908 projects online help [-]29179822 Supply Chain Management online help |
Example of adop apply phase commands is presented below:
{ echo $appspass; echo $systempass; echo $wlspass; }| adop phase=apply patchtop=/backup/patches/EBS12.2/ECC patches=28780020,28780020_AR:u28780020.drv,28780020_F:u28780020.drv,28780241,28780241_AR:u28780241.drv,28780241_D:u28780241.drv,28780241_F:u28780241.drv,28780241_ZHS:u28780241.drv { echo $appspass; echo $systempass; echo $wlspass; }| adop phase=apply patchtop=/backup/patches/EBS12.2/ECC patches=29760524:u29760524.drv,29622411_ZHS:u29622411.drv,29622411_F:u29622411.drv,29622411_D:u29622411.drv,29622411_AR:u29622411.drv,29622411:u29622411.drv,29602948_ZHS:u29602948.drv,29602948_F:u29602948.drv,29602948_D:u29602948.drv,29602948_AR:u29602948.drv,29602948:u29602948.drv,29592222_ZHS:u29592222.drv,29592222_F:u29592222.drv,29592222_D:u29592222.drv,29592222_AR:u29592222.drv,29592222:u29592222.drv,29556032_ZHS:u29556032.drv,29556032_F:u29556032.drv,29556032_D:u29556032.drv,29556032_AR:u29556032.drv,29556032:u29556032.drv,29551366_ZHS:u29551366.drv,29551366_F:u29551366.drv,29551366_D:u29551366.drv,29551366_AR:u29551366.drv,29551366:u29551366.drv,29551335_ZHS:u29551335.drv,29551335_F:u29551335.drv,29551335_D:u29551335.drv,29551335_AR:u29551335.drv,29551335:u29551335.drv,29551003:u29551003.drv,29550207:u29550207.drv,29359390_ZHS:u29359390.drv,29359390_F:u29359390.drv,29359390_D:u29359390.drv,29359390_AR:u29359390.drv,29359390:u29359390.drv,29008305_ZHS:u29008305.drv,29008305_F:u29008305.drv,29008305_D:u29008305.drv,29008305_AR:u29008305.drv,29008305:u29008305.drv,28969483_ZHS:u28969483.drv,28969483_F:u28969483.drv,28969483_D:u28969483.drv,28969483_AR:u28969483.drv,28969483:u28969483.drv,28816408_ZHS:u28816408.drv,28816408_F:u28816408.drv,28816408_D:u28816408.drv,28816408_AR:u28816408.drv,28816408:u28816408.drv,28780037_ZHS:u28780037.drv,28780037_F:u28780037.drv,28780037_D:u28780037.drv,28780037_AR:u28780037.drv,28780037:u28780037.drv,28779987_ZHS:u28779987.drv,28779987_F:u28779987.drv,28779987_D:u28779987.drv,28779987_AR:u28779987.drv,28779987:u28779987.drv,28528332_ZHS:u28528332.drv,28528332_F:u28528332.drv,28528332_D:u28528332.drv,28528332_AR:u28528332.drv,28528332:u28528332.drv,27839335_ZHS:u27839335.drv,27839335_F:u27839335.drv,27839335_D:u27839335.drv,27839335_AR:u27839335.drv,27839335:u27839335.drv,27673594_ZHS:u27673594.drv,27673594_F:u27673594.drv,27673594_D:u27673594.drv,27673594_AR:u27673594.drv,27673594:u27673594.drv,27073573:u27073573.drv,26437073_ZHS:u26437073.drv,26437073_F:u26437073.drv,26437073_D:u26437073.drv,26437073_AR:u26437073.drv,26437073:u26437073.drv,19766498:u19766498.drv,17361679:u17361679.drv,28780031,28780031_AR:u28780031.drv,28780031_D:u28780031.drv,28780031_F:u28780031.drv,29419432,29179916,29179895,29179889,29179908,29179822 merge=yes |
Configure the Oracle Enterprise Command Center installation
Database setup
ECC configuration includes setting up the database, ECC Framework and EBS integration.
For the full description of the parameters please refer to the Doc ID 2495053.1. I provide example config file below:
[oracle@ecc quickInstall]$ cat EccConfig.properties # Path of the ECC directory ECC_BASE=/u01 # Directory location of ecc-config.properties ECC_CONFIG_LOC=$ECC_BASE/Oracle/quickInstall/env/ecc # Log directories for ECC and SOLR ECC_LOG_DIR=$ECC_BASE/Oracle/quickInstall/logs/ecc # Ebs Middletier properties EBS_MIDDLETIER_HOST_FQDN=demo.enginatics.com EBS_MIDDLETIER_PORT=80 EBS_MIDDLETIER_PROTOCOL=http # Ebs Middletier DB Details EBS_DB_URL=jdbc:oracle:thin:@demo.enginatics.com:1521:EBSDB EBS_DB_USERNAME=apps EBS_ECC_USER=DEVELOPER TIMEZONE=CET # ECC DB Details ECC_DB_URL=jdbc:oracle:thin:@demo.enginatics.com:1521:EBSDB ECC_DB_USERNAME=ECC ECC_HOST_NAME=ecc.enginatics.com ECC_HOST_PROTOCOL=http #Zookeeper host url zkHost=localhost:2181/solr #SECURITY_FILTER_ALLOWED_HOSTS= # clustering mode enabled or standalone CLUSTER_MODE=standalone ECC_DATA_CACHE_SIZE=2000 ECC_ADMIN_PORT=7775 ECC_MANAGED_PORT=7776 ECC_ADMIN_SSL_PORT=7777 ECC_MANAGED_SSL_PORT=7778 #Heap Memory settings ADMIN_HEAP_USER_MEM=1024M MANAGED_HEAP_USER_MEM=2048M ECC_DEFAULT_LANGUAGE=en #ECC supported languages comma separated ECC_LANGUAGES=en #Dataset replication distributes complete copies of dataset index to one or more other servers. #value 1 means no replication, value 2 means the index will be exist in two servers and so on #DATASET_NUM_REPLICAS= #options solr or olt DATASET_ANALYZER_DEFAULT=solr DATASET_ANALYZER_OVERRIDE_SOLR_DATASETS= DATASET_ANALYZER_OVERRIDE_OLT_DATASETS= CLUSTER_JPA_MANAGER=zookeeper |
Run script to update environment file
$ECC_BASE/Oracle/quickInstall/createEnvFile.sh |
Run envSetup.sh script
Choose option “1. Database Setup”
[oracle@ecc quickInstall]$ source ./env/ecc.env [oracle@ecc quickInstall]$ ./envSetup.sh Select which option you want to proceed with 1. Database Setup 2. Install Weblogic Server 3. Create ECC Domain 4. Create EBS JNDI 5. Integrate ECC with EBS 6. Exit: 1 Selected ECC DB is jdbc:oracle:thin:@demo.enginatics.com:1521:EBSDB Is the user ECC existing in ECC database [y/n]? n Enter the database system user name: system Enter the database system password: Enter the password for ECC DB user ECC (Passwords must be at least 8 characters long): Confirm the password for user ECC : Creating ECC... ECC user created successfully Creating ECC schema... ECC schema created successfully |
Verify connection to new ECC schema
sqlplus $ECC_DB_USER@\"$ECC_DB_CONNECTION\" Enter password: SQL*Plus: Release 12.2.0.1.0 Production on Fri May 31 17:38:20 2019 Copyright (c) 1982, 2016, Oracle. All rights reserved. Enter password: Last Successful login time: Fri May 31 2019 14:54:54 +02:00 Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> show user; USER is "ECC" |
Set Up Oracle Enterprise Command Center Framework
Choose options 2 and 3 to perform setup.
Example output is presented below:
Select which option you want to proceed with 1. Database Setup 2. Install Weblogic Server 3. Create ECC Domain 4. Create EBS JNDI 5. Integrate ECC with EBS 6. Exit: 2 Launcher log file is /tmp/OraInstall2019-05-24_09-46-46AM/launcher2019-05-24_09-46-46AM.log. Extracting the installer . . . . . . . . . . . . . . . . . . . . Done Checking if CPU speed is above 300 MHz. Actual 3696.282 MHz Passed Checking swap space: must be greater than 512 MB. Actual 4087 MB Passed Checking if this platform requires a 64-bit JVM. Actual 64 Passed (64-bit not required) Checking temp space: must be greater than 300 MB. Actual 3506 MB Passed Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2019-05-24_09-46-46AM Log: /tmp/OraInstall2019-05-24_09-46-46AM/install2019-05-24_09-46-46AM.log Copyright (c) 1996, 2017, Oracle and/or its affiliates. All rights reserved. Reading response file.. Skipping Software Updates Starting check : CertifiedVersions Expected result: One of oracle-6, oracle-7, redhat-7, redhat-6, SuSE-11, SuSE-12 Actual Result: oracle-7.6 Check complete. The overall result of this check is: Passed CertifiedVersions Check: Success. Starting check : CheckJDKVersion Expected result: 1.8.0_131 Actual Result: 1.8.0_141 Check complete. The overall result of this check is: Passed CheckJDKVersion Check: Success. Validations are enabled for this session. Verifying data Copying Files Percent Complete : 10 Percent Complete : 20 Percent Complete : 30 Percent Complete : 40 Percent Complete : 50 Percent Complete : 60 Percent Complete : 70 Percent Complete : 80 Percent Complete : 90 Percent Complete : 100 The installation of Oracle Fusion Middleware 12c WebLogic Server and Coherence 12.2.1.3.0 completed successfully. Logs successfully copied to /u01/ecc_demo/Oracle/software/oraInventory/logs. |
Issue
Faced following error during ECC Domain creation:
Connectiong to t3://localhost:7775 to create JNDI for url:jdbc:oracle:thin:@demo.enginatics.com:1521:EBSDB Connecting to t3://localhost:7775 with userid weblogic ... This Exception occurred at Mon May 27 10:05:45 CEST 2019. javax.naming.CommunicationException: Failed to initialize JNDI context, tried 2 time or times totally, the interval of each time is 0ms. t3://localhost:7775: Destination 0:0:0:0:0:0:0:1, 7775 unreachable.; nested exception is: java.net.ConnectException: Connection refused (Connection refused); No available router to destination.; nested exception is: java.rmi.ConnectException: No available router to destination. [Root exception is java.net.ConnectException: t3://localhost:7775: Destination 0:0:0:0:0:0:0:1, 7775 unreachable.; nested exception is: java.net.ConnectException: Connection refused (Connection refused); No available router to destination.; nested exception is: java.rmi.ConnectException: No available router to destination.] Problem invoking WLST - Traceback (innermost last): File "/u01/ecc_demo/Oracle/software/temp/createJndi.py", line 22, in ? File "", line 19, in connect File "", line 553, in raiseWLSTException WLSTException: Error occurred while performing connect : Error getting the initial context. There is no server running at t3://localhost:7775 : Failed to initialize JNDI context, tried 2 time or times totally, the interval of each time is 0ms. t3://localhost:7775: Destination 0:0:0:0:0:0:0:1, 7775 unreachable.; nested exception is: java.net.ConnectException: Connection refused (Connection refused); No available router to destination.; nested exception is: java.rmi.ConnectException: No available router to destination. Use dumpStack() to view the full stacktrace : |
Root cause
ECC domain wasn’t unpacked completely. Logfile didn’t show unpacking actually started:
<< read template from "/u01/ecc_demo/Oracle/software/weblogic/templates/ecc_domain_template.jar" >> succeed: read template from "/u01/ecc_demo/Oracle/software/weblogic/templates/ecc_domain_template.jar" << set config option JavaHome to "/u01/ecc_demo/Oracle/software/java/jdk" >> succeed: set config option JavaHome to "/u01/ecc_demo/Oracle/software/java/jdk" << set config option ServerStartMode to "prod" >> succeed: set config option ServerStartMode to "prod" << find Security "ecc_domain" as obj0 << find Security "ecc_domain" as obj1 << find Security "ecc_domain" as obj2 << find Security!User "ecc_domain!weblogic" as obj3 >> succeed: find Security!User "ecc_domain!weblogic" as obj3 << find User "weblogic" as obj4 >> succeed: find User "weblogic" as obj4 |
Password for ECC admin user weblogic contained 8 characters, but wasn’t secure enough. I added special character and number to password and script executed without the issue.
Ecc domain creation output
Select which option you want to proceed with 1. Database Setup 2. Install Weblogic Server 3. Create ECC Domain 4. Create EBS JNDI 5. Integrate ECC with EBS 6. Exit: 3 Enter the password for ECC DB user ECC : Enter the password for ECC admin user weblogic (Passwords must be at least 8 characters long): Confirm the password for ECC admin user weblogic : Creating ECC Domain ... Configuring the wallet << read template from "/u01/ecc_demo/Oracle/software/weblogic/templates/ecc_domain_template.jar" >> succeed: read template from "/u01/ecc_demo/Oracle/software/weblogic/templates/ecc_domain_template.jar" << set config option JavaHome to "/u01/ecc_demo/Oracle/software/java/jdk" >> succeed: set config option JavaHome to "/u01/ecc_demo/Oracle/software/java/jdk" << set config option ServerStartMode to "prod" >> succeed: set config option ServerStartMode to "prod" << find Security "ecc_domain" as obj0 << find Security "ecc_domain" as obj1 << find Security "ecc_domain" as obj2 << find Security!User "ecc_domain!weblogic" as obj3 >> succeed: find Security!User "ecc_domain!weblogic" as obj3 << find User "weblogic" as obj4 >> succeed: find User "weblogic" as obj4 << set obj4 attribute Password to "********" >> succeed: set obj4 attribute Password to "********" << set obj4 attribute IsDefaultAdmin to "true" >> succeed: set obj4 attribute IsDefaultAdmin to "true" >> validateConfig "KeyStorePasswords" >> succeed: validateConfig "KeyStorePasswords" << write Domain to "/u01/ecc_demo/Oracle/Middleware/user_projects/domains/ecc_domain" .................................................. >> succeed: write Domain to "/u01/ecc_demo/Oracle/Middleware/user_projects/domains/ecc_domain" << close template >> succeed: close template ECC Domain is created... ECC Log directory is: /u01/ecc_demo/Oracle/quickInstall/logs/ecc Updating ECC Domain with the Config properties location /u01/ecc_demo/Oracle/quickInstall/env/ecc/ecc-config.properties ecc.log.path update in /u01/ecc_demo/Oracle/quickInstall/env/ecc/ecc-config.properties successful zkHost.url update in /ecc-config.properties successful ecc.languages update in /ecc-config.properties successful ecc.base_language update in /ecc-config.properties successful dataset.analyzer.default update in /ecc-config.properties successful dataset.analyzer.override.solr.datasets update in /ecc-config.properties successful dataset.analyzer.override.olt.datasets update in /ecc-config.properties successful cluster.jpa.manager update in /ecc-config.properties successful rmi.url update in /ecc-config.properties successful Starting ECC high availability configuation script. Configuring ECC in single mode. zookeeper numbers 1 updating dataset.num.replicas=1 dataset.num.replicas update in /ecc-config.properties successful eccConfigLocation jvm property configured for eccManaged Server Configuring WLS servers ports ... CLASSPATH=/u01/ecc_demo/Oracle/software/java/jdk/lib/tools.jar:/u01/ecc_demo/Oracle/Middleware/wlserver/modules/features/wlst.wls.classpath.jar: PATH=/u01/ecc_demo/Oracle/Middleware/wlserver/server/bin:/u01/ecc_demo/Oracle/Middleware/wlserver/../oracle_common/modules/thirdparty/org.apache.ant/1.9.8.0.0/apache-ant-1.9.8/bin:/u01/ecc_demo/Oracle/software/java/jdk/jre/bin:/u01/ecc_demo/Oracle/software/java/jdk/bin:/u01/ecc_demo/Oracle/software/java/jdk/bin:/u01/insta_client:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/oracle/.local/bin:/home/oracle/bin:/u01/ecc_demo/Oracle/Middleware/wlserver/../oracle_common/modules/org.apache.maven_3.2.5/bin Your environment has been set. Initializing WebLogic Scripting Tool (WLST) ... Welcome to WebLogic Server Administration Scripting Shell Type help() for help on available commands Exiting WebLogic Scripting Tool. WLS ports configured successfully for ECC Configuring WLS servers SSL ports ... CLASSPATH=/u01/ecc_demo/Oracle/software/java/jdk/lib/tools.jar:/u01/ecc_demo/Oracle/Middleware/wlserver/modules/features/wlst.wls.classpath.jar: PATH=/u01/ecc_demo/Oracle/Middleware/wlserver/server/bin:/u01/ecc_demo/Oracle/Middleware/wlserver/../oracle_common/modules/thirdparty/org.apache.ant/1.9.8.0.0/apache-ant-1.9.8/bin:/u01/ecc_demo/Oracle/software/java/jdk/jre/bin:/u01/ecc_demo/Oracle/software/java/jdk/bin:/u01/ecc_demo/Oracle/software/java/jdk/bin:/u01/insta_client:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/oracle/.local/bin:/home/oracle/bin:/u01/ecc_demo/Oracle/Middleware/wlserver/../oracle_common/modules/org.apache.maven_3.2.5/bin Your environment has been set. Initializing WebLogic Scripting Tool (WLST) ... Welcome to WebLogic Server Administration Scripting Shell Type help() for help on available commands Exiting WebLogic Scripting Tool. WLS SSL ports configured successfully for ECC Updating ECC Domain for Heap space... Done updating ECC Domain for Heap space... Starting ECC Domain Admin Server ... Started the ECC Admin Server successfully Creating JNDI for ECC schema... CLASSPATH=/u01/ecc_demo/Oracle/software/java/jdk/lib/tools.jar:/u01/ecc_demo/Oracle/Middleware/wlserver/modules/features/wlst.wls.classpath.jar: PATH=/u01/ecc_demo/Oracle/Middleware/wlserver/server/bin:/u01/ecc_demo/Oracle/Middleware/wlserver/../oracle_common/modules/thirdparty/org.apache.ant/1.9.8.0.0/apache-ant-1.9.8/bin:/u01/ecc_demo/Oracle/software/java/jdk/jre/bin:/u01/ecc_demo/Oracle/software/java/jdk/bin:/u01/ecc_demo/Oracle/software/java/jdk/bin:/u01/insta_client:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/oracle/.local/bin:/home/oracle/bin:/u01/ecc_demo/Oracle/Middleware/wlserver/../oracle_common/modules/org.apache.maven_3.2.5/bin Your environment has been set. Initializing WebLogic Scripting Tool (WLST) ... Welcome to WebLogic Server Administration Scripting Shell Type help() for help on available commands Connectiong to t3://localhost:7775 to create JNDI for url:jdbc:oracle:thin:@demo.enginatics.com:1521:EBSDB Connecting to t3://localhost:7775 with userid weblogic ... Successfully connected to Admin Server "AdminServer" that belongs to domain "ecc_domain". Warning: An insecure protocol was used to connect to the server. To ensure on-the-wire security, the SSL port or Admin port should be used instead. Location changed to edit tree. This is a writable tree with DomainMBean as the root. To make changes you will need to start an edit session via startEdit(). For more help, use help('edit'). Starting an edit session ... Started edit session, be sure to save and activate your changes once you are done. No stack trace available. eccdb does not exist Saving all your changes ... Saved all your changes successfully. Activating all your changes, this may take a while ... The edit lock associated with this edit session is released once the activation is completed. Activation completed eccdb created Successfully Disconnected from weblogic server: AdminServer JNDI setup successfully for ECC data source old 5: l_conn_string VARCHAR2(300) :='&&2'; new 5: l_conn_string VARCHAR2(300) :='demo.enginatics.com:1521/EBSDB'; old 6: l_conn_name VARCHAR2(30) := '&&1'; new 6: l_conn_name VARCHAR2(30) := 'ebsdb'; Starting creating connections with parameters : connection Name :ebsdb Connection String : demo.enginatics.com:1521/EBSDB port pos = 21 sid pos = 26 port pos = 21 sid pos = 26 l_hostname = demo.enginatics.com l_port = 1521 l_service_name = EBSDB l_conn_name = ebsdb created connection with parameters : connection Name :ebsdb Connection String : demo.enginatics.com:1521/EBSDB PL/SQL procedure successfully completed. old 8: l_conn_string VARCHAR2(300) :='&&3'; new 8: l_conn_string VARCHAR2(300) :='http://ecc.enginatics.com:7776'; old 9: l_conn_name VARCHAR2(30) := '&&1'; new 9: l_conn_name VARCHAR2(30) := 'ebsdb'; old 10: l_system_name VARCHAR2(100) := '&&2'; new 10: l_system_name VARCHAR2(100) := 'EBS'; Creating Source System with Parameters : Connection String = http://ecc.enginatics.com:7776 Connection Name = ebsdb System Name = EBS Creating Source System with System Name = EBS already exists . Deleting and creating again Creating Source System with Parameters : Connection String = http://ecc.enginatics.com:7776 Connection Name = ebsdb System Name = EBS protcol = http: protcol = http: protcol = http protoppos = 8 port_pos = 26 l_hostname =ecc.enginatics.com l_port =7776 Created Source System with Parameters : Created Source System with Parameters : Connection String = http://ecc.enginatics.com:7776 Connection Name = ebsdb System Name = EBS PL/SQL procedure successfully completed. ZooKeeper JMX enabled by default Using config: /u01/ecc_demo/Oracle/software/zookeeper/bin/../conf/zoo.cfg Starting zookeeper ... STARTED Zookeeper started. Starting Managed Server Starting the eccManaged ... Started the eccManaged successfully Configured the ECC domain successfully. |
Confirm that both admin and managed servers started
[root@ecc quickInstall]# vi /u01/ecc_demo/Oracle/Middleware/user_projects/domains/ecc_domain/bin/domain.log [root@ecc quickInstall]# vi /u01/ecc_demo/Oracle/Middleware/user_projects/domains/ecc_domain/bin/ecc.log |
Search for message “The server started in RUNNING mode”
Login to ECC admin url:
http://[ECC_HOST_NAME]:[ECC_MANAGED_PORT]/ecc |
Example:
http://ecc.enginatics.com:7776/ecc/ |
Configuring the JNDI to Connect to Oracle E-Business Suite:
Login to EBS apps node and find dbc file under $FND_SECURE directory.
Run following command, providing FQDN of ecc host and full path to dbc file:
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] |
Example:
java oracle.apps.fnd.security.AdminDesktop apps/$pass CREATE NODE_NAME=ecc.enginatics.com DBC=/u01/install/APPS/fs2/inst/apps/EBSDB_apps/appl/fnd/12.0.0/secure/EBSDB.dbc |
Copy generated dbc file to the ECC server under quickInstall directory as follows:
[oracle@demo secure]$ scp EBSDB_ECC.ENGINATICS.COM.dbc oracle@ecc.enginatics.com:/u01/ecc_demo/Oracle/quickInstall/connection.dbc |
Login to EBS as user with administrative privileges
Сhoose User Management Responsibility > Users function
Add UMX|APPS_SCHEMA_CONNECT role to the EBS_ECC_USER user in EccConfig.properties as per Doc ID 1556742.1
Otherwise you may get error:
weblogic.application.ModuleException: weblogic.common.resourcepool.ResourceSystemException: Could not create connection for datasource 'ebsDB'. The returned message is: ORA-01017: invalid username/password; logon denied |
Another possible cause of this error: make sure that HOST in connection.dbc is resolvable from ECC server.
APPS_JDBC_URL=jdbc\:oracle\:thin\:@(DESCRIPTION\=(ADDRESS_LIST\=(LOAD_BALANCE\=YES)(FAILOVER\=YES)(ADDRESS\=(PROTOCOL\=tcp)(<strong>HOST\=demo.enginatics.com</strong>)(PORT\=1521) ))(CONNECT_DATA\=(SERVICE_NAME\=EBSDB))) |
Script output:
4 Creating JNDI .... Checking connection.dbc file availability... DBC file /u01/ecc_demo/Oracle/quickInstall/connection.dbc available Enter the EBS apps password: Verify if the Node is registered in the EBS database... Node name ECC.ENGINATICS.COM EBS_ECC_USER DEVELOPER DB URL demo.enginatics.com:1521/EBSDB Node is registerd in EBS Check if the FND USER DEVELOPER exists User DEVELOPER already exists in FND_USER. Validating user Enter password: User DEVELOPER successfully validated Provide ECC admin credentials for JNDI setup Enter the password for weblogic admin for ECC domain : Creating JNDI for ECC to access EBS DB... CLASSPATH=/u01/ecc_demo/Oracle/software/java/jdk/lib/tools.jar:/u01/ecc_demo/Oracle/Middleware/wlserver/modules/features/wlst.wls.classpath.jar: PATH=/u01/ecc_demo/Oracle/Middleware/wlserver/server/bin:/u01/ecc_demo/Oracle/Middleware/wlserver/../oracle_common/modules/thirdparty/org.apache.ant/1.9.8.0.0/apache-ant-1.9.8/bin:/u01/ecc_demo/Oracle/software/java/jdk/jre/bin:/u01/ecc_demo/Oracle/software/java/jdk/bin:/u01/ecc_demo/Oracle/software/java/jdk/bin:/u01/insta_client:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/oracle/.local/bin:/home/oracle/bin:/u01/ecc_demo/Oracle/Middleware/wlserver/../oracle_common/modules/org.apache.maven_3.2.5/bin Your environment has been set. Initializing WebLogic Scripting Tool (WLST) ... Welcome to WebLogic Server Administration Scripting Shell Type help() for help on available commands Connecting to t3://localhost:7775 with userid weblogic ... Successfully connected to Admin Server "AdminServer" that belongs to domain "ecc_domain". Warning: An insecure protocol was used to connect to the server. To ensure on-the-wire security, the SSL port or Admin port should be used instead. Location changed to edit tree. This is a writable tree with DomainMBean as the root. To make changes you will need to start an edit session via startEdit(). For more help, use help('edit'). Starting an edit session ... Started edit session, be sure to save and activate your changes once you are done. No stack trace available. ebsDB does not exist Saving all your changes ... Saved all your changes successfully. Activating all your changes, this may take a while ... The edit lock associated with this edit session is released once the activation is completed. Activation completed Disconnected from weblogic server: AdminServer JNDI created for EBS database... |
Testing
Log in to the Oracle EСС domain admin console at the following URL: http://[ECC_HOST_NAME]:[ECC_ADMIN_PORT]/console
Example: http://ecc.enginatics.com:7775/console
Go to Services > Data Sources.
Select the ebsdb JNDI configuration in the right pane.
Navigate to the Monitoring tab and select the Testing subtab.
Select the managed server and choose the Test Data Source button. The following message should appear: Success Test of ebsdb on server was successful.
Integrate Oracle Enterprise Command Center Framework with Oracle E-Business Suite
Choose option 5, Integrate With EBS of the envSetup.sh script
5 Proceed with Integration? confirm(y) otherwise(n): y |
Error:
weblogic.management.provider.UpdateException: [Management:141190]The commit phase of the configuration update failed with an exception. Problem invoking WLST - Traceback (innermost last): File "/u01/ecc_demo/Oracle/software/temp/setConnFiltersEccServer.py", line 58, in ? File "", line 481, in activate File "", line 553, in raiseWLSTException WLSTException: Error occurred while performing activate : Error while Activating changes. : [Management:141190]The commit phase of the configuration update failed with an exception. Use dumpStack() to view the full stacktrace : Connection Filters cannot be applied.. Done. |
Found additional errors in /u01/ecc_demo/Oracle/Middleware/user_projects/domains/ecc_domain/servers/AdminServer/logs/AdminServer.log:
weblogic.utils.NestedRuntimeException: [Security:090233]problem with connection filter rules Caused By: java.text.ParseException: demo: Name or service not known |
demo.enginatics.com is resolved by DNS, but ecc installer for some reason wants to use hostname separately.
Fix:
Add hostname entry to /etc/hosts:
192.168.1.2 demo |
Rerun setup
5 Proceed with Integration? confirm(y) otherwise(n): y Enter the password for ECC DB user ECC : Enter the password for ECC admin user weblogic : Updating EBS Security Manager old 1: update ECC_SOURCE_SYSTEM set SECURITY_MANAGER='&1' where SYSTEM_NAME='EBS' new 1: update ECC_SOURCE_SYSTEM set SECURITY_MANAGER='oracle.ecc.security.extensions.EbsEccSecurityManager' where SYSTEM_NAME='EBS' 1 row updated. Commit complete. Done Restarting the ECC managed server Stopping ECC Managed Server ... Stopping Weblogic Server... Initializing WebLogic Scripting Tool (WLST) ... Welcome to WebLogic Server Administration Scripting Shell Type help() for help on available commands Connecting to t3://localhost:7775 with userid weblogic ... Successfully connected to Admin Server "AdminServer" that belongs to domain "ecc_domain". Warning: An insecure protocol was used to connect to the server. To ensure on-the-wire security, the SSL port or Admin port should be used instead. Shutting down the server eccManaged with force=false while connected to AdminServer ... .............. Exiting WebLogic Scripting Tool. Done Stopping Derby Server... Derby server stopped. ZooKeeper JMX enabled by default Using config: /u01/ecc_demo/Oracle/software/zookeeper/bin/../conf/zoo.cfg Stopping zookeeper ... STOPPED ZooKeeper JMX enabled by default Using config: /u01/ecc_demo/Oracle/software/zookeeper/bin/../conf/zoo.cfg Starting zookeeper ... STARTED Zookeeper started. Starting Managed Server Starting the eccManaged ... Started the eccManaged successfully EBS_IP6 is 192.168.1.2 EBS_IP4 is 192.168.1.2 Setting Connection Filter for ECC Server ... CLASSPATH=/u01/ecc_demo/Oracle/software/java/jdk/lib/tools.jar:/u01/ecc_demo/Oracle/Middleware/wlserver/modules/features/wlst.wls.classpath.jar: PATH=/u01/ecc_demo/Oracle/Middleware/wlserver/server/bin:/u01/ecc_demo/Oracle/Middleware/wlserver/../oracle_common/modules/thirdparty/org.apache.ant/1.9.8.0.0/apache-ant-1.9.8/bin:/u01/ecc_demo/Oracle/software/java/jdk/jre/bin:/u01/ecc_demo/Oracle/software/java/jdk/bin:/u01/ecc_demo/Oracle/software/java/jdk/bin:/u01/insta_client:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/oracle/.local/bin:/home/oracle/bin:/u01/ecc_demo/Oracle/Middleware/wlserver/../oracle_common/modules/org.apache.maven_3.2.5/bin Your environment has been set. Initializing WebLogic Scripting Tool (WLST) ... Welcome to WebLogic Server Administration Scripting Shell Type help() for help on available commands Connecting to t3://localhost:7775 with userid weblogic ... Successfully connected to Admin Server "AdminServer" that belongs to domain "ecc_domain". Warning: An insecure protocol was used to connect to the server. To ensure on-the-wire security, the SSL port or Admin port should be used instead. Location changed to domainConfig tree. This is a read-only tree with DomainMBean as the root MBean. For more help, use help('domainConfig') Location changed to domainRuntime tree. This is a read-only tree with DomainMBean as the root MBean. For more help, use help('domainRuntime') Server name AdminServer IPv4URL t3://127.0.0.1:7775 t3://[0:0:0:0:0:0:0:1%lo]:7775 Location changed to edit tree. This is a writable tree with DomainMBean as the root. To make changes you will need to start an edit session via startEdit(). For more help, use help('edit'). Starting an edit session ... Started edit session, be sure to save and activate your changes once you are done. Saving all your changes ... Saved all your changes successfully. Activating all your changes, this may take a while ... The edit lock associated with this edit session is released once the activation is completed. Activation completed Connection Filter is applied sucessfully.. Done. old 8: l_conn_string VARCHAR2(300) :='&&3'; new 8: l_conn_string VARCHAR2(300) :='http://demo.enginatics.com:80'; old 9: l_conn_name VARCHAR2(30) := '&&1'; new 9: l_conn_name VARCHAR2(30) := 'ebsdb'; old 10: l_system_name VARCHAR2(100) := '&&2'; new 10: l_system_name VARCHAR2(100) := 'EBS'; Source System with System Name = EBS already exists . Updating Source System with Parameters : Connection String = http://demo.enginatics.com:80 Connection Name = ebsdb System Name = EBS protcol = http: protcol = http: protcol = http protoppos = 8 port_pos = 29 l_hostname =demo.enginatics.com l_port =80 Updated Source System with Parameters : Connection String = http://demo.enginatics.com:80 Connection Name = ebsdb System Name = EBS PL/SQL procedure successfully completed. |
Edit EBS context variables using OAM
Remove ‘#’ from s_ecc_conf_comment
Before:
After:
Setup following variables accordingly:
s_ecc_protocol – The protocol for accessing the Oracle Enterprise Command Center Framework administration UI.
s_ecc_web_host – The Oracle Enterprise Command Center Framework host name.
s_ecc_managed_server_port – The port for the Oracle Enterprise Command Center Framework manager server.
Example:
s_ecc_protocol=http
s_ecc_web_host=ecc.enginatics.com
s_ecc_managed_server_port=7776
[oracle@demo ~]$ grep s_ecc $CONTEXT_FILE ecc.enginatics.com 7776 http |
Please make sure that ecc host name is resolved from the EBS server. If it’s not revolved via DNS, add an entry in the /etc/hosts file
88.99.107.178 ecc.enginatics.com ecc |
Run autoconfig
[oracle@demo ~]$ cd $ADMIN_SCRIPTS_HOME [oracle@demo scripts]$ ./adautocfg.sh |
Edit OHS configuration files
Get OHS instance location:
[oracle@demo ~]$ grep -i s_ohs_instance_loc $CONTEXT_FILE /u01/install/APPS/fs1/FMW_Home/webtier/instances/EBS_web_OHS1 [oracle@demo ~]$ grep -i s_ohs_component $CONTEXT_FILE EBS_web |
Go to directory
s_ohs_instance_loc/config/OHS/s_ohs_component |
[oracle@demo EBS_web]$ cd /u01/install/APPS/fs1/FMW_Home/webtier/instances/EBS_web_OHS1/config/OHS/EBS_web |
Check that OHS configuration file ecc.conf includes the following settings:
RewriteEngine on RewriteRule ^/ecc(.*)$ http://:/%{REQUEST_URI}?system=EBS [CO=GUEST_LANGUAGE_ID::,NE,P,QSA,L] |
Example:
RewriteEngine on RewriteRule ^/ecc$ http://ecc.enginatics.com:7776/ecc/?system=EBS [CO=ORA_ECC_GUEST_LANG:en:demo.enginatics.com,NE,P,QSA,L] |
Restart EBS services
cd $ADMIN_SCRIPTS_HOME ./adstpall.sh ./adstrtal.sh |
Import Enterprise Command Center Applications
In the ECC v2 it was required to copy $ECC_BASE/Oracle/quickInstall/scripts/patchEccFiles.pl script from ecc host to EBS host.
In the newer releases like ECC v9 patchEccFiles.pl is located under $FND_TOP/bin on the EBS host.
Login to EBS server and apply run fs environment.
[oracle@demo ~]$ . ./EBSapps.env run |
Create empty staging directory.
[oracle@demo scripts]$ mkdir /tmp/staging |
Run patchEccFiles.pl script
perl ./patchEccFiles.pl |
[oracle@demo tmp]$perl ./patchEccFiles.pl Enter temporary directory for ECC Files(Should be used only for this task and be empty): /tmp/staging Enter EBS DB apps user id(default: apps) : Enter EBS DB apps user password: List of languages installed in EBS: -------------------------------------------------- | Language| ECC Language Code| -------------------------------------------------- | ARABIC | ar | | GERMAN | de | | FRENCH | fr | | AMERICAN | en | | SIMPLIFIED CHINESE | zh-Hans | --------------------------------------------------- List of languages supported in ECC: Arabic(ar), Brazilian Portugese(pt), Canadian French(fr-CA),Croatian(hr), Cyrillic Kazakh(kk), Cyrillic Serbian(sr), Czech(cs), Danish(da), Dutch(nl), English(en), Finnish(fi), French(fr), German(de), Greek(el), Hebrew(he), Hungarian(hu), Indonesian(id), Italian(it), Japanese(ja), Korean(ko), Latin Spanish(es-419),Latin Serbian(sr-Latn), Lithuanian(lt), Norwegian(no), Polish(pl), Portugese(pt-PT),Romania(ro), Russian(ru), Simplified Chinese(zh-Hans), Slovak(sk), Slovenian(sl), Spanish(es), Swedish(sv), Thai(th), Traditional Chinese(zh-Hant), Turkish(tr), Ukranian(uk), Vietnamese(vi) NOTE: Only languages installed and enabled in ECC will be processed successfully Example: Enter ar,pt for Arabic and Brazilian Portugese language respectively. Enter all(ALL) for all languages Enter the Language code(s) from the list mentioned above to run the translation for: Do you want to add all products at once(Y) or specify the subset(N): Y Adding product top AP Adding product top AR Adding product top BOM Adding product top CN Adding product top CS Adding product top EAM Adding product top FA Adding product top GMO Adding product top ICX Adding product top INV Adding product top JMF Adding product top OKL Adding product top OKS Adding product top ONT Adding product top OZF Adding product top PA Adding product top PO Adding product top WIP Importing application /tmp/staging/ap/12.0.0/patch/115/ecc/applications/ap_ecc.zip ECC WEB ENTRY URL:http://demo.enginatics.com:80/ecc ECC Application File:/tmp/staging/ap/12.0.0/patch/115/ecc/applications/ap_ecc.zip Importing file /tmp/staging/ap/12.0.0/patch/115/ecc/applications/ap_ecc.zip finished with response [{"STATUS":200,"logFileName":"import_20190529095220.log"}] Imported application /tmp/staging/ap/12.0.0/patch/115/ecc/applications/ap_ecc.zip successfully Importing application /tmp/staging/ar/12.0.0/patch/115/ecc/applications/ar_ecc.zip ECC WEB ENTRY URL:http://demo.enginatics.com:80/ecc ECC Application File:/tmp/staging/ar/12.0.0/patch/115/ecc/applications/ar_ecc.zip Importing file /tmp/staging/ar/12.0.0/patch/115/ecc/applications/ar_ecc.zip finished with response [{"STATUS":200,"logFileName":"import_20190529095227.log"}] Imported application /tmp/staging/ar/12.0.0/patch/115/ecc/applications/ar_ecc.zip successfully Importing application /tmp/staging/fa/12.0.0/patch/115/ecc/applications/fa_ecc.zip ECC WEB ENTRY URL:http://demo.enginatics.com:80/ecc ECC Application File:/tmp/staging/fa/12.0.0/patch/115/ecc/applications/fa_ecc.zip Importing file /tmp/staging/fa/12.0.0/patch/115/ecc/applications/fa_ecc.zip finished with response [{"STATUS":200,"logFileName":"import_20190529095228.log"}] Imported application /tmp/staging/fa/12.0.0/patch/115/ecc/applications/fa_ecc.zip successfully Importing application /tmp/staging/okl/12.0.0/patch/115/ecc/applications/okl_ecc.zip ECC WEB ENTRY URL:http://demo.enginatics.com:80/ecc ECC Application File:/tmp/staging/okl/12.0.0/patch/115/ecc/applications/okl_ecc.zip Importing file /tmp/staging/okl/12.0.0/patch/115/ecc/applications/okl_ecc.zip finished with response [{"STATUS":200,"logFileName":"import_20190529095229.log"}] Imported application /tmp/staging/okl/12.0.0/patch/115/ecc/applications/okl_ecc.zip successfully SUMMARY REPORT: ----------------------------------------------- | Product| Application | Status| ----------------------------------------------- | AP | ap_ecc.zip | Success | | AR | ar_ecc.zip | Success | | FA | fa_ecc.zip | Success | | OKL | okl_ecc.zip | Success | ----------------------------------------------- |
Import Enterprise Command Center Applications into TLS enabled EBS instance
In case if the EBS instance is TLS enabled, then make sure that all the configuration steps are performed as per this document:
Enabling TLS in Oracle E-Business Suite Release 12.2 (Doc ID 1367293.1)
Pay attention to the section “5.3 Configure Loopback and Outbound Connections” as it is frequently skipped after the section “5.2 Configure Inbound Connections” is performed.
If you skip the section 5.3 you may face an error similar to the following:
Importing application /tmp/staging/ar/12.0.0/patch/115/ecc/applications/ar_ecc.zip ECC WEB ENTRY URL:https://r122.localdomain:4443/ecc ECC Application File:/tmp/staging/ar/12.0.0/patch/115/ecc/applications/ar_ecc.zip javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target at sun.security.ssl.Alerts.getSSLException(Alerts.java:192) at sun.security.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1897) at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:300) at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:294) |
This issue is described in the following document:
ECC: Error When Attempting to Import Applications in ECC using patchEccFiles.pl – Error: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target (Doc ID 2936137.1)
The steps must be performed for both 64-bit JDK and 32-bit JDK. In case of self-signed certificate, replace ca.crt to the name of the certificate file. The certificate file can be exported from the browser opening the EBS url.
cd [s_fmw_jdktop]/jre/lib/security keytool -import -alias r122SelfSigned -file /tmp/r122.localdomain.crt -v -keystore cacerts cd $OA_JRE_TOP/lib/security keytool -import -alias r122SelfSigned -file /tmp/r122.localdomain.crt -v -keystore cacerts |
Providing administrators access to ECC admin UI
Assign the ECC Developer responsibility to desired user.
Providing administrators access to the ECC core solr application
To allow login to core Solr application from additional hosts apart from ecc and integrated EBS servers:
– Log in to ECC Weblogic admin console.
– Go to Domain Structure->ecc_domain
– Choose Security->Filter->Lock & Edit
– Add allow rule. Below example is for 192.0.1.1
192.0.1.1 * 7776 allow t3 t3s http https
Click ‘Save’ and ‘Activate Changes’
Verify login to Core Solr application by logging in to:
[ECC_HOST_PROTOCOL>]://[ECC_HOST_NAME]:[ECC_PORT]/core_ecc |
Example:
http://ecc.enginatics.com:7776/core_ecc |
Loading product data to ECC
Run concurrent programs for each product to perform data load into the ECC. Programs should also be scheduled to perform periodic incremental loads to update the data.
To find the list of all ECC data loader programs you can run ECC Admin – Concurrent Programs report. This report’s output contains the concurrent program short code which can be used as multiple parameter value entry in FND Access Control report to see which responsibilities or users have access to schedule ECC data loaders.
Example for products that we implemented:
Oracle Payables
Payables Command Center Data Load
To run this request you need to switch to Payables responsibility as it’s not available under System Administrator responsibility. I used ‘Payables manager’ responsibility.
Oracle Receivables
Receivables Command Center Data Load
To run this request you need to switch to Receivables responsibility as it’s not available under System Administrator responsibility. I used ‘Receivables manager’ responsibility.
Issue:
Requests failed with errors:
0:46:23.282 [pool-4-thread-1] DEBUG 1.o.e.i.u.s.i.IRDataLoadServiceImpl - startJob --> job 1976 application ar, collection null was being served by pool-4-thread-1 for load type FULL_LOAD10:46:23.290 [pool-4-thread-1] DEBUG 1.o.e.i.u.s.i.DataLoadControllerServiceImpl - loadDataForDataset --> application ar, collection ar-billproc was being served by pool-4-thread-1 for load type FULL_LOAD10:46:23.306 [pool-4-thread-1] ERROR 1.o.e.i.u.s.i.DataLoadControllerServiceImpl - Collection ar-billproc failed with error There is an error while registering the collection Collection ar-billproc Deletion -> Dataset ar-billproc deletion failed with error Error from server at http://ecc.enginatics.com:7776/core_ecc: Expected mime type application/octet-stream but got text/html.The Server is not able to service this request: [Socket:000445]Connection rejected, filter blocked Socket, weblogic.security.net.FilterException: [Security:090220]rule 14weblogic.security.net.FilterException: [Security:090220]rule 14 at weblogic.security.net.ConnectionFilterImpl.accept(ConnectionFilterImpl.java:163) at weblogic.socket.MuxableSocketDiscriminator.maybeFilter(MuxableSocketDiscriminator.java:253) at weblogic.socket.MuxableSocketDiscriminator.dispatch(MuxableSocketDiscriminator.java:139) at |
Workaround:
EBS host is allowed to access 7776 port, so requests shouldn’t fail. Requests completed after removing following connection filter rule in Weblogic Admin console. Didn’t find other workaround so far.
* * 7776 deny |
To update data, requests can be rerun in INCREMENTAL_LOAD mode.
Providing users access to ECC
Product-specific roles are used to provide access to ECC.
For list of the roles please refer to Doc ID 2495053.1.
Below is the example of role assignment performed in our system.
Providing access manually
In Oracle E-Business Suite, log in to the User Management responsibility, and navigate to the Roles and Role Inheritance page.
Search for desired responsibility
Click the “View In Hierarchy” icon for your responsibility
Click the Add Node icon for your responsibility
Search for the role you want to add and click ‘Select’
Next step is to update the associated grant for the product-specific Enterprise Command Center roles to reference the specific responsibility as the security context.
Click on expand to see the added role and click on update icon for the new role:
If this is the first responsibility to which you are adding to the role, click the Update icon for the grant you want to update.
Enter the name of the responsibility to which ECC role is added and click Apply
After this step Receivables Command Center should appear under Receivables Manager responsibility.
Note: If you don’t see function appear after the responsibility, you may need to clear EBS cache using Functional Administrator responsibility.
Automating access provision using script
To automate roles and grants configuration following script can be used. It should be ran from EBS run fs:
source EBSapps.env run $FND_TOP/bin/UMX_ENDECA_RBACAuto.sh |
It will prompt for csv file location, which should be prepared before running the script. If csv file is called UMX_ENDECA_RBAC.csv and located under same directory as UMX_ENDECA_RBACAuto.sh, it will be used automatically. Example of the file we used in our system to assign payables and receivables ecc roles to Payables manager, Receivables manager and ECC Developer:
PERMISSION_SET_CODE,RESPONSIBILITY_CODE,ENDECA_ROLE_CODE AP_ECC_ACCESS_PS,FND_RESP|SQLAP|PAYABLES_MANAGER|STANDARD,UMX|AP_ECC_ACCESS_ROLE AP_ECC_ACCESS_PS,FND_RESP|FND|ECC_DEVELOPER_RESP|STANDARD,UMX|AP_ECC_ACCESS_ROLE AR_ECC_ACCESS_PS,FND_RESP|AR|RECEIVABLES_MANAGER|STANDARD,UMX|AR_ECC_ACCESS_ROLE AR_ECC_ACCESS_PS,FND_RESP|FND|ECC_DEVELOPER_RESP|STANDARD,UMX|AR_ECC_ACCESS_ROLE IAR_ECC_ACCESS_PS,FND_RESP|FND|ECC_DEVELOPER_RESP|STANDARD,UMX|IAR_ECC_ACCESS_ROLE IAR_ECC_INT_ACCESS_PS,FND_RESP|FND|ECC_DEVELOPER_RESP|STANDARD,UMX|IAR_ECC_INT_ACCESS_ROLE |
Example output:
[oracle@demo bin]$ ./UMX_ENDECA_RBACAuto.sh APPS username: apps APPS password: Executing for Permission_set AP_ECC_ACCESS_PS , Responsibility_name FND_RESP|SQLAP|PAYABLES_MANAGER|STANDARD and Endeca_Role UMX|AP_ECC_ACCESS_ROLE old 6: L_MENU_NAME varchar2(100) := '&1'; new 6: L_MENU_NAME varchar2(100) := 'AP_ECC_ACCESS_PS'; old 8: l_responsibility_name varchar2(300) := '&2'; new 8: l_responsibility_name varchar2(300) := 'FND_RESP|SQLAP|PAYABLES_MANAGER|STANDARD'; old 10: endeca_role_name varchar2(300) := '&3'; new 10: endeca_role_name varchar2(300) := 'UMX|AP_ECC_ACCESS_ROLE'; Completed Successfully. PL/SQL procedure successfully completed. Executing for Permission_set AP_ECC_ACCESS_PS , Responsibility_name FND_RESP|FND|ECC_DEVELOPER_RESP|STANDARD and Endeca_Role UMX|AP_ECC_ACCESS_ROLE old 6: L_MENU_NAME varchar2(100) := '&1'; new 6: L_MENU_NAME varchar2(100) := 'AP_ECC_ACCESS_PS'; old 8: l_responsibility_name varchar2(300) := '&2'; new 8: l_responsibility_name varchar2(300) := 'FND_RESP|FND|ECC_DEVELOPER_RESP|STANDARD'; old 10: endeca_role_name varchar2(300) := '&3'; new 10: endeca_role_name varchar2(300) := 'UMX|AP_ECC_ACCESS_ROLE'; Completed Successfully. PL/SQL procedure successfully completed. Executing for Permission_set AR_ECC_ACCESS_PS , Responsibility_name FND_RESP|AR|RECEIVABLES_MANAGER|STANDARD and Endeca_Role UMX|AR_ECC_ACCESS_ROLE old 6: L_MENU_NAME varchar2(100) := '&1'; new 6: L_MENU_NAME varchar2(100) := 'AR_ECC_ACCESS_PS'; old 8: l_responsibility_name varchar2(300) := '&2'; new 8: l_responsibility_name varchar2(300) := 'FND_RESP|AR|RECEIVABLES_MANAGER|STANDARD'; old 10: endeca_role_name varchar2(300) := '&3'; new 10: endeca_role_name varchar2(300) := 'UMX|AR_ECC_ACCESS_ROLE'; Role - Responsibility relationship already exists Grant already exists PL/SQL procedure successfully completed. Executing for Permission_set AR_ECC_ACCESS_PS , Responsibility_name FND_RESP|FND|ECC_DEVELOPER_RESP|STANDARD and Endeca_Role UMX|AR_ECC_ACCESS_ROLE old 6: L_MENU_NAME varchar2(100) := '&1'; new 6: L_MENU_NAME varchar2(100) := 'AR_ECC_ACCESS_PS'; old 8: l_responsibility_name varchar2(300) := '&2'; new 8: l_responsibility_name varchar2(300) := 'FND_RESP|FND|ECC_DEVELOPER_RESP|STANDARD'; old 10: endeca_role_name varchar2(300) := '&3'; new 10: endeca_role_name varchar2(300) := 'UMX|AR_ECC_ACCESS_ROLE'; Completed Successfully. PL/SQL procedure successfully completed. |
Access provision for all command centers.
I prepared UMX_ENDECA_RBAC.csv containing all responsibilities, permission sets and roles matched between each other.
FA_ECC_ACCESS_PS,FND_RESP|OFA|FIXED_ASSETS_MANAGER|STANDARD,UMX|FA_M_ECC_ACCESS_ROLE FA_ECC_ACCESS_PS,FND_RESP|OFA|FIXED_ASSETS_ACCOUNTANT|STANDARD,UMX|FA_M_ECC_ACCESS_ROLE FA_ECC_ACCESS_PS,FND_RESP|OFA|FIXED_ASSETS_MANAGER|STANDARD,UMX|FA_A_ECC_ACCESS_ROLE FA_ECC_ACCESS_PS,FND_RESP|OFA|FIXED_ASSETS_ACCOUNTANT|STANDARD,UMX|FA_A_ECC_ACCESS_ROLE FA_ECC_ACC_ACCESS_PS,FND_RESP|OFA|FIXED_ASSETS_MANAGER|STANDARD,UMX|FA_M_ECC_ACCESS_ROLE FA_ECC_ACC_ACCESS_PS,FND_RESP|OFA|FIXED_ASSETS_ACCOUNTANT|STANDARD,UMX|FA_M_ECC_ACCESS_ROLE FA_ECC_ACC_ACCESS_PS,FND_RESP|OFA|FIXED_ASSETS_MANAGER|STANDARD,UMX|FA_A_ECC_ACCESS_ROLE FA_ECC_ACC_ACCESS_PS,FND_RESP|OFA|FIXED_ASSETS_ACCOUNTANT|STANDARD,UMX|FA_A_ECC_ACCESS_ROLE OZF_CLAIM_ECC_MENU,FND_RESP|OZF|OZF_USER|STANDARD,UMX|OZF_ECC_ACCESS_ROLE OZF_CLAIM_ECC_MENU,FND_RESP|OZF|OZF_AR_DED_SET_RESP|STANDARD,UMX|OZF_ECC_ACCESS_ROLE PO_CLM_ECC_CO_PS,PUR_CLM_SUPER_USER,UMX|PO_CLM_ECC_CO_ROLE PO_CLM_ECC_PMO_PS,SELF_SERV_CLM_PURCHASING_5,UMX|PO_CLM_ECC_PMO_ROLE CST_ECC_ACCESS_PS,FND_RESP|BOM|COST_MANAGEMENT|STANDARD,UMX|CST_ECC_ACCESS_ROLE CST_ECC_GMF_ACCESS_PS,FND_RESP|BOM|COST_MANAGEMENT|STANDARD,UMX|CST_ECC_ACCESS_ROLE CST_ECC_ACCESS_PS,FND_RESP|CST|COST_MANAGEMENT|STANDARD,UMX|CST_ECC_ACCESS_ROLE CST_ECC_GMF_ACCESS_PS,FND_RESP|CST|COST_MANAGEMENT|STANDARD,UMX|CST_ECC_ACCESS_ROLE CST_ECC_ACCESS_PS,FND_RESP|GMF|OPM_FINANCIALS|STANDARD,UMX|CST_ECC_ACCESS_ROLE CST_ECC_GMF_ACCESS_PS,FND_RESP|GMF|OPM_FINANCIALS|STANDARD,UMX|CST_ECC_ACCESS_ROLE CST_ECC_ACCESS_PS,FND_RESP|BOM|COST_MANAGEMENT|STANDARD,UMX|CST_ECC_GMF_ACCESS_ROLE CST_ECC_GMF_ACCESS_PS,FND_RESP|BOM|COST_MANAGEMENT|STANDARD,UMX|CST_ECC_GMF_ACCESS_ROLE CST_ECC_ACCESS_PS,FND_RESP|CST|COST_MANAGEMENT|STANDARD,UMX|CST_ECC_GMF_ACCESS_ROLE CST_ECC_GMF_ACCESS_PS,FND_RESP|CST|COST_MANAGEMENT|STANDARD,UMX|CST_ECC_GMF_ACCESS_ROLE CST_ECC_ACCESS_PS,FND_RESP|GMF|OPM_FINANCIALS|STANDARD,UMX|CST_ECC_GMF_ACCESS_ROLE CST_ECC_GMF_ACCESS_PS,FND_RESP|GMF|OPM_FINANCIALS|STANDARD,UMX|CST_ECC_GMF_ACCESS_ROLE WIP_ECC_ACCESS_PERM_SET,FND_RESP|MSC|MFG_AND_DIST_SUPER_USER_APS|STANDARD,UMX|WIP_ECC_ACCESS_ROLE EAM_ECC_ACCESS_PS,FND_RESP|EAM|MSU_VIS_OPS|STANDARD,UMX|EAM_ECC_ACCESS_ROLE CN_ICM_ECC_ACCESS_PS,FND_RESP|CN|CN_INC_COMP_MANAGER|STANDARD,UMX|CN_ICM_ECC_ACCESS_ROLE WSH_ECC_DASHBOARD_ACCESS_PS,FND_RESP|INV|INV_HTML|STANDARD,UMX|WSH_ECC_DASHBOARD_ACCESS_ROLE ICX_ECC_ACCESS_PS,FND_RESP|ICX|SELF_SERVICE_PURCHASING_5|STANDARD,UMX|ICX_ECC_ACCESS_ROLE IAR_ECC_ACCESS_PS,FND_RESP|AR|ARI_EXTERNAL|STANDARD,UMX|IAR_ECC_ACCESS_ROLE IAR_ECC_ACCESS_PS,FND_RESP|AR|ARI_EXTERNAL|STANDARD,UMX|IAR_ECC_INT_ACCESS_ROLE IAR_ECC_ACCESS_PS,FND_RESP|AR|ARI_INTERNAL|STANDARD,UMX|IAR_ECC_ACCESS_ROLE IAR_ECC_ACCESS_PS,FND_RESP|AR|ARI_INTERNAL|STANDARD,UMX|IAR_ECC_INT_ACCESS_ROLE IAR_ECC_INT_ACCESS_PS,FND_RESP|AR|ARI_EXTERNAL|STANDARD,UMX|IAR_ECC_ACCESS_ROLE IAR_ECC_INT_ACCESS_PS,FND_RESP|AR|ARI_EXTERNAL|STANDARD,UMX|IAR_ECC_INT_ACCESS_ROLE IAR_ECC_INT_ACCESS_PS,FND_RESP|AR|ARI_INTERNAL|STANDARD,UMX|IAR_ECC_ACCESS_ROLE IAR_ECC_INT_ACCESS_PS,FND_RESP|AR|ARI_INTERNAL|STANDARD,UMX|IAR_ECC_INT_ACCESS_ROLE OKL_ECC_OKL_PS,FND_RESP|OKL|LEASE SUPER USER|STANDARD,UMX|OKL_ECC_ACCESS_ROLE ONT_ECC_PS,FND_RESP|ONT|ONT_HTMLUI_RESP|STANDARD,UMX|ONT_ECC_ROLE JMF_ECC_ACCESS_PS,FND_RESP||JMF||JMF_SHIKYU_SUPER_USER||STANDARD,UMX|JMF_ECC_ACCESS_ROLE AP_ECC_ACCESS_PS,FND_RESP|SQLAP|PAYABLES_MANAGER|STANDARD,UMX|AP_ECC_ACCESS_ROLE GMO_ECC_ACCESS_PS,FND_RESP||GME||PRODUCTION SUPERVISOR||STANDARD,UMX|GMO_ECC_ACCESS_ROLE PA_ECC_ACCESS_PS,FND_RESP|PA|PA_PRM_PROJ_SU_SVCS|STANDARD,UMX|PA_ECC_ACCESS_ROLE AR_ECC_ACCESS_PS,FND_RESP|AR|RECEIVABLES_MANAGER|STANDARD,UMX|AR_ECC_ACCESS_ROLE CS_ECC_SR_MGR_PS,FND_RESP|CS|CS_ECC_SERVICE_MANAGER|STANDARD,UMX|CS_ECC_SR_MGR_ACCESS_ROLE CS_ECC_SR_MGR_PS,FND_RESP|CS|CS_ECC_SERVICE_MANAGER|STANDARD,UMX|CS_ECC_SR_AGNT_ACCESS_ROLE CS_ECC_SR_MGR_PS,FND_RESP|CS|CSZ_CS_SPECIALIST|STANDARD,UMX|CS_ECC_SR_MGR_ACCESS_ROLE CS_ECC_SR_MGR_PS,FND_RESP|CS|CSZ_CS_SPECIALIST|STANDARD,UMX|CS_ECC_SR_AGNT_ACCESS_ROLE CS_ECC_SR_AGNT_PS,FND_RESP|CS|CS_ECC_SERVICE_MANAGER|STANDARD,UMX|CS_ECC_SR_MGR_ACCESS_ROLE CS_ECC_SR_AGNT_PS,FND_RESP|CS|CS_ECC_SERVICE_MANAGER|STANDARD,UMX|CS_ECC_SR_AGNT_ACCESS_ROLE CS_ECC_SR_AGNT_PS,FND_RESP|CS|CSZ_CS_SPECIALIST|STANDARD,UMX|CS_ECC_SR_MGR_ACCESS_ROLE CS_ECC_SR_AGNT_PS,FND_RESP|CS|CSZ_CS_SPECIALIST|STANDARD,UMX|CS_ECC_SR_AGNT_ACCESS_ROLE OKS_ECC_ACCESS,FND_RESP|OKS|OKS_MANAGER|STANDARD,UMX|OKS_ECC_ACCESS_ROLE |
Clear cache
Command centers didn’t appear under the responsibilities after running above script. It was fixed by clearing EBS cache using Functional Administrator responsibility.
Conclusion
At this stage ECC installation and integration is complete. Reminding you again that you can try ECC in our demo instance. Just log in as DEVELOPER and choose desired product responsibility and find associated command center menu entry. To continue your acquaintance with ECC I suggest reading the following article: Oracle Enterprise Command Center administration and enriched dashboard data export to Excel.
Please leave your comments if this article helped you or you faced any issues – we’re always happy to help you.
And please check out Blitz Report which complements ECC nicely with the fast excel export feature.
while Import Enterprise Command Center Applications (./patchEccFiles.pl) facing below error. please help me on this
Importing application /tmp/patchEccFile/fa/12.0.0/patch/115/ecc/applications/fa_ecc.zip
ECC WEB ENTRY URL:http://abc.abc.com:8000/ecc
ECC Application File:/tmp/patchEccFile/fa/12.0.0/patch/115/ecc/applications/fa_ecc.zip
ERROR: Failed with status 500 for url http://abc.abc.com:8000/ecc/user/import/applications?gfmString=Q6cKS_TYxMW-Rn9FfGG8-g..
Please check the log: null in ECC instance for error details
java.lang.Exception: http://abc.abc.com:8000/ecc/user/import/applications?gfmString=Q6cKS_TYxMW-Rn9FfGG8-g.. failed with HTTP status: 500
at oracle.ecc.client.util.ApplicationImporter.finish(ApplicationImporter.java:216)
at oracle.ecc.client.util.ApplicationImporter.importApplication(ApplicationImporter.java:113)
at oracle.ecc.client.ECCClient.main(ECCClient.java:71)
Import of applications failed
ERROR: Importing application /tmp/patchEccFile/fa/12.0.0/patch/115/ecc/applications/fa_ecc.zip failed
Hello Shivva
I will try to help, though it’s hard, as there is no additional information in the log messages
– Please send to my email your installation work note, so I can verify if all the steps were completed correctly
– Have you faced any errors before this issue?
– Are all EBS and ECC services running including Weblogic admin and managed servers?
Regards,
Alex
For a shortcut, import application directly from ECC UI through ECC developer responsibility.
For error above, you need to ensure a REST call to ECC is possible through the URL noted:
http://abc.abc.com:8000/ecc/user/import/applications?gfmString=Q6cKS_TYxMW-Rn9FfGG8-g….
If you already integrated with EBS then validate you can display ECC embedded in EBS to ensure your proxy settings are correct. If this is valid then above error could be due to load balancer set up on your end (you may or may not have that but a possibility)
My Oracle EBS is on Solaris. Will there be any issues as ECC requires Linux server?
Hello, Vengatanarayan
You can’t install ECC on the EBS server in this case as it’s on Solaris
But if you install ECC on a separate Oracle Linux server, there shouldn’t be any issues.
Regards,
Alex
Hi Alexander,
Very good explanation of Oracle Enterprise Command Center. Can you please let me know how we can extend the custom security handler to enable VPD(Virtual Private Database) access control. Thanks.
With Regards,
Satish.
Hi Satish
Thank you for the feedback
We need some time to gather additional information to answer your question
Regards,
Alex
Thanks Alexander. I was thinking if we could use the security handlers package to validate the VPD access.
Hi Satish
I’ve made some research and think that it’s not possible to combine security handlers with VPD
VPD works on a table level in an Oracle database.
In case of ECC however, data loader EBS concurrent programs load data into the ECC instance. The data is stored using Apache Lucene technology.
When a user logs into ECC, security handlers construct JSON conditions restricting data available for the user.
The data is retrieved from the files on the ECC server, not from the Oracle Database. So VPD is not involved here.
Here’s an example of JSON filter condition that we obtained from our ECC instance:
{
"filters":
[{
"values":
[
"204"]
,
"operator": "in",
"key":"ORG_ID",
"minValue":"null",
"maxValue":"null"
}
]
}
Regards,
Alex
Getting below error while trying to import ECC.
its a 4 NODE RAC 2APP TIER setup.
Importing application/*****//ECC/staging/pn/12.0.0/patch/115/ecc/applications/pn_ecc.zip
ECC WEB ENTRY URL:http://*****/:80/ecc
ECC Application File:/*****//ECC/staging/pn/12.0.0/patch/115/ecc/applications/pn_ecc.zip
java.net.ConnectException: Connection refused (Connection refused)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:344)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at sun.net.NetworkClient.doConnect(NetworkClient.java:175)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:463)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:558)
at sun.net.www.http.HttpClient.(HttpClient.java:242)
at sun.net.www.http.HttpClient.New(HttpClient.java:339)
at sun.net.www.http.HttpClient.New(HttpClient.java:357)
at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:1039)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:975)
at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:893)
at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(HttpURLConnection.java:1134)
at oracle.ecc.client.util.ApplicationImporter.importApplication(ApplicationImporter.java:106)
at oracle.ecc.client.ECCClient.main(ECCClient.java:88)
Import of applications failed
ERROR: Importing application /*****/ECC/staging/pn/12.0.0/patch/115/ecc/applications/pn_ecc.zip failed
Hi Pik!
Please check:
1) If the Linux firewall on the ECC server allows connections to the ecc managed server port (by default 7776) from the both APPS servers
2) Check if connection filter rules in the Weblogic Admin console could cause the issue
3) If the ecc server name is resolvable from the apps servers via DNS or the hosts file
Regards,
Alex
Hi Alex,
We are using same server for ECC and EBS but with different OSuser and different mount point.
Connection filter rules in ECC weblogic admin console is already set to allow
ECC server name is already set in hosts file
Hi Pik
Let’s try more diagnostic steps:
1) Are you using a firewall? It can refuse connections even from localhost. Please try stopping firewall temporarily for testing.
2) Could you please try the following commands on ebs/ecc server to test if EBS web port and ECC managed server ports are accepting connections on the same server:
telnet ebs_hostname 80
telnet ebs_hostname 7776
Please change ebs_hostname to the actual ebs and ecc server hostname (in your case it’s the same server)
3) Please try to access the following url from a browser and let me know the results
http://*****/:80/ecc
Please also do the same from the ebs server on Linux using curl command:
curl http://*****/:80/ecc
4) Please confirm that both ECC weblogic admin and managed servers are running fine. Please confirm that you don’t see any errors during startup in the weblogic logfiles and see ‘RUNNING’.
Also please check the servers status from the web console:
http://ecc_hostname:7775/console
5) Even though you confirmed that Weblogic connection rules are already set, please also try to remove the following rule if present, then restart the services and retest:
* * 7776 deny
Regards,
Alex
Hi Alex
1:->telnet ebs_hostname 80 doesnt work
telnet to load-balance works fine *****.com 80 doesnt work
telnet ebs_hostname 7776 works Fine
for ecc url from web getting User is not authenticated to access /ecc/index.jsp
for ecc url from linux getting below
curl: (7) Failed connect to *****.com:80; Connection refused
ECC weblogic is running fine
deny entry was already removed…
Hi
As we discussed via email please check the load balancer settings
If you find the solution, please share it here so it helps the others
Thank you,
Alex
We discussed the issue via email
So posting the solution for the readers:
“there was ***.com LB entry in /etc/hosts file so the moment import was trying to connect it used to look for /etc/hosts file and based on LB entry in localhost /etc/hosts it was trying to connect the IP on localhost which wasnt correct because actual IP of LB was different
So we had to remove LB entry from /etc/hosts”
Regards,
Alex
I am using ECC for quality module. Can i bring some additional data from database in ECC dashboard like Quality charts etc? I mean the chart which we create in OA page using Quality table data, can we create same in ECC dashboard? is it possible to bring data of chart table from ECC?
Hi Rohit,
I am not familiar with the quality module and do not fully understand your question, but it is possible to extend existing ECC dashboards with additional data as explained in Oracle’s documentation https://docs.oracle.com/cd/E26401_01/doc.122/f21671/toc.htm. It is also possible to create a complete new dashboard based on a custom dataset.
Does your last question mean if we can export the underlying data from the ECC charts? Then the answer is yes: Blitz Report can export the Oracle standard ECC data to Excel.
Regards,
Andy
How to configure DFF fields in ECC.
Hi Lavanya,
To show descriptive flexfield values in the ECC, you need to run the command center data load concurrent program first with load type METADATA and then again with FULL_LOAD. You should then see the flexfields that are set up in the lower transaction detail data section of the ECC (switch from the Main to the Additional Information data group with the dropdown on the left). You can also search or filter for DFF values then.
Regards,
Andy
Thank you so much Andy…Now i am able to access DFF.
Hi Andy,
Can you share enginatics link about MSCA mobile app testing.
Getting error while import
| Language | ECC Language Code|
————————————————–
Use of uninitialized value in printf at ./patchEccFiles.pl line 448, line 2.
| select NLS_LANGUAGE | |
Use of uninitialized value in concatenation (.) or string at ./patchEccFiles.pl line 449, line 2.
Use of uninitialized value in printf at ./patchEccFiles.pl line 448, line 2.
| * | |
Use of uninitialized value in concatenation (.) or string at ./patchEccFiles.pl line 449, line 2.
Use of uninitialized value in printf at ./patchEccFiles.pl line 448, line 2.
| ERROR at line 1: | |
Use of uninitialized value in concatenation (.) or string at ./patchEccFiles.pl line 449, line 2.
Use of uninitialized value in printf at ./patchEccFiles.pl line 448, line 2.
| ORA-00904: “FND_ECC_UTIL_MLS_PVT”.”CONVERTORALANGCODETOBCP47″: invalid | |
Use of uninitialized value in concatenation (.) or string at ./patchEccFiles.pl line 449, line 2.
| identifier | |
I check and did not found FND_ECC_UTIL_MLS_PVT
Hi
Please make sure that all EBS patches are applied as per Doc ID 2495053.1
For example for ECC V5 FND_ECC_UTIL_MLS_PVT package definition is contained in the following patch:
30535550: ATG ECC ADAPTER PATCH – V5
File name: 30535550/fnd/patch/115/sql/FNDECCMLSUTB.pls
Regards,
Alex
Hi Alex,
Thanks for you help and support, as I am on 12.2.9 Instance mostly patches were applied already there and I applied
30535540
30535550
only,
SQL> SELECT bug_number FROM apps.ad_bugs WHERE bug_number=’30535540′;
BUG_NUMBER
——————————
30535540
SQL> SELECT bug_number FROM apps.ad_bugs WHERE bug_number=’30535550′;
BUG_NUMBER
——————————
30535550
the patch 3053550 was missing after applied issue has been resolve
but its nothing import
[oracle@dev12 tmp]$ ./patchEccFiles.pl
Enter temporary directory for ECC Files(Should be used only for this task and be empty): /tmp/staging
Enter EBS DB apps user password:
List of languages installed in EBS:
————————————————–
| Language | ECC Language Code|
————————————————–
| AMERICAN | en |
—————————————————
List of languages supported in ECC:
Arabic(ar), Brazilian Portugese(pt), Canadian French(fr-CA),Croatian(hr), Cyrillic Kazakh(kk), Cyrillic Serbian(sr), Czech(cs), Danish(da), Dutch(nl), English(en), Finnish(fi), French(fr), German(de), Greek(el), Hebrew(he), Hungarian(hu), Icelandic(is), Indonesian(id), Italian(it), Japanese(ja), Korean(ko), Latin Spanish(es-419),Latin Serbian(sr-Latn), Lithuanian(lt), Norwegian(no), Polish(pl), Portugese(pt-PT),Romania(ro), Russian(ru), Simplified Chinese(zh-Hans), Slovak(sk), Slovenian(sl), Spanish(es), Swedish(sv), Thai(th), Traditional Chinese(zh-Hant), Turkish(tr), Ukranian(uk), Vietnamese(vi)
NOTE: Only languages installed and enabled in ECC will be processed successfully
Example: Enter ar,pt for Arabic and Brazilian Portugese language respectively. Enter all(ALL) for all languages
Enter the Language code(s) from the list mentioned above to run the translation for: ALL
Do you want to add all products at once(Y) or specify the subset(N): Y
Adding product top AP
Adding product top AR
Adding product top BOM
Adding product top CN
Adding product top CS
Adding product top CSD
SUMMARY REPORT:
—————————————————————
| Product | Application | Language | Status |
—————————————————————
—————————————————————
its normal or some thing wrong ?
thanks a lot to support and help
Regards,
Kunwar
Hi Kunwar
Please read Doc ID 2495053.1 carefully and apply all the required patches.
I suspect that nothing is imported because the product family and additional patches were not applied. Please pay attention at the following sections:
“4. Apply the product family consolidated patches that contain the products with Enterprise Command Centers that you want to use”
“6. If you plan to use one of the Enterprise Command Centers listed in the following table, then you must also apply the additional required patches as shown.”
Regards,
Alex
Hi Alex,
As I reviewed the document and applied the all missing patches,
issue is here I need to bounce the application ,I was on the import steps
so now how ti start from import process ? its normally to run scripts but
now ecc all services down, I need to know how to start ecc service and stop
I stuck on this phase
Regards,
Kunwar
Hi Kunwar
Have you performed cutover after applying the patches to EBS?
To continue from the import please start both EBS and ECC. For starting and stopping ECC please refer to Doc ID 2495053.1
APPENDIX B: STARTING AND STOPPING THE ORACLE ENTERPRISE COMMAND CENTER FRAMEWORK ENVIRONMENT
Regards,
Alex
Hi, Alex
getting this error while connection manage domain
User is not authenticated to access /ecc/index.jsp
at the creation time it was connecting now its show this error
http://dev12.tata.com:7776/ecc/
Regards,
Kunwar
Hi Kunwar
It’s the expected behaviour
You should access ECC through EBS login
So at attempt to connect directly will give you the above error.
Regards,
Alex
Hi, Alex
thanks your reply,
I still getting issue while import , I applied almost all patches which available/mention on document (Doc ID 2495053.1)
in import process successfully completed with any error but nothing import , during import its create folder but at the
end its delete all zip file which was created during import..
Importing application /tmp/staging/qp/12.0.0/patch/115/ecc/applications/qp_ecc.zip
ECC WEB ENTRY URL:http://dev12.tata.com:8000/ecc
ECC Application File:/tmp/staging/qp/12.0.0/patch/115/ecc/applications/qp_ecc.zip
Importing file /tmp/staging/qp/12.0.0/patch/115/ecc/applications/qp_ecc.zip finished with response [{“STATUS”:200,”logFileName”:”import_20201016170937.log”}]
Imported application /tmp/staging/qp/12.0.0/patch/115/ecc/applications/qp_ecc.zip successfully
Importing application /tmp/staging/wip/12.0.0/patch/115/ecc/applications/wip_ecc.zip
ECC WEB ENTRY URL:http://dev12.tata.com:8000/ecc
ECC Application File:/tmp/staging/wip/12.0.0/patch/115/ecc/applications/wip_ecc.zip
Importing file /tmp/staging/wip/12.0.0/patch/115/ecc/applications/wip_ecc.zip finished with response [{“STATUS”:200,”logFileName”:”import_20201016170938.log”}]
Imported application /tmp/staging/wip/12.0.0/patch/115/ecc/applications/wip_ecc.zip successfully
SUMMARY REPORT:
———————————————–
| Product | Application | Status |
———————————————–
| AP | ap_ecc.zip | Success |
| AR | ar_ecc.zip | Success |
| BOM | cst_ecc.zip | Success |
| CN | cn_ecc.zip | Success |
| CS | cs_ecc.zip | Success |
| CSD | csd_ecc.zip | Success |
Regards,
Kunwar
Hi Kunwar
Per summary everything was imported successfully
It’s expected that at the end the staging directory is cleaned
You can safely proceed with the other steps
Regards,
Alex
Dear Alex,
I am very thankful for your kind support and help , I have successfully completed Installation and configuration v5 on 12.2.9
Regards,
Kunwar
Hi Kunwar
I’m happy to hear that!
Was glad to help you
Regards,
Alex
Hi, Alex,
did you work on Mobile apps Implementation with Oracle EBS R12.2.9 or any version of ebs ,
if please share document link .
Regards,
Kunwar
Hi Kunwar
Sorry I don’t have experience with Mobile apps
Regards,
Alex
Hi Alex,
When i’m trying to login with payables manager command center, its gives me a blank page with 3 tabs.
Can you please help me to retrive data
Just for Info…While importing faced Connection reset…..
Soluation:->Make Sure Applciation services are up and running (no need of Concurrent managers to be up)
ECC Application File:***************/ECC/staging/pa/12.0.0/patch/115/ecc/applications/pa_ecc.zip
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(SocketInputStream.java:197)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read1(BufferedInputStream.java:275)
at java.io.BufferedInputStream.read(BufferedInputStream.java:334)
at sun.net.www.http.HttpClient.parseHTTPHeader(HttpClient.java:721)
at sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:664)
at sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:692)
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1366)
at java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:468)
at oracle.ecc.client.util.ApplicationImporter.finish(ApplicationImporter.java:202)
at oracle.ecc.client.util.ApplicationImporter.importApplication(ApplicationImporter.java:113
Hi
Thank you for your contribution!
That will be very helpful for other readers
Regards,
Alex
Hi Alex.
Importing Application using patchECCFiles.pl fails during ECC and EBS integration
Importing application /u06/tmpecc/ap/12.0.0/patch/115/ecc/applications/ap_ecc.zip
ECC WEB ENTRY URL:https://ebsdev.grupoazor.net:4473/ecc
ECC Application File:/u06/tmpecc/ap/12.0.0/patch/115/ecc/applications/ap_ecc.zip
javax.net.ssl.SSLHandshakeException: Received fatal alert: handshake_failure
at sun.security.ssl.Alerts.getSSLException(Alerts.java:192)
at sun.security.ssl.Alerts.getSSLException(Alerts.java:154)
at sun.security.ssl.SSLSocketImpl.recvAlert(SSLSocketImpl.java:1972)
at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:1089)
at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1325)
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1352)
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1336)
at sun.net.www.protocol.https.HttpsClient.afterConnect(HttpsClient.java:559)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:185)
at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(HttpURLConnection.java:1158)
at sun.net.www.protocol.https.HttpsURLConnectionImpl.getOutputStream(HttpsURLConnectionImpl.java:264)
at oracle.ecc.client.util.ApplicationImporter.importApplication(ApplicationImporter.java:106)
at oracle.ecc.client.ECCClient.main(ECCClient.java:88)
Import of applications failed
ERROR: Importing application /u06/tmpecc/ap/12.0.0/patch/115/ecc/applications/ap_ecc.zip failed
Hi Ulises
Please tell if you performed all the configuration per the following Doc:
Enabling TLS for Oracle Enterprise Command Center Framework, Release 12.2 (Doc ID 2496445.1)
Regards,
Alex
Hi ,
We have done ECC integration on oracle ebs 12.2.9 and we are seeing lot of ECC related invalids please suggest
Hi
Can you please share a list of those invalid objects?
Regards,
Alex
good day
I have problems with the installation, when the handle finishes it marks the following error.
java.lang.Exception: http://********:8001/ecc/user/import/applications?gfmString= failed with HTTP status: 404
at oracle.ecc.client.util.ApplicationImporter.finish(ApplicationImporter.java:213)
at oracle.ecc.client.util.ApplicationImporter.importApplication(ApplicationImporter.java:110)
at oracle.ecc.client.ECCClient.main(ECCClient.java:29)
ECC WEB ENTRY URL:http://*********:8001/ecc ECC Application File:/u01/Oracle/quickInstall/applications/activity_audit_ecc.zip ERROR: Failed with status 404 for url http://**********:8001/ecc/user/import/applications?gfmString= Please check the log: Error 404–Not Found Error 404–Not Found From RFC 2068 Hypertext Transfer Protocol — HTTP/1.1: 10.4.5 404 Not Found The server has not found anything matching the Request-URI. No indication is given of whether the condition is temporary or permanent.If the server does not wish to make this information available to the client, the status code 403 (Forbidden) can be used instead. The 410 (Gone) status code SHOULD be used if the server knows, through some internally configurable mechanism, that an old resource is permanently unavailable and has no forwarding address. in ECC instance for error details Import of applications failed
can you help me please!!!
Hi David
The symptoms look similar to the following Doc:
Error In Import Enterprise Command Center Applications (Doc ID 2572477.1)
Please check if ECC and EBS servers’ hostnames are resolvable and pingable from each other.
You may need to configure /etc/hosts files or DNS server.
Regards,
Alex
Hi David, can you confirm you have 19c database with a pluggable database?
David should have mentioned that using scan was the cause of all evil, use vip, from EccConfig.properties and even the .dbc that is copied from internal, if it contains scan replace vip manually in connection.dbc file. :D
Thank you for the update!
Hi David, i have the same issue. ECC and EBS both on the same server. It is not a DNS or resolve issue. This happens when creating the ecc domain in weblogic. Sill investigating.
Thank you for the reply Rene
Please share the results of your investigation if you find the root cause
Could you please also check if firewall can prevent from connecting to the port?
Hi ,
I have problem accessing ECC developer responsibility.
We have ECCV4 integrated with EBS R12.2.9. Earlier it was working fine but now we are facing below error:
Unable to resolve ‘ebsdb’. Resolved ”
Could you please help me.
Hi Mounika
1) Please tell in which logfile you found this error? An on which side – EBS or ECC?
2) Is this the only error line appearing or there are others?
Could you please post the full error stack.
3) What are the steps to reproduce the issue? Do you get this error exactly at the time when you try to loging to ECC developer responsibility?
Thank you,
Alex
Hi,
1)I logged in as sysadmin user.
2) clicked on ECC developer responsibility.
Then i am getting the error:
Unable to resolve ‘ebsdb’. Resolved ”
->I am trying to configure the JNDI to Connect to Oracle E-Business Suite but it is again failing with below error:
————————————————————————————————————————————-
weblogic.application.ModuleException: weblogic.common.resourcepool.ResourceSystemException:
Could not create connection for datasource ‘ebsDB’.
The returned message is: ORA-01017: invalid username/password; logon denied
It is likely that the login or password is not valid.
It is also possible that something else is invalid in
the configuration or that the database is not available.
Problem invoking WLST – Traceback (innermost last):
File “/home/oraecc/ECC4/Oracle/software/temp/createEBSJndi.py”, line 75, in ?
NameError: BeanAlreadyExistsException
cannot create EBS Jndi…
JNDI creation failed for EBS database.
-> As per the error validated all the credentials and all correct.
->As per the above document Apps Schema Connect Role is also assign to EBS user.
Could you please let me know if there is any solution to fix this?
Thanks,
Mounika
Hi
As per the above document another possible cause of this error: make sure that HOST in connection.dbc is resolvable from ECC server.
APPS_JDBC_URL=jdbc\:oracle\:thin\:@(DESCRIPTION\=(ADDRESS_LIST\=(LOAD_BALANCE\=YES)(FAILOVER\=YES)(ADDRESS\=(PROTOCOL\=tcp)(HOST\=demo.enginatics.com)(PORT\=1521) ))(CONNECT_DATA\=(SERVICE_NAME\=EBSDB)))
So please open connection.dbc on the ECC server. Check the value of the APPS_JDBC_URL
1) Verify that the database host is resolvable by pinging it from the ECC server:
ping
2) Verify that the port is opened for connections from the ECC server by telnet or similar commands:
telnet
Regards,
Alex
Hello.
I solved the same issue recreating .dbc file and copy to ECC server:
java oracle.apps.fnd.security.AdminDesktop apps/$pass CREATE NODE_NAME=ecc.enginatics.com DBC=/u01/install/APPS/fs2/inst/apps/EBSDB_apps/appl/fnd/12.0.0/secure/EBSDB.dbc
Regards.
Hi Alex,
thanks for the inputs I have validated below steps:
1)Verified Connection.dbc file and everything is correct.
2)I am able to ping EBS server from ECC server successfully.
3)Port is also opened for connections and telnet connection is also successful.
Thanks,
Mounika
Hi Mounika
I have sent you an email with questions a while ago but didn’t get a response
Please tell if you were able to solve your problem?
Regards,
Alex
Hello,
I have same error kindly suggest some work around .
Thanks
Hi
Please post your error message
Thank you
Hi,
I have implemented the above steps, but when I open the ECC I cant see any data? Which logs I should check or verify?
Thanks,
Mohammed Al-Masri
Hi Mohammed
Please check ECC data load concurrent request logs – if they successfully loaded data into ECC
Regards,
Alex
Hi,
I am unable to access my ecc managed server either standalone nor through the EBS URL
The Server is not able to service this request: [Socket:000445]Connection rejected, filter blocked Socket, weblogic.security.net.FilterException: [Security:090220]rule 14 weblogic.security.net.FilterException: [Security:090220]rule 14 at weblogic.security.net.ConnectionFilterImpl.accept(ConnectionFilterImpl.java:167) at
Hi Gaurav
In this post I covered a similar issue. Please use ‘ctrl+F’ and search by “weblogic.security.net.FilterException”.
You will find a workaround
Please try and let me know if it works for you
Regards,
Alex
Hi Pavlik,
I am able to resolve the the issue i reported earlier. I have changed the this value in in my config.xml (* * 7776 allow).
However while accessing the standalone ECC URL. I am now getting below error. Admin console is working fine without any issues.
User is not authenticated to access /ecc/index.jsp
While accessing ECC from EBS (ECC Developer responsibility), I am getting below issue. Can you please help me? I will send any log file if you require. Please share your email ID if any other detail is required.
Service Temporarily Unavailable
The server is currently unable to handle the request due to a temporary overloading or maintenance of the server.
We had a email conversation with Gaurav and I’m posting the final solution here:
Turned out that there were no Linux firewall rules, but servers were hosted on AWS.
So allow rules for ports 7775 and 7776 on ECC server for connections from EBS server were needed in an AWS security group.
Hope it helps someone
Regards,
Alex
I follow the steps, but ECC command not found in the “Order Management Super User” responsibility.
Hi
Please kindly review the steps from the section “Providing users access to ECC” and make sure they’re all performed correctly
Also as it’s mentioned in the document: “If you don’t see function appear after the responsibility, you may need to clear EBS cache using Functional Administrator responsibility.”
So please try clearing the cache
Regards,
Alex
Hi Alex,
Thanks for your input. We have two separate EBS and ECC servers. In which server I have to perform the step.
Regards,
Haresh
Those steps are applicable to the EBS server
Hi Alexander,
I am trying to enable SSL in ECC.
Doc ID:
Enabling TLS for Oracle Enterprise Command Center Framework, Release 12.2 (Doc ID 2496445.1)
2.2 Configuring HTTPS After Installing Oracle Enterprise Command Center Framework
Performing below step:
Make the ports you specified in the configuration properties take effect by running the configurePorts.sh script using the following command:
sh $ECC_BASE/Oracle/quickInstall/wlsScripts/configurePorts.sh $ECC_BASE/Oracle/quickInstall/env/ecc.env $ECC_SERVER_DOMAIN
while running the above script, I am getting below errors/exceptions. But getting “WLS SSL ports configured successfully for ECC” in the end. Not sure if i can ignore this warning and go ahead further.
Caused by: com.oracle.cie.domain.script.ScriptException: 64016: Attempt to set disabled property.
64016: The property “SSL Listen Port” is disabled on type SSL.
64016: Internal error. No user actions available.
at com.oracle.cie.domain.script.ScriptExecutor.setValue(ScriptExecutor.java:3230)
at com.oracle.cie.domain.script.jython.ScriptInvocationHandler.set(ScriptInvocationHandler.java:311)
at com.oracle.cie.domain.script.jython.ScriptInvocationHandler.invoke(ScriptInvocationHandler.java:203)
… 44 more
Caused by: com.oracle.cie.domain.aspect.ConfigAspectValidateException: 64016: Attempt to set disabled property.
64016: The property “SSL Listen Port” is disabled on type SSL.
64016: Internal error. No user actions available.
at com.oracle.cie.domain.aspect.AbstractConfigAspect.setValue(AbstractConfigAspect.java:829)
at com.oracle.cie.domain.aspect.AbstractConfigAspect.setValue(AbstractConfigAspect.java:847)
at com.oracle.cie.domain.aspect.FilteredConfigAspect.setValue(FilteredConfigAspect.java:748)
at com.oracle.cie.domain.script.ScriptExecutor.setAttrValue(ScriptExecutor.java:6490)
at com.oracle.cie.domain.script.ScriptExecutor.setValue(ScriptExecutor.java:3219)
… 46 more
Exiting WebLogic Scripting Tool.
WLS SSL ports configured successfully for ECC
-bash-4.2$
Hi
Can’t say for sure as I didn’t enable SSL for ECC.
But this MOS Doc has the following remark, though regarding another script:
Installing Oracle Enterprise Command Center Framework, Release 12.2 (Latest Version) (Doc ID 2495053.1)
“Note: During the execution of the restore.sh script, the following exception may occur:
Caused by: com.oracle.cie.domain.aspect.ConfigAspectValidateException: 64016: Attempt to set disabled property.
64016: The property “SSL Listen Port” is disabled on type SSL.
64016: Internal error. No user actions available
This is an expected behavior and does not need any action from the administrator.”
So please test you application – if everything is working correctly there’s a possibility that it also can be ignored.
Regards,
Alex
Thanks for the information Alex !!
Was glad to help)
Hi Alex,
If I installed ECC on a separate server, will it require a license?
Regards,
Haresh
Hi Haresh
I can’t give you an official answer.
But according to my research all Oracle Docs say that ‘Oracle Enterprise Command Centers are available at no additional cost to licensed users of the
underlying Oracle E-Business Suite products.’
Example:
https://www.oracle.com/a/ocom/docs/applications/ebusiness/ebs-enterprise-command-centers-ga.pdf
And it’s recommended by Doc ID 2495053.1 to install ECC on a separate server for better performance.
So my assumption would be it will Not require a separate license if you own an EBS license.
For an official answer please contact your Oracle Sales representative.
Thank you,
Alex
Hi Alex,
Do you have any idea like how to tune the starting of ECC application? Since it is taking more than 45 minutes to start the application process.
Thanks,
Gaurav
Hi Gaurav
Could you please share your ECC server RAM, swap and CPU (frequency and number of cores) values?
I want to make sure that your server has enough resources as it may be the reason of the issue.
Please make that swap is not being used due to lack of RAM during ECC startup.
Another possible issue is described in this doc:
Java Programs Are Running Slower In Newer Servers Due To Lack Of Entropy In The System (Doc ID 1615981.1)
Thank you,
Alex
Thank you so much, but i can’t find ecc.conf in “Edit OHS configuration files” step, can’t you help me
Thanks,
Hi Thuong
Please try to
cd $FMW_HOME/webtier/instances
Then the rest of directory path will look similar to:
EBS_web_OHS1/config/OHS/EBS_web/
Alternatively
cd $FMW_HOME/webtier/instances
find . -name ecc.conf
Regards,
Alex
./patchEccFiles.pl
-bash: ./patchEccFiles.pl: /usr/local/bin/perl: bad interpreter: No such file or directory
I AM GETTING ABOVE ERROR WHILE EXECUTING THE ./patchEccFiles.pl FILE
Hi
Please try the following
1) Identify perl location on your system executing:
which perl
It will return something like
/usr/bin/perl
2) Modify patchEccFiles.pl. Replace the first line from:
#!/usr/local/bin/perl -w
To:
#!/usr/bin/perl -w
i have used perl patchEccFiles.pl
Thanks,
Edwin.K
Yes, that’s also a valid option
Thank you for the update,
Alex
Hi Alexander,
How are you doing, I have question about EBS TLS and ECC TLS.
our EBS is on R12.2.9 with https and TLS Enabled.
I Installed ECC V6 and it is running on http and NO TLS.
My question is : Is it mandatory to enable https and TLS for ECC V6?
If ECC is not using https and TLS what is the impact on ECC Data loads and Dashboards ?
can we integrate EBS with ECC with out http and TLS setup?
Thanks,
Vijay.
Hi Vijay
If it’s ok that the traffic will not be encrypted between EBS and ECC you can perform such a configuration
For example if the both servers are located in the internal network and protected by VPN.
Regards,
Alex
Hi Alex,
How are you doing.
Kindly help me with below requirement.
My client is asking to do the setup of ECC to all the EBS environments.
What will be beast approach here.
Can I install/setup Single ECC to multiple EBS environments.
I have 4 EBS environments and all should be setup with ECC.
is it possible to install / setup all ECC in single server and integrate with EBS env’s accordingly.
Could you please confirm whether my requirement is possible with below setup
On same ECC server separate account ecctst for ecc with different ECC_BASE
On same ECC server separate account eccuat2 for ecc with different ECC_BASE
Thanks,
Rajesh
Hi Rajesh
Ideally it’s better to assign a separate server for each of 4 ECC instances.
But sometimes we lack resources, so you can setup it in the proposed way.
But you have to ensure that all 4 ECC instances with different ECC_BASE use different ports on the server, so there’s no conflict.
Also you need to assign enough CPU and memory for several ECC instances running on the same server.
Regards,
Alex
Hi Alex
thanks for your easy to do document which i have followed
http://ECCHOST.us.colorcon.com:7776/ecc
this will not work?
am getting below error
User is not authenticated to access /ecc/index.jsp
This started happening after
4.3.2.3 Integrate Oracle Enterprise Command Center Framework with Oracle E-Business Suite
{
When the integration is done, security should be in place and Oracle Enterprise Command Center Framework
should be linked to the Oracle E-Business Suite instance. Note that the Oracle Enterprise Command Center Framework administration UI
cannot be accessed directly, but must be accessed from within Oracle E-Business Suite.
You must complete the setup in
Section 5: Providing Administrators Access to the Oracle Enterprise Command Center Framework Administration UI
so that a functional administrator can access this UI from Oracle E-Business Suite.
}
Thanks,
Edwin.K
Hi Edwin
It’s the expected behaviour
You should access ECC through EBS login
So at attempt to connect directly will give you the above error.
Regards,
Alex
Thanks a bunch alex….so we must must assign “ECC Developer” role and then am able to access ECC from EBS login
and i have another doubt
Importing application /dbstage/dba/edw/temp/ecc_23aug2021/ecc_pl_zip/temp/wip/12.0.0/patch/115/ecc/applications/wip_gnt_ecc.zip
ECC WEB ENTRY URL:http://MTNODE.us.colorcon.com:9240/ecc
ECC Application File:/dbstage/dba/edw/temp/ecc_23aug2021/ecc_pl_zip/temp/wip/12.0.0/patch/115/ecc/applications/wip_gnt_ecc.zip
ERROR: Failed with status 403 for url http://MTNODE.us.colorcon.com:9240/ecc/user/import/applications?gfmString=spjgOL0bZt-4PYyccO4q4A..
Please check the log: 403 ForbiddenThe Server is not able to service this request: [Socket:000445]Connection rejected, filter blocked Socket, weblogic.security.net.FilterException: [Security:090220]rule 9
weblogic.security.net.FilterException: [Security:090220]rule 9
so in ECC managed server as you said
i did below
ECCMTNODE.us.colorcon.com * 7776 allow t3 t3s http https
localhost * 7776 allow t3 t3s http https
mt64-080 * 7776 allow t3 t3s http https
0:0:0:0:0:0:0:1 * 7776 allow t3 t3s http https
10.32.1.124 * 7776 allow t3 t3s http https
0:0:0:0:0:0:0:1%lo * 7776 allow t3 t3s http https
EBSMTNODE.us.colorcon.com * 7776 allow t3 t3s http https
* * 7776 deny===============>changed it to ==========>* * 7776 allow
now perl patchEccFiles.pl was successful
Is this okay?
Thanks,
Edwin.K
Yes it should be fine
Thanks,
Alex
Hi All,
if you face “page not found” error When attempting to CLICK on ECC Developer responsibility in Oracle EBS after ECC V6 upgrade/install .
Follow below :-> ECC Developer Showing Page Not Found In Oracle EBS (Doc ID 2515194.1)
Hi
Thank you for your update which may help others
Regards,
Alex
Hi Alex,
We have installed ECC on different linux server and integrated with EBS R12.2.8. Now we want to modify below URLS comes under ECC Developer>about>monitoring tab
ECC Health
ECC Logs
Please let me know if have any clue
Thanks
Hi Sumit
Sorry, don’t have a quick solution for this
If you find the steps, please share them with others in the comments
Thank you,
Alex
Hello
as give path I did not find ecc.conf file ,what is means
Hi Kunwar
Please try to
cd $FMW_HOME/webtier/instances
Then the rest of directory path will look similar to:
EBS_web_OHS1/config/OHS/EBS_web/
Alternatively
cd $FMW_HOME/webtier/instances
find . -name ecc.conf
Regards,
Alex
AutoConfig completed successfully.
[oracle@dev16 scripts]$ grep s_ecc $CONTEXT_FILE
#
dev16.tata.com
7776
http
true
Hi Alex,
We have load balancer on EBS side and ECC is non TLS, now when we try to run ECC data load for EBS responsibility for example payable manager or receivable manager it is failing without giving any proper error message , while all same program is running fine from ECC developer, do you know what additional steps we need to perftto make this work?
Hi
Is there any message at all in the data load concurrent logfile/output?
Thank you
Hi Alexander,
When we run the concurrent request “ECC Run Data Load”, it ends up with the below error. Can you please help.
13:06:14.459 [pool-4-thread-6] ERROR 3.o.e.i.u.s.i.DataLoadControllerServiceImpl – InterruptedException Read timed out
java.lang.InterruptedException: Read timed out
at oracle.ecc.index.update.metadata.CollectionRegistration.createCollection(CollectionRegistration.java:395) ~[ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.DataLoadControllerServiceImpl.loadDataForDataset(DataLoadControllerServiceImpl.java:550) ~[ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.startJob(IRDataLoadServiceImpl.java:930) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.tryToStartJob(IRDataLoadServiceImpl.java:542) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.lambda$runLoadDataForApplicationWorkFlow$21(IRDataLoadServiceImpl.java:2155) [ecc-ir-1.0.0.jar:na]
at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1640) ~[na:1.8.0_281]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_281]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_281]
at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_281]
13:06:14.460 [pool-4-thread-6] ERROR 3.o.e.i.u.s.i.DataLoadControllerServiceImpl – Read timed out
java.lang.InterruptedException: Read timed out
at oracle.ecc.index.update.metadata.CollectionRegistration.createCollection(CollectionRegistration.java:395) ~[ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.DataLoadControllerServiceImpl.loadDataForDataset(DataLoadControllerServiceImpl.java:550) ~[ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.startJob(IRDataLoadServiceImpl.java:930) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.tryToStartJob(IRDataLoadServiceImpl.java:542) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.lambda$runLoadDataForApplicationWorkFlow$21(IRDataLoadServiceImpl.java:2155) [ecc-ir-1.0.0.jar:na]
at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1640) ~[na:1.8.0_281]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_281]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_281]
at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_281]
Hi Prasad
1) Please let me know for which product you run Data Load and what is the exact name of this request?
Example: “Receivables Command Center Data Load”
2) What are the parameters provided for this concurrent request?
3) What responsibility did you use to submit the request?
4) Did you try to run data loads for other products and did they complete successfully?
Thank you
Hi Alex,
I am facing the same issue.
below are the requested details,
1) Product: Oracle Process Manufacturing
Program: Process Manufacturing Command Center Data Load
2) Parameter:
System name: EBS
Load type: FULL_LOAD
Log level: Error
3) MES for Process Manufacturing Administrator
4) Yes I have tried for other data load programs and they completed successfully
please help to resolve the issue.
below error message for your reference.
Error:
In child request: ECC – Run Data Load (ECC Run Data Load)
ECCRUNDL: ECC Run Data Load
+—————————————————————————+
Current system time is 20-MAY-2022 07:53:35
+—————————————————————————+
CP main executing runProgram for oracle.apps.fnd.ecc.dataload.EccDataLoadCP
APPS_FRAMEWORK_AGENT: http://url:port
datasetsForSerialLangsProfile is empty
Parameter [name:pSystemId, value:EBS]
Parameter [name:pAppShortName, value:GMO]
Parameter [name:pDataSetKey, value:gmo-batch]
Parameter [name:pLoadType, value:FULL_LOAD]
Parameter [name:pLang, value:]
Parameter [name:pTraceFlag, value:]
Parameter [name:pLogLevel, value:ERROR]
Parameter [name:Parameter1, value:]
Parameter [name:Parameter2, value:]
Parameter [name:Parameter3, value:]
Parameter [name:Parameter4, value:]
Parameter [name:Parameter5, value:]
Parameter [name:Parameter6, value:]
Parameter [name:Parameter7, value:]
Parameter [name:Parameter8, value:]
Parameter [name:Parameter9, value:]
Parameter [name:Parameter10, value:]
Parameter [name:Parameter11, value:]
Parameter [name:Parameter12, value:]
Parameter [name:Parameter13, value:]
Parameter [name:Parameter14, value:]
Parameter [name:Parameter15, value:]
Parameter [name:pLastRunDateIdentifier, value:]
Parameter [name:pForceCreate, value:]
Concurrent request ID is 129521034
PARAMETERS LIST :
SystemId -> EBS
Application Short Name -> GMO
Load Type -> FULL_LOAD
DataSet Key -> gmo-batch
Language ->
Trace Flag ->
Force Create Flag ->
Last Run Date Identifier ->
Log Level -> ERROR
INFO: Language parameter is not specified. Hence defaulting to base language US
Running Full Load
JobId -> 33098
status-> PENDING
done
RUNNING
. . . . . done
CANCELLED
data load concurrent program failed
null
JOB Details:
Details of auditDataset#: 33099
dataset: gmo-batch
startTime: Fri May 20 08:13:32 IST 2022
endTime: Fri May 20 08:15:35 IST 2022
status: CANCELLED
total elapsed time: 0:2:123
JOB Details:
Please check the output Log of Concurrent program for error details
Error Details:
08:15:35.569 [pool-5-thread-8] ERROR 3.o.e.i.u.s.i.DataLoadControllerServiceImpl – InterruptedException Read timed out
java.lang.InterruptedException: Read timed out
at oracle.ecc.index.update.metadata.CollectionRegistration.createCollection(CollectionRegistration.java:447) ~[ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.DataLoadControllerServiceImpl.loadDataForDataset(DataLoadControllerServiceImpl.java:558) ~[ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.startJob(IRDataLoadServiceImpl.java:962) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.tryToStartJob(IRDataLoadServiceImpl.java:546) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.lambda$runLoadDataForDatasetWorkFlowSourceSystem$26(IRDataLoadServiceImpl.java:2357) [ecc-ir-1.0.0.jar:na]
patchEccFiles.pl is failing with timeout error when trying to connect to EBS URL on 8021. Both EBS and ECC servers are in the same subnet and firewall is down on both servers. LB settings also look ok. Can you please suggest what to check?
Hi Kevin
Please post the output patchEccFiles.pl shows
Include the error itself and some lines before it to understand what script tried to do
Thank you,
Alex
Hi Alex,
I am facing the issue.
below are the requested details,
1) Product: Oracle Process Manufacturing
Program: Process Manufacturing Command Center Data Load
2) Parameter:
System name: EBS
Load type: FULL_LOAD
Log level: Error
3) MES for Process Manufacturing Administrator
4) Yes I have tried for other data load programs and they completed successfully
please help to resolve the issue.
below error message for your reference.
Error:
In child request: ECC – Run Data Load (ECC Run Data Load)
ECCRUNDL: ECC Run Data Load
+—————————————————————————+
Current system time is 20-MAY-2022 07:53:35
+—————————————————————————+
CP main executing runProgram for oracle.apps.fnd.ecc.dataload.EccDataLoadCP
APPS_FRAMEWORK_AGENT: http://url:port
datasetsForSerialLangsProfile is empty
Parameter [name:pSystemId, value:EBS]
Parameter [name:pAppShortName, value:GMO]
Parameter [name:pDataSetKey, value:gmo-batch]
Parameter [name:pLoadType, value:FULL_LOAD]
Parameter [name:pLang, value:]
Parameter [name:pTraceFlag, value:]
Parameter [name:pLogLevel, value:ERROR]
Parameter [name:Parameter1, value:]
Parameter [name:Parameter2, value:]
Parameter [name:Parameter3, value:]
Parameter [name:Parameter4, value:]
Parameter [name:Parameter5, value:]
Parameter [name:Parameter6, value:]
Parameter [name:Parameter7, value:]
Parameter [name:Parameter8, value:]
Parameter [name:Parameter9, value:]
Parameter [name:Parameter10, value:]
Parameter [name:Parameter11, value:]
Parameter [name:Parameter12, value:]
Parameter [name:Parameter13, value:]
Parameter [name:Parameter14, value:]
Parameter [name:Parameter15, value:]
Parameter [name:pLastRunDateIdentifier, value:]
Parameter [name:pForceCreate, value:]
Concurrent request ID is 129521034
PARAMETERS LIST :
SystemId -> EBS
Application Short Name -> GMO
Load Type -> FULL_LOAD
DataSet Key -> gmo-batch
Language ->
Trace Flag ->
Force Create Flag ->
Last Run Date Identifier ->
Log Level -> ERROR
INFO: Language parameter is not specified. Hence defaulting to base language US
Running Full Load
JobId -> 33098
status-> PENDING
done
RUNNING
. . . . . done
CANCELLED
data load concurrent program failed
null
JOB Details:
Details of auditDataset#: 33099
dataset: gmo-batch
startTime: Fri May 20 08:13:32 IST 2022
endTime: Fri May 20 08:15:35 IST 2022
status: CANCELLED
total elapsed time: 0:2:123
JOB Details:
Please check the output Log of Concurrent program for error details
Error Details:
08:15:35.569 [pool-5-thread-8] ERROR 3.o.e.i.u.s.i.DataLoadControllerServiceImpl – InterruptedException Read timed out
java.lang.InterruptedException: Read timed out
at oracle.ecc.index.update.metadata.CollectionRegistration.createCollection(CollectionRegistration.java:447) ~[ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.DataLoadControllerServiceImpl.loadDataForDataset(DataLoadControllerServiceImpl.java:558) ~[ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.startJob(IRDataLoadServiceImpl.java:962) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.tryToStartJob(IRDataLoadServiceImpl.java:546) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.lambda$runLoadDataForDatasetWorkFlowSourceSystem$26(IRDataLoadServiceImpl.java:2357) [ecc-ir-1.0.0.jar:na]
Hi
The following Doc contains the similar symptoms – CANCELLED request
ECC Data Load Concurrent Request Ends With “CANCELLED” Status (Doc ID 2649008.1)
Please check if there’re any errors in the database alert log after the data load request fails?
Thank you
Hi Alex,
I have an EBS 12.2.10 with TLS enable running on Server A and ECC V9 installed on Server B without TLS enable.
My customer not going to enable TLS in ECC Server B.
Possible to run ECC without TLS enable in Server B? If possible, what are the further setup we need to do?
Best Regards,
lwc
Hi Iwc
Yes, it’s possible
You need to follow Doc ID 2496445.1
SECTION 2: CONFIGURING HTTPS FOR THE ORACLE ENTERPRISE COMMAND CENTER FRAMEWORK INSTALLATION
Configure the EBS_ parameters for TLS
Configure ECC_ parameters for NO TLS
Regards,
Alex
Great. So meaning, just complete Section 2 only?
I can skip the rest of the sections?
Thanks and Best Regards,
lwc
Yes, section 2 only should be sufficient
Please try and let me know if it works for you
Hi,
1. I am able to completed till “option 5 – Integrate with EBS” in section 2,
2. I proceed with checking the s_ecc_conf_comment, s_ecc_protocol, s_ecc_web_host and s_ecc_managed_Server_port
3. Ran autoconfig
4. check the OHS ecc.conf file
5. But when I run perl patchEccFiles.pl, I get this error:
Importing application /tmp/staging/ap/12.0.0/patch/115/ecc/applications/ap_ecc.zip
ECC WEB ENTRY URL:https://EBSserver.abc.com:443/ecc
ECC Application File:/tmp/staging/ap/12.0.0/patch/115/ecc/applications/ap_ecc.zip
javax.net.ssl.SSLHandshakeException: java.security.cert.CertificateException: No subject alternative DNS name matching EBSserver.abc.com found.
at sun.security.ssl.Alerts.getSSLException(Alerts.java:192)
at sun.security.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1897)
at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:294)
at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:288)
The ECC WEB ENTRY URL is pointing to EBSserver.abc.com, It’s this right?
best regards,
lwc
The ECC WEB ENTRY URL looks correct. Please compare it to the one in my post, it’s also pointing to the EBS instance: http://demo.enginatics.com:80/ecc
I don’t know the root cause of this error.
Please check if everything is all right with the TLS certificate.
For example if it matches the EBS url “EBSserver.abc.com”.
Good. Where is the directory of the TLS certificate in EBS? There must be a $SOME_EBS_TLS_PATH, right?
Please refer to the following document:
Enabling TLS in Oracle E-Business Suite Release 12.2 (Doc ID 1367293.1)
5.2 Configure Inbound Connections
The directory is (need to replace the context variables):
[s_ohs_instance_loc]/config/OHS/[s_ohs_component]/keystores/default
Hi,
I noticed:
1. When I run URL “http://demo.enginatics.com:80/ecc” – I get “User is not authenticated to access /ecc/index.jsp”
2. When I run URL “https://EBSserver.abc.com:443/ecc” – I get “Proxy Error The request could not be processed. An invalid response was received by the proxy or gateway server.”
Any idea with the “Proxy Error”?
Best Regards,
lwc
Hi,
Besides the log file, patchEccFiles.out, any other logfile I can refer to?
Thanks,
lwc
Hi,
I have a question. Any difference between a self-signed or CA cert setup in EBS TLS? Currently, the EBS TLS is a self-signed Cert.
Best Regards,
lwc
Hi Iwc
I performed some tests with ECC and EBS with a self-signed certifiecate.
I faced an issue similar to what you experienced, but not the same.
Please check the new section “Import Enterprise Command Center Applications into TLS enabled EBS instance” I added to this article.
Hope it will help you to resolve your issue.
Regards,
Alex
I also created a new post about ECC and EBS TLS configuration.
https://www.enginatics.com/blog/configuring-tls-for-oracle-enterprise-command-center-framework/
Hope it will help
Thank you,
Alex
Hello Alexander,
In General Ledger we can see the function “General Ledger Command Center”. But when we open it, the html page shows below error.
You are not authorized to access the function GL_ECC_ACC_ANALYSIS. Please contact your System Administrator.
as per Doc D 2960448.1 the function “GL_ECC_ACC_ANALYSIS” should be added to the menu. But this function is NOT available.
What could be the reason?
Thanks
Ismail
Thanks, DBA has reloaded the applications then this problem is resolved.
Hi Ismail
Thank you for the feedback!
It will be useful for other users facing the same issue.
Regards,
Alex
Hi,
Thanks for this blog. I followed your blog to implement ECC.
After completion of ECC installation and configuration, I have 2 issues currently.
Issue 1. while accessing ECC through http://ebs-url/ecc, it shows error “Current user is not allowed to access admin resource /ecc/index.jsp”
message in ecc log file:
——————————-
ExecuteThread: ‘8’ for queue: ‘weblogic.kernel.Default (self-tuning)’] ERROR o.ecc.web.filter.EccSecurityFilter – Current user is not allowed to access admin resource /ecc/index.jsp
Issue 2. “No Data to display” it show most cases and i cannot see configuration option on my Pyables or, receivables command center.
need your guidance to resolve these issues.
Thanks,
Farhad
Hi Farhad
1) It is expected and I get the same message. You should access the ECC configuration through the “ECC Developer” responsibility.
2) Please let me know if you ran the ECC Data Load requests for the associated command centers? If yes, did they complete successfully?
Thank you,
Alex
Hi Alex,
1. Yes, I can access ECC configuration through the “ECC Developer” responsibility.
2. ECC Data Load requests complete successfully.
I need to be more specific, then it will be easy to understand, currently i have 2 issues:
Problem 1: Aging of Past-Due Invoices show “No data to display”
—————————————————————————————
I followed the Documents “R12: AP: ECC: Aging of Past-Due Invoices Dashboard Is Empty – No Data to Display ( Doc ID 2817175.1 )” And tried accordingly but not solved.
Problem 1: Supplier Dashboard Does Not Include All Invoice Types, It shows only “Prepayment”.
———————————————————————————————————————————
I followed below docs, but didn’t get solution. Even cannot download Patch 35353953:R12.AP.C, it’s password protected, which was in Doc ID 3006110.1.
R12: AP/ECC: Supplier Dashboard Does Not Include All Invoice Types ( Doc ID 3006110.1 )
R12: AP: Payables ECC Dashboard Doesn’t Show Up All Statuses Of the Invoices ( Doc ID 3006776.1 )
Thank you,
Farhad
Hi Farhad
I’m afraid I can’t help you with those issues.
You have already done what I would do – check MOS for the related documents.
Thank you,
Alex