XCC_CF_TRANSACTION_ERRORS
This table contains any errors encountered by the carry forward enterprise service scheduler process while final closing and reopening purchase orders. The Carry Forward Results Report uses this data to show the results of the carry forward enterprise service scheduler process. Data in this table is purged at a later time by the archive and purge process.
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
XCC_CF_TRANSACTION_ERRORS_PK |
CF_TRANSACTION_ERROR_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CF_TRANSACTION_ERROR_ID | NUMBER | 18 | Yes | Carry forward transaction error identifier. | |
| CF_TRANSACTION_ID | NUMBER | 18 | Yes | Carry forward transaction identifier. | |
| TEXT_LINE | VARCHAR2 | 1000 | Yes | Carry forward transaction error message. | |
| PO_LINE_ID | NUMBER | 18 | Purchase order document line unique identifier if the error is specific to a line. References PO_LINES_ALL.PO_LINE_ID. | ||
| PO_LINE_LOCATION_ID | NUMBER | 18 | Purchase order shipment schedule unique identifier if the error is specific to a schedule. References PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID. | ||
| PO_DISTRIBUTION_ID | NUMBER | 18 | Purchase order document distribution unique identifier if the error is specific to a distribution. References PO_DISTRIBUTIONS_ALL.DISTRIBUTION_ID. | ||
| SEQUENCE_NUMBER | NUMBER | Yes | Carry forward transaction action error sequence for display purpose. | ||
| 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_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to 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_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| XCC_CF_TRANSACTION_ERRORS_N1 | Non Unique | Default | CF_TRANSACTION_ID |
| XCC_CF_TRANSACTION_ERRORS_U1 | Unique | Default | CF_TRANSACTION_ERROR_ID |