Supply Forecasts
The Supply Forecasts view object contains information on the current cycle supply forecasts and commits from Oracle Fusion product data model.
Data Store Key : FscmTopModelAM.ScmExtractAM.VcsBiccExtractAM.VcsSupplyForecastExtractPVO
Primary Keys : VcsCollabPartShipFromPEOShipFromVcsParticipantId, VcsCollabPartShipToPEOShipToVcsParticipantId, VcsCollaborationPlanPEOCollaborationSourceId, VcsSupplyForecastPEOCollaborationOrderForecastEntryId
Initial Extract Date : VcsSupplyForecastPEOCreationDate
Incremental Extract Date : VcsSupplyForecastPEOLastUpdateDate
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. |
| 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. |
| VcsCollabPartShipToPEOShipToCustomerId | Value that uniquely identifies the customer who receives the item. It's a primary key that the application creates when it creates the 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 the 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. |
| VcsSupplyForecastPEOAutoCommitPercentFactor | Value that identifies the percentage of the forecast quantity used to calculate the automatic commit quantities when CommitQuantityPreferenceCode is set to PERCENTAGE_OF_FORECAST. |
| VcsSupplyForecastPEOAutoCommitPeriodCode | Code that identifies the period of time for which automatic commits are provided. Values include DAYS or COMMIT_HORIZON. |
| VcsSupplyForecastPEOAutoCommitPeriodFactor | Number of days that defines the time range for automatic commits when AutoCommitPeriodCode is DAYS. |
| VcsSupplyForecastPEOBaseUomCode | Code that identifies the primary unit of measure of the item. |
| VcsSupplyForecastPEOCmOnHandPublishedByPartyCode | 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. |
| VcsSupplyForecastPEOCmOnHandPublishedByPersonId | Value that uniquely identifies the most recent user to publish the contract manufacturer on-hand quantity. |
| VcsSupplyForecastPEOCmOnHandPublishedDate | Date and time when the user published the contract manufacturer's on-hand quantities. |
| VcsSupplyForecastPEOCmOnHandQuantity | Quantity of the contract manufacturer's on-hand inventory for the item in the collaboration unit of measure. |
| VcsSupplyForecastPEOCollaborationEntryVersion | Value that identifies the version of the collaboration entry. |
| VcsSupplyForecastPEOCollaborationIdentityId | Value that uniquely identifies the collaboration order forecast identity. |
| VcsSupplyForecastPEOCollaborationOrderForecastEntryId | Value that uniquely identifies the collaboration order forecast entry. |
| VcsSupplyForecastPEOCollaborationOrderForecastEntryTypeId | Value that uniquely identifies the type of collaboration order forecast entry. |
| VcsSupplyForecastPEOCollaborationSourceId | Value that uniquely identifies the source of the collaboration plan. |
| VcsSupplyForecastPEOCollaborationUomSourceCode | Code that identifies the unit of measure source that defines the collaboration unit of measure resolution strategy. A list of accepted values is defined in the lookup type ORA_VCS_COLLAB_UOM_SOURCE_CODE. Review and update the values for this attribute using the Setup and Maintenance work area, and the Manage Supply Chain Collaboration Lookups task. |
| VcsSupplyForecastPEOCommitDate | Date when the supply was committed for the collaboration order forecast. |
| VcsSupplyForecastPEOCommitDetailLastUpdatedByEnterprise | Date and time when the commit detail was last updated by the enterprise user. |
| VcsSupplyForecastPEOCommitDetailLastUpdatedBySupplier | Date and time when the commit detail was last updated by the supplier user. |
| VcsSupplyForecastPEOCommitDueDate | Date when the supply commits are due for the collaboration order forecast. |
| VcsSupplyForecastPEOCommitHorizonEndDate | Date when the commit horizon ended. |
| VcsSupplyForecastPEOCommitQuantityPreferenceCode | Code that identifies the options that determine the value of the commit quantities when automatic commit is enabled. A list of accepted values is defined in the lookup type ORA_VCS_COMMIT_QUANTITY. Review and update the values for this attribute using the Setup and Maintenance work area, and the Manage Supply Chain Collaboration Lookups task. |
| VcsSupplyForecastPEOCommitTotalQuantity | Sum of the commit quantities over the commit horizon for a collaboration order forecast. |
| VcsSupplyForecastPEOCommittedByPartyCode | 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. |
| VcsSupplyForecastPEOCommittedByPersonId | Value that uniquely identifies the user who committed to the order forecast commit quantity. |
| VcsSupplyForecastPEOCorrelationCode | Code that identifies the instance of the orchestration process. |
| VcsSupplyForecastPEOCreatedBy | User who created the collaboration order forecast. |
| VcsSupplyForecastPEOCreationDate | Date and time when the user created the collaboration order forecast. |
| VcsSupplyForecastPEODropShipFlag | Contains one of the following values: Y or N. If Y, then the collaboration order forecast is drop ship. If N, then the collaboration order forecast isn't drop ship. This attribute doesn't have a default value. |
| VcsSupplyForecastPEOEnterpriseDraftQtyFlag | 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. |
| VcsSupplyForecastPEOExternalReferenceFlag | Contains one of the following values: Y or N. If Y, then the data is externally referenced for the collaboration order forecast. If N, then the data isn't externally referenced for the collaboration order forecast. This attribute doesn't have a default value. |
| VcsSupplyForecastPEOForecastDetailLastUpdateEnterprise | Date and time when the forecast detail was last updated by the enterprise user. |
| VcsSupplyForecastPEOForecastDetailLastUpdateSupplier | Date and time when the forecast detail was last updated by the supplier user. |
| VcsSupplyForecastPEOForecastHorizonEndDate | Date when the forecast horizon ended. |
| VcsSupplyForecastPEOForecastTotalCommitHorizonQuantity | Sum of the forecast quantities over the commit horizon for a collaboration order forecast. |
| VcsSupplyForecastPEOForecastTotalForecastHorizonQuantity | Sum of the forecast quantities over the forecast horizon for a collaboration order forecast. |
| VcsSupplyForecastPEOInventoryItemId | Value that uniquely identifies the inventory item. |
| VcsSupplyForecastPEOInventoryItemOrganizationId | Value that uniquely identifies the inventory item organization. |
| VcsSupplyForecastPEOIsCurrentFlag | 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. |
| VcsSupplyForecastPEOIsManagedFlag | Contains one of the following values: Y or N. If Y, then the collaboration order forecast has an existing relationship. If N, then the collaboration order forecast doesn't have an existing relationship. This attribute doesn't have a default value. |
| VcsSupplyForecastPEOLastPublishedPlanName | Name of the last published supply plan used to generate the collaboration order forecast. |
| VcsSupplyForecastPEOLastUpdateDate | Date and time when the collaboration order forecast was last updated. |
| VcsSupplyForecastPEOLastUpdatedBy | User who last updated the order forecast. |
| VcsSupplyForecastPEOMaxCommitVersion | Value that identifies the number of midcycle commit updates performed on this collaboration order forecast. |
| VcsSupplyForecastPEOMaxForecastVersion | Value that identifies the number of midcycle forecast updates performed on this collaboration order forecast. |
| VcsSupplyForecastPEONoteToPlanner | Note to the planner from the supplier regarding the collaboration order forecast. |
| VcsSupplyForecastPEONoteToSupplier | Note to the supplier from the planner regarding the collaboration order forecast. |
| VcsSupplyForecastPEOObjectVersionNumber | 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. |
| VcsSupplyForecastPEOPublishCycleEndDate | Date when the publish cycle ended. |
| VcsSupplyForecastPEOPublishCycleStartDate | Date when the publish cycle started. |
| VcsSupplyForecastPEOPublishedByPartyCode | 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. |
| VcsSupplyForecastPEOPublishedByPersonId | Value that uniquely identifies the user who most recently published the collaboration order forecast. |
| VcsSupplyForecastPEOPublishedDate | Date when the collaboration order forecast was published. |
| VcsSupplyForecastPEOPublishedOnHandQuantity | Quantity of the on-hand inventory for the item that was published with the collaboration order forecast in the collaboration unit of measure. |
| VcsSupplyForecastPEOPublishedUomCode | Code that identifies the published unit of measure for the collaboration order forecast. |
| VcsSupplyForecastPEOShipFromId | Value that uniquely identifies the ship from object who ships the item. |
| VcsSupplyForecastPEOShipToId | Value that uniquely identifies the ship to object who receives the item. |
| VcsSupplyForecastPEOSlaDays | Number of days in the service level agreement for the supplier to respond to an order forecast. |
| VcsSupplyForecastPEOSlaPastDueActionCode | Code that identifies the past due action for service level agreements. Values include null and AUTO_COMMIT. |
| VcsSupplyForecastPEOStatusCode | 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. |
| VcsSupplyForecastPEOSupplierDraftQtyFlag | 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. |
| VcsSupplyForecastPEOSupplierOnHandPublishedByPartyCode | 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. |
| VcsSupplyForecastPEOSupplierOnHandPublishedByPersonId | Value that uniquely identifies the user who published the supplier on-hand quantity. |
| VcsSupplyForecastPEOSupplierOnHandPublishedDate | Date and time when the supplier on-hand quantity was published. |
| VcsSupplyForecastPEOSupplierOnHandQuantity | Quantity of the supplier on-hand inventory for the item in the collaboration unit of measure. |
| VcsSupplyForecastPEOTimeLevel | Value that identifies the time level of the collaboration order forecast. Values are null and AS_REQUESTED. |
| VcsSupplyForecastPEOUOMCode | Code that identifies the unit of measure for the item. |