Search Results customer_bank_check_digits

Overview

The view JE_ES_REMITTED_RECEIPTS_V is a reporting object within the JE – European Localizations product family of Oracle E-Business Suite, and is specifically associated with the Spanish localization (JE_ES). It consolidates receipt information for remitted and remittable customer receipts processed through Oracle Receivables, joining cash receipt data to customer, bank, receipt method, payment schedule, and batch information. The view is designed to support the Spanish remittance reporting requirements, where receipts must be presented with both the customer's own bank details and the remitting bank's details so that the remittance documentation (such as the carta de remesa or associated bank files) reflects the correct routing and account information.

In Oracle EBS 12.1.1 and 12.2.2, this object is delivered as part of the Spanish localizations and is exposed through the standard view layer rather than through a physical table. Its role is primarily reporting and integration: it feeds remittance listings, bank remittance files, and supplementary reports required by Spanish financial practice. Because it is a view, no data is stored in it directly; all content is derived at query time from its base tables.

Underlying Base Objects

The ETRM metadata for JE_ES_REMITTED_RECEIPTS_V documents no dedicated owner and no separately registered base objects, and the implementation/DBA section states that the view is not implemented in the reference database. However, the documented view text defines its structure explicitly. It is built over a join of the following Receivables and Payables tables:

• AR_CASH_RECEIPTS (CR) – the driving receipt records.
• AR_BATCHES (B) – remittance batch information.
• AR_LOOKUPS (LK) – decoding the remittance method meaning.
• RA_CUSTOMERS (C) – customer name and number.
• AR_RECEIPT_METHODS (RM) – payment method description and printed name.
• AP_BANK_ACCOUNTS (CBA) – the customer's bank account (pay-from account).
• AP_BANK_BRANCHES (CBAB) – the customer's bank branch.
• AP_BANK_ACCOUNTS (RBA) – the remitting bank account.
• AP_BANK_BRANCHES (RBAB) – the remitting bank branch.
• AR_PAYMENT_SCHEDULES (PS) – due date for maturity reporting.

The use of AP_BANK_BRANCHES for both the customer and remitting bank sides explains why users searching on "ap_bank_branches" encounter this view: it is a principal consumer of that table within the Spanish remittance reporting flow. The join conditions confirm outer joins on the customer, bank, and payment schedule relationships, ensuring receipts without complete bank data are still returned.

Key Columns

The columns exposed by the view fall into distinct groupings that support remittance reporting:

• Receipt identifiers and amounts: RECEIPT_NUMBER, RECEIPT_CURRENCY, RECEIPT_AMOUNT, RECEIPT_DATE, RECEIPT_EXCHANGE_RATE, MATURITY_DATE (derived from the payment schedule due date, defaulting to the deposit date).
• Customer information: CUSTOMER_NAME, CUSTOMER_NUMBER.
• Customer bank details: CUSTOMER_BANK_NAME, CUSTOMER_BANK_BRANCH_NAME, CUSTOMER_BANK_BRANCH_NUM, CUSTOMER_BANK_BRANCH_NUMBER, CUSTOMER_BANK_ACCOUNT_NAME, CUSTOMER_BANK_ACCOUNT_NUMBER, CUSTOMER_BANK_CHECK_DIGITS.
• Remitting bank details: REMIT_BANK_NAME, REMIT_BANK_ACCOUNT_ID, REMIT_BANK_BRANCH_NAME, REMIT_BANK_BRANCH_NUM, REMIT_BANK_BRANCH_NUMBER, REMIT_BANK_ACCOUNT_NAME, REMIT_BANK_ACCOUNT_N.
• Payment method and batch: PAYMENT_METHOD, batch fields (B.NAME, B.BATCH_DATE, B.BATCH_ID) and the lookup MEANING for the remittance method code.

Common Use Cases and Queries

Typical usage includes generating Spanish remittance reports and bank files, reconciling remitted receipts, and analyzing receipts by bank branch. A representative query lists remitted receipts for a batch:

• SELECT receipt_number, customer_name, remit_bank_branch_num, remit_bank_account_number, receipt_amount, receipt_currency FROM je_es_remitted_receipts_v WHERE batch_id = :batch_id;
• SELECT receipt_number, customer_bank_branch_num, remit_bank_branch_num, maturity_date FROM je_es_remitted_receipts_v WHERE receipt_date BETWEEN :from_date AND :to_date;

Because the view joins AR_CASH_RECEIPTS to AP_BANK_BRANCHES, it is frequently used when troubleshooting missing or incorrect Spanish remittance output, particularly where bank branch numbering (bank_num, bank_number) is incomplete.