1. Tables and Views for Financials
  2. EXM_VALIDATION_RESULTS

EXM_VALIDATION_RESULTS

This table contains validation results of spend authorization creation processes.

Details

  • Schema: FUSION

  • Object owner: EXM

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

EXM_VALIDATION_RESULTS_PK

VALIDATION_ID

Columns

Name Datatype Length Precision Not-null Comments Status
VALIDATION_ID NUMBER 18 Yes Validation result identifier of spend authorization.
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.
SOURCE_OBJECT_ID NUMBER 18 Yes Foreign key to Expenses table that contains data that is the source of the validation. A possible value is EXPENSE_ID.
SOURCE_TABLE VARCHAR2 128 Yes Expense table that contains data that is the source of error, such as EXM_EXPENSE_REPORTS or EXM_EXPENSES. Active
MESSAGE_NAME VARCHAR2 30 Yes Name of FND, Foundation, message type. Active
MESSAGE_TOKEN_NAME1 VARCHAR2 30 First text token name of the message. Active
MESSAGE_TOKEN_NAME2 VARCHAR2 30 Second text token name of the message. Active
MESSAGE_TOKEN_NAME3 VARCHAR2 30 Third text token name of the message. Active
MESSAGE_TOKEN_NAME4 VARCHAR2 30 Fourth text token name of the message. Active
MESSAGE_TOKEN_NAME5 VARCHAR2 30 Fifth text token name of the message. Active
MESSAGE_TOKEN_VALUE1 VARCHAR2 240 First token value of the message. Active
MESSAGE_TOKEN_VALUE2 VARCHAR2 240 Second token value of the message. Active
MESSAGE_TOKEN_VALUE3 VARCHAR2 240 Third token value of the message. Active
MESSAGE_TOKEN_VALUE4 VARCHAR2 240 Fourth token value of the message. Active
MESSAGE_TOKEN_VALUE5 VARCHAR2 240 Fifth token value of the message. Active
SEVERITY_NAME VARCHAR2 32 Yes Severity of validation result. Possible values are Warning and Error. Active
BC4J_OBJECT_ATTRIBUTE VARCHAR2 64 Yes Attribute of object that generated error. Active
BC4J_OBJECT_ATTRIBUTE_VALUE VARCHAR2 240 Value of object attribute error. Active
EXCEPTION_TYPE VARCHAR2 32 Yes Type of exception for the validation. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created 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.

Indexes

Index Uniqueness Tablespace Columns
EXM_VALIDATION_RESULTS_N1 Non Unique FUSION_TS_TX_DATA SOURCE_OBJECT_ID, SOURCE_TABLE, MESSAGE_NAME
EXM_VALIDATION_RESULTS_PK Unique FUSION_TS_TX_DATA VALIDATION_ID