PX_CDPOOL_ERROR

This table is used to temporarily store errors during promotion code generation on Oracle. This table has the same columns as the PX_CDPOOL table with a few additional columns for Oracle's use. Note: This table only exists on the Oracle database.

Column Descriptions:

NameTypeDescription
ORA_ERR_NUMBER$BIGINTData type: NUMBER. Oracle error number.
ORA_ERR_MESG$VARCHAR (2000)Data type: VARCHAR2(2000). Oracle error message text.
ORA_ERR_ROWID$VARCHAR (18)Data type: ROWID. The RowID of the row causing the error.
ORA_ERR_OPTYP$VARCHAR (2)Type of operation: I: Insert U: Update D: Delete
ORA_ERR_TAG$VARCHAR (2000)Value of the tag in the error logging.
PX_CDPOOL_IDBIGINTData type: NUMBER
STORE_IDOTHERData type: NUMBER(38). Key to STORE
USAGETYPEOTHERData type: NUMBER(38) 0: Private, single use 1: Public, multi uses
CODEVARCHAR (128)Data type: VARCHAR2(128). The code string.
STATUSOTHERData type: NUMBER(38) 0: Inactive 1: Active 2: Mark for delete
TRANSFERABLEOTHERData type: NUMBER(38) 0: Transferring allowed 1: Transferring not allowed
VALIDFROMTIMESTAMPCurrently not in use
VALIDUNTILTIMESTAMPCurrently not in use
OPTCOUNTEROTHERThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
REFERENCE_IDBIGINTData type: NUMBER. The unique identifier of the promotion that has the code associated with it.
INTERNAL_IDBIGINTData type: NUMBER. For unique promotion codes, this column will always have a value of 0 to ensure that the same code is not used in another promotion in the store. For public promotion codes, this column will have a unique value to allow multiple promotions to share the same code.
WORKSPACEVARCHAR (25)This column will have the value 'IBM_WC_BASE' to indicate that the unique promotion codes are present in base schema. When the codes are generated from the context of a workspace, this column will hold the name of the workspace.
TASKGROUPVARCHAR (25)When the codes are generated from the context of a workspace, this column will hold the name of the taskgroup.