MSS_PLAN_STATUS

This table stores plan action execution records.

Details

• Schema: FUSION

• Object owner: MSS

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
MSS_PLAN_STATUS_PK	EXECUTION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PLAN_ID	NUMBER		18	Yes	Identifier of the Production Scheduling plan.
EXECUTION_ID	NUMBER		18	Yes	Execution Id corresponding to a plan execution session in the engine
JOB_ID	NUMBER		18		ESS Job ID of the plan execution.
EXECUTION_USER	VARCHAR2	64		Yes	User who launches the plan execution.
CURRENT_REQUEST_ACTION	VARCHAR2	16			Macro-level action code of the current request: Refresh|Solve|Release|Duplicate.
STATUS	NUMBER		5		Plan overall execution status: PlanRunning=0, PlanSucceeded=1, PlanFailed=2, PlanWarning=3, JobCancelled=4
ERROR_CODE	NUMBER		5		Error code that describes the reason of last request failure, otherwise null: EnvironmentError=0, DataError=1, SolveError=2, SolveStopped=3, SolveTimeout=4, ReleaseIncomplete=5, DataLimitExceeded=6, DuplicateIncomplete=7
CURRENT_REQUEST	NUMBER		5		Current request that is handled by the engine. Will be reset to null on successful completion of the plan, otherwise it identifies the request that failed.
START_DATE	TIMESTAMP			Yes	Start date-time of plan execution session
END_DATE	TIMESTAMP				Completion date-time of plan execution session
SNAPSHOT_SCN	NUMBER		18		System change numbers used internally in snapshot.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
mss_plan_status_detail	mss_plan_status	EXECUTION_ID
mss_plan_definitions	mss_plan_status	LAST_EXECUTION_ID

Indexes

Index	Uniqueness	Tablespace	Columns
MSS_PLAN_STATUS_U1	Unique	Default	EXECUTION_ID