Supply Chain Planning
In the Supply Chain Planning data model, the server 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 server.
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 server:
| 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.