CML_CP_ERRORS
This table holds all the errors for the cost process and is viewed through the review errors UI. The errors are aggregated by appropriate values, such as currency code, UOM or item(which are stored as tokens), depending on the info required by the user.
Details
-
Schema: FUSION
-
Object owner: CML
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CML_CP_ERRORS_PK |
CP_ERROR_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CP_ERROR_ID | NUMBER | 18 | Yes | Unique key identifying a allocation process error. | |
| RUN_CONTROL | VARCHAR2 | 30 | Yes | Identifies the Run Control used allocation run. . In case of online calls it will be hardcoded to ONLINE. User may not be able to define run control with the name ONLINE. | |
| REQUEST_RUN_ID | NUMBER | 18 | Yes | Stores either the request id or the run id depending whether the process is submitted in batch or online mode. | |
| PROCESSOR_NAME | VARCHAR2 | 30 | Yes | Identifies the processor that created the message. | |
| ERROR_MESSAGE_NAME | VARCHAR2 | 30 | Yes | Identifies the event that occurred. This value maps to the MESSAGE_NAME column of the FND_MESSAGES table. | |
| MESSAGE_TYPE | VARCHAR2 | 30 | Yes | FND message type for this message. | |
| MESSAGE_TEXT | VARCHAR2 | 240 | Message text associated with the error code. | ||
| PRC_BU_ID | NUMBER | 18 | Identifies the Procurement BU for which this error was reported. | ||
| TABLE_NAME | VARCHAR2 | 30 | Identifies the source table from which the error or event was generated. | ||
| SUBPROCESSOR_NAME | VARCHAR2 | 900 | Subprocessor Name. This value is the direct name and not a look up. Used internally and not displayed on a UI. | ||
| ROW_COUNT | NUMBER | 18 | Yes | Row count, stores the total number of rows that failed with this error. | |
| TOKEN1_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN1_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| TOKEN2_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN2_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| TOKEN3_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN3_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| TOKEN4_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN4_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| TOKEN5_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN5_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| TOKEN6_NAME | VARCHAR2 | 30 | Token name as required by error code message. | ||
| TOKEN6_VALUE | VARCHAR2 | 240 | Token value as required by error code message. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CML_CP_ERRORS_PK | Unique | Default | CP_ERROR_ID |