Getting Started with Oracle Healthcare Provider Supply Chain Analytics

Overview

Oracle® Healthcare Provider Supply Chain Analytics (OHPSCA) is an analytical reporting application based on a predefined set of key performance indicators (KPIs), facts, and dimensions with support for predefined and custom reporting. OHPSCA also functions as a decision support system to monitor process bottlenecks and compliance deviations.

OHPSCA provides mechanisms to gain operational insights to evaluate efficiency and utilization of provider supply chain, and to identify corrective actions to address problems.

What Can I Do Using Oracle Healthcare Provider Supply Chain Analytics

OHPSCA provides predefined reports and supports the creation of custom reports using key metrics addressing supply chain efficiency and utilization. With OHPSCA, you can perform the following functions:

View predefined analytical reports delivered with the application.
Rapidly create new reports using the extensive predefined efficiency and volume based metrics related to supply chain processes.

Architecture

Figure 1-1 The Oracle Healthcare Provider Supply Chain Application Architecture

Description of "Figure 1-1 The Oracle Healthcare Provider Supply Chain Application Architecture"

The OHPSCA architecture includes the following principal components:

A data warehouse that consists of a set of data marts (facts and conformed dimensions), which model business processes important for Oracle Healthcare Provider Supply Chain Analytics (OHPSCA).
An Oracle Business Intelligence Enterprise Edition Plus (OBIEE) repository file (RPD), which supplements the data warehouse with business logic such as hierarchies, derived measures, and user groups.
A predefined set of Oracle BI reports, accessible through prebuilt interactive dashboards.
A predefined set of presentation catalogs, including a unique mix of provider supply chain dimensions and measures, and allowing the creation of custom reports and ad-hoc queries.

Note:

You need to implement ETL from source systems to data warehouse at customer site.

Reporting

OHPSCA provides reports for the following key functional areas:

Financial Performance
Inventory Efficiency
Operational Performance
Product Expenses and Delivery Efficiency
Supplier Efficiency, Profile, and Diversity

See Also:

Security

Access to data is available for authorized personnel only constrained through user groups or roles.

The application has predefined dashboards, pages, and user roles. User roles have access to dashboards and pages as follows:

Note:

In the Table 1-1, x denotes that the user role has access to the dashboard while - denotes that the user role does not have access to the dashboard.

Table 1-1 User Roles and Dashboard Access

Dashboard	Page	Supplier Performance Analyst	Supplier Performance Manager	Supply Chain Executive	Purchasing Buyer	Financial Analyst	Department Manager	Inventory Manager	Inventory Analyst	Warehouse Manager	Warehouse Staff
01 Summary	Current	-	-	x	-	-	x	-	-	x	-
01 Summary	Trends	-	-	x	-	-	x	-	-	x	-
02 Financial Performance	Supply Expense	-	-	x	-	x	x	-	-	-	-
02 Financial Performance	Supply Expense Trends	-	-	x	-	x	x	-	-	-	-
02 Financial Performance	Departmental Supply Expense	-	-	x	-	x	x	-	-	-	-
02 Financial Performance	Cost Center Supply Expense	-	-	x	-	x	x	-	-	-	-
02 Financial Performance	Laundry Services	-	-	x	-	x	x	-	-	-	-
02 Financial Performance	Accounts Payable	-	-	x	-	x	-	-	-	-	-
03 Operational Performance	Requisitions	x	x	x	x	-	-	-	-	-	-
03 Operational Performance	Order Activity	x	x	x	x	-	-	-	-	-	-
03 Operational Performance	Order Value	x	x	x	x	-	-	-	-	-	-
03 Operational Performance	Cycle Time Reports	x	x	x	x	-	-	-	-	-	-
03 Operational Performance	Recalls	x	x	x	x	-	-	-	-	-	-
04 Inventory	Scorecard - Inventory Organization	-	-	x	-	x	x	x	x	x	x
04 Inventory	Scorecard - Operating organization	-	-	x	-	x	x	x	x	x	x
04 Inventory	Balances	-	-	x	-	x	x	x	x	x	x
04 Inventory	Discrepancies	-	-	x	-	x	x	x	x	x	x
04 Inventory	Movements	-	-	x	-	x	x	x	x	x	x
04 Inventory	Linen Utilization	-	-	x	-	x	x	x	x	x	x
04 Inventory	Replenishment	-	-	-	-	x	x	x	x	x	x
04 Inventory	Returns	-	-	x	-	x	x	x	x	x	x
04 Inventory	Obscolescence and Recalls	-	-	x	-	x	x	x	x	x	x
05 Suppliers	Supplier Profile	x	x	x	x	-	-				-
05 Suppliers	Supplier Diversity	x	x	x	x	-	-				-
05 Suppliers	Supplier Details	-	x	x	x	-	-				-
05 Suppliers	Supplier Rejection Acceptance Rate	x	x	x	x	-	-				-
05 Suppliers	Product Delivery Reports	x	x	x	x	-	-				-
05 Suppliers	Delivery Rate	x	x	x	x	-	-				-
05 Suppliers	Supplier Scorecard	x	x	x	x	-	-				-
06 Contracts	Contracts	-	x	x	x	x	-	-	-	-	-
06 Contracts	Contract Utilization	-	x	x	x	x	-	-	-	-	-
07 Products	Product Delivery Reports	x	x	x	-	-	-	-	-	-	-
07 Products	Supply Expense	-	-	x	-	x	x	-	-	-	-
07 Products	Item Master	-	-	x	-	-	-	x	x	-	-

Calculations can be performed in reports managed through OBIEE Answers. The OBIEE Answers Administrator is responsible for controlling what calculations are performed, and who can perform them. Only Administrator and Business Analyst user roles have access to OBIEE Answers.