Overview

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

Key Features

• The connector models Oracle Fusion Cloud SCM entities like Ideas, ItemCatalogs, and ProductProposals 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 connector.

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 be used to upload objects like item batches, catalog attachments, and more.