Supply Forecast Details

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

Data Store Key : FscmTopModelAM.ScmExtractAM.VcsBiccExtractAM.VcsSupplyForecastDetailsExtractPVO

Primary Keys : VcsSupplyForecastDetailsPEOEntryDetailId, VcsBucketsPEOBucketId

Initial Extract Date : VcsSupplyForecastDetailsPEOCreationDate

Incremental Extract Date : VcsSupplyForecastDetailsPEOLastUpdateDate

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.
VcsSupplyForecastDetailsPEOBucketId	Value that uniquely identifies the time bucket.
VcsSupplyForecastDetailsPEOBucketIndex	Value that identifies the order of the bucket within the collaboration order forecast set.
VcsSupplyForecastDetailsPEOCollaborationOrderForecastEntryId	Value that uniquely identifies the historical collaboration order forecast entry.
VcsSupplyForecastDetailsPEOCollaborationSourceId	Value that uniquely identifies the source of a collaboration plan.
VcsSupplyForecastDetailsPEOCommitBucketId	Value that uniquely identifies the time bucket.
VcsSupplyForecastDetailsPEOCommitDate	Date and time when the supply was committed against the collaboration order forecast.
VcsSupplyForecastDetailsPEOCommitDetailVersion	Version of the commit time bucket for the collaboration order forecast.
VcsSupplyForecastDetailsPEOCommitDueDate	Date and time when the supply commits are due for the collaboration order forecast detail.
VcsSupplyForecastDetailsPEOCommitMismatchReasonCode	Code that identifies the reason for the commit to the order forecast mismatch.
VcsSupplyForecastDetailsPEOCommitQuantity	Quantity of the supplier commit.
VcsSupplyForecastDetailsPEOCommitQuantityUOM	Code that identifies the unit of measure of an item.
VcsSupplyForecastDetailsPEOCommittedByPartyCode	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.
VcsSupplyForecastDetailsPEOCommittedByPersonId	Value that uniquely identifies the user who committed to the order forecast commit quantity.
VcsSupplyForecastDetailsPEOCorrelationCode	Code that identifies the orchestration process instance that was provided during the commit process.
VcsSupplyForecastDetailsPEOCreatedBy	User who created the collaboration order forecast detail.
VcsSupplyForecastDetailsPEOCreationDate	Date and time when the user created the collaboration order forecast detail.
VcsSupplyForecastDetailsPEOCumulativeCommitQuantity	Total commit quantity for the current and all previous commit quantities within the order forecast for the item.
VcsSupplyForecastDetailsPEOCumulativeForecastQuantity	Total forecast quantity for the current and all previous forecast quantities within the order forecast for the item.
VcsSupplyForecastDetailsPEODraftEnterpriseCommitBucketId	Value that uniquely identifies the draft commit bucket made by an enterprise user.
VcsSupplyForecastDetailsPEODraftEnterpriseCommitQuantity	Quantity for the draft commit made by a enterprise user.
VcsSupplyForecastDetailsPEODraftEnterpriseCommitQuantityUom	Code that identifies the unit of measure for an item of a draft commit quantity made by an enterprise user.
VcsSupplyForecastDetailsPEODraftEnterpriseForecastBucketId	Value that uniquely identifies the draft forecast bucket made by an enterprise user.
VcsSupplyForecastDetailsPEODraftEnterpriseForecastQuantity	Quantity for the draft forecast made by a enterprise user.
VcsSupplyForecastDetailsPEODraftEnterpriseForecastUom	Code that identifies the unit of measure for an item of a draft forecast quantity made by an enterprise user.
VcsSupplyForecastDetailsPEODraftEnterpriseQtyFlag	Contains one of the following values: Y or N. If Y, then the collaboration order forecast details are in a draft status for an enterprise user. If N, then the collaboration order forecast details aren't in a draft status for an enterprise user. This attribute doesn't have a default value.
VcsSupplyForecastDetailsPEODraftSupplierCommitBucketId	Value that uniquely identifies the bucket of the draft commit made by a supplier user.
VcsSupplyForecastDetailsPEODraftSupplierCommitQuantity	Quantity for the draft commit made by a supplier user.
VcsSupplyForecastDetailsPEODraftSupplierCommitQuantityUom	Code that identifies the unit of measure for an item quantity of a draft commit made by a supplier user.
VcsSupplyForecastDetailsPEODraftSupplierForecastBucketId	Value that uniquely identifies the bucket of the draft forecast made by a supplier user.
VcsSupplyForecastDetailsPEODraftSupplierForecastQuantity	Quantity for the draft forecast made by a supplier user.
VcsSupplyForecastDetailsPEODraftSupplierForecastUom	Code that identifies the unit of measure for an item quantity of a draft forecast made by a supplier user.
VcsSupplyForecastDetailsPEODraftSupplierQtyFlag	Contains one of the following values: Y or N. If Y, then the collaboration order forecast details are in a draft status for a supplier user. If N, then the collaboration order forecast details aren't in a draft status for a supplier user. This attribute doesn't have a default value.
VcsSupplyForecastDetailsPEOEntryDetailId	Value that uniquely identifies the collaboration order forecast details record.
VcsSupplyForecastDetailsPEOForecastDetailVersion	Version of the forecast time bucket for the collaboration order forecast.
VcsSupplyForecastDetailsPEOForecastQuantity	Quantity of the supply forecast.
VcsSupplyForecastDetailsPEOForecastQuantityUOM	Code that identifies the unit of measure of an item.
VcsSupplyForecastDetailsPEOIsCurrentFlag	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.
VcsSupplyForecastDetailsPEOLastUpdateDate	Date and time when the collaboration order forecast was last updated by the user.
VcsSupplyForecastDetailsPEOLastUpdatedBy	User who last updated the collaboration order forecast.
VcsSupplyForecastDetailsPEOObjectVersionNumber	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.
VcsSupplyForecastDetailsPEOPublishedByPartyCode	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.
VcsSupplyForecastDetailsPEOPublishedByUserName	User who most recently published the forecast quantity.
VcsSupplyForecastDetailsPEOPublishedDate	Date and time when the forecast quantity was published.
VcsSupplyForecastDetailsPEOPublisherOrderType	Code that identifies the publisher order type. Values include SUPPLY_COMMIT and SUPPLY_FORECAST.
VcsSupplyForecastDetailsPEOReceivedDate	Date and time when the collaboration detail entry was received from Oracle Supply Planning Cloud or uploaded from a spreadsheet.
VcsSupplyForecastDetailsPEOStatusCode	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.