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 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 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 issue requests to solve plans, request the release of plans, and more.