Power BI Connector for Oracle Fusion Cloud SCM

Build 23.0.8839

CollaborationOrderForecastsexceptionQuantities

CollaborationOrderForecastsexceptionQuantities

Columns

Name Type Description
CollaborationOrderForecastsCollaborationOrderForecastId [KEY] Long Value that uniquely identifies the order forecast.
CollaborationOrderForecastId Long Value that uniquely identifies the collaboration order forecast.
ExceptionId [KEY] Long Value that uniquely identifies the collaboration order forecast exception.
BucketId [KEY] Long Value that uniquely identifies the time bucket.
ExceptionTypeCode String Abbreviation that identifies the exception type. Values include COMMIT_MISMATCH or FORECAST_DEVIATION.
BucketAggregationCode String Abbreviation that identifies the bucket aggregation type for the exception quantity. A list of accepted values is defined in the lookup type ORA_VCS_BUCKET_AGGR_LEVEL. Review and update the values for this attribute using the Setup and Maintenance work area, and the Manage Supply Chain Collaboration Lookups task.
BucketStartDate Date Date when the time bucket starts.
BucketEndDate Date Date when the time bucket ends.
ExceptionFactor Double Value that identifies the amount of change based on the exception type.
PrimaryExceptionVariable Double Value that's used in the calculation of the exception factor.
SecondaryExceptionVariable Double Value that's used in the calculation of the exception factor.
MaximumCommitVersion Int Version of the maximum commit when the exception occurred for the aggregation type.
MaximumForecastVersion Int Version of the maximum forecast when the exception occurred for the aggregation type.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Finder String finder

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839