PJC_XCC_BURDEN_DIST_ERRORS
This table stores exceptions encountered during burden cost generation, planning resource breakdown structure element mapping for raw cost and burden cost, or burden cost account generation.
Details
-
Schema: FUSION
-
Object owner: PJC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PJC_XCC_BURDEN_DIST_ERROR_PK |
BURDEN_DIST_ERROR_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BURDEN_DIST_ERROR_ID | NUMBER | 18 | Yes | Surrogate key that uniquely identifies the exception record. | |
| DATA_SET_ID | NUMBER | 18 | Yes | Identifies data for a particular budgetary control request. A budgetary control request has only one DATA_SET_ID. | |
| TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Yes | Transaction source identifier. | |
| SOURCE_HEADER_ID_1 | VARCHAR2 | 30 | Yes | Transaction identifier of the burden cost. | |
| SOURCE_HEADER_ID_2 | VARCHAR2 | 30 | Yes | Transaction identifier of the burden cost. | |
| SOURCE_LINE_ID_1 | VARCHAR2 | 30 | Yes | Distribution identifier of the burden cost. | |
| SOURCE_LINE_ID_2 | VARCHAR2 | 30 | Yes | Distribution identifier of the burden cost. | |
| SOURCE_LINE_ID_3 | VARCHAR2 | 30 | Yes | Distribution identifier of the burden cost. | |
| SOURCE_LINE_ID_4 | VARCHAR2 | 30 | Yes | Distribution identifier of the burden cost. | |
| SOURCE_LINE_ID_5 | VARCHAR2 | 30 | Yes | Distribution identifier of the burden cost. | |
| SOURCE_LINE_ID_6 | VARCHAR2 | 30 | Yes | Distribution identifier of the burden cost. | |
| ERROR_GROUP | VARCHAR2 | 15 | Yes | Indicates cause of the error. Valid values are BURDENGEN for burden generation, RBSMAP for RBS element mapping, and TAB for budget account generation. | |
| MESSAGE_NAME | VARCHAR2 | 30 | Name of the message recorded in Oracle Middleware Extensions for Applications. | ||
| TOKEN1_NAME | VARCHAR2 | 30 | Name of the message token. | ||
| TOKEN1_DATATYPE | VARCHAR2 | 10 | Data type of the token, for example char, number, or date. | ||
| TOKEN1_VALUE | VARCHAR2 | 2000 | Value for the message token. | ||
| TOKEN2_NAME | VARCHAR2 | 30 | Name of the message token. | ||
| TOKEN2_DATATYPE | VARCHAR2 | 10 | Data type of the token, for example char, number, or date. | ||
| TOKEN2_VALUE | VARCHAR2 | 2000 | Value for the message token. | ||
| TOKEN3_NAME | VARCHAR2 | 30 | Name of the message token. | ||
| TOKEN3_DATATYPE | VARCHAR2 | 10 | Data type of the token, for example char, number, or date. | ||
| TOKEN3_VALUE | VARCHAR2 | 2000 | Value for the message token. | ||
| TOKEN4_NAME | VARCHAR2 | 30 | Name of the message token. | ||
| TOKEN4_DATATYPE | VARCHAR2 | 10 | Data type of the token, for example char, number, or date. | ||
| TOKEN4_VALUE | VARCHAR2 | 2000 | Value for the message token. | ||
| TOKEN5_NAME | VARCHAR2 | 30 | Name of the message token. | ||
| TOKEN5_DATATYPE | VARCHAR2 | 10 | Data type of the token, for example char, number, or date. | ||
| TOKEN5_VALUE | VARCHAR2 | 2000 | Value for the message token. | ||
| 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 |
|---|---|---|---|
| PJC_XCC_BURDEN_DIST_ERRS_N1 | Non Unique | Default | DATA_SET_ID |
| PJC_XCC_BURDEN_DIST_ERRS_N2 | Non Unique | Default | SOURCE_HEADER_ID_1, SOURCE_LINE_ID_1, SOURCE_LINE_ID_2, TRANSACTION_TYPE_CODE, SOURCE_HEADER_ID_2, SOURCE_LINE_ID_3, SOURCE_LINE_ID_4, SOURCE_LINE_ID_5, SOURCE_LINE_ID_6 |
| PJC_XCC_BURDEN_DIST_ERRS_U1 | Unique | Default | BURDEN_DIST_ERROR_ID |