About the Oracle EBS Revenue and Billing Data Application

The Oracle E-Business Suite (EBS) Revenue Management and Billing module optimizes customer value and maximizes profitability. The Incorta Direct Data Platform™ data application for the Revenue Management and Billing module provides prebuilt schemas, dashboards, and insights to provide you visibility into your revenue drivers.

Here are some of the questions answered by the Oracle EBS Revenue and Billing data application:

  • What is the revenue performance trend?
  • What is the customer performance trend?
  • What products contribute to 80% of revenue?

You can further customize and add on to the insights in the Incorta Revenue and Billing data application to support your specific business needs.

Accounts Receivable Data Application Components

Here are the Incorta prebuilt Accounts Receivable data application physical schemas, business schemas, dashboard folders, dashboards, and insights:

Physical Schemas

  • EBS_AR
  • EBS_AR_MV
  • EBS common schemas:
    • EBS_CAL_COMMON
    • EBS_FIN_COMMON
    • EBS_FND_COMMON
    • EBS_HR_COMMON
    • EBS_ITEM_COMMON
    • EBS_PARTY_COMMON

Business Schemas

  • BillingAndTax: Provides AR billing and tax information, including customer, invoice, payment, and tax details

Dashboards and Insights

Revenue Summary Dashboard

InsightDescription
# of PartsThis KPI insight shows the number of product items the company sells
# of CustomersThis KPI insight shows the number of customers the company sells to
Global Revenue without Tax (Mil)This KPI insight shows the global revenue amount without tax
Revenue Performance by OUThis pie donut insight shows the revenue amount by operating unit as a percent of total revenue
Revenue by CountryThis donut insight shows the revenue amount by country as a percentage of total revenue
Top Parts (Pareto)This dual axis insight shows the cumulative revenue percent of total revenue for the top 30 product items as a line, and the total revenue amount by product item as a bar
Customers contributing to top 80%This aggregated table insight shows a list of the top customers that contribute to eighty percent of total revenue, including the revenue amount for each customer and the rolling revenue percent of total
Revenue Performance by Item CategoryThis line insight shows the revenue amount trend by quarter for each product item category

Example: Revenue Summary Dashboard

Revenue Billing and Tax Details Dashboard

InsightDescription
# of PartsThis KPI insight shows the number of product items the company sells
# of CustomersThis KPI insight shows the number of customers the company sells to
Global Revenue without TaxThis KPI insight shows the global revenue amount without tax
Revenue PerformanceThis line insight shows the revenue amount by quarter
Customer PerformanceThis stacked column insight shows the revenue amount by customer and year
Which Parts contribute to Top 80% of RevenueThis aggregated table insight shows a list of product items that contribute to eighty percent of total revenue, including the revenue amount for each product item and the rolling revenue percent of total
Which Customers contribute to Top 80% of RevenueThis aggregated table insight shows a list of the top customers that contribute to eighty percent of total revenue, including the revenue amount for each customer and the rolling revenue percent of total
Invoice DetailsThis listing table insight shows the invoice details, including: invoice number, line number, invoice description - summary, invoice year, country, customer number, customer name, item number, item description, transaction type, transaction type name, comments, transaction date, GI date, GL period, complete flag, account description, credit requested by, functional currency, transactional currency, global currency, unit price, quantity, transactional amount, transactional tax, functional amount, functional tax, global amount, global tax, and global total with tax

Example: Revenue - Billing and Tax Details Dashboard