Enterprise Command Center V3
How to install and configure on Vision demo 12.2.7
Introduction
Installation
Follow metalink note: Doc ID 2495053.1
Key steps:
1.
Capacity planning
Following table shows examples of Enterprise Command Center
hardware requirements for a single data set, based on the number
of users and the number of records.
records.
Number of Users
Number of Records
Number of Cores
Required Memory
50
2 million
2
5 GB
100
2 million
3
5 GB
150
2 million
4
5 GB
50
5 million
2
6 GB
100
5 million
3
6 GB
150
5 million
4
6 G
2.
Download and install ECC
Patch 29905497 and Patch 30276526
(Tech stack patch)
3.
Download and install Other EBS ECC patches
I have installed following patches except help patches, as this is
a demo environment.
•
Patches applied on top of core 12.2.7
29499012,29499071,29499123,29499116,29501257,29499098,29499152,294
99090, 17345755, 17361679, 19766498, 27073573, 30003234, 30192168,
30204729, 30215625, 30480158
4.
Configure the Oracle Enterprise Command Center Framework
Installation
o
Update main properties $ECC_BASE/Oracle/quickInstall/
EccConfig.properties
o
Create ENV $ECC_BASE/Oracle/quickInstall/createEnvFile.sh
1
© 2020 Subhendu Datta Bhowmik,CSCP
Digital Blogs
o
$ECC_BASE/Oracle/quickInstall/envSetup.sh (execute options
one by one)
5.
Import Enterprise Command Center Applications
o
Using patchEccFiles.pl import applications one by one
6.
View Enterprise Command Center Applications from ECC
Developer responsibility.
o
User Operations and Sysadmin has ECC Admin and ECC developer
role (I have assigned)
2
© 2020 Subhendu Datta Bhowmik,CSCP
Digital Blogs
7.
Loaded full data sets for them
-
next time only run
incremental data load
1.
AP data load full - successful
2.
AR data load full - successful
3.
FA data load full
- partially failed
(high temp
issue, there is a patch, but it is password protected, need SR to
get password - patch 29504650:R12.FA.C )
4.
CST data load full - successful
5.
Quality data load full - successful
6.
Service data load full - successful
7.
Depot repair load full - successful
8.
EAM load full - successful
9.
Process Mfg load full - successful
10.
iProcurement load full
- partially failed
- need
analysis
11.
Outsourced Mfg load full - successful
12.
Lease contract - load full - successful
13.
Service Contract load full - successful
14.
Inventory Management load full - successful
15.
Order Management Load full - successful
16.
Channel Management load full - successful
17.
Project load full - successful
18.
Human Resource load full - successful
19.
Contract
life
cycle
management
load
full
-
partially failed - need analysis
20.
Procurement full load
-
This is taking huge time
and not finishing
21.
Project procurement full load - successful
22.
Discrete Manufacturing full load - successful
-
Data loading submission screen
8.
ECC UMX role and responsibility matrix for this demo env.
Complete the role and responsibility assignments using User
Management responsibility and assign responsibilities to
functional users.
3
© 2020 Subhendu Datta Bhowmik,CSCP
Digital Blogs
Shipped
Responsibility
Shipped Responsibility Code
Role Code Assignments
Name
Fixed Assets
FND_RESP|OFA|FIXED_ASSETS_MANAGER|STANDARD
UMX|FA_M_ECC_ACCESS_ROLE
Manager
Fixed Assets
FND_RESP|OFA|FIXED_ASSETS_ACCOUNTANT|
UMX|FA_A_ECC_ACCESS_ROLE
Accountant
STANDARD
Oracle Trade
FND_RESP|OZF|OZF_USER|STANDARD
UMX|OZF_ECC_ACCESS_ROLE
Management User
Accounts
Receivable
FND_RESP|OZF|OZF_AR_DED_SET_RESP|STANDARD
UMX|OZF_ECC_ACCESS_ROLE
Deductions and
Settlement
CLM Purchasing
FND_RESP|PO|PUR_CLM_SUPER_USER|STANDARD
UMX|PO_CLM_ECC_CO_ROLE
Super User
CLM
FND_RESP|ICX|SELF_SERV_CLM_PURCHASING_5|
UMX|PO_CLM_ECC_PMO_ROLE
iProcurement
STANDARD
Cost Management
FND_RESP|BOM|COST_MANAGEMENT|STANDARD
UMX|CST_ECC_ACCESS_ROLE
Cost Management
FND_RESP|CST|COST_MANAGEMENT|STANDARD
UMX|CST_ECC_ACCESS_ROLE
- SLA
OPM Financials
FND_RESP|GMF|OPM_FINANCIALS|STANDARD
UMX|CST_ECC_GMF_ACCESS_ROLE
Depot Repair
UMX|
Manager, Vision
FND_RESP|CSD|DEPOT REPAIR|STANDARD
CSD_ECC_RO_MGR_ACCESS_ROLE
Operations
Manufacturing
and
FND_RESP|MSC|MFG_AND_DIST_SUPER_USER_APS|
UMX|WIP_ECC_ACCESS_ROLE
Distribution
STANDARD
Manager
Maintenance
Super, User
Vision
FND_RESP|EAM|MSU_VIS_OPS|STANDARD
UMX|EAM_ECC_ACCESS_ROLE
Operations,
Standard
US Super HRMS
UMX|
FND_RESP|PER|US_SHRMS_MANAGER|STANDARD
Manager
PER_ECC_PEOPLE_SEARCH_ROLE
Compensation
FND_RESP|CN|CN_INC_COMP_MANAGER|STANDARD
UMX|CN_ICM_ECC_ACCESS_ROLE
Manager
UMX|
Logistics
FND_RESP|INV|INV_HTML|STANDARD
WSH_ECC_DASHBOARD_ACCESS_ROL
Manager
E
FND_RESP|ICX|SELF_SERVICE_PURCHASING_5|
iProcurement
UMX|ICX_ECC_ACCESS_ROLE
STANDARD
iReceivables
Account
FND_RESP|AR|ARI_EXTERNAL|STANDARD
UMX|IAR_ECC_ACCESS_ROLE
Management
iReceivables
FND_RESP|AR|ARI_INTERNAL|STANDARD
UMX|IAR_ECC_INT_ACCESS_ROLE
2.0 Internal
Lease Super
FND_RESP|OKL|LEASE SUPER USER|STANDARD
UMX|OKL_ECC_ACCESS_ROLE
User
Order
Management HTML
FND_RESP|ONT|ONT_HTMLUI_RESP|STANDARD
UMX|ONT_ECC_ROLE
User Interface
Subcontracting
FND_RESP|JMF|JMF_SHIKYU_SUPER_USER|
UMX|JMF_ECC_ACCESS_ROLE
Super User
STANDARD
Payables
FND_RESP|SQLAP|PAYABLES_MANAGER|STANDARD
UMX|AP_ECC_ACCESS_ROLE
Manager
Production
FND_RESP|GME|PRODUCTION SUPERVISOR|
UMX|GMO_ECC_ACCESS_ROLE
Supervisor
STANDARD
4
© 2020 Subhendu Datta Bhowmik,CSCP
Digital Blogs
Projects SU,
Vision Services
FND_RESP|PA|PA_PRM_PROJ_SU_SVCS|STANDARD
UMX|PA_ECC_ACCESS_ROLE
(USA)
Purchasing
Vision
FND_RESP|PO|PURCHASING_OPERATIONS|STANDARD
UMX|PO_PCC_ECC_ROLE
Operations
(USA)
Receivables
FND_RESP|AR|RECEIVABLES_MANAGER|STANDARD
UMX|AR_ECC_ACCESS_ROLE
Manager
FND_RESP|CS|CS_ECC_SERVICE_MANAGER|
UMX|
Service Manager
STANDARD
CS_ECC_SR_MGR_ACCESS_ROLE
Customer
UMX|
Support
FND_RESP|CS|CSZ_CS_SPECIALIST|STANDARD
CS_ECC_SR_AGNT_ACCESS_ROLE
Specialist
Service
Contracts
FND_RESP|OKS|OKS_MANAGER|STANDARD
UMX|OKS_ECC_ACCESS_ROL
Manager Vision
Enterprises
** All these responsibilities are - tagged with user -
“operations”
Sample Output - A look from EAM ECC dashboard
5
© 2020 Subhendu Datta Bhowmik,CSCP
