CZ_MODEL_TMP_SESSIONDATA

This table stores the temporary session specific data associated with a model version. When user opens a model tab in CME, this table will be populated with temporary data associated with that model version, this temporary data is primarily designed to improve the performance of the search and other queries when user working on the model.

Details

• Schema: FUSION

• Object owner: CZ

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
CZ_MODEL_TMP_SESSIONDATA_PK	SESSION_ID, WORKSPACE_ID, ROOT_MODEL_ID, ROOT_MODEL_VERSION, REFD_BOM_MODEL_NODE_PATH, SUPL_MREF_NODE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
SESSION_ID	VARCHAR2	32		Yes	Application Session identifier from FND_SESSIONS table, populated using FND_GLOBAL.SESSION_ID.
WORKSPACE_ID	NUMBER		18	Yes	Identifier of the workspace that root model version belongs to.
ROOT_MODEL_ID	NUMBER		18	Yes	Root model identifier. Here root model is the model that is opened as a dynamic tab in CME. All the referred model records will have the same root model identifier.
ROOT_MODEL_VERSION	NUMBER		18	Yes	Version of the root model under the workspace.
REFD_BOM_MODEL_NODE_PATH	VARCHAR2	4000		Yes	Referred BOM models inventory id path. This uniquely identifies a referred BOM Model. For supplemental model reference records it will be empty string.
SUPL_MREF_NODE_ID	NUMBER		18	Yes	Node identifier of the supplemental model reference node.
ROW_TYPE	VARCHAR2	30		Yes	This column indicates the row type of the temporary record. There are following four types of rows: ROOT_BOM_MODEL, ROOT_SUPL_MODEL, BOM_MODEL_REF, SUPL_MODEL_REF
GROUPING_MODEL_ID	NUMBER		18		Identifier of the grouping model that groups the model references. In case of BOM model, root bom model and each referred BOM model become a grouping model. In case of supplemental only model, the root supplemental model will be the only grouping model.
GROUPING_MODEL_VERSION	NUMBER		18		Effective version of the grouping model.
REFERRING_MODEL_ID	NUMBER		18		Identifier of the referring model that has the model reference node. This column is used for both BOM and Supplemental model references. This will be null for the root model's record.
REFD_MODEL_ID	NUMBER		18		Referred Model Identifier. For root model record ROOT_MODEL_ID=REFD_MODEL_ID.
REFD_MODEL_VERSION	NUMBER		18		Referred Model's effective version under the root model's workspace.
REFD_MODEL_BASE_VERSION	NUMBER		18		Referred Model's baseline version.
SUPL_MREF_NODE_START_VER	NUMBER		18		Supplemental model reference node start version.
SUPL_MREF_NODE_END_VER	NUMBER		18		Supplemental model reference node end version.
IS_EFFECTIVE	VARCHAR2	1			This flag indicates whether the model reference is effective or not at the workspace Effective Start Date (ESD). You can ignore this column, as the temporary script deletes records which are not effective. It is used only by the session data creation script.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	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.
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.

Indexes

Index	Uniqueness	Tablespace	Columns
CZ_MODEL_TMP_SESSIONDATA_U1	Unique	Default	SESSION_ID, WORKSPACE_ID, ROOT_MODEL_ID, ROOT_MODEL_VERSION, REFD_BOM_MODEL_NODE_PATH, SUPL_MREF_NODE_ID, SUPL_MREF_NODE_START_VER
CZ_MODEL_TMP_SESSIONDATA_U2	Unique	Default	SESSION_ID, WORKSPACE_ID, ROOT_MODEL_ID, ROOT_MODEL_VERSION, REFD_BOM_MODEL_NODE_PATH, SUPL_MREF_NODE_ID