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. |