Search from 700 + Posts

Jul 15, 2019

Oracle Enterprise Command Center Framework (ECC)


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.

K E Y F E A T U R E S

  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)


K E Y B E N E F I T S

  1. Identify and act on top priorities without custom operational reporting.
  2. Access from mobile or desktop devices, and with high performance.
  3. Experience quick user adoption.
  4. Improve data communication with support for a variety of visualizations and charts.
  5. Deploy rapidly, with no change to the Oracle E-Business Suite database.
  6. Leverage out-of-the-box UI and security integration.
  7. Analyze structured and unstructured Oracle E-Business Suite information.
  8. Flexibly meet new business requirements through configuration instead of coding.
  9. Customize the layout of delivered command center dashboards and include custom data elements in the Oracle E-Business Suite instance


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 Oracle E-Business Suite. With tools and visualizations such as
Actionable indicators
Tag clouds.
Interactive charts
Consumer-like search
Filters,
users can browse and drill on whatever engages their attention. With each drilldown or search refinement, the entire interface recomputes, revealing 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. Having identified the most pressing business challenges, users seamlessly transition to detailed transaction screens to take immediate, informed action. Transaction screens are pre-populated with the results of information discovery ─ no re-querying of data is required. Users can switch between information discovery and transaction screens as they work their way through a set of identified problems, retaining the current discovery context.

Below is some key feature for Order Management Dashboard 
You can access the Orders Dashboard using the following navigation:
Order Management, HTML User Interface responsibility > Command Center
From the Orders Dashboard, you can:
  • Review assigned orders.
  • Review and book orders to meet customer requirements.
  • Act on potential delays or issues.
  • Validate that draft orders are correct prior to booking and book the orders.
  • Monitor order alerts such as order holds, and take the necessary follow-up action.
  • Monitor exceptions related to order fulfillment and take the necessary follow-up action.
  • Quickly and efficiently search orders based on various attributes across the entire record.
  • Prioritize shipments to meet revenue goals.




Dashboard  Extension

Because Oracle E-Business Suite is used across many industries and environments, users may have special requirements to extended these dashboard and data sets to fulfill business requirements and good news is Oracle has provided framework to

  1. Extend a data set to include additional attributes not shipped out of the box but available in Oracle E-Business Suite
  2. Display those attributes in the different part of the ECC dashboard


May 6, 2019

Query to find next approver in Oracle EBS


SELECT     LEVEL, e.*
      FROM (SELECT DISTINCT papf.person_id, papf.employee_number,
                            papf.full_name "EMPLOYEE_FULL_NAME",
                            paaf.supervisor_id,
                            papf1.employee_number "SUPERVISOR_EMP_NUMBER",
                            papf1.full_name "SUPERVISOR_FULL_NAME",
                            ppt.user_person_type,
                            papf.business_group_id
                       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'

Oracle AME API to find Next Approver in AME hierarchy

Below is quick way to find next approver in Oracle AME hierarchy  ( Using oracle AME APIs)

declare
a   VARCHAR2(100);
b ame_util.approversTable2;
BEGIN
 AME_API2.getNextApprovers4(applicationIdIn   => 200,
                            transactionTypeIn => 'APEXP' ,  --Application Type
                            transactionIdIn   => '9999',   --Transaction ID
                            approvalProcessCompleteYNOut => a,
                            nextApproversOut   => b);
END;