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 Receivables Extensions for Oracle Endeca

This chapter covers the following topics:

Overview

You can use Oracle Receivables Extensions for Oracle Endeca to quickly search and filter transaction details across organizations and related entities.

Using the Receivables Endeca pages, you can review and analyze data using key Performance Indicators (KPIs), performance evaluation metrics, charts, graphs, and tables.

You can search using Receivables pages and Endeca Information Discovery (EID) design tools. These pages are hosted in an EID environment, and called from new container pages in EBS. In Oracle Receivables, the following pages enable search functions 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.4 for the Oracle Receivables Extensions for the 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.

Oracle Receivables Extensions for Oracle Endeca User Interfaces

Outstanding Receivables Overview Page

The Outstanding Receivables Overview page provides an overview of open receivables transactions and associated key metrics. There are two Outstanding Receivables Overview pages:

The structure of the two pages is the same, however, there is a difference in the list of attributes available to support Guided Navigation, Key Metrics and related Graphs, as well as the transaction details displayed in the transactions list and details regions. The differences address specific business needs of users, and allow them to efficiently perform analysis and related tasks.

You can perform specific actions directly from the Outstanding Receivables Overview pages, or navigate to the core iReceivables application to perform further investigation prior to taking necessary actions. This is available from action icons and links associated with a specific transaction in the transactions list table, actions menu items applicable across multiple selected transactions, or through links associated with individual transaction attributes. The following is a display of the Outstanding Receivables Overview page.

From the iReceivables responsibility, navigate to the Outstanding Receivables Overview page:

(N) iReceivables 2.0 Internal > Outstanding Receivables Overview

the picture is described in the document text

the picture is described in the document text

Within the Outstanding Receivables Overview page, you can view and analyze problem areas in respect to outstanding receivables using display tools that include metrics, charts, graphs, and tables. The following describes the Endeca Outstanding Receivables Overview page regions and components:

Region Components
Alerts Alerts bring attention to specific accounts or subsets of transactions that require immediate attention. You can customize alerts based on your business requirements.
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:
  • Customer Information Attributes

    • Account Number

    • Bill-to Customer

    • Bill-to Location

    • Ship-to Customer

    • Ship-to Location

    • Collector

    • Profile Class

  • Transaction Information Attributes

    • Currency

    • Transaction Number

    • Transaction Class

    • Transaction Type

    • Transaction Date

    • Transaction Source

    • Transaction Amount

    • Due Amount

    • Due Date

    • Aging Buckets

    • Purchase Order Number

    • Sales Order Number

    • Salesperson

    • Operating Unit

    • Transaction Context

    • Transaction Reference

Task Metrics (metrics bar)

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

- Red: Critical warning state

- Yellow: Warning state

- Green: Good

  • Transaction Currency

    Either value of currency attribute selected or 'Multiple' if either no currency or multiple currencies are selected by the user.

  • Total Outstanding Balance

    Sum of all open Debit transactions (Transaction amount - Payment and Credits - Adjusted amount) - Sum of all open Credit transactions amount.

  • Past Due Balance

    Sum of all debit transactions Due amount where the Due Date < System Date.

  • Current Balance

    Sum of all debit transactions Due amount where the Due Date >= System Date

  • Unapplied Credit

    Sum of all credit transactions amount, independent of Due Date value

Transaction List (results table) Transaction List (results table)
  • Actions

    • Export

    • Print

    • Pay

    • Dispute

    • Apply Credit

  • Column Sets

    • Transaction Number

    • Transaction Class

    • Transaction Date

    • Due Date

    • Currency

    • Due Amount

    • Transaction Amount

    • Installment

    • Account Number

    • Bill-to Customer

    • Bill-to Location

    • Purchase Order Number

    • Operating Unit

Transaction Details (cross tab) Transaction Details (cross tab)
  • Customer Information

    • Account Number

    • Bill-to Customer

    • Bill-to Location

    • Bill-to Contact

    • Collector

    • Profile Class

    • Ship-to Customer

    • Ship-to Location

  • Transaction Details

    • Transaction Class

    • Transaction Source

    • Transaction Type

    • Installment

    • Purchase Order Number

    • Sales Order

    • Salesperson

    • Internal Notes

    • Credit Memo Reason

    • Special Instruction

    • Transaction Context

    • Transaction Reference

    • Business Unit

  • Amounts

    • Transaction Currency

    • Due Amount

    • Transaction Amount

    • Adjusted Amount

    • Applied Amount

    • Credited Amount

    • Payment and Credits

    • Finance Charges

    • Discount Amount

    • Open Disputed Amount

  • Dates

    • Due Date

    • Transaction Date

    • Purchase Order Date

    • Discount Expiration Date

Graphs Outstanding Balance Aging (pie chart)

Top 10 Customers by Past Due Balance (bar chart)
  • Sort Options

    • Bill-to Customers

    • Bill-to Customers by Past Due (sum)

    • Bill-to Customers by Current (sum)

Outstanding Receivables Overview Page (external)

The Outstanding Receivables Overview Page (external) targets the requirements of external customers who are either responsible for reconciling their account receivables balance, or need easy access to individual transactions to take specific action. The following is a display of the Outstanding Receivables Overview (external) page.

From the iReceivables Account Management responsibility, navigate to the Outstanding Receivables Overview page:

(N) iReceivables Account Management > Outstanding Receivables Overview

the picture is described in the document text

the picture is described in the document text

The following describes the Outstanding Receivables Overview page (external) regions and components:

Region Components
Alerts Alerts bring attention to potential problem areas in respect to accounts that require prompt investigation and action, such as unreasonably high past due receivables transactions and discounts that could be lost within the next few days.
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:
  • Customer Information Attributes

    • Account Number

    • Bill-to Customer

    • Bill-to Location

    • Ship-to Customer

    • Ship-to Location

  • Transaction Information Attributes

    • Transaction Number

    • Transaction Class

    • Transaction Date

    • Transaction Currency

    • Transaction Amount

    • Due Amount

    • Due Date

    • Purchase Order Number

    • Purchase Order Date

    • Sales Order

    • Discount Amount

Task Metrics (metrics bar)

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

- Red: Critical warning state

- Yellow: Warning state

- Green: Good

  • Transaction Currency

    Either value of currency attribute selected or 'Multiple' if either no currency or multiple currencies are selected by the user.

  • Total Outstanding Balance

    Sum of all open Debit transactions (Transaction amount - Payment and Credits - Adjusted amount) - Sum of all open Credit transactions amount.

  • Past Due Balance

    Sum of all debit transactions Due amount where the Due Date < System Date.

  • Current Balance

    Sum of all debit transactions Due amount where the Due Date >= System Date

  • Unapplied Credit

    Sum of all credit transactions amount, independent of Due Date value

  • Available Discounts

    Sum of all early payment discount amounts available

Transaction List (results table) Transaction List (results table)
  • Actions

    • Export

    • Print

    • Pay

    • Dispute

  • Column Sets

    • Transaction Number

    • Transaction Class

    • Transaction Date

    • Due Date

    • Currency

    • Due Amount

    • Transaction Amount

    • Discount Amount

    • Dispute Amount

    • Purchase Order Number

    • Account Number

    • Bill-to Customer

    • Bill-to Location

Transaction Details (cross tab) Transaction Details (cross tab)
  • Transaction Details

    • Transaction Class

    • Installment

    • Purchase Order Number

    • Sales Order

    • Credit Memo Reason

    • Special Instruction

    • Transaction Context

    • Transaction Reference

  • Amounts

    • Transaction Currency

    • Due Amount

    • Transaction Amount

    • Adjusted Amount

    • Applied Amount

    • Credited Amount

    • Payment and Credits

    • Finance Charges

    • Discount Amount

  • Dates

    • Due Date

    • Transaction Date

    • Purchase Order Date

    • Discount Expiration Date

  • Disputes

    • Dispute Numbers

    • Open Dispute Amounts

    • Dispute Dates

  • Customer Information

    • Account Number

    • Bill-to Customer

    • Bill-to Location

    • Bill-to Contact

    • Ship-to Customer

    • Ship-to Location

Graphs (region) Outstanding Balance Aging (pie chart)

Dispute List (cross tab)
  • Dispute Number

  • Dispute Date

  • Dispute Amount

  • Currency

  • Dispute Status

  • Dispute Reason

  • Transaction Number

Disputes Overview Page

The Disputes Overview page enables you to analyze disputes flow within the organization, identify specific dispute reasons requiring closer attention and further investigation, and customers abusing the disputes mechanism to delay payments. You can also use the Disputes Overview page to quickly access a specific dispute to investigate and take action. The following is a display of the Disputes Overview page.

From the iReceivables responsibility, navigate to the Disputes Overview page:

(N) iReceivables 2.0 Internal > Disputes Overview

the picture is described in the document text

the picture is described in the document text

Region Components
Alerts Alerts bring attention to specific accounts or subsets of transactions that require immediate attention, such as recently created disputes. You can customize alerts based on your business requirements.
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:
  • Customer Information Attributes

    • Account Number

    • Bill-to Customer

    • Bill-to Location

    • Collector

    • Profile Class

  • Transaction Information Attributes

    • Currency

    • Transaction Number

    • Transaction Date

    • Transaction Amount

    • Dispute Number

    • Dispute Reason

    • Dispute Date

    • Dispute Amount

    • Dispute Status

    • Dispute Requestor

    • Transaction Currency

    • Sales Order

    • Salesperson

    • Business Unit

Dispute Metrics (metrics bar)

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

- Red: Critical warning state

- Yellow: Warning state

- Green: Good

  • Transaction Currency

    Either value of currency attribute selected or 'Multiple' if either no currency or multiple currencies are selected.

  • Open Disputes Amount

    Sum of all open Disputes amounts as of the System Date.

  • Open Disputes Count

    Total number of open Disputes as of the System Date

  • Approved Disputes Amount

    Sum of all Disputes amounts where Dispute Status = Approved

  • Rejected Disputes Amount

    Sum of all Disputes amounts where Dispute Status = Rejected

Dispute Reasons (tag cloud) Top Ten Dispute Reasons Tag Cloud Component

Note: The Dispute Reasons tag cloud component displays the top ten dispute reasons by frequency of occurrence.

Disputes List (results table) Disputes List (results table)
  • Actions

    • Export

    • Print

  • Column Sets

    • Cancel

    • Dispute Number

    • Dispute Date

    • Dispute Status

    • Currency

    • Dispute Amount

    • Transaction Amount

    • Transaction Number

    • Transaction Class

    • Transaction Date

    • Account Number

    • Bill-to Customer

    • Bill-to Location

    • Operating Unit

Dispute Details (cross tab) Dispute Details (cross tab)
  • Customer Information

    • Account Number

    • Bill-to Customer

    • Bill-to Location

    • Collector

    • Profile Class

    • Ship-to Customer

    • Ship-to Location

  • Dispute Details

    • Dispute Status

    • Dispute Reason

    • Dispute Requestor

    • Transaction Number

    • Transaction Class

    • Operating Unit

  • Amounts

    • Currency

    • Dispute Amount

    • Transaction Amount

    • Due Amount

  • Dates

    • Dispute Date

    • Transaction Date

    • Due Date

Graphs Region Disputes by Dispute Reason (pie chart)

Note: This chart represents the overall disputes organized by dispute reason and enables you to identify potential systemic issues with the product quality, shipping channel, or any other area that results in a high number of specific disputes.

  • Group Metric (value)

    • Dispute Count (sum)

    • Dispute Amount (sum)

  • Series Dimensions (color)

    • Dispute Reason

    • Dispute Status


Top 10 Customers by Number of Disputes (bar chart)

Note: This chart represents the top ten customers who have the most disputes and allow the information to be partitioned by Dispute Status (insight in the relative number of approved versus rejected disputes on a per customer basis), or Dispute Reason (understanding those issues that the customer is experiencing that result in disputes initiation).

  • Sort Options

    • Bill-to Customers

    • Bill-to Customers by Open Dispute Count (sum)

    • Bill-to Customers by Approved Dispute Count (sum)

    • Bill-to Customers by Rejected Dispute Count (sum)

  • Group Dimensions (category axis)

    • Bill-to Customers

    • Dispute Reason

Oracle Receivables Extensions for Oracle Endeca Product Configuration

Setting Up Oracle Receivables Extensions for Oracle Endeca

The Oracle Receivables 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

You must complete the following steps to set up Oracle Receivables Extensions for Oracle Endeca:

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

  2. Run the full load graph in the Clover server to import all transaction and dispute data.

  3. Schedule Setup in the Clover server to run incremental and daily load graphs.

  4. Set Profile Options.

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

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

UMX Role Internal Code Name
OIR Endeca Internal Role UMX|ARI_INT_ENDECA_ACCESS_ROLE
OIR Endeca External Role UMX|ARI_EXT_ENDECA_ACCESS_ROLE

You must add the new UMX role 'OIR Endeca Internal Role' (Internal Code Name: UMX|ARI_INT_ENDECA_ACCESS_ROLE) for the internal user Receivables responsibility to enable the Endeca menus. Add the 'OIR Endeca External Role' (Internal Code Name: UMX|ARI_EXT_ENDECA_ACCESS_ROLE) for external users accessing iReceivables using their custom responsibility to enable Endeca menus for the custom responsibility. You must assign these UMX roles to the responsibilities. When the UMX roles are assigned to the iReceivables Information Portal, the Endeca pages appear.

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

Receivables includes separate Permissions, Grants, and Responsibilities due to the sensitive information displayed on the Internal and External Outstanding Receivables Overview Pages. The following are the Receivables Permission Sets, Grants, and Responsibilities.

Permission Sets Internal Code Name
OIR Endeca Internal Access Permission Set OIR_ENDECA_INT_ACCESS_PS
OIR Endeca External Access Permission Set OIR_ENDECA_EXT_ACCESS_PS
Grants Internal Code Name
OIR Internal Access Grant OIR_ENDECA_INT_ACCESS_GRANT
OIR External Access Grant OIR_ENDECA_EXT_ACCESS_GRANT
Responsibilities Function Name
iReceivables 2.0 Internal ARI_INTERNAL
iReceivables Account Management ARI_EXTERNAL

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

  1. Assign a UMX Role to the Responsibility.

  2. Update OIR_ENDECA_INT_ACCESS_GRANT (OIR Internal Access Grant)

  3. Update OIR_ENDECA_EXT_ACCESS_GRANT (OIR External Access 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 Receivables Data into the Endeca Data Store

Clover ETL within Endeca queries Receivables Views and completes a full data load to the Receivables data store in Endeca. After the first data load, you can perform full data load, incremental data load, and daily load as required. Incremental data load updates all records in the Endeca data store which were updated in EBS after the last load. The daily load calculates the aging bucket and discount. After the data has been loaded into the Endeca data store, it can be queried and shown in the Receivables Extensions for Oracle Endeca pages.

Receivables Data Sources in the Endeca Data Store

Three data sources are defined in the Receivables data store in Endeca and are used to query data for different Receivables Extensions for Oracle Endeca pages. These data sources include:

Setting Up the Scheduler for Endeca Full, Incremental, and Daily Load

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. Run the daily load graph to calculates the aging bucket and discount.

Note: No changes will be reflected in the Endeca Receivables pages until incremental refresh is performed. Therefore, Oracle recommends that you schedule incremental and daily load to perform frequent updates. These processes typically finish quickly. Full load can take time to finish and is not required once it has been implemented unless exceptions occur, such as data corruption, or the aging bucket profile is changed.

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, and Daily.grf..

  13. Click 'Create' to set the scheduler.

ETL Parameters for Receivables

You can load data to the Receivables data store by running full load, incremental load, and daily load graphs provided by Receivables.

To load data to the Receivables data store

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

  2. Graphs to load data include:

Profile Options for Receivables

You must set the following profile options:

Profile Option Name Description
OIR: Aging Buckets This site level profile reuses the Oracle Receivables aging buckets for the Outstanding Receivables Overview pages.
OIR: Filter Transactions Days Older Than This site level profile reuses the Oracle Receivables dispute range for the Disputes Overview page.

Views and Joins for Receivables

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

View Name Purpose
ARI_EID_TRX_V Loads transaction data from the AR payment schedule and other reference tables. It queries attributes of invoice, credit memo, debit memo, charge back, deposit, and guarantee.
ARI_EID_CMREQ_V Loads credit memo request related information including transaction number, credit request number, request amount, request date, and so on.

Menus for Endeca Receivables

Endeca Receivables integration includes the following new user menu and Responsibilities functions:

Menus

User Function Name Function Name
OIR Endeca Search Page ARI_ENDECA_SEARCH
OIR Endeca Dispute Home Page ARI_ENDECA_DISPUTE_HOME_PG
iReceivables V2.0 Internal ARI_MENU_INTERNAL
iReceivables Account Management ARI_MENU_EXTERNAL

Responsibilities

User Function Name Function Name
iReceivables 2.0 Internal ARI_INTERNAL
iReceivables Account Management ARI_EXTERNAL