Business Intelligence Cloud Connector for Purchasing

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.

Best Practices

  • 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.

Constraints

  • 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.