REMITTANCE_BANK_ACCOUNT_ID column is not populating in AR_CASH_RECEIPTS_ALL table

The AR_CASH_RECEIPTS_ALL table stores one record for each receipt that you enter. Oracle Receivables concurrently creates records in the AR_CASH_RECEIPT_HISTORY_ALL, AR_PAYMENT_SCHEDULES_ALL, and AR_RECEIVABLE_APPLICATIONS_ALL tables for Invoice-related Receipts.

For receipts that are not related to Iinvoices, such as Miscellaneous Receipts, Receivables creates records in the AR_MISC_CASH_DISTRIBUTIONS_ALL table instead of the AR_RECEIVABLE_APPLICATIONS_ALL table.

Receivables associates a status with each Receipt. These statuses include:

• APP for applied
• UNAPP for unapplied
• UNID for unidentified
• NSF for nonsufficient funds
• REV for reversed receipt and 
• STOP for stop payment. 

Receivables does not update the status of a receipt from UNAPP to APP until the entire amount of the receipt is either applied or placed on account. A receipt can have a status of APP even if the entire receipt amount is placed on account. Cash receipts proceed through the confirmation, remittance, and clearance steps. Each step creates rows in the AR_CASH_RECEIPT_HISTORY table.

The CODE_COMBINATION_ID column in this table stores the general ledger accounts that are debited and credited as part of the cycle of steps.

The RECEIVABLES_TRX_ID column links the AR_CASH_RECEIPTS_ALL table to AR_RECEIVABLES_TRX_ALL table and identifies receivables activity associated with miscellaneous receipts. T

he DISTRIBUTION_SET_ID column links AR_CASH_RECEIPTS_ALL table to AR_DISTRIBUTION_SETS_ALL table and identifies distribution set and distribution set line accounts that are credited for miscellaneous receipts.

The CUSTOMER_BANK_ACCOUNT_ID column is a foreign key to the IBY_EXT_BANK_ACCOUNTS table for bank accounts that do not belong to you and have a type of EXTERNAL.


When creating Receipts from Application through Receipts Form or importing through API REMITTANCE_BANK_ACCOUNT_ID column in R12 is blank. This is intended functionality from Oracle. 

REMITTANCE_BANK_ACCOUNT_ID in AR_CASH_RECEIPTS_ALL is Not used in R12.
This field has been replaced by REMIT_BANK_ACCT_USE_ID in AR_CASH_RECEIPTS_ALL.