Overview

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

Key Features

• The add-in models Oracle Fusion Cloud SCM entities like Configurations, FlexFndPvsCharacterValues, and ConfigurationmodelNodes 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 add-in.

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 cancel sales orders, settle manual claims, and more.