Views
Views are similar to tables in the way that data is represented; however, views are read-only.
Queries can be executed against a view as if it were a normal table.
CData Power BI Connector for Oracle Fusion Cloud SCM Views
| Name | Description |
| BacklogCategoriesLOV | Returns the available backlog categories for items requested on demand, for use in list-of-values selections. |
| CollaborationAggregationSchedules | Returns active collaboration aggregation schedules used to display data in supply chain collaboration. |
| CollaborationOrderForecastQuantities | CollaborationOrderForecastQuantities |
| CollaborationOrderForecastQuantitiescommitQuantities | CollaborationOrderForecastQuantitiescommitQuantities |
| CollaborationOrderForecastQuantitiesexceptionQuantities | CollaborationOrderForecastQuantitiesexceptionQuantities |
| CollaborationOrderForecastQuantitiesforecastQuantities | CollaborationOrderForecastQuantitiesforecastQuantities |
| CollaborationOrderForecastQuantitiesreferenceQuantities | CollaborationOrderForecastQuantitiesreferenceQuantities |
| 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. |
| DemandAndSupplyPlansItemRelationships | Lists the item relationships used in the demand and supply plan. |
| DemandAndSupplyPlansworkDefinitionVersions | Lists the work definitions and their versions used in the demand and supply plan. |
| Dimensions | Returns stored planning dimensions used in supply chain planning. |
| 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. |
| NpiCustomerTrees | Returns customers and their associated customer sites linked to a specified source product in a plan. |
| PlanningMeasureContextLevels | Returns the levels used for planning measure contexts. |
| PlanStatus | Returns status records for supply chain plans, including plan type, execution status, and action history. |
| ReplenishmentPolicyComparisons | Returns comparisons of suggested and in-force policy measures for inventory replenishment. |
| SimulateDemands | Returns the simulated impact of data changes, such as price discounts, on the demand forecast. |
| StandardLookupsLOV | Provides a queryable list of standard lookup codes and their descriptions, supporting consistent reference data sharing. |
| SupplyChainPlansApproves | Lists the approve plan jobs submitted for the supply chain plan. |
| SupplyChainPlansCloses | Lists the close plan jobs submitted for the supply chain plan. |
| SupplyChainPlansLoads | Lists the load plan jobs submitted for the supply chain plan. |
| SupplyChainPlansMeasureBasedExceptions | Lists the measure-based exceptions generated for the supply chain plan. |