PJB_ERRORS
This table is used to store the errors that could ocurr in various processes in project billing. The errors are recorded against a transaction (identified by TRANSACTION_TYPE_CODE and corresponding id).
Details
-
Schema: FUSION
-
Object owner: PJB
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PJB_ERRORS_PK |
ERROR_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ERROR_ID | NUMBER | 18 | Yes | Primary Key column containing a random generated number. This column is not updateable ***** | |
| BUSINESS_UNIT_ID | NUMBER | 18 | Business Unit Identifier of the errored object ***** | ||
| TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Yes | Identifies the source of transaction for which this error has occurred. Based on Lookup ERROR_TRANSACTION_TYPE_CODE ***** | |
| EXPENDITURE_ITEM_ID | NUMBER | 18 | Unique identifier of the expenditure item for which the error occurred ***** | ||
| EVENT_ID | NUMBER | 18 | Unique identifier of the billing event for which the error occurred ***** | ||
| BILL_TRX_ID | NUMBER | 18 | Unique identifier of the bill transaction for which the error occurred ***** | ||
| CONTRACT_ID | NUMBER | 18 | Unique identifier of the contract pertaining to the transaction for which the error occurred ***** | ||
| MAJOR_VERSION | NUMBER | 18 | Major version of the contract ***** | ||
| BILLING_TYPE_CODE | VARCHAR2 | 30 | Identifies if the contract is Inter Project / Inter Company / External ***** | ||
| CONTRACT_LINE_ID | NUMBER | 18 | Unique identifier of the contract line pertaining to the transaction for which the error occurred ***** | ||
| INVOICE_ID | NUMBER | 18 | Unique identifier of the invoice for which the error occurred ***** | ||
| INVOICE_LINE_ID | NUMBER | 18 | Unique identifier of the invoice line for which the error occurred ***** | ||
| BILL_PLAN_ID | NUMBER | 18 | Unique identifier of the bill plan pertaining to the transaction / contract line for which the error occurred ***** | ||
| BILLING_CONTROL_ID | NUMBER | 18 | BILLING_CONTROL_ID ***** | ||
| LINKED_PROJECT_ID | NUMBER | 18 | Identifier of the linked project (when applicable) for the failed transaction ***** | ||
| LINKED_TASK_ID | NUMBER | 18 | Identifier of the linked task (when applicable) for the failed transaction ***** | ||
| TRANSACTION_PROJECT_ID | NUMBER | 18 | Identifier of the transaction project (when applicable) for the failed transaction ***** | ||
| TRANSACTION_TASK_ID | NUMBER | 18 | Identifier of the linked project (when applicable) for the failed transaction ***** | ||
| ERRORING_PROCESS | VARCHAR2 | 30 | Yes | Lookup code identifying the origin of error ***** | |
| TXN_NUM_ATTRIBUTE1 | NUMBER | 18 | Addtional information pertaining to the failed transaction or error. ***** | ||
| TXN_DATE_ATTRIBUTE1 | DATE | Addtional information pertaining to the failed transaction or error. ***** | |||
| TXN_CHAR_ATTRIBUTE1 | VARCHAR2 | 900 | Addtional information pertaining to the failed transaction or error. ***** | ||
| APPLICATION_CODE | VARCHAR2 | 4000 | Yes | Application Code of the error. ***** | |
| ERROR_CODE | VARCHAR2 | 30 | Yes | Message code of the error. ***** | |
| ERROR_TOKEN1 | VARCHAR2 | 30 | ERROR_TOKEN1 ***** | ||
| ERROR_TOKEN_VALUE1 | VARCHAR2 | 2000 | ERROR_TOKEN_VALUE1 ***** | ||
| ERROR_TOKEN2 | VARCHAR2 | 30 | ERROR_TOKEN2 ***** | ||
| ERROR_TOKEN_VALUE2 | VARCHAR2 | 2000 | ERROR_TOKEN_VALUE2 ***** | ||
| ERROR_TOKEN3 | VARCHAR2 | 30 | ERROR_TOKEN3 ***** | ||
| ERROR_TOKEN_VALUE3 | VARCHAR2 | 2000 | ERROR_TOKEN_VALUE3 ***** | ||
| ERROR_TOKEN4 | VARCHAR2 | 30 | ERROR_TOKEN4 ***** | ||
| ERROR_TOKEN_VALUE4 | VARCHAR2 | 2000 | ERROR_TOKEN_VALUE4 ***** | ||
| ERROR_TOKEN5 | VARCHAR2 | 30 | ERROR_TOKEN5 ***** | ||
| ERROR_TOKEN_VALUE5 | VARCHAR2 | 2000 | ERROR_TOKEN_VALUE5 ***** | ||
| CURRENCY_CODE | VARCHAR2 | 30 | CURRENCY_CODE ***** | ||
| UNREC_REV_AMOUNT | NUMBER | Unrecognized revenue amount due to this error ***** | |||
| UNINV_AMOUNT | NUMBER | Uninvoiced Amount due to this error. ***** | |||
| TXN_DATE | DATE | Transaction date of the source object when the exception occurred. This would be used while querying in "Exceptions" Overview page ***** | |||
| PA_DATE | DATE | Project Accounting Date of the transaction when the error occurred ***** | |||
| PA_PERIOD | VARCHAR2 | 30 | Project Accounting Period of the transaction when the error occurred ***** | ||
| ACCOUNTING_DATE | DATE | Accounting Date of the transaction when the error occurred ***** | |||
| ACCOUNTING_PERIOD | VARCHAR2 | 30 | Accounting period of the transaction when the error occurred ***** | ||
| ERRORED_DATE | DATE | Yes | Date on which the error occurred ***** | ||
| 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. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or 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. | ||
| CONTRACT_EVENT_ID | NUMBER | 18 | Unique identifier of the contract event, such as a milestone, to which the error is related. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJB_ERRORS | pjc_exp_items_all | EXPENDITURE_ITEM_ID |
| PJB_ERRORS | pjb_billing_events | EVENT_ID |
| PJB_ERRORS | pjb_bill_trxs | BILL_TRX_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJB_ERRORS_N1 | Non Unique | Default | BUSINESS_UNIT_ID, BILLING_TYPE_CODE, ERRORING_PROCESS, TRANSACTION_TYPE_CODE |
| PJB_ERRORS_N2 | Non Unique | Default | INVOICE_ID, ERRORING_PROCESS, TRANSACTION_TYPE_CODE |
| PJB_ERRORS_N3 | Non Unique | Default | INVOICE_LINE_ID, ERRORING_PROCESS, TRANSACTION_TYPE_CODE |
| PJB_ERRORS_N4 | Non Unique | Default | EXPENDITURE_ITEM_ID, ERRORING_PROCESS, TRANSACTION_TYPE_CODE |
| PJB_ERRORS_N5 | Non Unique | Default | EVENT_ID, ERRORING_PROCESS, TRANSACTION_TYPE_CODE |
| PJB_ERRORS_N6 | Non Unique | Default | CONTRACT_ID, ERRORING_PROCESS, TRANSACTION_TYPE_CODE, CONTRACT_EVENT_ID |
| PJB_ERRORS_N7 | Non Unique | Default | LINKED_PROJECT_ID, ERRORING_PROCESS, TRANSACTION_TYPE_CODE |
| PJB_ERRORS_U1 | Unique | Default | ERROR_ID |