Search from 700 + Posts

Jul 23, 2019

Oracle EBS Enterprise Command Center

Oracle EBS Enterprise Command Center 

In this post I will highlight

  1. What is Enterprise Command Centers for EBS
  2. ECC Framework 
  3. Key Feature of Payables Command Center
  4. Key Feature of Service Contract Command Center
  5. Key Feature of Shipping/Logistics Command Center
  6. Key Feature of Service Command Center

Enterprise Command Centers (ECC) provide information discovery along with visualization and exploration capabilities embedded within Oracle E-Business Suite user interfaces. ECC Framework enables the creation of business dashboards in different functional areas. Oracle E-Business Suite users navigate transactional information using interactive visual components and guided discovery capabilities allowing exploratory data analysis. Mobility and responsive design is built into the ECC Framework, and all dashboards automatically adjust layout to better fit a desktop or mobile device form factor. ECC automatically adheres to existing Oracle E-Business Suite security. The dashboard content a user sees is completely consistent with Oracle E-Business Suite context and security.

Each Oracle Enterprise Command Center extends the owning Oracle E-Business Suite application with discovery-oriented dashboards that bring together diverse operational data from across the Oracle E-Business Suite. ECC dashboard users identify and act on top priorities without the need for custom operational reporting, and use information-driven navigation. With tools and visualizations such as actionable indicators, tag clouds, interactive charts, and consumer-like search and filters, users can browse and drill on whatever engages their attention. With each drilldown or search refinement, the data engine recalculates indicators, tag clouds, charts, and search choices to provide the user with new information on which to base next discovery steps. Through this "conversation with the data", users narrow in on today's most important business challenges, all without predefined navigation paths, structured queries, or operational reports.

Jul 15, 2019

Oracle Enterprise Command Center Framework (ECC) for EBS

Oracle Enterprise Command Center Framework (ECC) is data discovery feature provide by Oracle for E-Business user ( EBS 12.2.4 onward and it is FREE)  provides information discovery, visualization, and exploration capabilities embedded within the Oracle E-Business Suite user interface. Oracle Enterprise Command Center Framework enables the creation of business dashboards in different functional areas such as Supply Chain, Financials, Manufacturing, Procurement, and so on.

In an Enterprise Command Center dashboard, users navigate transactional information using interactive visual components and guided discovery that allow exploratory data analysis. The ability to drill down to detailed insights into the data allows the dashboards to be action driven.
Each ECC dashboard has a set of features that allow users to answer essential questions, uncover business insights, and drill down to take the relevant action. It helps users quickly and intuitively analyze data so they can make confident decisions driven by data.

Oracle E-Business Suite delivers out-of-the-box dashboards across many product families and functional areas. The dashboards are rich in functionality and the nature of the technology allows for a highly interactive user experience that can cater to various use cases and scenarios. At the same time, the dashboards are extensible, allowing users to extend the use of the feature set and address additional requirements specific to their implementation.

Oracle Enterprise Command Centers are aimed at solving the problem of what users should work on next. Included with Oracle E-Business Suite, Oracle Enterprise Command Center dashboards enable information-driven navigation to help users focus on the right information, at the right time, to make the right decisions.


  1. Actionable indicators
  2. Consumer-like search and filters.
  3. Instant search results.
  4. Search across organizations.
  5. Interactive visualizations.
  6. Guided navigation.
  7. Tag clouds.
  8. Charts.
  9. Fully integrated with Oracle EBusiness Suite security and page flows 
  10. Available for both desktop and mobile devices.
  11. Multilingual Support (MLS).
  12. Built with Oracle Enterprise Command Center Framework (ECC)

May 6, 2019

Query to find next approver in Oracle EBS

      FROM (SELECT DISTINCT papf.person_id, papf.employee_number,
                            papf.full_name "EMPLOYEE_FULL_NAME",
                            papf1.employee_number "SUPERVISOR_EMP_NUMBER",
                            papf1.full_name "SUPERVISOR_FULL_NAME",
                       FROM apps.per_all_people_f papf,
                            apps.per_all_assignments_f paaf,
                            apps.per_all_people_f papf1,
                            apps.per_person_types ppt
                      WHERE papf.person_id = paaf.person_id
                        AND papf1.person_id = paaf.supervisor_id
                       -- AND papf.business_group_id = 142
                        AND papf.business_group_id = paaf.business_group_id
                        AND TRUNC (SYSDATE) BETWEEN TRUNC(NVL(papf.effective_start_date,sysdate)) AND TRUNC(NVL(papf.effective_end_date,sysdate))
                        AND TRUNC (SYSDATE) BETWEEN TRUNC(NVL(paaf.effective_start_date,sysdate)) AND TRUNC(NVL(paaf.effective_end_date,sysdate))
                        AND ppt.person_type_id = papf.person_type_id
                        AND ppt.user_person_type <> 'Ex-employee'
                        ) e
CONNECT BY PRIOR person_id = supervisor_id
START WITH person_id = 'Enter Employee ID'