Historical Supply Forecast Details

The Historical Supply Forecast Details view object contains information on historical supply forecasts and commits details from Oracle Fusion product model data.

Data Store Key : FscmTopModelAM.ScmExtractAM.VcsBiccExtractAM.VcsHistSupplyForecastDetailsExtractPVO

Primary Keys : VcsHistSupplyForecastDetailsPEOEntryDetailId

Initial Extract Date : VcsHistSupplyForecastDetailsPEOCreationDate

Incremental Extract Date : VcsHistSupplyForecastDetailsPEOLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
VcsBucketsPEOBucketEndDate	Date when the time bucket ends.
VcsBucketsPEOBucketId	Value that uniquely identifies the time bucket.
VcsBucketsPEOBucketStartDate	Date when the time bucket starts.
VcsBucketsPEOBucketType	Code that identifies the bucket aggregation type for the commit 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.
VcsHistSupplyForecastDetailsPEOBucketId	Value that uniquely identifies the time bucket.
VcsHistSupplyForecastDetailsPEOBucketIndex	Value that identifies the order of the bucket within the collaboration order forecast set.
VcsHistSupplyForecastDetailsPEOCollaborationOrderForecastEntryId	Value that uniquely identifies the historical collaboration order forecast entry.
VcsHistSupplyForecastDetailsPEOCollaborationSourceId	Value that uniquely identifies the source of a collaboration plan.
VcsHistSupplyForecastDetailsPEOCommitBucketId	Value that uniquely identifies the time bucket.
VcsHistSupplyForecastDetailsPEOCommitDate	Date and time when the supply was committed against the collaboration order forecast.
VcsHistSupplyForecastDetailsPEOCommitDetailVersion	Version of the commit time bucket for the collaboration order forecast.
VcsHistSupplyForecastDetailsPEOCommitDueDate	Date and time when the supply commits are due for the collaboration order forecast detail.
VcsHistSupplyForecastDetailsPEOCommitMismatchReasonCode	Code that identifies the reason for the commit to the order forecast mismatch.
VcsHistSupplyForecastDetailsPEOCommitQuantity	Quantity of the supplier commit.
VcsHistSupplyForecastDetailsPEOCommitQuantityUOM	Code that identifies the unit of measure of an item.
VcsHistSupplyForecastDetailsPEOCommittedByPartyCode	Code that identifies the type of user who performed the commit action. A list of accepted values is defined in the lookup type ORA_VCS_PARTY_ORIGIN. Review and update the values for this attribute using the Setup and Maintenance work area, and the Manage Supply Chain Collaboration Lookups task.
VcsHistSupplyForecastDetailsPEOCommittedByPersonId	Value that uniquely identifies the user who committed to the order forecast commit quantity.
VcsHistSupplyForecastDetailsPEOCorrelationCode	Code that identifies the orchestration process instance that was provided during the commit process.
VcsHistSupplyForecastDetailsPEOCreatedBy	User who created the collaboration order forecast detail.
VcsHistSupplyForecastDetailsPEOCreationDate	Date and time when the user created the collaboration order forecast detail.
VcsHistSupplyForecastDetailsPEOCumulativeCommitQuantity	Total commit quantity for the current and all previous commit quantities within the order forecast for the item.
VcsHistSupplyForecastDetailsPEOCumulativeForecastQuantity	Total forecast quantity for the current and all previous forecast quantities within the order forecast for the item.
VcsHistSupplyForecastDetailsPEOEntryDetailId	Value that uniquely identifies the collaboration order forecast details record.
VcsHistSupplyForecastDetailsPEOForecastDetailVersion	Version of the forecast time bucket for the collaboration order forecast.
VcsHistSupplyForecastDetailsPEOForecastQuantity	Quantity of the supply forecast.
VcsHistSupplyForecastDetailsPEOForecastQuantityUOM	Code that identifies the unit of measure of an item.
VcsHistSupplyForecastDetailsPEOIsCurrentFlag	Contains one of the following values: Y or N. If Y, then the collaboration order forecast is in the current collaboration cycle. If N, then the collaboration order forecast isn't in the current collaboration cycle. This attribute doesn't have a default value.
VcsHistSupplyForecastDetailsPEOLastUpdateDate	Date and time when the collaboration order forecast was last updated by the user.
VcsHistSupplyForecastDetailsPEOLastUpdatedBy	User who last updated the collaboration order forecast.
VcsHistSupplyForecastDetailsPEOObjectVersionNumber	Number of times the object row has been updated. This attribute is used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
VcsHistSupplyForecastDetailsPEOPublishedByPartyCode	Code that identifies the type of user who performed the publish action. A list of accepted values is defined in the lookup type ORA_VCS_PARTY_ORIGIN. Review and update the values for this attribute using the Setup and Maintenance work area, and the Manage Supply Chain Collaboration Lookups task.
VcsHistSupplyForecastDetailsPEOPublishedByUserName	User who most recently published the forecast quantity.
VcsHistSupplyForecastDetailsPEOPublishedDate	Date and time when the forecast quantity was published.
VcsHistSupplyForecastDetailsPEOPublisherOrderType	Code that identifies the publisher order type. Values include SUPPLY_COMMIT and SUPPLY_FORECAST.
VcsHistSupplyForecastDetailsPEOReceivedDate	Date and time when the collaboration detail entry was received from Oracle Supply Planning Cloud or uploaded from a spreadsheet.
VcsHistSupplyForecastDetailsPEOStatusCode	Code that identifies the current state of the collaboration detail entry. A list of accepted values is defined in the lookup type ORA_VCS_FORECAST_PROCESS_STATU. Review and update the values for this attribute using the Setup and Maintenance work area, and the Manage Supply Chain Collaboration Lookups task.