Collaboration Plans

The Collaboration Plans view object contains information on supply chain collaboration plans.

Data Store Key : FscmTopModelAM.ScmExtractAM.VcsBiccExtractAM.VcsCollaborationPlansExtractPVO

Primary Keys : VcsPlanScenariosTranslatePEOLanguage, VcsCollaborationPlansPEOCollaborationSourceId, VcsPlanScenariosTranslatePEOScenarioId, VcsPlanScenariosBasePEOScenarioId

Initial Extract Date : VcsCollaborationPlansPEOCreationDate

Incremental Extract Date : VcsCollaborationPlansPEOLastUpdateDate

Attributes

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

Name	Description
VcsCollaborationPlansPEOCollabName	Name of the collaboration plan.
VcsCollaborationPlansPEOCollaborationSourceId	Value that uniquely identifies the collaboration plan.
VcsCollaborationPlansPEOCollaborationTypeCode	Code that identifies the source of the supply plan. A list of accepted values is defined in the lookup type ORA_VCS_SUPPLY_PLAN_SOURCE. Review and update the values for this attribute using the Setup and Maintenance work area, and the Manage Supply Chain Collaboration Lookups task.
VcsCollaborationPlansPEOCollaborationVersion	Value that identifies the version of the collaboration.
VcsCollaborationPlansPEOCreatedBy	User who created the collaboration plan.
VcsCollaborationPlansPEOCreationDate	Date and time when the user created the collaboration plan.
VcsCollaborationPlansPEODescription	Description of the collaboration plan.
VcsCollaborationPlansPEOLastUpdateDate	Date and time when the collaboration plan was last updated.
VcsCollaborationPlansPEOLastUpdatedBy	User who last updated the collaboration plan.
VcsCollaborationPlansPEOObjectVersionNumber	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.
VcsCollaborationPlansPEOOriginSourceCode	Code that identifies the origin of the collaboration plan's data source. Values include VCP and IMPORT.
VcsCollaborationPlansPEOParentCollaborationSourceId	Value that uniquely identifies the parent collaboration source.
VcsCollaborationPlansPEOPublishCycleEndDate	Date when the current publish cycle ends.
VcsCollaborationPlansPEOPublishCycleStartDate	Date when the current publish cycle starts.
VcsCollaborationPlansPEOScenarioId	Value that uniquely identifies the plan scenario.
VcsCollaborationPlansPEOSourceSystemCode	Code that identifies the product data model source system for the supply plan that's available for supply chain collaboration. A list of accepted values is defined in the lookup type ORA_VCS_SOURCE_SYSTEM. Review and update the values for this attribute using the Setup and Maintenance work area, and the Manage Supply Chain Collaboration Lookups task.
VcsPlanScenariosBasePEOCreatedBy	User who created the collaboration plan.
VcsPlanScenariosBasePEOCreationDate	Date and time when the user created the collaboration plan.
VcsPlanScenariosBasePEOLastUpdateDate	Date and time when the collaboration plan was last updated.
VcsPlanScenariosBasePEOLastUpdatedBy	User who last updated the collaboration plan.
VcsPlanScenariosBasePEOObjectVersionNumber	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.
VcsPlanScenariosBasePEOPlanName	Name of the supply plan.
VcsPlanScenariosBasePEOPublishCycleDayCode	Code that identifies the day that the publish cycle started. A list of accepted values is defined in the lookup type ORA_VCS_WEEKDAY. Review and update the values for this attribute using the Setup and Maintenance work area, and the Manage Supply Chain Collaboration Lookups task.
VcsPlanScenariosBasePEOPublishCycleFrequency	Number of weeks or months between new planning cycles.
VcsPlanScenariosBasePEOPublishCycleTypeCode	Code that indicates the frequency of the collaboration planning cycle. A list of accepted values is defined in the lookup type ORA_VCS_PLAN_CYCLE_FRQ. Review and update the values for this attribute using the Setup and Maintenance work area, and the Manage Supply Chain Collaboration Lookups task.
VcsPlanScenariosBasePEOPublishMonthlyStartDate	Number that indicates the day of the month when the application publishes supply plans for the publish cycle. Values include 1 to 28.
VcsPlanScenariosBasePEOScenarioId	Value that uniquely identifies the plan scenario.
VcsPlanScenariosBasePEOStartDayOrdinal	Code that identifies the ordinal value that indicates the position of the planning cycle's start day within a month. A list of accepted values is defined in the lookup type ORA_VCS_PLANCYCLE_STARTDAY_ORD. Review and update the values for this attribute using the Setup and Maintenance work area, and the Manage Supply Chain Collaboration Lookups task.
VcsPlanScenariosBasePEOStartType	Code that identifies whether the planning cycle start is defined on a date or on a day of the month. A list of accepted values is defined in the lookup type ORA_VCS_PLAN_CYCLE_START_TYPE. Review and update the values for this attribute using the Setup and Maintenance work area, and the Manage Supply Chain Collaboration Lookups task.
VcsPlanScenariosBasePEOStatusCode	Code that identifies the status of the collaboration plan. Value include A for active and I for inactive.
VcsPlanScenariosTranslatePEOCreatedBy	User who created the collaboration plan.
VcsPlanScenariosTranslatePEOCreationDate	Date and time when the user created the collaboration plan.
VcsPlanScenariosTranslatePEOLanguage	Code that identifies the language into which the content of the translatable columns is translated.
VcsPlanScenariosTranslatePEOLastUpdateDate	Date when the collaboration plan was last updated.
VcsPlanScenariosTranslatePEOLastUpdatedBy	User who last updated the collaboration plan.
VcsPlanScenariosTranslatePEOName	Translatable name of the collaboration plan.
VcsPlanScenariosTranslatePEOObjectVersionNumber	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.
VcsPlanScenariosTranslatePEOScenarioId	Value that uniquely identifies the plan scenario.
VcsPlanScenariosTranslatePEOSourceLang	Code that identifies the language in which the content of the translatable columns was originally created.