Supply Forecast Reference Measures

The Supply Forecast Reference Measures view object contains information on the current cycle reference measures from Oracle Fusion product data model.

Data Store Key : FscmTopModelAM.ScmExtractAM.VcsBiccExtractAM.VcsSupplyForecastReferenceMeasureExtractPVO

Primary Keys : VcsSupplyForecastReferenceMeasurePEOReferenceDetailId

Initial Extract Date : VcsSupplyForecastReferenceMeasurePEOCreationDate

Incremental Extract Date : VcsSupplyForecastReferenceMeasurePEOLastUpdateDate

Attributes

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

Name Description
VcsSupplyForecastReferenceMeasurePEOCollaborationOrderForecastEntryId Value that uniquely identifies the collaboration order forecast entry.
VcsSupplyForecastReferenceMeasurePEOCollaborationSourceId Value that uniquely identifies the source of the collaboration plan.
VcsSupplyForecastReferenceMeasurePEOCreatedBy User who created the reference measure quantity.
VcsSupplyForecastReferenceMeasurePEOCreationDate Date and time when the reference measure quantity was created.
VcsSupplyForecastReferenceMeasurePEOLastUpdateDate Date and time when the reference measure was last updated.
VcsSupplyForecastReferenceMeasurePEOLastUpdatedBy User who most recently updated the reference measure.
VcsSupplyForecastReferenceMeasurePEOObjectVersionNumber 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.
VcsSupplyForecastReferenceMeasurePEOPublisherOrderType Code that identifies the publisher order type. Values include InTransitShipment, PlannedOrder, PurchaseOrder, ReceivedShipment and Requisition.
VcsSupplyForecastReferenceMeasurePEOReceivedDate Date and time when the historical reference measure entry was received from Oracle Supply Planning Cloud or uploaded from a spreadsheet.
VcsSupplyForecastReferenceMeasurePEORefMeasureBucketEndDate Date when the time bucket ends.
VcsSupplyForecastReferenceMeasurePEORefMeasureBucketId Value that uniquely identifies the time bucket.
VcsSupplyForecastReferenceMeasurePEORefMeasureBucketStartDate Date when the time bucket starts.
VcsSupplyForecastReferenceMeasurePEORefMeasureBucketType Code that identifies the bucket aggregation type for the reference measure 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.
VcsSupplyForecastReferenceMeasurePEORefMeasurePublishedByPartyCode 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.
VcsSupplyForecastReferenceMeasurePEORefMeasurePublishedByPersonId User who most recently published the reference measure quantity.
VcsSupplyForecastReferenceMeasurePEORefMeasurePublishedDate Date and time when the reference measure quantity was published.
VcsSupplyForecastReferenceMeasurePEORefMeasureQuantity Value that identifies the quantity of the reference measure for the item in the reference measure unit of measure.
VcsSupplyForecastReferenceMeasurePEORefMeasureQuantityUOM Code that identifies the unit of measure of a reference measure quantity.
VcsSupplyForecastReferenceMeasurePEOReferenceDetailId Value that uniquely identifies the reference measure details record.
VcsSupplyForecastReferenceMeasurePEOReferenceHeaderId Value that uniquely identifies the header of the reference measure quantity.
VcsSupplyForecastReferenceMeasurePEOReferenceHeaderNumber Value that identifies the header number of the reference measure quantity.
VcsSupplyForecastReferenceMeasurePEOReferenceLineId Value that uniquely identifies the line of the reference measure quantity.
VcsSupplyForecastReferenceMeasurePEOReferenceLineLocationId Value that uniquely identifies the line location of the reference measure quantity.
VcsSupplyForecastReferenceMeasurePEOReferenceLineLocationNumber Value that identifies the line location number of the reference measure quantity.
VcsSupplyForecastReferenceMeasurePEOReferenceLineNumber Value that identifies the line number of the reference measure quantity.