Skip Headers

Oracle E-Business Suite Extensions for Oracle Endeca Integration and System Administration Guide
Release 12.1.3.4
Part Number E37993-04
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Oracle Cost Management Extensions for Oracle Endeca

This chapter covers the following topics:

Overview

You can use Oracle Cost Management Extensions for Oracle Endeca to quickly search and filter transaction details across organizations and related entities. You can also use the guided navigation and other search features of Endeca to identify hidden trends. Using the Cost Management Endeca pages, you can review and analyze data using key Performance Indicators (KPIs), performance evaluation metrics, charts, graphs, and tables.

You can search using Cost Management pages and Endeca Information Discovery (EID) design tools. These pages are hosted in an EID environment, and called from new pages that embed the Endeca pages in EBS. The following pages are available for Costing using Endeca Information Discovery integration:

This chapter provides product-specific details required to integrate Endeca Information Discovery (EID) with Oracle E-Business Suite Release 12.1.3.3 for the Oracle Cost Management Extensions for Oracle Endeca application. This supplements the information provided in Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.1.3.4 (Doc ID: 1562372.1). You must read this document and make note of the requirements before you begin your installation.

Note: Landed Cost Management Endeca pages are included in the Cost Management Extensions for Oracle Endeca product.

Oracle Cost Management Extensions for Oracle Endeca User Interfaces

Period Health Check Page

The Period Health Check page lets you search for and display Inventory, Manufacturing, Receiving, Shipping, Landed Cost Management, and Enterprise Asset Management transactions that are preventing period close, as well as transactions that are to be reviewed and preferably processed but are not necessary for period close. Using the Guided Navigation and other search features, you can search on Organization, Transaction, Job, Receiving, Maintenance, Project, and Inter Organization Transfer data. You can view period close metrics, charts, and transaction data displayed in results tables. The following is a display of the Period Health Check page.

From the Cost Management responsibility, navigate to the Period Health Check page:

(N) Cost > Accounting Close Cycle > Period Health Check

the picture is described in the document text

You can use the Period Health Check page to view transactions that could prevent or delay period close. You can analyze data and review transaction metrics, charts, graphs, and tables. The following describes the Endeca Cost Management Period Health Check page regions and components:

Region Components
Alerts The Period Close, Alerts displays a list of the transactions with errors that are preventing Period Close.
Range Filters You can use Range Filters to refine the displayed data to only include records that have attribute values within a specified range. Range Filters include:
  • Transaction Date

Guided Navigation You can use the Guided Navigation component to filter data using attribute groups. Expand the following attribute groups to view and select attribute names:
  • Transaction Date

  • Organization Structure

  • Maintenance

  • Receiving

  • Job

  • Transaction

  • Inter Organization Transfer

Period Health Check Metrics (metrics bar)

Note: The Metric Components are color coded to highlight warnings and health:

- Red: Critical warning state

- Yellow: Warning state

- Gray: Normal

- Green: Good

  • Unprocessed Material

  • Uncosted Material/WSM

  • Pending WIP Costing

  • Pending WSM Interface

  • Pending LCM Interface

  • Unprocessed Shipping

  • Pending Receiving

  • Pending Material

  • Pending Shop Floor Move

  • Incomplete Work Orders

Organizations (tag cloud) Top Ten Organizations Tag Cloud Component

Note: The Organizations tag cloud component displays the top ten organizations having the most transactions displayed in relative sizes by frequency of occurrence.

Transactions Overview (tabbed component container)
Overview (tab)
Transaction Backlog (chart)
  • Sort Options

    • Organization

    • Organization by Record Count

  • Series Dimensions (color)

    • Duration


Transaction Distribution by Organization (cross tab)

Note: The Overview - Transactions Distribution by Organization cross tab displays the transaction counts grouped by Functional Group and Organization.

Transactions Overview (tabbed component container)
The tabbed container includes tabs for each of the following transaction sources:
  • Inventory (tab)

  • Manufacturing (tab)

  • Receiving (tab)

  • Shipping (tab)

  • Landed Cost Management (tab)

  • Enterprise Asset Management (tab)

Transaction Distribution by Organization (chart)

Note: The Transaction Distribution by Organization chart displays the transaction counts grouped by Transaction Source and Organization.

  • Sort Options

    • Organization

    • Organization by Record Count

  • Series Dimensions (color)

    • Data Source


Transaction Distribution by Organization (cross tab)

Note: The Transaction Distribution by Organization cross tab displays the counts of transactions grouped by Source Type and Organization.


Transaction Details (results table)

Note: The Transaction Details results table displays all attributes pertaining to the transactions and are grouped into column sets. Each column set contains a subset of logically related and relevant columns. Therefore, there is no need for long scrolls to view all the transaction details.

Transaction Accounting Register Page

The Transaction Accounting Register page displays material, manufacturing, receiving, and write-off transaction accounting information along with SLA and GL accounting (if transferred to GL in detail mode). Using the Guided Navigation, you can search on various attributes classified under Organization, Job, Account, Transaction, Receiving, and Write-off attribute groups. You can view Transaction Distributions Overview charts, graphs and Subledger results tables. The following is a display of the Transaction Accounting Register page.

From the Cost Management responsibility, navigate to the Transaction Accounting Register page:

(N) Cost > View Transactions > Transaction Accounting Register

the picture is described in the document text

You can use the Transaction Accounting Register page to view charts, graphs, and tag clouds for insights into Transaction Accounting Distributions. The following describes the Endeca Cost Management Transaction Accounting Register page regions and components:

Region Components
Guided Navigation You can use the Guided Navigation component to filter data using attribute groups. Expand the following attribute groups to view and select attribute names:
  • Transaction Date

  • Organization Structure

  • Account

  • Receiving

  • Transaction

  • Write Off

  • Job

Transaction Distributions by Natural Segment (tag cloud) Top Ten Transaction Distributions by Natural Segment Tag Cloud Component

Note: The Transaction Distributions by Natural Segment tag cloud component displays the top ten Natural Segment Accounts based on the accounting distributions displayed in relative sizes by frequency of occurrence.

Transactions Accounting Overview (tabbed component container)
Overview (tab)
Transactions by Organization (chart)

Note: The Overview - Transaction by Organization chart displays distributions of the number of transactions by Organizations stacked by Source Type of the transactions.

  • Sort Options

    • Organization

    • Organization by Record Count

  • Series Dimension (color)

    • Data Source


Ledger Balance by Organization (cross tab)

Note: The Overview - Ledger Balance by Organization cross tab displays ledger balances for all Organizations.

  • Actions

    • Configure

    • Export to Microsoft Excel

Transactions Accounting Overview (tabbed component container)
Inventory (tab)
Transaction Value by Organization (chart)
  • Sort Options

    • Organization

    • Organization by Base Transaction Value (sum)

  • Series Dimension (color)

    • Accounting Line Type


Inventory Subledger (cross tab)
  • Column Sets

    • Transaction Details

    • Organization Attributes

    • Manufacturing Attributes

    • Purchasing Attributes

    • SLA Accounting

    • GL Journals

    • SLA and GL Accounting

    • Inventory Attributes

    • Inventory Subledger Accounting

Transactions Accounting Overview (tabbed component container)
Manufacturing (tab)
Transaction Value by Organization (chart)
  • Sort Options

    • Organization

    • Organization by Base Transaction Value (sum)

  • Series Dimension (color)

    • (none)

    • Accounting Line Type


Manufacturing Subledger (cross tab)
  • Column Sets

    • Transaction Details

    • Organization Attributes

    • Work-In-Process Subledger Accounting

    • Purchasing Attributes

    • SLA Accounting

    • GL Journals

    • SLA and GL Accounting

    • Manufacturing Attributes

Transactions Accounting Overview (tabbed component container)
Receiving (tab)
Transaction Value by Organization (chart)
  • Sort Options

    • Organization

    • Organization by Base Transaction Value (sum)

  • Series Dimension (color)

    • (none)

    • Accounting Line Type


Receiving Subledger (cross tab)
  • Column Sets

    • Transaction Details

    • Organization Attributes

    • Receiving Subledger Accounting

    • Receiving Attributes

    • Purchasing Attributes

    • Job Attributes

    • SLA Accounting

    • GL Journals

    • SL and GL Accounting

Transactions Accounting Overview (tabbed component container)
Write Off (tab)
Transaction Value by Organization (chart)
  • Sort Options

    • Organization

    • Organization by Base Transaction Value (sum)

  • Series Dimension (color)

    • Accounting Line Type


Receiving Subledger (cross tab)
  • Column Sets

    • Transaction Details

    • Organization Attributes

    • Invoice Attributes

    • Receiving Attributes

    • Inventory Attributes

    • SLA Accounting

    • GL Journals

    • SLA and GL Accounting

    • Write-off Attributes

Oracle Cost Management Extensions for Oracle Endeca Product Configuration

Setting Up Oracle Cost Management Extensions for Oracle Endeca

The Oracle Cost Management application configuration and setup must be completed after the installation and common configurations are completed as described in Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.1.3.4 (Doc ID: 1562372.1).

Setup and Configuration Steps

To set up Oracle Cost Management Extensions for Oracle Endeca, you must complete the following steps:

  1. Set Access Control by assigning UMX roles and updating access grants.

  2. Load Cost Management data to the Endeca data store by running graphs provided by Cost Management.

  3. Schedule Setup for Full Endeca Refresh.

  4. Set Profile Options.

Access Control: Hide and Show EID Dashboards (User Interfaces) for Oracle Cost Management

As part of the Oracle E-Business Suite-EID integration for the Oracle Cost Management application, the following UMX Roles are provided:

UMX Role Internal Code Name
Costing Endeca Period Health Check Access Role UMX|CST ENDECA PRD HLTH CHK ACCESS ROLE
Costing Endeca Transaction Accounting Register Access Role UMX|CST ENDECA TXN REG ACCESS ROLE

You must add the new UMX roles 'Costing Endeca Period Health Check Access Role' (Internal Code Name: UMX|CST ENDECA PRD HLTH CHK ACCESS ROLE) and 'Costing Endeca Transaction Accounting Register Access Role' (Internal Code Name: UMX|CST ENDECA TXN REG ACCESS ROLE) to enable Endeca menus for the Cost Management responsibility (or any other custom responsibility which is using the same menu). You must assign these UMX roles to the responsibility. When these UMX roles are assigned to the Cost Management Information Portal, the Endeca Cost Management menus appear.

If you want to use the Endeca-related roles with more than one responsibility, then you must have an additional grant with a security context corresponding to each responsibility. You can add grants for a given role as a separate process instead while you are adding the role to the responsibility.

Complete the following steps to enable Endeca Menus in Oracle E-Business Suite (EBS):

  1. Assign a UMX Role to the Responsibility.

  2. Update CST_ENDECA_ACCESS_GRANT Grant.

For assigning UMX Roles and Grants, refer to Appendix C in Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.1.3.4 (Doc ID: 1562372.1).

Loading Cost Management Data into the Endeca Data Store

Clover ETL within Endeca queries Cost Management views and processes full or incremental data load to the Cost Management data stores in Endeca. There are two Cost Management data stores:

First, set up the Profile CST:Endeca Txn Reg Start Date (DD-MON-YYYY) to a date which lowers cutoff date for the accounting data that is loaded into Endeca server for the Transaction Accounting Register. Then, run the first full data load. Incremental data load can be performed periodically. Incremental data load will update all the records in the Endeca Cost Management data stores which were updated in EBS after the last load. After the data has been loaded in the Cost Management data stores, it can be queried and shown in the Cost Management Endeca pages. For the Period Health Check data store, there is only a full load graph because of the nature of data where successfully processed transactions must be removed.

Cost Management Data Sources in the Cost Management Data Store

Period Health Check uses parent and child data sources. The parent data source contains all transactions and the child data source contains transactions for a specific tab. Data sources include:

The Transaction Accounting Register also uses parent and child data sources. The parent data source contains all transactions and the child data source contains transactions for a specific tab. Data sources include:

Setting Up the Scheduler for Endeca Full Refresh

The initial data upload for Endeca Search is complete when the Full graph is run as described in Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.1.3.4 (Doc ID: 1562372.1). Full refresh deletes all data from Endeca and repopulates it with a full data extract from the E-Business Suite system. For incremental refresh, you should determine how often the Endeca data should be refreshed from E-Business Suite depending on your organizational requirements.

To schedule ETL on the Integrator Server

  1. Login to Integrator server using your Clover login.

  2. Click the Scheduling tab.

  3. Select the New Schedule link.

  4. Enter a Description for the scheduler.

  5. Select Periodic as the Type.

  6. Select by interval as the Periodicity.

  7. Enter a start date and time in the Not active before date/time field.

  8. Enter an end date and time in the Not active after date/time field.

  9. Enter a value in the Interval (minutes) field.

  10. Ensure you select the Fire misfired event as soon as possible check box.

  11. Select Start a graph from the Task Type list.

  12. Select the graph for schedule to run. I.e. Full.grf/incremental.grf.

  13. Click Create to set the scheduler.

ETL Parameters for Cost Management

You can load data to the Cost Management data store by running graphs provided by Cost Management.

To load data to the Cost Management Data Store

  1. Using the URL for the EID Integrator Server, navigate to the Sandboxes page and expand the graph node under Cost Management.

  2. Graphs to load data include:

    Endeca ETL Parameters for Period Health Check

    ##### Endeca Server Specifics ######
    ENDECA_SERVER_HOST=localhost
    ENDECA_SERVER_PORT=7770
    DATA_STORE_NAME=bom-cstphc
    
    ##### Data Store Specifics ######
    MDEX_EXTRA_ARGS=<server-control:arg>--threads</server-control:arg><server-control:arg>4</server-control:arg>
    MDEX_PORT=9901
    MDEX_BULK_PORT=9902
    MDEX_TRANSACTION_ID=

    Endeca ETL Parameters for Transaction Accounting Register

    ##### Endeca Server Specifics ######
    ENDECA_SERVER_HOST=localhost
    ENDECA_SERVER_PORT=7770
    DATA_STORE_NAME=bom-csttar
    
    ##### Data Store Specifics ######
    MDEX_EXTRA_ARGS=<server-control:arg>--threads</server-control:arg><server-control:arg>4</server-control:arg>
    MDEX_PORT=9601
    MDEX_BULK_PORT=9602
    MDEX_TRANSACTION_ID=
    
    ##### EBS FND Table Specifics #####
    LANGUAGE_CODE=US
    INSTANCE_ID=204
    LOAD_TYPE=F
    FND_USER=1
    RECORD_TYPE=bom-csttar
    
    ### Misc ########
    MULTIASSIGN_DELIMITER=\u007F
    
    ##### Sample Load View view_config.xml Location #####
    viewXMLFile=sandbox://bom-csttar/data-out/view_config.xml

Profile Options for Cost Management

You must set the following profile option to load all data from a specified date for the Transaction Accounting Register page.

Profile Option Name Description
CST:Endeca Txn Reg Start Date (DD-MON-YYYY) This profile option defines the start date from which the data is selected for full load of the Transaction Accounting Register.

Views and Joins for Cost Management

The following views are used by the ETL layer in Endeca to load Cost Management data to the Endeca data store:

TAR:
View Purpose
CST_END_ORG_STRUCTURE_V Denormalized view for organization structure details.
CST_END_TXN_REG_INV_V View for accounting information of inventory transactions.
CST_END_TXN_REG_RCV_V View for accounting information of receiving transactions.
CST_END_TXN_REG_WIP_V View for accounting information of WIP transactions.
CST_END_TXN_REG_WO_V View for accounting information of write-offs.
CST_END_TXN_REG_FULL_LOAD_V Denormalized view for Receiving, Inventory, WIP, and Write-off accounting (Full Load).
CST_END_TXN_REG_INCREMENTAL_V Denormalized view for Receiving, Inventory, WIP, and Write-off accounting (Incremental Load).

PHC:
View Purpose
CST_END_ORG_STRUCTURE_V Denormalized view for organization structure details.
CST_END_PHC_EAM_WO_V View for pending work order details.
CST_END_PHC_INVENTORY_TXNS_V View for pending / unprocessed / uncosted inventory transactions.
CST_END_PHC_LCM_INT_TXNS_V View for pending LCM transactions.
CST_END_PHC_RCV_INT_TXNS_V View for pending receiving transactions.
CST_END_PHC_WMTI_V View for pending WIP / Move transactions.
CST_END_PHC_WSH_UNP_TXNS_V View for unprocessed shipping transactions.
CST_END_PHC_WSM_INT_TXNS_V View for pending WSM transactions.
CST_END_PRD_HLTH_CHK_MAIN_V Denormalized view for all pending transactions.

Note: CST_END_ORG_STRUCTURE_V is common to both TAR and PHC.

Menus for Endeca Cost Management

Endeca Cost Management integration includes the following user menu functions:

User Function Name Function Name
Costing Endeca Period Health Check Function CST_ENDECA_PERIOD_HLTH_CHECK
Costing Period Health Check OA Page CST_ENDECA_PRD_HLTH_CHK_OA
Costing Endeca Transaction Accounting Register Function CST_ENDECA_TXN_ACCT_REG
Costing Transaction Accounting Register OA Page CST_ENDECA_TXN_ACCT_REG_OA