External Supply Forecasts

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

Data Store Key : FscmTopModelAM.ScmExtractAM.VcsBiccExtractAM.VcsExtSupplyForecastExtractPVO

Primary Keys : VcsCollabPartShipFromPEOShipFromVcsParticipantId, VcsCollabPartShipToPEOShipToVcsParticipantId, VcsCollaborationPlanPEOCollaborationSourceId, VcsExtSupplyForecastPEOCollaborationOrderForecastEntryId

Initial Extract Date : VcsExtSupplyForecastPEOCreationDate

Incremental Extract Date : VcsExtSupplyForecastPEOLastUpdateDate

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.
VcsExtSupplyForecastPEOAutoCommitPercentFactor	Value that identifies the percentage of the forecast quantity used to calculate the automatic commit quantities when CommitQuantityPreferenceCode is set to PERCENTAGE_OF_FORECAST.
VcsExtSupplyForecastPEOAutoCommitPeriodCode	Code that identifies the period of time for which automatic commits are provided. Values include DAYS or COMMIT_HORIZON.
VcsExtSupplyForecastPEOAutoCommitPeriodFactor	Number of days that defines the time range for automatic commits when AutoCommitPeriodCode is DAYS.
VcsExtSupplyForecastPEOBaseUomCode	Code that identifies the primary unit of measure of the item.
VcsExtSupplyForecastPEOCmOnHandPublishedByPartyCode	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.
VcsExtSupplyForecastPEOCmOnHandPublishedByPersonId	Value that uniquely identifies the most recent user to publish the contract manufacturer on-hand quantity.
VcsExtSupplyForecastPEOCmOnHandPublishedDate	Date and time when the user published the contract manufacturer's on-hand quantities.
VcsExtSupplyForecastPEOCmOnHandQuantity	Quantity of the contract manufacturer's on-hand inventory for the item in the collaboration unit of measure.
VcsExtSupplyForecastPEOCollaborationEntryVersion	Value that identifies the version of the collaboration entry.
VcsExtSupplyForecastPEOCollaborationIdentityId	Value that uniquely identifies the collaboration order forecast identity.
VcsExtSupplyForecastPEOCollaborationOrderForecastEntryId	Value that uniquely identifies the collaboration order forecast entry.
VcsExtSupplyForecastPEOCollaborationOrderForecastEntryTypeId	Value that uniquely identifies the type of collaboration order forecast entry.
VcsExtSupplyForecastPEOCollaborationSourceId	Value that uniquely identifies the source of the collaboration plan.
VcsExtSupplyForecastPEOCollaborationUomSourceCode	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.
VcsExtSupplyForecastPEOCommitDate	Date when the supply was committed for the collaboration order forecast.
VcsExtSupplyForecastPEOCommitDetailLastUpdatedByEnterprise	Date and time when the commit detail was last updated by the enterprise user.
VcsExtSupplyForecastPEOCommitDetailLastUpdatedBySupplier	Date and time when the commit detail was last updated by the supplier user.
VcsExtSupplyForecastPEOCommitDueDate	Date when the supply commits are due for the collaboration order forecast.
VcsExtSupplyForecastPEOCommitHorizonEndDate	Date when the commit horizon ended.
VcsExtSupplyForecastPEOCommitQuantityPreferenceCode	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.
VcsExtSupplyForecastPEOCommitTotalQuantity	Sum of the commit quantities over the commit horizon for a collaboration order forecast.
VcsExtSupplyForecastPEOCommittedByPartyCode	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.
VcsExtSupplyForecastPEOCommittedByPersonId	Value that uniquely identifies the user who committed to the order forecast commit quantity.
VcsExtSupplyForecastPEOCorrelationCode	Code that identifies the instance of the orchestration process.
VcsExtSupplyForecastPEOCreatedBy	User who created the collaboration order forecast.
VcsExtSupplyForecastPEOCreationDate	Date and time when the user created the collaboration order forecast.
VcsExtSupplyForecastPEODropShipFlag	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.
VcsExtSupplyForecastPEOEnterpriseDraftQtyFlag	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.
VcsExtSupplyForecastPEOExternalReferenceFlag	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.
VcsExtSupplyForecastPEOForecastDetailLastUpdateEnterprise	Date and time when the enterprise user last updated the forecast detail.
VcsExtSupplyForecastPEOForecastDetailLastUpdateSupplier	Date and time when the supplier user last updated the forecast detail.
VcsExtSupplyForecastPEOForecastHorizonEndDate	Date when the forecast horizon ended.
VcsExtSupplyForecastPEOForecastTotalCommitHorizonQuantity	Sum of the forecast quantities over the commit horizon for a collaboration order forecast.
VcsExtSupplyForecastPEOForecastTotalForecastHorizonQuantity	Sum of the forecast quantities over the forecast horizon for a collaboration order forecast.
VcsExtSupplyForecastPEOInventoryItemId	Value that uniquely identifies the inventory item.
VcsExtSupplyForecastPEOInventoryItemOrganizationId	Value that uniquely identifies the inventory item organization.
VcsExtSupplyForecastPEOIsCurrentFlag	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.
VcsExtSupplyForecastPEOIsManagedFlag	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.
VcsExtSupplyForecastPEOLastPublishedPlanName	Name of the last published supply plan used to generate the collaboration order forecast.
VcsExtSupplyForecastPEOLastUpdateDate	Date and time when the collaboration order forecast was last updated.
VcsExtSupplyForecastPEOLastUpdatedBy	User who last updated the order forecast.
VcsExtSupplyForecastPEOMaxCommitVersion	Value that identifies the number of midcycle commit updates performed on this collaboration order forecast.
VcsExtSupplyForecastPEOMaxForecastVersion	Value that identifies the number of midcycle forecast updates performed on this collaboration order forecast.
VcsExtSupplyForecastPEONoteToPlanner	Note to the planner from the supplier regarding the collaboration order forecast.
VcsExtSupplyForecastPEONoteToSupplier	Note to the supplier from the planner regarding the collaboration order forecast.
VcsExtSupplyForecastPEOObjectVersionNumber	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.
VcsExtSupplyForecastPEOPublishCycleEndDate	Date when the publish cycle ended.
VcsExtSupplyForecastPEOPublishCycleStartDate	Date when the publish cycle started.
VcsExtSupplyForecastPEOPublishedByPartyCode	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.
VcsExtSupplyForecastPEOPublishedByPersonId	Value that uniquely identifies the user who most recently published the collaboration order forecast.
VcsExtSupplyForecastPEOPublishedDate	Date when the collaboration order forecast was published.
VcsExtSupplyForecastPEOPublishedOnHandQuantity	Quantity of the on-hand inventory for the item that was published with the collaboration order forecast in the collaboration unit of measure.
VcsExtSupplyForecastPEOPublishedUomCode	Code that identifies the published unit of measure for the collaboration order forecast.
VcsExtSupplyForecastPEOShipFromId	Value that uniquely identifies the ship from object who ships the item.
VcsExtSupplyForecastPEOShipToId	Value that uniquely identifies the ship to object who receives the item.
VcsExtSupplyForecastPEOSlaDays	Number of days in the service level agreement for the supplier to respond to an order forecast.
VcsExtSupplyForecastPEOSlaPastDueActionCode	Code that identifies the past due action for service level agreements. Values include null and AUTO_COMMIT.
VcsExtSupplyForecastPEOStatusCode	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.
VcsExtSupplyForecastPEOSupplierDraftQtyFlag	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.
VcsExtSupplyForecastPEOSupplierOnHandPublishedByPartyCode	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.
VcsExtSupplyForecastPEOSupplierOnHandPublishedByPersonId	Value that uniquely identifies the user who published the supplier on-hand quantity.
VcsExtSupplyForecastPEOSupplierOnHandPublishedDate	Date and time when the supplier on-hand quantity was published.
VcsExtSupplyForecastPEOSupplierOnHandQuantity	Quantity of the supplier on-hand inventory for the item in the collaboration unit of measure.
VcsExtSupplyForecastPEOUOMCode	Value that identifies the time level of the collaboration order forecast. Values are null and AS_REQUESTED.
VcsSupplyForecastPEOTimeLevel	Code that identifies the unit of measure for the item.