CML_CP_ERROR_DTLS
The purpose of this table is to store the trade operation, trade operation charges or trade operation material PO schedules, invoice id, invoice line number that are affected by the errors logged during an allocation process/association process run. All processors that are a part of the allocation process/association process create the data in this table.
Details
-
Schema: FUSION
-
Object owner: CML
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CML_CP_ERROR_DTLS_PK |
CP_ERROR_ID, TRADE_OPERATION_ID, TRADE_OPERATION_CHARGE_ID, TROP_CHARGE_PO_SCHEDULE_ID, INVOICE_ID, INVOICE_LINE_NUMBER, TROP_CHARGE_TO_SHIP_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CP_ERROR_ID | NUMBER | 18 | Yes | Identifies the unique allocation/association process error in the CML_CP_ERRORS table. | |
| TRADE_OPERATION_ID | NUMBER | 18 | Yes | Identifies the trade operation for which this error occurred. | |
| TRADE_OPERATION_CHARGE_ID | NUMBER | 18 | Yes | Identifies the trade operation charge line for which this error occurred. | |
| TROP_CHARGE_PO_SCHEDULE_ID | NUMBER | 18 | Yes | Identifies the trade operation PO schedule for which this error occurred. | |
| INVOICE_ID | NUMBER | 18 | Yes | Indicates the Invoice Id for which the error occurred. | |
| INVOICE_LINE_NUMBER | NUMBER | 18 | Yes | Indicates the Invoice Line Number for 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. | ||
| TROP_CHARGE_TO_SHIP_LINE_ID | NUMBER | 18 | Yes | Identifies the transfer order shipment line for which this error occurred. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CML_CP_ERROR_DTLS_U2 | Unique | Default | CP_ERROR_ID, TRADE_OPERATION_ID, TRADE_OPERATION_CHARGE_ID, TROP_CHARGE_PO_SCHEDULE_ID, INVOICE_ID, INVOICE_LINE_NUMBER, TROP_CHARGE_TO_SHIP_LINE_ID |