Business Intelligence Cloud Connector

Oracle Purchasing offers a collection of public view objects (PVOs) that give you read-only access to the raw data stored in the business objects.

Key Features

Use the standard features available in Oracle Business Intelligence Cloud Connector (BICC).
Configure an external storage location that works for your data needs.
Extract complete or partial data.
Run extracts on-demand or schedule them to run at specified intervals during the day, in a week, or throughout the month.
Schedule multiple independent extracts at convenient intervals.
Monitor extracts and review logs.
Export configured offerings and associated data stores.
Manage refresh metadata and specify dates for incremental refresh comparison.

Perform periodic extraction close to near real-time extraction.
Run incremental extracts if you need only the data that changed since your last extract.
Control who has access to the content and what they can do with it.

Conditional data extraction isn't supported. That is, the data rows from a PVO can't be based on a specific data condition.
This option isn't suitable for extracting purchasing data on a real-time basis.
View objects aren't supported for purchasing archive tables.