1. Tables and Views for HCM
  2. PER_MASS_ERROR_LINES

PER_MASS_ERROR_LINES

Stores error information generated during the processing of a mass action.

Details

  • Schema: FUSION

  • Object owner: PER

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

PER_MASS_ERROR_LINES_PK

MASS_ACTION_ERROR_ID

Columns

Name Datatype Length Precision Not-null Comments
MASS_ACTION_ERROR_ID NUMBER 18 Yes System generated primary key column.
MASS_ACTION_LINE_ID NUMBER 18 Yes Foreign Key to PER_MASS_ACTION_LINES table.
ENTERPRISE_ID NUMBER 18 Yes Identifier of Enterprise, used for multi-tenancy partitioning. Foreign key to HR_ORGANIZATION_UNITS.
ORIGINATING_SYSTEM VARCHAR2 200 Name of the AM running update and catching error.
ROW_STATUS VARCHAR2 100 Whether line is in error or warning.
MSG_TEXT VARCHAR2 500 Exception generated by method running the update.
MSG_ERROR_ID NUMBER 18 Reference Identifier for error message.
PARAMETER_01 VARCHAR2 200 Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_02 VARCHAR2 200 Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_03 VARCHAR2 200 Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_04 VARCHAR2 200 Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_05 VARCHAR2 200 Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_06 VARCHAR2 200 Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_07 VARCHAR2 200 Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_08 VARCHAR2 4000 Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_09 VARCHAR2 200 Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_10 VARCHAR2 200 Descriptive field used by Batch Loader: Used to hold parameter values
LOADER_BATCH_ID NUMBER 18 Identifies the batch processed by batch loader.
STACKTRACE VARCHAR2 4000 Contents of error generated (java stacktrace).
ERROR_STACK CLOB Short version of error generated.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
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_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.
PARAMETER_11 VARCHAR2 200 Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_12 VARCHAR2 200 Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_13 VARCHAR2 200 Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_14 VARCHAR2 200 Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_15 VARCHAR2 200 Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_16 VARCHAR2 4000 Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_17 VARCHAR2 4000 Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_18 VARCHAR2 4000 Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_19 VARCHAR2 4000 Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_20 VARCHAR2 4000 Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_NUM_1 NUMBER Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_NUM_2 NUMBER Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_NUM_3 NUMBER Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_NUM_4 NUMBER Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_NUM_5 NUMBER Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_DATE_1 DATE Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_DATE_2 DATE Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_DATE_3 DATE Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_DATE_4 DATE Descriptive field used by Batch Loader: Used to hold parameter values
PARAMETER_DATE_5 DATE Descriptive field used by Batch Loader: Used to hold parameter values
SEC_OBJ_NAME VARCHAR2 80 This is to Store the object Name on which error line needs to be secured
SEC_PRIV_NAME VARCHAR2 400 This is to store the Date privilege name on which error line needs to be secured
SEC_KEY1 NUMBER To Store the first Security Key attribute for evaluating Security
SEC_KEY2 DATE To Store the second Security Key attribute for evaluating Security if it is date line Effective Start date
SEC_KEY3 DATE To Store the third Security Key attribute for evaluating Security if it is date line Effective end date
SEC_KEY4 VARCHAR2 20 To Store the fourth Security Key attribute for evaluating Security if it is date line Effective latest changes
SEC_KEY5 VARCHAR2 20 To store any extra Security attributes
SEC_KEY6 VARCHAR2 20 To store any extra Security attributes

Indexes

Index Uniqueness Tablespace Columns
PER_MASS_ERROR_LINES_N1 Non Unique Default MASS_ACTION_LINE_ID
PER_MASS_ERROR_LINES_PK Unique Default MASS_ACTION_ERROR_ID