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 ADO.NET Provider 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.