Oracle

Enterprise
Command
Centers
(ECC)
What are Enterprise
Key Features
Command Centers?

High Level
Key Benefits
Architecture

Data Load Security

Useful Links
Oracle Enterprise Command Centers (ECC)

Information Driven Aimed at solving on the Fully Integrated with

Navigation to discover problem of what users Oracle E-Business Suite
and act upon business should work on next
challenges

Enable to optimize Real-time access to

operation decisions and operational data, driving
improve process better costs and revenue
efficiency decisions
Oracle Enterprise Command Centers (ECC)
Key Features
• Actionable indicators

• Consumer-like search and filters

• Instant search results

• Search across organizations

• Saved search for frequently-used filters

• Interactive visualizations

• Guided navigation

• Tag clouds

• Charts

• Fully integrated with Oracle EBusiness Suite security and page flows

• Available for both desktop and mobile devices

• Multilingual Support (MLS)

• Extensible with Oracle Enterprise Command Center Framework

 Key Benefits

Oracle Enterprise Command Centers (ECC)

• Identify and act on top • Access from mobile or
• Experience quick user
priorities without custom desktop devices, and
adoption
operational reporting with high performance

• Improve data
• Deploy rapidly, with no • Leverage out-of-the-
communication with
change to the Oracle E- box UI and security
support for a variety of
Business Suite database integration
visualizations and charts

• Flexibly meet new

• Expose additional data
business requirements • Update dashboard
in the EBS instance on
through configuration design and visualizations
the dashboard
instead of coding
31 command centers with more than 110 role-
based dashboards for use with the following Oracle Enterprise Command Centers (ECC)
Oracle E-Business Suite products:
• Financial Management: Receivables,
iReceivables, Payables, Assets, Lease Contracts
(Financials), Lease and Finance Management
• Order Management and Logistics: Order
Management, Inventory Management, Advanced
Pricing, iStore, Landed Cost Management,
Channel Revenue Management, Incentive
Compensation
• Asset Lifecycle and Service: Enterprise Asset
Management, Asset Tracking, Service Contracts,
Service (TeleService), Field Service, Depot Repair
• Procurement and Projects: iProcurement,
Procurement, Projects, Project Procurement,
Contract Lifecycle Management for Public Sector
• Manufacturing: Discrete Manufacturing, Process
Manufacturing, Outsourced Manufacturing,
Project Manufacturing, Cost Management,
Quality
• Human Capital Management: Human Resources
 Oracle Enterprise Command Centers (ECC)

ECC is a middleware technology, architecture of which is made up of three main components.

1. Interactive User Interface layer. ECC development framework allows for code-free creation of dashboards using
drag-and-drop layout design, declarative configuration of all components and automatic rich interactions across
different sections of a dashboard.

2. Service Layer. ECC provides services that allow the client to define a data set, ingest data into it, and control
advanced behaviors using metadata.

3. ECC Core Engine. This is the core component of ECC where the data ingested from the source system, that is,
Oracle EBusiness Suite, is stored. During data storage, analysis is performed to allow fast and advanced data
access supporting several patterns of user queries. Advanced capabilities for language processing can optionally
be employed
 •To create an Enterprise Command
Center dashboard, the following steps
are needed:
• Define an application and relevant
data sets. This will include all
metadata required to render pages
and control every attribute
behavior on the user interface.

• Data ingested from the source

system, that is, Oracle E-Business
Suite, into the ECC data set
defined above.

Data is the core foundation for any dashboard. • Pages that expose ingested data
The data is ingested into the ECC engine from the source system using rules and shapes defined and takes advantage of interactive
by the source system. components available in the ECC
The source of truth of the data is the Oracle E-Business Suite system. component palette to build
ECC architecture relies on the power and flexibility of Oracle E-Business Suite database SQL and business dashboards.
PL/SQL to prepare and retrieve the data in the shape required and run the data load process
from Oracle E-Business Suite into ECC.

Oracle Enterprise Command Centers (ECC)

 Incremental Load

Incremental data load follows the same logic and procedure as that for data load with two
main differences.
First, incremental load expects that the data set is already created, and its metadata be
already captured .
Second, incremental data load will pick up only the modified data from Oracle E-Business
Full Load Suite as of the time of the last successful
full or incremental load.

Metadata Load

One of the first steps after installing ECC and import an Metadata load is an advanced feature that allows the definition of dynamic metadata
application for a particular business area is run full data load. at runtime (not shipped in dashboard
A full load for a business dashboard is triggered from a definition). An excellent example of this is Descriptive Flexfields (DFFs) in Oracle E-
concurrent job owned by the same business area. Business Suite. Those cannot be defined at design time as they differ from one
The program triggers the associated data set load rules customer instance to the next. Hence a dynamic metadata definition phase is
defined in ECC. available that allows such metadata to be specified at runtime and later get populated
ECC connects to Oracle E-Business Suite using the with data during the full and incremental loads.
EBS SDK to allow the data load code to run any data
preparation, cleansing and wrangling logic before data is
ingested into ECC.
Oracle Enterprise Command Centers (ECC)
 ECC AUTHENTICATION
•When a business user accesses an embedded
ECC dashboard, ECC will validate the existence of
a valid and authenticated Oracle E-Business Suite
session before any additional checks are
performed.
• Authorization controls are applied next to that
allow granular control over which dashboards
are exposed to user.
ECC relies on security model provided by Oracle E-Business Suite to secure access to dashboards and
the underlying data. It inherits user access privileges from Oracle E-Business Suite and relies on the ECC AUTHORIZATION
user being authenticated before gaining access to the embedded ECC dashboards. •Once authentication is done through an Oracle
E-Business Suite session, then authorization is
verified through matching the ECC data set
privilege name with the FND form function.
Page Level Security
•Pages secured in ECC using
FND_FORM_FUNCTION defined in Oracle E-
Business Suite.
•A shipped Oracle E-Business Suite role (utilizing
Role Based Access Control, RBAC) is used to
assign ECC dashboard access to responsibilities.

Oracle Enterprise Command Centers (ECC)

 Data Level Security

•To access data within an ECC data set, the user must
have at least one of the data set privileges (these are
controlled and defined as an Oracle E-Business Suite
form function).

•Once access to the data set is verified, a security

handler is applied for any subsequent query against
that data set to ensure data access is restricted to
the subset the user is allowed to see.

•This is the next level of security which enforces data

access restrictions on data displayed in dashboard.

Oracle Enterprise Command Centers (ECC)

Oracle Enterprise Command Centers (ECC)

Or
ac
le
Pr
Re oc
qu
isit ur
Or io n em
Ag
de
rs
sd
ash en
St r re
em D ash
bo t
ar d
at e en bo
Ind gic ts ar d
ir e So Da
ct ur sh
Pr cin bo
Su o g ar d
O ra c le pp
lie
cu
re Da
A sse t s Em It e
rA me
nt
shb
oa
O ra c le plo m na
lys Da rd
Asse t R
Oracle Assets
e co ncilia Oracle ReceivablesRe c e iva Oracle Payables
ye A n is sh
t io ns ble s eS aly
sis
Da
sh
bo
ar d
O ut st an O ho
ra c le Pppi Da b oa
Asse t C
Asset Reconciliations
o st
d ing Re ce
Outstanding Receivables ayngable shb
ivable s Supplier Balance Dashboard
s rd
Tr oa
Supplie r a ck r d
Billing Pr Balance
AssCost
Asset e t Aging Billing Processo ce ss Holds Dashboear D
r dash
bo
Asse tAging Payme nt Ho lds ar d
Asset Lo cat io n Payment Process Pr o ce s s Discounts
Asse t M Payme nt D o un
AssetasLocation
s Tr ansac Payment Hist o r y
History PeriodiscClose
ts
t io ns
Pe r io d C Pe r io d C
Asset Asse t Transactions
Mass Pipeline Period Close
lo se   lo se

Asset Pipeline    
Useful Resources

https://www.oracle.com/a/ocom/docs/ebs-enterprise-command-centers-march-2021.pdf

https://www.oracle.com/a/ocom/docs/applications/ebusiness/ebs-enterprise-command-center-quick-start-guide.pdf

https://docs.oracle.com/cd/E26401_01/doc.122/f21671/T673609T673613.htm

https://docs.oracle.com/cd/E26401_01/doc.122/f21671/T673609T673834.htm