External Historical Supply Forecasts

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

Data Store Key : FscmTopModelAM.ScmExtractAM.VcsBiccExtractAM.VcsExtHistSupplyForecastExtractPVO

Primary Keys : VcsCollabPartShipFromPEOShipFromVcsParticipantId, VcsCollabPartShipToPEOShipToVcsParticipantId, VcsCollaborationPlanPEOCollaborationSourceId, VcsExtHistSupplyForecastPEOCollaborationOrderForecastEntryId

Initial Extract Date : VcsExtHistSupplyForecastPEOCreationDate

Incremental Extract Date : VcsExtHistSupplyForecastPEOLastUpdateDate

Attributes

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

Name	Description
VcsCollabPartShipFromPEOObjectVersionNumber	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.
VcsCollabPartShipFromPEOShipFromOrganizationId	Value that uniquely identifies the organization that ships the item. It's a primary key that the application generates when it creates the organization.
VcsCollabPartShipFromPEOShipFromSupplierId	Value that uniquely identifies the supplier who ships the item. It's a primary key that the application generates when it creates the supplier.
VcsCollabPartShipFromPEOShipFromSupplierSiteId	Value that uniquely identifies the supplier site from where the item is shipped. It's a primary key that the application generates when it creates the supplier site.
VcsCollabPartShipFromPEOShipFromVcsParticipantId	Value that uniquely identifies the participant who ships the item. It's a primary key that the application generates when it creates the corresponding participant object.
VcsCollabPartShipFromPEOShipToCustomerId	Value that uniquely identifies the customer who will receive the item. It's a primary key that the application creates when it creates the customer.
VcsCollabPartShipToPEOObjectVersionNumber	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.
VcsCollabPartShipToPEOPartnerCode	Code that identifies the type of the partner. Values include ENTERPRISE, SUPPLIER, CUSTOMER, SCP_ENTERPRISE, SCP_SUPPLIER, and SCP_CUSTOMER.
VcsCollabPartShipToPEOShipToCustomerSiteId	Value that uniquely identifies the customer site where the item is received. It's a primary key that the application creates when it creates the customer site.
VcsCollabPartShipToPEOShipToOrganizationId	Value that uniquely identifies the organization that receives the item. It's a primary key that the application creates when it creates the organization.
VcsCollabPartShipToPEOShipToSupplierId	Value that uniquely identifies the supplier who receives the item. It's a primary key that the application generates when it creates the supplier.
VcsCollabPartShipToPEOShipToSupplierSiteId	Value that uniquely identifies the supplier site that receives the item. It's a primary key that the application generates when it creates the supplier site.
VcsCollabPartShipToPEOShipToVcsParticipantId	Value that uniquely identifies the participant who ships the item. It's a primary key that the application generates when it creates the corresponding participant object.
VcsCollaborationPlanPEOCollaborationSourceId	Value that uniquely identifies the source of a collaboration plan.
VcsCollaborationPlanPEOObjectVersionNumber	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.
VcsCollaborationPlanPEOScenarioId	Value that uniquely identifies the plan scenario.
VcsExtHistSupplyForecastPEOCmOnHandPublishedByPartyCode	Code that identifies the type of user who performed the contract manufacturer's on-hand 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.
VcsExtHistSupplyForecastPEOCmOnHandPublishedByPersonId	Value that uniquely identifies the most recent user to publish the contract manufacturer on-hand quantity.
VcsExtHistSupplyForecastPEOCmOnHandPublishedDate	Date and time when the contract manufacturer's on-hand quantities was published.
VcsExtHistSupplyForecastPEOCmOnHandQuantity	Value that identifies the quantity of the contract manufacturer's on-hand inventory for the item in the collaboration unit of measure.
VcsExtHistSupplyForecastPEOCollaborationEntryVersion	Value that identifies the version of the collaboration entry.
VcsExtHistSupplyForecastPEOCollaborationOrderForecastCollabIdentityId	Value that uniquely identifies the collaboration plan scenario.
VcsExtHistSupplyForecastPEOCollaborationOrderForecastEntryId	Value that uniquely identifies the historical collaboration order forecast entry.
VcsExtHistSupplyForecastPEOCollaborationOrderForecastEntryTypeId	Value that uniquely identifies the type of historical collaboration order forecast entry.
VcsExtHistSupplyForecastPEOCollaborationSourceId	Value that uniquely identifies the source of a collaboration plan.
VcsExtHistSupplyForecastPEOCollaborationUOMCode	Code that identifies the supply chain collaboration unit of measure. All collaboration order forecast historical quantities are stored in the item's primary unit of measure.
VcsExtHistSupplyForecastPEOCommitDate	Date when the supply was committed for the collaboration order forecast.
VcsExtHistSupplyForecastPEOCommitDueDate	This should be Date when the supply commits are due for the collaboration order forecast.
VcsExtHistSupplyForecastPEOCommitHorizonEndDate	Date when the commit horizon ended.
VcsExtHistSupplyForecastPEOCommitTotalQuantity	Sum of the commit quantities over the commit horizon for a collaboration order forecast.
VcsExtHistSupplyForecastPEOCommittedByPartyCode	Code that identifies the party that committed to the order forecast. 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.
VcsExtHistSupplyForecastPEOCommittedByPersonId	Value that uniquely identifies the user who committed to the order forecast commit quantity.
VcsExtHistSupplyForecastPEOCorrelationCode	Code that identifies the instance of the orchestration process.
VcsExtHistSupplyForecastPEOCreatedBy	User who created the collaboration order forecast.
VcsExtHistSupplyForecastPEOCreationDate	Date and time when the user created the collaboration order forecast.
VcsExtHistSupplyForecastPEOForecastHorizonEndDate	Date when the forecast horizon ended.
VcsExtHistSupplyForecastPEOForecastTotalCommitHorizonQuantity	Sum of the forecast quantities over the commit horizon for a collaboration order forecast.
VcsExtHistSupplyForecastPEOForecastTotalForecastHorizonQuantity	Sum of the forecast quantities over the forecast horizon for a collaboration order forecast.
VcsExtHistSupplyForecastPEOInventoryItemId	Value that uniquely identifies the inventory item.
VcsExtHistSupplyForecastPEOInventoryItemOrganizationId	Value that uniquely identifies the inventory item organization.
VcsExtHistSupplyForecastPEOLastPublishedPlanName	Name of the last published supply plan used to generate the collaboration order forecast.
VcsExtHistSupplyForecastPEOLastUpdateDate	Date and time when the collaboration order forecast was last updated.
VcsExtHistSupplyForecastPEOLastUpdatedBy	User who last updated the order forecast.
VcsExtHistSupplyForecastPEOMaxCommitVersion	Value that identifies the number of midcycle commit updates performed on this collaboration order forecast.
VcsExtHistSupplyForecastPEOMaxForecastVersion	Value that identifies the number of midcycle forecast updates performed on this collaboration order forecast.
VcsExtHistSupplyForecastPEONoteToPlanner	Note to the planner from the supplier regarding the collaboration order forecast.
VcsExtHistSupplyForecastPEONoteToSupplier	Note to the supplier from the planner regarding the collaboration order forecast.
VcsExtHistSupplyForecastPEOObjectVersionNumber	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.
VcsExtHistSupplyForecastPEOPreviousCollaborationEntryVersion	Value that identifies the previous version of the collaboration entry.
VcsExtHistSupplyForecastPEOPublishCycleEndDate	Date when the publish cycle ended.
VcsExtHistSupplyForecastPEOPublishCycleStartDate	Date when the publish cycle started.
VcsExtHistSupplyForecastPEOPublishedByPartyCode	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.
VcsExtHistSupplyForecastPEOPublishedByPersonId	Value that uniquely identifies the most recent user to publish the collaboration order forecast.
VcsExtHistSupplyForecastPEOPublishedDate	Date when the collaboration order forecast was published.
VcsExtHistSupplyForecastPEOPublishedOnHandQuantity	Value that identifies the quantity of the on-hand inventory for the item that was published with the collaboration order forecast in the collaboration unit of measure.
VcsExtHistSupplyForecastPEOShipFromId	Value that uniquely identifies the ship from object who ships the item.
VcsExtHistSupplyForecastPEOShipToId	Value that uniquely identifies the ship to object who receives the item.
VcsExtHistSupplyForecastPEOSlaDays	Number of days in the service level agreement for the supplier to respond to an order forecast.
VcsExtHistSupplyForecastPEOStatusCode	Code that identifies the current state of the collaboration 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.
VcsExtHistSupplyForecastPEOSupplierOnHandPublishedByPartyCode	Code that identifies the party that published the supplier on-hand quantity. 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.
VcsExtHistSupplyForecastPEOSupplierOnHandPublishedByPersonId	User who published the supplier on-hand quantity.
VcsExtHistSupplyForecastPEOSupplierOnHandPublishedDate	Date and time when the supplier on-hand quantity was published.
VcsExtHistSupplyForecastPEOSupplierOnHandQuantity	Value that identifies the quantity of the supplier on-hand inventory for the item in the collaboration unit of measure.
VcsExtHistSupplyForecastPEOUOMCode	Code that identifies the unit of measure for the item.