Historical Supply Forecasts
The Historical Supply Forecasts view object contains information on historical supply forecasts and commits from Oracle Fusion product data model.
Data Store Key : FscmTopModelAM.ScmExtractAM.VcsBiccExtractAM.VcsHistSupplyForecastExtractPVO
Primary Keys : VcsCollabPartShipFromPEOShipFromVcsParticipantId, VcsCollabPartShipToPEOShipToVcsParticipantId, VcsCollaborationPlanPEOCollaborationSourceId, VcsHistSupplyForecastPEOCollaborationOrderForecastEntryId
Initial Extract Date : VcsHistSupplyForecastPEOCreationDate
Incremental Extract Date : VcsHistSupplyForecastPEOLastUpdateDate
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 receives 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. |
| VcsHistSupplyForecastPEOCmOnHandPublishedByPartyCode | 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. |
| VcsHistSupplyForecastPEOCmOnHandPublishedByPersonId | Value that uniquely identifies the most recent user to publish the contract manufacturer on-hand quantity. |
| VcsHistSupplyForecastPEOCmOnHandPublishedDate | Date and time when the contract manufacturer's on-hand quantities was published. |
| VcsHistSupplyForecastPEOCmOnHandQuantity | Value that identifies the quantity of the contract manufacturer's on-hand inventory for the item in the collaboration unit of measure. |
| VcsHistSupplyForecastPEOCollaborationEntryVersion | Value that identifies the version of the collaboration entry. |
| VcsHistSupplyForecastPEOCollaborationIdentityId | Value that uniquely identifies the collaboration order forecast identity. |
| VcsHistSupplyForecastPEOCollaborationOrderForecastEntryId | Value that uniquely identifies the historical collaboration order forecast entry. |
| VcsHistSupplyForecastPEOCollaborationOrderForecastEntryTypeId | Value that uniquely identifies the type of collaboration order forecast entry. |
| VcsHistSupplyForecastPEOCollaborationSourceId | Value that uniquely identifies the source of a collaboration plan. |
| VcsHistSupplyForecastPEOCollaborationUOMCode | 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. |
| VcsHistSupplyForecastPEOCommitDate | Date when the supply was committed for the collaboration order forecast. |
| VcsHistSupplyForecastPEOCommitDueDate | Date when the supply commits are due for the collaboration order forecast. |
| VcsHistSupplyForecastPEOCommitHorizonEndDate | Date when the commit horizon ended. |
| VcsHistSupplyForecastPEOCommitTotalQuantity | Sum of the commit quantities over the commit horizon for a collaboration order forecast. |
| VcsHistSupplyForecastPEOCommittedByPartyCode | 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. |
| VcsHistSupplyForecastPEOCommittedByPersonId | Value that uniquely identifies the user who committed to the order forecast commit quantity. |
| VcsHistSupplyForecastPEOCorrelationCode | Code that identifies the instance of the orchestration process. |
| VcsHistSupplyForecastPEOCreatedBy | User who created the collaboration order forecast. |
| VcsHistSupplyForecastPEOCreationDate | Date and time when the user created the collaboration order forecast. |
| VcsHistSupplyForecastPEOForecastHorizonEndDate | Date when the forecast horizon ended. |
| VcsHistSupplyForecastPEOForecastTotalCommitHorizonQuantity | Sum of the forecast quantities over the commit horizon for a collaboration order forecast. |
| VcsHistSupplyForecastPEOForecastTotalForecastHorizonQuantity | Sum of the forecast quantities over the forecast horizon for a collaboration order forecast. |
| VcsHistSupplyForecastPEOInventoryItemId | Value that uniquely identifies the inventory item. |
| VcsHistSupplyForecastPEOInventoryItemOrganizationId | Value that uniquely identifies the inventory item organization. |
| VcsHistSupplyForecastPEOLastPublishedPlanName | Name of the last published supply plan used to generate the collaboration order forecast. |
| VcsHistSupplyForecastPEOLastUpdateDate | Date and time when the collaboration order forecast was last updated. |
| VcsHistSupplyForecastPEOLastUpdatedBy | User who last updated the order forecast. |
| VcsHistSupplyForecastPEOMaxCommitVersion | Value that identifies the number of midcycle commit updates performed on this collaboration order forecast. |
| VcsHistSupplyForecastPEOMaxForecastVersion | Value that identifies the number of midcycle forecast updates performed on this collaboration order forecast. |
| VcsHistSupplyForecastPEONoteToPlanner | Note to the planner from the supplier regarding the collaboration order forecast. |
| VcsHistSupplyForecastPEONoteToSupplier | Note to the supplier from the planner regarding the collaboration order forecast. |
| VcsHistSupplyForecastPEOObjectVersionNumber | 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. |
| VcsHistSupplyForecastPEOPreviousCollaborationEntryVersion | Value that identifies the previous version of the collaboration entry. |
| VcsHistSupplyForecastPEOPublishCycleEndDate | Date when the publish cycle ended. |
| VcsHistSupplyForecastPEOPublishCycleStartDate | Date when the publish cycle started. |
| VcsHistSupplyForecastPEOPublishedByPartyCode | 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. |
| VcsHistSupplyForecastPEOPublishedByPersonId | Value that uniquely identifies the user who most recently published the collaboration order forecast. |
| VcsHistSupplyForecastPEOPublishedDate | Date when the collaboration order forecast was published. |
| VcsHistSupplyForecastPEOPublishedOnHandQuantity | 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. |
| VcsHistSupplyForecastPEOShipFromId | Value that uniquely identifies the ship from object who ships the item. |
| VcsHistSupplyForecastPEOShipToId | Value that uniquely identifies the ship to object who receives the item. |
| VcsHistSupplyForecastPEOSlaDays | Number of days in the service level agreement for the supplier to respond to an order forecast. |
| VcsHistSupplyForecastPEOStatusCode | 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. |
| VcsHistSupplyForecastPEOSupplierOnHandPublishedByPartyCode | 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. |
| VcsHistSupplyForecastPEOSupplierOnHandPublishedByPersonId | User who published the supplier on-hand quantity. |
| VcsHistSupplyForecastPEOSupplierOnHandPublishedDate | Date and time when the supplier on-hand quantity was published. |
| VcsHistSupplyForecastPEOSupplierOnHandQuantity | Value that identifies the quantity of the supplier on-hand inventory for the item in the collaboration unit of measure. |
| VcsHistSupplyForecastPEOUOMCode | Code that identifies the unit of measure for the item. |