External Historical Supply Forecast Details

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

Data Store Key : FscmTopModelAM.ScmExtractAM.VcsBiccExtractAM.VcsExtHistSupplyForecastDetailsExtractPVO

Primary Keys : VcsExtHistSupplyForecastDetailsPEOEntryDetailId

Initial Extract Date : VcsExtHistSupplyForecastDetailsPEOCreationDate

Incremental Extract Date : VcsExtHistSupplyForecastDetailsPEOLastUpdateDate

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.
VcsExtHistSupplyForecastDetailsPEOBucketId	Value that uniquely identifies the time bucket.
VcsExtHistSupplyForecastDetailsPEOBucketIndex	Value that identifies the order of the bucket within the collaboration order forecast set.
VcsExtHistSupplyForecastDetailsPEOCollaborationOrderForecastEntryId	Value that uniquely identifies the historical collaboration order forecast entry.
VcsExtHistSupplyForecastDetailsPEOCollaborationSourceId	Value that uniquely identifies the source of a collaboration plan.
VcsExtHistSupplyForecastDetailsPEOCommitBucketId	Value that uniquely identifies the time bucket.
VcsExtHistSupplyForecastDetailsPEOCommitDate	Date and time when the supply was committed against the collaboration order forecast.
VcsExtHistSupplyForecastDetailsPEOCommitDetailVersion	Version of the commit time bucket for the collaboration order forecast.
VcsExtHistSupplyForecastDetailsPEOCommitDueDate	Date and time when the supply commits are due for the collaboration order forecast detail.
VcsExtHistSupplyForecastDetailsPEOCommitMismatchReasonCode	Code that identifies the reason for the commit to the order forecast mismatch.
VcsExtHistSupplyForecastDetailsPEOCommitQuantity	Quantity of the supplier commit.
VcsExtHistSupplyForecastDetailsPEOCommitQuantityUOM	Code that identifies the unit of measure of an item.
VcsExtHistSupplyForecastDetailsPEOCommittedByPartyCode	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.
VcsExtHistSupplyForecastDetailsPEOCommittedByPersonId	Value that uniquely identifies the user who committed to the order forecast commit quantity.
VcsExtHistSupplyForecastDetailsPEOCorrelationCode	Code that identifies the orchestration process instance that was provided during the commit process.
VcsExtHistSupplyForecastDetailsPEOCreatedBy	User who created the collaboration order forecast detail.
VcsExtHistSupplyForecastDetailsPEOCreationDate	Date and time when the user created the collaboration order forecast detail.
VcsExtHistSupplyForecastDetailsPEOCumulativeCommitQuantity	Total commit quantity for the current and all previous commit quantities within the order forecast for the item.
VcsExtHistSupplyForecastDetailsPEOCumulativeForecastQuantity	Total forecast quantity for the current and all previous forecast quantities within the order forecast for the item.
VcsExtHistSupplyForecastDetailsPEOEntryDetailId	Value that uniquely identifies the collaboration order forecast details record.
VcsExtHistSupplyForecastDetailsPEOForecastDetailVersion	Version of the forecast time bucket for the collaboration order forecast.
VcsExtHistSupplyForecastDetailsPEOForecastQuantity	Quantity of the supply forecast.
VcsExtHistSupplyForecastDetailsPEOForecastQuantityUOM	Code that identifies the unit of measure of an item.
VcsExtHistSupplyForecastDetailsPEOIsCurrentFlag	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.
VcsExtHistSupplyForecastDetailsPEOLastUpdateDate	Date and time when the collaboration order forecast was last updated by the user.
VcsExtHistSupplyForecastDetailsPEOLastUpdatedBy	User who last updated the collaboration order forecast.
VcsExtHistSupplyForecastDetailsPEOObjectVersionNumber	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.
VcsExtHistSupplyForecastDetailsPEOPublishedByPartyCode	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.
VcsExtHistSupplyForecastDetailsPEOPublishedByUserName	User who most recently published the forecast quantity.
VcsExtHistSupplyForecastDetailsPEOPublishedDate	Date and time when the forecast quantity was published.
VcsExtHistSupplyForecastDetailsPEOPublisherOrderType	Code that identifies the publisher order type. Values include SUPPLY_COMMIT and SUPPLY_FORECAST.
VcsExtHistSupplyForecastDetailsPEOReceivedDate	Date and time when the collaboration detail entry was received from Oracle Supply Planning Cloud or uploaded from a spreadsheet.
VcsExtHistSupplyForecastDetailsPEOStatusCode	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.