Oracle Financials Information Discovery Plus: Payables

This chapter covers the following topics:

• Overview
• Supplier Balance Page
• Holds Page
• Discounts Opportunity Page
• Setting Up Oracle Financials Information Discovery Plus: Payables
• Setup and Configuration Steps
• Access Control: Hide and Show EID Dashboards (User Interfaces) for Oracle Payables
• Loading Payables Data into the Endeca Data Domain
• Setting Up the Scheduler for Endeca Full and Incremental Load
• ETL Parameters for Payables
• Profile Options for Payables
• Views and Joins for Payables
• Menus and Functions for Payables

Overview

You can use Oracle Financials Information Discovery Plus for Payables to quickly search and filter transaction details across organizations and related entities.

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

You can search using payables 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 Payables, the following pages enable search functions using Endeca Information Discovery Integration:

• Supplier Balance Page: The Supplier Balance Page enables a payables manager to utilize several different features and functionality to access pertinent payables information quickly. For example, the manager can view which supplier has highest invoice amount due along with the due date; and once that information is identified, can then take an action on that invoice for example pay up that specific invoice. In addition this page also lists the recently paid invoices. With this the manager will be able to quickly look at the details of invoices which were recently paid and track necessary information as required.

• Holds Page: The Holds page, provides the payables manager the ability to view payables invoices which are currently on hold due to several reasons. Based on the information available, the manager can easily view the problematic invoices and act upon those invoices by resolving the issues that resulted in holding of the invoice; the action may also involve resolving potential dispute with the supplier. Once the invoice gets released from the hold, it can be paid. The Holds page is designed to show both PO matched and non-PO invoices.

• Discounts Opportunity Page: The Discounts Opportunity page, provides the payables manager the ability to view payables invoices along with the discounts that can be availed on these invoices. The discount available information includes a breakdown of the discount amounts by invoices as well as by discount expiration dates etc. Based on the information available, the manager can maximize discounts by managing the timing of invoice payments.

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

Oracle Financials Information Discovery Plus: Payables User Interfaces

Supplier Balance Page

The Supplier Balance Page enables a payables manager to utilize several different features and functionality to access payables information quickly. For example, the manager can view which supplier has highest invoice amount due along with the due date; and once that information is identified, can then take an action on that invoice for example pay up that specific invoice. In addition this page also lists the recently paid invoices. The payables manager can quickly view details of recently paid invoices and track information as required. The following describes the Endeca Supplier Balance page regions and components:

From the Payables responsibility, navigate to the Supplier Balance page:

(N) Payables Dashboard > Supplier Balance

Region	Components
Sub Tabs (page links)	Supplier Balance - Select this sub-tab to navigate to the Supplier Balance page. Holds - Select this sub-tab to navigate to the Holds page. Discounts Opportunity - Select this sub-tab to navigate to the Discounts Opportunity page.
Advanced Search Search within	The Advanced Search component includes value search, record search, Boolean search, and partial search capabilities. You can submit keyword searches and the application provides type-ahead suggestions and displays attribute values that match the typed text. When you perform a search, the search term is added to the Selected Refinements component. As you type, you may be prompted to select a matching attribute value, or simply search for the entered text. Additional Information: See the Advanced Search Capabilities appendix in this guide for details.
Selected Refinements	The Selected Refinements component displays all values that you have selected to filter data, and allows you to quickly make adjustments to the current refinement by removing items or clearing all filters from the list.
Bookmarks	The Bookmarks component allows you to save a given navigation and component state and return to it at a later time.
Available Refinements	You can use the Available Refinements component to filter data using attribute groups. Expand the following attribute groups to view and select attribute names: Ledger Invoice Details Supplier Hold Details Date Amount
Open Payables (summarization bar) Note: The Metric Components are color coded to highlight warnings and health: Red: Critical Warning State Yellow: Warning state Green: Good	Open Payables - Use this to monitor the health of payables open transactions. These metrics are based on the filters applied for the report. However in the default view as there will be no filters applied the information displayed will be based on the data which you can access. Following metrics are displayed for this report: Functional Currency: The currency of the selected ledger (primary filter) Supplier Balance: Sums all invoices in ledger currency which are unpaid or partially paid invoices. This displays all invoice types except for Expense Reports and Prepayments. Only unpaid prepayment invoices are included. Amount displays in ledger currency and the conversion of foreign currency invoices uses the invoice exchange rate. Employee Balance: Sums all invoices of Expense Reports type that are unpaid. Amount displays in ledger currency and the conversion of foreign currency invoices uses the invoice exchange rate. Unapplied Prepayment: Sums all prepayment invoices that are available and are not fully applied. Amount displays in ledger currency and the conversion of foreign currency invoices uses the invoice exchange rate. Past Due Invoices: Displays the sum of all overdue invoices. Amount displays in ledger currency and the conversion of foreign currency invoices uses the invoice exchange rate. Invoices Due in 7 Days: Displays the sum of all invoices due within the next 7 days. Amount displays in ledger currency and the conversion of foreign currency invoices uses the invoice exchange rate.
Top 10 Suppliers	Top 10 Suppliers - Displays details of the top 10 suppliers. The ranking is based on the frequency of operations with the supplier
Charts and Graphs	Aging of Past Due Invoices: The resulting data, based on applicable filters, is displayed according to the aging template selected. The x-axis represents the aging periods for open invoices according to the template set in the profile option and the y-axis represents Unpaid Invoice Amount / Invoice Count. The invoice amount displays ledger currency and the conversion uses the exchange rate available on the invoice. Supplier Open Balance: The resulting data, based on applicable filters, displays party wise. The x-axis represents the LE/BU/Supplier/Currency and the y-axis represents Unpaid Invoice Amount / Invoice Count. The invoice amount displays ledger currency and the conversion uses the exchange rate available on the invoice.
Results Tables	Open Invoices: Displays results based on filters applied on various dimensions. Results display in column format and display schedules of all unpaid or partially paid invoices that are accessible to you (OU security). Invoices Paid in Last 7 Days: Displays results based on filters applied on various dimensions. Results display in a column format and display schedules of invoices paid in the last 7 days.

Holds Page

The Holds page provides the payables manager the ability to view payables invoices which are currently on hold due to several reasons. Based on the information available, the manager can easily view the problematic invoices and act upon those invoices by resolving the issues that resulted in holding of the invoice; the action may also involve resolving potential disputes with the supplier. Once the invoice is released from the hold, it can be paid. The Holds page is designed to show both PO matched and non-PO matched invoices. The following describes the Endeca Holds page regions and components:

From the Payables responsibility, navigate to the Holds page:

(N) Payables Dashboard > Holds

Region	Components
Sub Tabs (page links)	Supplier Balance - Select this sub-tab to navigate to the Supplier Balance page. Holds - Select this sub-tab to navigate to the Holds page. Discounts Opportunity - Select this sub-tab to navigate to the Discounts Opportunity page.
Advanced Search Search within	The Advanced Search component includes value search, record search, Boolean search, and partial search capabilities. You can submit keyword searches and the application provides type-ahead suggestions and displays attribute values that match the typed text. When you perform a search, the search term is added to the Selected Refinements component. As you type, you may be prompted to select a matching attribute value, or simply search for the entered text. Additional Information: See the Advanced Search Capabilities appendix in this guide for details.
Selected Refinements	The Selected Refinements component displays all values that you have selected to filter data, and allows you to quickly make adjustments to the current refinement by removing items or clearing all filters from the list.
Bookmarks	The Bookmarks component allows you to save a given navigation and component state and return to it at a later time.
Available Refinements	You can use the Available Refinements component to filter data using attribute groups. Expand the following attribute groups to view and select attribute names: Ledger Invoice Details Supplier Hold Details Date Amount
Hold Metrics (summarization bar) Note: The Metric Components are color coded to highlight warnings and health: Red: Critical warning state Yellow: Warning state Green: Good	Hold Metrics Functional Currency: Currency of the selected ledger (primary filter) Past Due Invoices on Hold: Amount of invoices on hold with past due date. Invoices Held due in 7 Days: Amount of invoices on hold and due in the next 7 days. Discount Lost due to Holds: Discount amount available on invoices on hold and missing at least one discount date. Invoice Amount on Hold: Sum of all invoices on hold (not payment hold). Amount displays in selected ledger currency and the conversion of foreign currency invoices uses the invoice exchange rate. Invoices on Hold: Count of the invoices on hold. Average Hold Period: Derived as Sysdate - Hold date for all pending holds / count of invoices on hold.
Top 10 Holds (tag cloud component)	Top 10 Holds Tag Cloud: - Displays details of the top 10 hold reasons. The ranking is based on the frequency that a hold is applied, either manually or by the application. The analysis is based on the display filters. However, the default view applies no filters and the analysis covers the entire data set. The tag cloud displays the hold name and count of invoices on hold. When you select any hold name, the hold is added as a filter and data is refreshed.
Charts and Graphs	Invoices on Hold: The data is based on the filters displays party wide. The x-axis represents the LE/OU/Supplier and the y-axis represents Invoice amount on Hold / Count of Invoices on Hold. The invoice amount displays in the selected ledger currency and the conversion uses the exchange rate available on the invoice. Aging of Invoices on Hold: The data is based on filters and displays according to the pre-seeded aging buckets. The aging is based on the period in which the invoice was on hold. The x-axis represents the aging periods for invoices which are on hold and the y-axis represents the Invoice amount on hold / count of invoices on hold. The invoice amount displays in the selected ledger currency and the conversion uses the exchange rate available on the invoice. Discount Available on Invoices Held: The data is based on the filters and displays according to discount or due date. This alerts you of a potential loss of discount or the possibility of slipping payments on a due date if the holds are not resolved within the next few days. The x-axis represents either Discount date or due date and the y-axis represents count of invoices on hold.
Results Tables	Invoices on Hold: - Displays all invoices on hold according to selected parameters. Hold Details: - Displays hold details.

Discounts Opportunity Page

The Discounts Opportunity page provides the payables manager the ability to view payables invoices along with the discounts that can be availed on these invoices. The discount available information includes a breakdown of the discount amounts by invoices as well as by discount expiration dates, etc. Based on the information available, the payables manager can maximize discounts by managing the timing of invoice payments. The following describes the Discounts Opportunity page regions and components:

From the Payables responsibility, navigate to the Discounts Opportunity page:

(N) Payables Dashboard > Discounts Opportunity

Region	Components
Sub Tabs (page links)	Supplier Balance - Select this sub-tab to navigate to the Supplier Balance page. Holds - Select this sub-tab to navigate to the Holds page. Discounts Opportunity - Select this sub-tab to navigate to the Discounts Opportunity page.
Advanced Search Search within	The Advanced Search component includes value search, record search, Boolean search, and partial search capabilities. You can submit keyword searches and the application provides type-ahead suggestions and displays attribute values that match the typed text. When you perform a search, the search term is added to the Selected Refinements component. As you type, you may be prompted to select a matching attribute value, or simply search for the entered text. Additional Information: See the Advanced Search Capabilities appendix in this guide for details.
Selected Refinements	The Selected Refinements component displays all values that you have selected to filter data, and allows you to quickly make adjustments to the current refinement by removing items or clearing all filters from the list.
Bookmarks	The Bookmarks component allows you to save a given navigation and component state and return to it at a later time.
Available Refinements	You can use the Available Refinements component to filter data using attribute groups. Expand the following attribute groups to view and select attribute names: Ledger Invoice Details Supplier Date Amount Hold Details
Discount Metrics (summarization bar) Note: The Metric Components are color coded to highlight warnings and health: Red: Critical warning state Yellow: Warning state Green: Good	Discount Metrics Functional Currency: The currency of the selected ledger (primary filter) Discount Available in 7 Days: Displays the sum of all available discounts (either first/second/third) expiring in the next 7 days. Amount displays in the ledger currency and the conversion of foreign currency invoices uses the invoice exchange rate. Discount on Invoices Held: Discount amount, presented in ledger currency, is available on invoices on hold but has the risk to be lost due to holds on invoices. Derived by summing the next available discount on invoices which are placed on hold.
Top 10 Suppliers (tag cloud component)	Top 10 Suppliers: Displays details of the top 10 suppliers. Ranking is based on the maximum number of discountable schedules available from each supplier's outstanding balance.
Charts and Graphs	Discounts Available: The data is a result of the selected filters and is based on the discount date. One bar represents the schedule amount and another bar represents the discount available on the scheduled amount. The x-axis represents the individual Dates/Weeks/Suppliers and the y-axis represents discount amount and the invoice amount. The amount displays the ledger currency or entered currency and the conversion uses the invoice exchange rate. Discount Available by Percentage: The data is a result of the selected filters and displays by discount date. The graph is a bar chart where two bars are displayed for every value of x-axis. One bar represents the schedule amount and another bar represents the discount available on the scheduled amount. The x-axis represents discount dates and the y-axis represents discount amount. The amount displays the ledger currency or entered currency, and the conversion uses invoice exchange rate. In addition, there is a trend line that displays the discount percentage for the available discounts across discount expiration dates.
Results Table	Payment Schedules with Discount: Displays all invoices with discount terms (based on the parameters selected).

Oracle Financials Information Discovery Plus: Payables Product Configuration

Setting Up Oracle Financials Information Discovery Plus: Payables

The Oracle Payables application configuration and setup must be completed after the installation and common configurations are completed as described in Installing Oracle E-Business Suite Information Discovery, Release 12.2 V8 (Doc ID: 2214431.1).

Setup and Configuration Steps

You must complete the following steps to set up Oracle Financials Information Discovery Plus for Payables:

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

2. Set Profile Options.

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

4. Schedule Setup, in the Clover server to run incremental load graphs.

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

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

UMX Role	Internal Code Name
Payables Endeca Access Role	UMX|AP_ENDECA_ACCESS_ROLE

You must add the new UMX role Payables Endeca Access Role (Internal Code Name: UMX|AP_ENDECA_ACCESS_ROLE) for the Payables Manager responsibility to enable the Endeca menus.

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.

Payables includes the following Permission Sets, Grants, and Responsibilities.

Permission Sets

• Permission Set Name: Payables Endeca Access Permission Set

• Code: AP_ENDECA_ACCESS_PS

• Permissions Included in the Set:

  • Discount Opportunity (EID)

  • Payables Discounts Page

  • Supplier Balance (EID)

  • Payables Supplier Balance Page

  • Holds Management (EID)

  • Payables Holds Page

  • Payments Schedule Validation

Grants

• Grant Name: AP Endeca Access Grant

• Grantee Type: All Users

• Responsibility: select the predefined responsibility Payables Manager or a custom responsibility of your choice

• Permission Set Name: Payables Endeca Access Permission Set

Responsibilities

• Payables Manager

• Any custom responsibility

Enabling Financials Information Discovery Plus: Payables Menus in Oracle E-Business Suite (EBS)

1. Assign a UMX Role to the Responsibility

2. Add the Payables Endeca Access Role to the predefined Payables Manager responsibility or to any custom payables responsibility. Update the Grant AP Endeca Access Grant and the Permission Set Payables Endeca Access Permission Set.

   For assigning UMX Roles and Grants, refer to Appendix C in Installing Oracle E-Business Suite Information Discovery, Release 12.2 V8 (Doc ID: 2214431.1).

Loading Payables Data into the Endeca Data Domain

Clover ETL within Endeca queries payables views and completes a full data load to the payables data domain 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 domain 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 domain, it can be loaded and displayed in the payables pages.

Payables Data Sources in the Endeca Data Domain

Data sources are defined in the payables data domain in Endeca and are used to load data for different payables extensions for Oracle Endeca pages. The parent data source is ap and includes the following:

• ap-trx: This data domain is used to load data for supplier balance pages.

• ap-disc: This data domain is used to load data for discount opportunity pages.

• ap-hold: This data domain is used to load hold pages.

• ap-misc: This data domain is used to load hold details and recent paid history.

Setting Up the Scheduler for Endeca Full and Incremental Load

The initial data upload for Endeca Search is complete when the Full graph is run as described in Installing Oracle E-Business Suite Information Discovery, Release 12.2 V8 (Doc ID: 2214431.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.

Note: No changes will be reflected in the Payables pages until incremental refresh is performed. Therefore, Oracle recommends that you schedule incremental 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.

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. FullLoadConfig.grf or IncrementalLoadConfig.grf.

13. Click Create to set the scheduler.

ETL Parameters for Payables

You can load data to the payables data domain by running the full load and incremental load graphs provided by payables.

To load data to the Payables data domain

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

2. Graphs to load data include:

   • FullLoadConfig.grf: This graph deletes all existing data, initializes the data domain, and loads all data to the payables data domain.

   • IncrementalLoadConfig.grf: This graph loads updated and new data, and deletes closed or incomplete records since last full load or incremental load was processed. The Purpose of this graph is to synchronize the Endeca data domain with the database. Oracle recommends that you run this graph frequently (every few minutes), depending on your business requirements.

Profile Options for Payables

You must set the following profile option:

Profile Option Name

Description

AP: Endeca Aging Template

This profile option (AP_EID_AGING_TEMPLATE) set at the site level enables you to set your own aging template for Endeca reports. The profile option displays a list of all the aging templates defined in payables which are active. You can select any one template for use. Important: If this profile is not set, then Full Load Graph cannot run for payables during the Endeca installation and configuration process.

Views and Joins for Payables

The following views are used by the ETL layer in Endeca to load payables data to the Endeca data domain:

View Name	Purpose
AP_EID_INSTALLMENT_V	Fetches installment data from the AP payment schedule and other reference tables. It queries attributes of invoices, installment, hold, supplier, and so on.
AP_EID_HOLD_V	Fetches hold details data from the AP holds which are not released.
AP_EID_PAID_HISTORY_V	Fetches recent payments from the invoice payments & AP checks tables.
AP_EID_PREPAYMENT_V	Fetches the paid prepayments.

Menus and Functions for Payables

Payables integration includes the following new user menu and responsibilities functions:

Functions

User Function Name	Function Name
Discount Opportunity(EID)	AP_ENDECA_DISCOUNT_HOME
Discount Opportunity	AP_ENDECA_DISCOUNTS
Supplier Balance(EID)	AP_ENDECA_BALANCE_HOME
Supplier Balance	AP_ENDECA_SUPP_BALANCE
Holds Management(EID)	AP_ENDECA_HOLD_HOME
Holds Management	AP_ENDECA_HOLDS
Payments Schedule Validation	AP_ENDECA_VALIDATION

Menus

Menu Name	Menu Code	Function Name
Payables EID Dashboard	AP_ENDECA_EID_MENU	Holds Management(EID)
Payables EID Dashboard	AP_ENDECA_EID_MENU	Discounts Opportunity(EID)
Payables EID Dashboard	AP_ENDECA_EID_MENU	Supplier Balance(EID)
Payables Dashboard Prompt - Holds Management	AP_ENDECA_MENU	Holds Management
Payables Dashboard Prompt - Discounts Opportunity	AP_ENDECA_MENU	Discounts Opportunity
Payables Dashboard Prompt - Supplier Balance	AP_ENDECA_MENU	Supplier Balance
Payables Dashboard	AP_ENDECA_MENU	Payments Schedule Validation
Payables Dashboard	AP_ENDECA_MENU Sub Menu - Payables EID Dashboard