External Supply Forecast Details

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

Data Store Key : FscmTopModelAM.ScmExtractAM.VcsBiccExtractAM.VcsExtSupplyForecastDetailsExtractPVO

Primary Keys : VcsExtSupplyForecastDetailsPEOEntryDetailId, VcsBucketsPEOBucketId

Initial Extract Date : VcsExtSupplyForecastDetailsPEOCreationDate

Incremental Extract Date : VcsExtSupplyForecastDetailsPEOLastUpdateDate

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.
VcsExtSupplyForecastDetailsPEOBucketId	Value that uniquely identifies the time bucket.
VcsExtSupplyForecastDetailsPEOBucketIndex	Value that identifies the order of the bucket within the collaboration order forecast set.
VcsExtSupplyForecastDetailsPEOCollaborationOrderForecastEntryId	Value that uniquely identifies the historical collaboration order forecast entry.
VcsExtSupplyForecastDetailsPEOCollaborationSourceId	Value that uniquely identifies the source of a collaboration plan.
VcsExtSupplyForecastDetailsPEOCommitBucketId	Value that uniquely identifies the time bucket.
VcsExtSupplyForecastDetailsPEOCommitDate	Date and time when the supply was committed against the collaboration order forecast.
VcsExtSupplyForecastDetailsPEOCommitDetailVersion	Version of the commit time bucket for the collaboration order forecast.
VcsExtSupplyForecastDetailsPEOCommitDueDate	Date and time when the supply commits are due for the collaboration order forecast detail.
VcsExtSupplyForecastDetailsPEOCommitMismatchReasonCode	Code that identifies the reason for the commit to the order forecast mismatch.
VcsExtSupplyForecastDetailsPEOCommitQuantity	Quantity of the supplier commit.
VcsExtSupplyForecastDetailsPEOCommitQuantityUOM	Code that identifies the unit of measure of an item.
VcsExtSupplyForecastDetailsPEOCommittedByPartyCode	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.
VcsExtSupplyForecastDetailsPEOCommittedByPersonId	Value that uniquely identifies the user who committed to the order forecast commit quantity.
VcsExtSupplyForecastDetailsPEOCorrelationCode	Code that identifies the orchestration process instance that was provided during the commit process.
VcsExtSupplyForecastDetailsPEOCreatedBy	User who created the collaboration order forecast detail.
VcsExtSupplyForecastDetailsPEOCreationDate	Date and time when the user created the collaboration order forecast detail.
VcsExtSupplyForecastDetailsPEOCumulativeCommitQuantity	Total commit quantity for the current and all previous commit quantities within the order forecast for the item.
VcsExtSupplyForecastDetailsPEOCumulativeForecastQuantity	Total forecast quantity for the current and all previous forecast quantities within the order forecast for the item.
VcsExtSupplyForecastDetailsPEODraftEnterpriseCommitBucketId	Value that uniquely identifies the draft commit bucket made by an enterprise user.
VcsExtSupplyForecastDetailsPEODraftEnterpriseCommitQuantity	Quantity for the draft commit made by a enterprise user.
VcsExtSupplyForecastDetailsPEODraftEnterpriseCommitQuantityUom	Code that identifies the unit of measure for an item of a draft commit quantity made by an enterprise user.
VcsExtSupplyForecastDetailsPEODraftEnterpriseForecastBucketId	Value that uniquely identifies the draft forecast bucket made by an enterprise user.
VcsExtSupplyForecastDetailsPEODraftEnterpriseForecastQuantity	Quantity for the draft forecast made by a enterprise user.
VcsExtSupplyForecastDetailsPEODraftEnterpriseQtyFlag	Code that identifies the unit of measure for an item of a draft forecast quantity made by an enterprise user.
VcsExtSupplyForecastDetailsPEODraftEnterpriseQuantityUom	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.
VcsExtSupplyForecastDetailsPEODraftSupplierCommitBucketId	Value that uniquely identifies the bucket of the draft commit made by a supplier user.
VcsExtSupplyForecastDetailsPEODraftSupplierCommitQuantity	Quantity for the draft commit made by a supplier user.
VcsExtSupplyForecastDetailsPEODraftSupplierCommitQuantityUom	Code that identifies the unit of measure for an item quantity of a draft commit made by a supplier user.
VcsExtSupplyForecastDetailsPEODraftSupplierForecastBucketId	Value that uniquely identifies the bucket of the draft forecast made by a supplier user.
VcsExtSupplyForecastDetailsPEODraftSupplierForecastQuantity	Quantity for the draft forecast made by a supplier user.
VcsExtSupplyForecastDetailsPEODraftSupplierForecastUom	Code that identifies the unit of measure for an item quantity of a draft forecast made by a supplier user.
VcsExtSupplyForecastDetailsPEODraftSupplierQtyFlag	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.
VcsExtSupplyForecastDetailsPEOEntryDetailId	Value that uniquely identifies the collaboration order forecast details record.
VcsExtSupplyForecastDetailsPEOForecastDetailVersion	Version of the forecast time bucket for the collaboration order forecast.
VcsExtSupplyForecastDetailsPEOForecastQuantity	Quantity of the supply forecast.
VcsExtSupplyForecastDetailsPEOForecastQuantityUOM	Code that identifies the unit of measure of an item.
VcsExtSupplyForecastDetailsPEOIsCurrentFlag	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.
VcsExtSupplyForecastDetailsPEOLastUpdateDate	Date and time when the collaboration order forecast was last updated by the user.
VcsExtSupplyForecastDetailsPEOLastUpdatedBy	User who last updated the collaboration order forecast.
VcsExtSupplyForecastDetailsPEOObjectVersionNumber	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.
VcsExtSupplyForecastDetailsPEOPublishedByPartyCode	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.
VcsExtSupplyForecastDetailsPEOPublishedByUserName	User who most recently published the forecast quantity.
VcsExtSupplyForecastDetailsPEOPublishedDate	Date and time when the forecast quantity was published.
VcsExtSupplyForecastDetailsPEOPublisherOrderType	Code that identifies the publisher order type. Values include SUPPLY_COMMIT and SUPPLY_FORECAST.
VcsExtSupplyForecastDetailsPEOReceivedDate	Date and time when the collaboration detail entry was received from Oracle Supply Planning Cloud or uploaded from a spreadsheet.
VcsExtSupplyForecastDetailsPEOStatusCode	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.