AR_CASH_PROCESSING_EXCEPTIONS
This table contains error information resulting from cash processing documents.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
ar_cash_processing_excepti_PK |
EXCEPTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EXCEPTION_ID | NUMBER | 18 | Yes | Unique identifier for the cash processing exception record. | |
| SOURCE_OBJECT_CODE | VARCHAR2 | 30 | Yes | Type of Cash Processing Document associated with the exception. | |
| SOURCE_ID | NUMBER | 18 | Yes | Identifier of the Cash Processing Document associated with the exception. | |
| SOURCE_DOC_CURRENCY_CODE | VARCHAR2 | 15 | Stores the currency code of the document in error. | ||
| SOURCE_DOC_AMOUNT | NUMBER | Stores the amount of the document in error, such as receipt amount or lockbox amount. | |||
| SOURCE_DOC_CUSTOMER_ID | NUMBER | 18 | Stores the customer account identifier of the document in error. | ||
| SOURCE_DOC_DATE | DATE | Stores the document date of the document in error, such as receipt date. | |||
| SOURCE_DOC_NUMBER | VARCHAR2 | 30 | Stores the document number of the document in error, such as receipt number or check number. | ||
| SECONDARY_SOURCE_ID | NUMBER | 18 | Stores the identifier of the secondary cash processing document associated with the exception. | ||
| SECONDARY_SOURCE_OBJECT_CODE | VARCHAR2 | 30 | Stores the type of the secondary cash processing document associated with the exception. | ||
| SOURCE_PROCESS_CODE | VARCHAR2 | 30 | Yes | Process that caused the exception. | |
| DOCUMENT_ID | NUMBER | Document IO file identifier. Foreign key to DocIO file record. | |||
| MESSAGE_NAME | VARCHAR2 | 30 | Yes | Exception details. Foreign key to FND_MESSAGES. | |
| MESSAGE_CONTEXT_1 | VARCHAR2 | 100 | Additional message context and parameters. | ||
| MESSAGE_CONTEXT_2 | VARCHAR2 | 100 | Additional message context and parameters. | ||
| MESSAGE_CONTEXT_3 | VARCHAR2 | 100 | Additional message context and parameters. | ||
| MESSAGE_CONTEXT_4 | VARCHAR2 | 100 | Additional message context and parameters. | ||
| MESSAGE_CONTEXT_5 | VARCHAR2 | 100 | Additional message context and parameters. | ||
| EXCEPTION_STATUS_CODE | VARCHAR2 | 30 | Yes | Current status of the exception: OPEN/RESOLVED. | |
| EXCEPTION_NOTES | VARCHAR2 | 500 | User-entered notes about the exception. | ||
| ADDITIONAL_INFORMATION | VARCHAR2 | 3000 | Additional information related to the exception. For example, space to store parameters of an errored API call. | ||
| EXCEPTION_TYPE_CODE | VARCHAR2 | 30 | Yes | Indicates type of exception to end user: ERROR/WARNING/INFO. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| 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_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. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER1 | NUMBER | 1 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER2 | NUMBER | 1 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER3 | NUMBER | 1 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER4 | NUMBER | 1 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER5 | NUMBER | 1 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| EXCEPTION_ATTRIBUTE | VARCHAR2 | 30 | Attribute exception indicating that receipt creation to failed. | ||
| SOURCE_ORG_ID | NUMBER | 18 | Identifier of the business unit associated with the source document row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AR_CASH_PROCESSING_EXCEPTIONS | fnd_currencies_b | SOURCE_DOC_CURRENCY_CODE |
| AR_CASH_PROCESSING_EXCEPTIONS | hz_cust_accounts | SOURCE_DOC_CUSTOMER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AR_CASH_PROCESS_EXCEPTIONS_N1 | Non Unique | AR_CASH_PROCESS_EXCEPTIONS_N1 | DOCUMENT_ID |
| AR_CASH_PROCESS_EXCEPTIONS_N2 | Non Unique | AR_CASH_PROCESS_EXCEPTIONS_N2 | EXCEPTION_STATUS_CODE, MESSAGE_NAME |
| AR_CASH_PROCESS_EXCEPTIONS_U1 | Unique | AR_CASH_PROCESS_EXCEPTIONS_U1 | EXCEPTION_ID |
| AR_CASH_PROCESS_EXCEPTIONS_U2 | Unique | AR_CASH_PROCESS_EXCEPTIONS_U2 | SOURCE_OBJECT_CODE, SOURCE_ID, MESSAGE_NAME |