Overview

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

Key Features

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

Views

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

Stored Procedures

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