Supply Chain Planning
In the Supply Chain Planning data model, the add-in models data such as collaboration requests and standard lookups as an easy-to-use SQL database. Live connectivity to these objects means that any changes to your Oracle Fusion Cloud SCM account are immediately reflected in the add-in.
Views
The Views section, which lists read-only SQL tables, contains samples of what you might have access to in your Oracle Fusion Cloud SCM account.
These views are shipped with the add-in:
| View | Description |
| CollaborationOrderForecastRequests | Facilitates supplier collaboration by requesting order forecasts and tracking the status of submitted requests. |
| CollaborationOrderForecastRequestsdetails | Manages detailed information about requested collaboration order forecasts for streamlined planning. |
| CollaborationOrderForecastRequestsrequestStatusDetails | Tracks and manages the status of collaboration order forecasts, including processing details and error messages. |
| CollaborationOrderForecasts | Provides access to published order forecasts for supplier collaboration and enables response submissions for supply commitments |
| CollaborationOrderForecastscommitQuantities | Retrieves and manages commit measure details associated with collaboration order forecasts, including supply commit responses. |
| CollaborationOrderForecastsexceptionQuantities | Highlights forecast and commit exceptions, such as changes or mismatches, to ensure planning accuracy. |
| CollaborationOrderForecastsforecastQuantities | Manages forecast measure details, allowing updates and new entries for collaboration order forecasts. |
| CollaborationOrderForecastsreferenceQuantities | Provides access to additional measures for collaboration order forecasts, such as purchasing metrics, enhancing decision-making. |
| Finders | Lists finder names and associated attributes for specific views, aiding in efficient data retrieval. |
| FlexFndDffDescriptiveFlexfieldContexts | Enables management and retrieval of descriptive flexfield contexts using REST API endpoints. |
| FlexFndPvsCharacterIdCharacterValues | Supports retrieval of character-based flexfield values through REST API endpoints for enhanced data configuration. |
| FlexFndPvsCharacterValues | Facilitates access to character-based flexfield values, enabling detailed customizations in Oracle SCM. |
| FlexFndPvsNumberIdCharacterValues | Manages numeric flexfield values for extended data configuration and retrieval. |
| StandardLookupsLOV | Provides a queryable list of standard lookup codes and their descriptions, supporting consistent reference data sharing. |
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including issuing requests to solve plans and requesting plan releases.