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. |