PJC_ASSET_ERRORS_INT
PJC_ASSET_ERRORS_INT table used to store error messages and ID fields relating to the importing of the assets and the asset assignments. The data recorded in this error table is used to generate BIP reports and displaying the errors through the UI.
Details
-
Schema: FUSION
-
Object owner: PJC
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
ERROR_ID | NUMBER | 18 | Yes | Unique primary key column. | |
SOURCE_ID | NUMBER | 18 | Yes | Identifier from Assets Stage and Asset Assignment Stage Tables. | |
MESSAGE_NAME | VARCHAR2 | 30 | Yes | The message_name in FND_MESSAGES_B that indicates the exception that has occurred. | |
TOKEN_NAME1 | VARCHAR2 | 30 | Token name1. | ||
TOKEN_NAME2 | VARCHAR2 | 30 | Token name2. | ||
TOKEN_NAME3 | VARCHAR2 | 30 | Token name3. | ||
TOKEN_VALUE1 | VARCHAR2 | 1000 | Token value1. | ||
TOKEN_VALUE2 | VARCHAR2 | 1000 | Token value2. | ||
TOKEN_VALUE3 | VARCHAR2 | 1000 | Token value3. | ||
TOKEN_DATA_TYPE1 | VARCHAR2 | 20 | Token Data Type1. | ||
TOKEN_DATA_TYPE2 | VARCHAR2 | 20 | Token Data Type2. | ||
TOKEN_DATA_TYPE3 | VARCHAR2 | 20 | Token Data Type3. | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
LOAD_REQUEST_ID | NUMBER | 18 | Load Request ID to be populated by parent ESS job. | ||
CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | 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 |
---|---|---|---|
PJC_ASSET_ERRORS_INT_N1 | Non Unique | Default | SOURCE_ID |
PJC_ASSET_ERRORS_INT_N2 | Non Unique | Default | REQUEST_ID |
PJC_ASSET_ERRORS_INT_U1 | Unique | Default | ERROR_ID |