JDBC Driver for Oracle SCM

Build 22.0.8462

CollaborationOrderForecastsexceptionQuantities

The Exception Quantities resource gets the forecast and commit exceptions associated with the collaboration order forecast, such as, forecast changes and commit mismatches.

Columns

Name Type Description
CollaborationOrderForecastsCollaborationOrderForecastId String Value that uniquely identifies the order forecast.
CollaborationOrderForecastId String Value that uniquely identifies the collaboration order forecast.
ExceptionId String Value that uniquely identifies the collaboration order forecast exception.
BucketId String 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 String Value that identifies the amount of change based on the exception type.
PrimaryExceptionVariable String Value that is used in the calculation of the exception factor.
SecondaryExceptionVariable String Value that is 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462