PlanStatus
Returns status records for supply chain plans, including plan type, execution status, and action history.
Columns
| Name | Type | SupportedFinders | Description |
| PlanId [KEY] | Long | PrimaryKey | The unique identifier of the plan. |
| PlanDefPlanId | Long | The unique identifier of the plan. | |
| PlanDefStatus | Decimal | The status of plan actions performed in the past. Contains one of the following values. 0: Completed, 1:Processing, 2:Error, or 3: Warning. A list of accepted values are defined in the lookup type ORA_MSC_PLAN_STATUS_TYPE. This attribute does not have a default value. | |
| CompileDesignator | String | The name of the plan. | |
| PlanDefPlanType | Long | The type of plan. A list of accepted values are defined in the lookup type ORA_MSC_PLAN_TYPE. Valid values include 1:Demand Plan, 2: Supply Plan, 3:Demand and Supply Plan, 4:Sales and Operations Plan, and 5 :Replenishment Plan. This attribute does not have a default value. | |
| PlanStatusCreatedBy | String | The user who performed the action for the plan status change. | |
| PlanStatusCreationDate | Datetime | The date when the plan status was created. | |
| PlanStatusEndDate | Datetime | The date when the plan status ended. | |
| PlanStatusExecutionId | Long | The unique identifier of the plan status execution. | |
| PlanStatusExecutionUser | String | The user who performed the action for the plan status change. | |
| PlanStatusLastUpdateDate | Datetime | The date when the plan status was last updated. | |
| PlanStatusLastUpdateLogin | String | The user who logged in for the last action update for the plan status change. | |
| PlanStatusLastUpdatedBy | String | The user who performed the last action update for the plan status change. | |
| PlanStatusVersionNumber | Int | The version number of the plan status. | |
| PlanStatusPlanAction | Int | The plan action performed. Contains one of the following values. 1 : Run plan full refresh, 2: Run plan partial refresh, 3:Run plan no refresh, 4 :Copy plan, 5:Load plan, 6: Save plan, 7: Delete plan or 8: Close plan. A list of accepted values are defined in the lookup type ORA_MSC_PLAN_USER_ACTION. This attribute does not have a default value. | |
| PlanStatusPlanId | Long | The unique identifier of the plan. | |
| PlanStatusStartDate | Datetime | The date when the plan status started. | |
| PlanStatusStatus | Int | The status of plan actions performed in the past. Contains one of the following values. 0 : Completed, 1 :Processing, 2:Error, or 3: Warning. A list of accepted values are defined in the lookup type ORA_MSC_PLAN_STATUS_TYPE. This attribute does not have a default value. | |
| Finder | String | The name of the finder method used to search and filter records. |