AR_CREATE_RECEIPTS_ERROR
This table contains errors resulting from unsuccessful attempts by the bulk receipts creation API.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BATCH_ID | NUMBER | 18 | Batch Identifier | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| CASH_RECEIPT_ID | NUMBER | 18 | Cash Receipt Identifier | ||
| RECEIPT_NUMBER | VARCHAR2 | 30 | Receipt number | ||
| RECEIPT_DATE | DATE | Receipt Date on which Receipt got created | |||
| CUSTOMER_TRX_ID | NUMBER | 18 | Customer Transaction Identifier | ||
| TRXN_NUMBER | VARCHAR2 | 30 | Transaction Number | ||
| PAYMENT_SCHEDULE_ID | NUMBER | 18 | Payment schedule identifier. | ||
| APPLIED_PAYMENT_SCHEDULE_ID | NUMBER | 18 | Applied payment schedule identifier. | ||
| PAYING_CUSTOMER_ID | NUMBER | 18 | Paying customer identifier. | ||
| PAYING_SITE_USE_ID | NUMBER | 18 | Paying customer site identifier. | ||
| EXCEPTION_CODE | VARCHAR2 | 30 | Exception code. | ||
| ADDITIONAL_MESSAGE | VARCHAR2 | 2000 | Stores error messages when multiple errors occur during bulk receipt creation using an application programming interface. | ||
| REMIT_BANK_ACCT_USE_ID | NUMBER | 18 | Remittance bank account use identifier. | ||
| 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. | ||
| PROGRAM_APPLICATION_ID | NUMBER | 18 | Who column: indicates application that last updated this row. Foreign key to FND_APPLICATION.APPLICATION_ID. | ||
| PROGRAM_ID | NUMBER | 18 | Who column: indicates program that last updated this row. Foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID. | ||
| PROGRAM_UPDATE_DATE | DATE | Who column: date on which a program last updated this row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. |