Overview

This section shows the available API objects and provides more information on executing SQL to Oracle Fusion Cloud SCM APIs.

Key Features

• The driver models Oracle Fusion Cloud SCM entities like FlexFndDffDescriptiveFlexfieldContexts, PlexFndPvsCharacterValues, and FlexFndPvsNumberIdCharacterValues as relational views, allowing you to write SQL to query Oracle Fusion Cloud SCM data.
• Stored procedures allow you to execute operations to Oracle Fusion Cloud SCM.
• Live connectivity to these objects means any changes to your Oracle Fusion Cloud SCM account are immediately reflected when using the driver.

Views

Views are dynamically obtained to model Oracle Fusion Cloud SCM objects. These objects are presented as read-only tables.

Stored Procedures

Stored Procedures are function-like interfaces to Oracle Fusion Cloud SCM. They can issue requests to solve plans, request the release of plans, and more.