AR_CC_ERROR_HISTORY
Whenever a transaction has a credit card error that has been marked for automatic correction, the AR_CC_ERROR_HISTORY table stores the details of the transaction, its error code, and its corrective action.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AR_CC_ERROR_HISTORY_PK |
REQUEST_ID, CC_TRX_CATEGORY, CC_TRX_ID, CC_ERROR_CODE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REQUEST_ID | NUMBER | 18 | Yes | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |
| CC_TRX_CATEGORY | VARCHAR2 | 15 | Yes | Transaction category for credit card errors. Based on lookup CC_TRX_CATEGORY. | |
| CC_TRX_ID | NUMBER | 18 | Yes | Identifier for transactions with credit card errors | |
| CC_ERROR_CODE | VARCHAR2 | 80 | Yes | Error code from credit card payment processor | |
| CC_ERROR_DATE | DATE | Credit card error date | |||
| CC_VENDOR_ERROR_DESC | VARCHAR2 | 255 | Payment processor description of credit card error | ||
| CC_ERROR_TEXT | VARCHAR2 | 255 | User-enterable description for credit card error code | ||
| CC_ACTION_CODE | VARCHAR2 | 30 | Corrective action to be performed on transactions with errors. Based on lookup AR_CC_ACTION_CODES. | ||
| CC_ACTION_TYPE_FLAG | VARCHAR2 | 1 | S indicates if a subsequent action can be performed for a credit card error after N number of days. Otherwise, set to A. | ||
| PAYMENT_SERVER_ORDER_NUM | VARCHAR2 | 80 | Identifies credit card payment authorized by Oracle Payment Server | ||
| CUSTOMER_BANK_ACCOUNT_ID | NUMBER | 18 | Customer credit card account identifier. | ||
| FIRST_RECORD_FLAG | VARCHAR2 | 1 | Y indicates transactions that have credit card errors for the first time | ||
| CURRENT_RECORD_FLAG | VARCHAR2 | 1 | Y indicates current attempt at correction of credit card error. Used to identify if number of days for subsequent action (or manual correction) have passed. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| 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_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| PAYMENT_TRXN_EXTENSION_ID | NUMBER | Payment transaction extension identifier for credit card or bank account payment processing. Identifier of the transaction created in Fusion Oracle Payments for processing the credit card or bank account payment. | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| AR_CC_ERROR_HISTORY_N1 | Non Unique | CC_TRX_ID, CC_TRX_CATEGORY |