PJC_CAP_EXCEPTIONS
Exceptions table used for PJC Capital concurrent processes. Used to store error messages and ID fields relating to the error for use in reporting the errors through the UI.
Details
-
Schema: FUSION
-
Object owner: PJC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
PJC_CAP_EXCEPTIONS_PK |
EXCEPTION_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
EXCEPTION_ID | NUMBER | 18 | Yes | Unique primary key column ***** | |
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
MODULE | VARCHAR2 | 30 | Yes | Text identifier of the process that is being run ***** | |
SUB_MODULE | VARCHAR2 | 30 | Sub section of the concurrent process for which errors are being thrown. Allows reports to be grouped by a sub module if any exist. | ||
MESSAGE_NAME | VARCHAR2 | 30 | Yes | The message_name in FND_MESSAGES_B that indicates the exception that has occurred ***** | |
PROJECT_ID | NUMBER | 18 | Project ID relating to the exception that has occurred ***** | ||
TOKEN_NAME1 | VARCHAR2 | 30 | Token name ***** | ||
TOKEN_NAME2 | VARCHAR2 | 30 | Token name ***** | ||
TOKEN_NAME3 | VARCHAR2 | 30 | Token name ***** | ||
TOKEN_NAME4 | VARCHAR2 | 30 | Token name ***** | ||
TOKEN_NAME5 | VARCHAR2 | 30 | Token name ***** | ||
TOKEN_VALUE1 | VARCHAR2 | 2000 | Token value ***** | ||
TOKEN_VALUE2 | VARCHAR2 | 2000 | Token value ***** | ||
TOKEN_VALUE3 | VARCHAR2 | 2000 | Token value ***** | ||
TOKEN_VALUE4 | VARCHAR2 | 2000 | Token value ***** | ||
TOKEN_VALUE5 | VARCHAR2 | 2000 | Token value ***** | ||
PROJECT_ASSET_ID | NUMBER | 18 | Stores the unique asset identifier associated with the exception. | ||
AMOUNT | NUMBER | Stores amounts associated with the exception. | |||
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. | ||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or 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. | |
TASK_ID | NUMBER | 18 | The task identifier for which there is a cost exception or an asset capitalization exception. | ||
NUM_OF_ROWS | NUMBER | 18 | This column stores the number of rows that were not processed by the asset generation run. | ||
MESSAGE_TYPE | VARCHAR2 | 1 | This column would indicate the type of error message. E -> Error, W -> Warning, I -> Information. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
PJC_CAP_EXCEPTIONS | pjf_projects_all_b | PROJECT_ID |
PJC_CAP_EXCEPTIONS | pjf_proj_elements_b | TASK_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
PJC_CAP_EXCEPTIONS_U1 | Unique | Default | EXCEPTION_ID |