Data Applications → Analyze Oracle EBS Purchasing
About the Oracle EBS Purchasing Data Application
The Oracle E-Business Suite (EBS) Purchasing module streamlines purchase order processing while strengthening policy compliance. It automates routine purchasing tasks to make buyers more productive, improves supply base management, and adapts to virtually any procurement process. The Incorta Direct Data Platform™ data application for the Purchasing module provides prebuilt schemas, dashboards, and insights to provide you increased visibility into the complete Procurement and Spend process, including supplier performance analysis and payables analysis. Organizations can significantly reduce costs, enhance profitability, increase customer satisfaction, and gain competitive advantage through complete end-to-end insight into the factors that impact Procurement and Spend performance.
Here are some of the questions answered by the Oracle EBS Purchasing data application:
- What is the root cause of unfavorable purchase price variance (PPV)?
- Is my inventory carrying cost consuming gains from favorable PPV?
- Which suppliers have quality and delivery issues?
- Are there outstanding payments for suppliers with quality and delivery issues?
- What is the off-contract spend for this quarter?
- What are the top 10 products by indirect spend amount?
You can further customize and add on to the insights in the Incorta Purchasing data application to support your specific business needs.
Note
The Oracle EBS Purchasing data application is available in the On-Premises and Cloud Versions of Incorta.
Purchasing Data Application Components
Here are the Incorta prebuilt Purchasing data application physical schemas, business schemas, dashboard folders, dashboards, and insights:
Physical Schemas
EBS_PO- EBS common schemas:
EBS_ITEM_COMMONEBS_CAL_COMMONEBS_FND_COMMONEBS_HR_COMMONEBS_FIN_COMMONEBS_PARTY_COMMON
Business Schemas
- PurchaseOrder: Provides an operational view of the purchase orders to help manage the overall procurement process and make sure purchase orders are processed in a timely manner
- ReceivingTransactions: Analyzes receiving transactions by entities, such as supplier and location, for a given period
- SpendOverview: Provides an accounting view of the purchase orders, where you can get visibility into all aspects of spend by supplier, buyer, item, business unit and accounting segments to help decrease procurement costs, improve efficiency, and monitor compliance
Dashboard Folder
- Purchasing
- Buyer Dashboards
Dashboards and Insights
- Purchasing
Purchasing Dashboards
Procure2Pay Overview Dashboard
The Procure2Pay Overview Dashboard provides insight into requisitions, purchase orders (POs), and suppliers. This dashboard consists of the following tabs: Overview, and Invoice & Payments.
Overview Tab
| Insight | Description |
|---|---|
| Requisition Count | This KPI insight shows the count of total purchase requisitions |
| Open POs | This KPI insight shows the count of open purchase orders |
| Receipt Count | This KPI insight shows the count of total transaction receipts |
| Top Requisition Items | This pie insight shows the top ten requisition product item by quantity as a percent of total requisition quantity for these items |
| Supplier Summary | This column insight shows the ordered amount, invoice amount, and payment amount as a column for each supplier |
| Requisition Details | This listing table insight shows the requisition details, including: operating unit (OU), PO number, supplier name, requisition header ID, requisition number, requisition line number, requisition approval status, purchase requestor, item, product description, request creation date, PO header ID, requisition quantity, and requisition amount |
| Purchase Order Details | This aggregated table insight shows the purchase order details, including: PO number, supplier name, line number, approved date, buyer, supplier site, item description, PO open flag, quantity, and amount ordered. Select a PO number to open the Go To Menu. From this menu, you are able to select the AP Drill dashboard. The AP Drill dashboard opens and inherits the runtime filters from the Purchase Order Details insight. |
| PO Receipts | This listing table insight shows the PO receipt details, including: PO number, supplier name, line number, transaction type, transaction date, transaction amount, amount billed, invoice status, receipt number, shipment number, line number, shipped date, item description, amount shipped, and amount received |
Example: Overview Tab
Invoice & Payments Tab
| Insight | Description |
|---|---|
| Invoice Count | This KPI insight shows a count of invoices |
| Invoice Amount (USD) | This KPI insight shows the total invoice amount in US dollars |
| Amount Remaining (USD) | This KPI insight shows the invoice due amount remaining in US dollars |
| Top 10 Suppliers by Outstanding Payment | This sunburst insight shows the top ten suppliers by outstanding payment amount in the outer ring, with the total supplier outstanding payment amount in the innermost element |
| Payment Due Aging | This column insight shows the remaining payment due amount by aging bucket |
| AP Invoice Details | This listing table insight shows the accounts payable (AP) invoice details, including: PO number, invoice number, line number, supplier name, invoice description, invoice date, invoice currency code, amount, and amount USD |
| Invoice Payment Details | This listing table insight shows the invoice payment details, including: PO number, invoice number, supplier name, invoice date, payment period, payment number, invoice currency, payment amount, discount offered, discount taken, discount lost, global (USD) rate, amount remaining, and amount remaining (global) |
Example: Invoice & Payments Tab
Buyer Control Panel Dashboard
| Insight | Description |
|---|---|
| Approved Amount | This KPI insight shows the PO approved amount |
| # of Buyers | This KPI insight shows the number of buyers associated with the POs |
| Open POs | This KPI insight shows the number of open POs |
| # of Suppliers | This KPI insight shows the number of suppliers associated with the POs |
| # 7 Days | This KPI insight shows the number of POs for which payment is at least seven days late |
| # POs | This KPI insight shows the total number of POs |
| # Lines | This KPI insight shows the total number of PO lines |
| Late PO Buckets | This stacked column insight shows the number of POs that are at least seven days late, and the number of POs that are not late |
| Late POs Supplier Summary | This packed bubble insight shows the number of late POs by supplier |
| MRB $ | This KPI insight shows the Material Review Board (MRB) inventory dollar amount |
| # Items | This KPI insight shows the MRB number of inventory items |
| MRB$ | This pie insight shows the MRB inventory dollar amount by buyer as a percent of total MRB amount |
| MRB Item Detail sorted by most recent date | This aggregated table insight shows the MRB item details sorted by most recent date, including: date, item organization, item description, MRB, MRB stage, and total |
| Invoices on Hold | This KPI insight shows the number of AP invoices on hold |
| Open Holds | This KPI insight shows the number of AP open invoices on hold |
| AP Holds Aging | This stacked column insight shows the number of AP holds by aging bucket and hold lookup code |
| AP Holds by Supplier | This line insight shows the number of AP holds by supplier |
| POs not approved @ Line Level | This aggregated table insight shows POs that are not approved with details at the line level, including: PO, header status, shipment status, buyer, organization,item, item description, supplier name, drop ship flag, days PO late, creation date, release date, promised date, match type, PO type, closed code, quantity ordered, quantity received, quantity billed, and dollar amount ordered |
| POs not approved @ Header | This aggregated table insight shows POs that are not approved with details at the header level, including: PO, header status, shipment status, buyer, organization,item, item description, supplier name, drop ship flag, days PO late, creation date, release date, promised date, match type, PO type, closed code, quantity ordered, quantity received, quantity billed, and dollar amount ordered |
Example: Buyer Control Panel Dashboard
Procure2Pay Cycle Dashboard
The Procure2Pay Cycle Dashboard provides insight into requisition, purchase order, supplier and accounts payable details. This dashboard consists of the following tabs: Reqs and PO, and AP.
Reqs and PO Tab
| Insight | Description |
|---|---|
| Approved Amount | This KPI insight shows the total purchase order approved amount |
| # of Buyers | This KPI insight shows the number of buyers associated with the POs |
| Open POs | This KPI insight shows the number of open POs |
| # of Suppliers | This KPI insight shows the number of suppliers associated with the POs |
| Receipts | This KPI insight shows the number of transaction receipts without invoices |
| Req # | This KPI insight shows the number of requisitions without an invoice |
| Fulfilled Amount | This KPI insight shows the fulfilled requisition amount |
| In Process Amount | This KPI insight shows the in process requisition amount |
| Incomplete Amount | This KPI insight shows the incomplete requisition amount |
| Top Supplier Outstanding Payments | This donut insight shows the top twenty suppliers by outstanding payment amount, as a percentage of total outstanding payment amount |
| Supplier Summary | This stacked column insight shows the ordered amount, invoice amount, and payment amount for each supplier |
| PO Req Details | This listing table insight shows the PO requisition details, including: supplier name, PO number, requisition number, requisition type, requisition status, authorization status, buyer, amount ordered, amount delivered, amount billed, and amount |
| Requisitions Without PO | This listing table insight shows the details for requisitions without a PO, including: item description, requisition number, requisition description, requisition type, line number, destination type code, requisition line quantity, requisition line amount, and distribution ID |
| PO Receipts Without Invoices | This listing table shows the details for PO receipts without invoices, including: supplier name, PO number, PO line number, transaction type, transaction date, invoice status, receipt number, shipment number, line number, and item description |
| PO Receipts | This listing table insight shows PO receipt details, including: supplier name, PO number, line number, transaction type, transaction date, transaction amount, amount billed, invoice status, receipt number, shipment number, receiving transaction line number, shipped date, item description, amount shipped, and amount received |
| Purchase Order Details | This aggregated table insight shows purchase order details, including: supplier name, PO number, line number, approved date, buyer, supplier site, item description, PO open flag, quantity, and amount ordered |
Example: Reqs and PO Tab
AP Tab
| Insight | Description |
|---|---|
| Outstanding Payments | This KPI insight shows the total amount of outstanding supplier payments |
| Early Payment Amount | This KPI insight shows the amount that suppliers paid early |
| % Overdue | This KPI insight shows the percent of payments that are overdue |
| % Due | This KPI insight shows the percent of payments that are due in the future |
| Invoices on Hold | This KPI insight shows the number of invoice that are on hold |
| Open Holds | This KPI insight shows the number of open holds |
| AP Holds by Supplier | This column insight shows the number of AP holds by supplier |
| AP Invoice Details | This listing table insight shows the AP invoice details, including: supplier name, invoice number, invoice line number, PO number, period name, supplier site, invoice amount, discount amount taken, and quantity invoiced |
| Invoice Payment Details | This listing table insight shows the invoice payment details, including: supplier name, invoice number, invoice date, payment period, payment number, invoice currency, payment amount, discount offered, discount taken, discount lost, global (USD) rate, amount remaining, and amount remaining (global) |
Example: AP Tab
Buyer and Supplier Performance Dashboard
| Insight | Description |
|---|---|
| Quantity Fill Rate | This KPI insight shows the PO fill rate (quantity received / quantity ordered) percent |
| Quantity Ordered | This KPI insight shows the item quantity ordered |
| Quantity Received | This KPI insight shows the item quantity received |
| Supplier Evaluation Metrics | This line insight shows the supplier fill rate by year |
| Supplier Evaluation (sorted by low fill rate) | This aggregated table insight shows the supplier evaluation details sorted by low fill rate, including: supplier name, fill rate, quantity ordered, quantity received, and quantity remaining |
| Buyers with Open/Late POs | This aggregated table insight shows buyers and the associated number of open and late POs |
| Top Vendors by Avg PO Amount | This aggregated table insight shows the top vendors sorted by highest average PO amount, and also includes number of purchase orders and order amount |
| Purchase Order Details | This aggregated table insight shows the purchase order details, including: supplier name, buyer, purchase order number, line number, approved date, supplier site, item description, PO open flag, amount ordered, quantity ordered, and quantity received. Select a PO number to open the Go To Menu. From this menu, you are able to select the AP Drill dashboard. The AP Drill dashboard opens and inherits any dashboard runtime filters from the Purchase Order Details insight. |
Example: Buyer and Supplier Performance Dashboard
Blanket POs Dashboard
| Insight | Description |
|---|---|
| Blanket Total Amount | This KPI insight shows the total amount for Blanket POs |
| Released Amount | This KPI insight shows the released amount for Blanket POs |
| Top Suppliers by % Blanket Released | This aggregated table insight shows the top suppliers sorted by highest percent of blanket POs released, and also includes the total blanket PO amount |
| Top Blanket POs by % Blanket Released | This aggregated table insight shows the top blanket POs sorted by highest percent of blanket POs released, and also includes the total blanket PO amount |
| Purchase Order Details | This aggregated table insight shows the purchase order details, including: PO number, PO type, line number, release number, buyer, supplier name, supplier site code, PO open flag, quantity, and amount ordered |
Example: Blanket POs Dashboard
Late POs Dashboard
| Insight | Description |
|---|---|
| Late POs | This KPI insight shows the number of late POs |
| Open POs Past Due Date | This stacked bar insight shows the number of late POs by days late bucket |
| By Supplier | This packed bubble insight shows the number of late POs by supplier |
| By Buyer => Match Type | This donut insight shows the number of late POs by buyer as a percent of total late POs. Select a buyer to view the number of late POs by match type a percent of total late POs for the buyer. |
| By Item Category | This aggregated table insight shows quantity ordered, quantity received, quantity billed, and dollar amount ordered by item category |
| Purchase Order Details | This aggregated table insight shows the purchase order details, including: PO number, release number, line number, PO type, match type, drop ship flag, status, days PO late, creation date, promised date, item, item description, buyer, supplier name, header closed code, closed code, commodity, quantity ordered, quantity received, quantity billed, and dollar amount ordered |
Example: Late POs Dashboard
Spend Dashboard
| Insight | Description |
|---|---|
| Total Spend (Millions) | This KPI insight shows the total spend in millions |
| Avg. Spend per Supplier (Millions) | This KPI insight shows the average spend per supplier in millions |
| Off Contract Spend % | This KPI insight shows the off contract spend percent |
| Spend Trend | This line insight shows a trend of amount spent by quarter |
| Total Spend by Categories | This dual axis insight shows the cumulative spend percent as a line, and the total spend amount as a bar by item category |
| Which Items make up Top 80% of the Spend? | This aggregated table insight shows the product items that make up the top eighty percent of the spend amount |
| Which Suppliers make up Top 80% of the Spend? | This aggregated table insight shows the suppliers that make up the top eighty percent of the spend amount |
| Spend by category and sub category | This listing table insight shows the details of the spend by category and subcategory, including: PO organization, department, supplier name, requestor, PO creation date, item, PO currency, unit price, purchase order number, quantity ordered, quantity cancelled, quantity billed, quantity delivered, PO transactional amount, and PO amount USD |
Example: Spend Dashboard
PO Management Dashboard
| Insight | Description |
|---|---|
| # of Buyers | This KPI insight shows the number of buyers |
| Open POs | This KPI insight shows the number of open POs |
| # of Suppliers | This KPI insight shows the number of suppliers |
| Top 10 Suppliers by Open POs | This packed bubble insight shows the top ten suppliers by the highest number of open POs |
| Top 10 Buyers by Open POs | This treemap insight shows the top ten buyers by the highest number of open POs |
| Late POs | This column in sight shows the number of POs by days late bucket |
| Suppliers contributing to top 80% for all POs | This aggregated table insight shows the suppliers that make up the top eighty percent of the PO amount |
| Top 10 Items with Open POs | This aggregated table insight shows the top ten items with the highest open PO amount |
| Suppliers with Late POs | This aggregated table insight shows suppliers with late POs sorted by the highest number of late POs |
| Purchase Order Details | This aggregated table insight shows the purchase order details, including: PO number, line number, item description, release number, buyer, supplier name, supplier site code, PO open flag, quantity, and amount ordered |
Example: PO Management Dashboard
PO Requisitions Dashboard
| Insight | Description |
|---|---|
| Requisition by BU | This pie insight shows the requisition amount by business unit as a percent of total requisition amount |
| Requisition by Supplier | This treemap insight shows the requisition amount by supplier |
| PO and Requisition Details | This listing table insight shows the PO and requisition details, including: PO requisition number, requisition line number, requisition approval status, PO number, PO revision number, PO status, PO requestor, PO buyer, PO business unit, supplier name, supplier site name, item, product description, requisition creation date, requisition approved date, PO creation date, PO line type, PO authorization status, PO unit price, requisition quantity, requisition amount, PO amount, and PO quantity |
Example: PO Requisitions Dashboard
Open PO with Open Commitments Dashboard
| Insight | Description |
|---|---|
| PO Details | This listing table insight shows the PO details, including: company, PO organization, buyer, PO creation date, PO approved date, PO number, PO line number, promised date, supplier number, supplier name, supplier site name, item, PO status, PO line type, PO unit of measure (UOM), unit price, PO currency, requestor, PO line closed status, department, PO requisition number, segment 1, segment 2, segment 3, segment 4, segment 5, segment 6, quantity ordered, quantity billed, quantity cancelled, quantity delivered, PO transactional amount, and PO amount USD |
Example: Open PO with Open Commitments Dashboard
Buyer Dashboards
ASCP Exceptions Dashboard
| Insight | Description |
|---|---|
| Critical Exceptions (<3 DOH) | This KPI insight shows the number of critical exceptions where the days on hand (DOH) is less than or equal to 3 |
| # Exceptions | This KPI insight shows the number of exceptions |
| Exceptions with PO in RCV | This KPI insight shows the number of exceptions where the PO is in receiving |
| Exceptions by Type / Order Type / Supplier | This stacked column insight shows the number of exceptions by exception type and supplier |
| Order Type | This pie insight shows the number of exceptions by order type as a percentage of total exceptions |
| Exceptions by Supplier | This aggregated table shows the number of exceptions by supplier |
| Exception Details | This listing table insight shows exception details, including: item organization, exception type text, item, item description, order type, order number, compressed days, rescheduled days, days past, buyer name, supplier name, exception quantity, safety stock (SS) bucket day, firm type, old due date (need by), and from date |
Example: ASCP Exceptions Dashboard
Item Org Deep Dive Dashboard
| Insight | Description |
|---|---|
| Item Details | This listing table insight shows the item details, including: organization name, item, item description, lead time, list price, SS fixed days, SS bucket days, SS percent, minimum order quantity, material requirements planning (MRP) SS code |
| Inv vs. Safety Stock | This KPI insight shows the inventory versus safety stock percent |
| Safety Stock Target & Inventory Position | This column insight shows the quantity by safety stock, inventory, warehouse, supermarket, and MRB |
| ASCP Exceptions | This listing table insight shows Advanced Supply Chain Planning (ASCP) exception details, including: exception type text, order number, order type, fixed lot multiplier (FLM), exception quantity, date compressed, reschedule in days, days past, firm type, old due date (need by), from date, and to date |
| PO History | This listing table insight shows PO history details, including: organization, PO, PO type, PO create date, release date, promise date, supplier name, authorization status, closed code, closed for receiving date, quantity ordered, quantity received, percent received, and quantity billed |
| Daily Forecast | This aggregated table shows the forecast quantity and projected available balance by forecast date |
| Upcoming Weekly Forecast | This stacked column insight shows the current forecast quantity by forecast date |
| Transaction Trend Over Last X Days | This stacked column insight shows the usage quantity by transaction type by week start date |
| Transaction Detail (includes all transaction types) | This listing table insight shows transaction details, including: master organization, subinventory code, transaction date, transaction type, reason, source name, item, and usage quantity |
Example Item Org Deep Dive Dashboard
MRB Deep Dive Dashboard
| Insight | Description |
|---|---|
| MRB Aging | This stacked column insight shows the MRB amount by organization code by month/year |
| MRB | This aggregated table insight shows the MRB details, including: item organization, organization, item, item description, transaction date, buyer, quantity, and MRB dollar amount |
| MRB Stage | This aggregated table insight shows the MRB stage details, including: item organization, organization, item, item description, buyer, transaction date, quantity, and MRB dollar amount |
Example: MRB Deep Dive Dashboard
Item Attributes Dashboard
| Insight | Description |
|---|---|
| Item Org Details (Active) | This listing table insight shows the item org details, including: item, item description, master organization, lead time, list price, SS fixed days, SS bucket days, SS percent, and minimum order quantity |
Example: Item Attributes Dashboard
Purchasing Data Application Data Model
