Results for “remittance_bank_name”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKL_EXT_CSH_RCPTS_V is a VALID Oracle E-Business Suite view owned by the APPS schema and belonging to the OKL (Leasing and Finance Management) product family. It exposes external cash receipts that have been received from a customer and are destined for the Receivables lockbox interface. In practice, the view serves as a staging read model over the OKL external cash receipt entities, allowing receipts captured or imported within Oracle Leasing and Finance Management to be inspected, validated, and subsequently pushed into Oracle Receivables. Because it flattens the header and translation information into a single relational projection, it is well suited for reporting, diagnostic queries, and integration extracts that must present customer remittance data in a format compatible with the Receivables lockbox processing conventions.

Underlying Base Objects

The view is defined over two documented base objects, both exposed to APPS as synonyms:

• OKL_EXT_CSH_RCPTS_B (SYNONYM) — the base table that stores the receipt-level attributes of each external cash receipt, including remittance amount, receipt date and method, customer and bank information, exchange rate details, descriptive flexfield attributes, and standard WHO/audit columns.
• OKL_EXT_CSH_RCPTS_TL (SYNONYM) — the translation table, which supplies language-dependent descriptive content such as COMMENTS.

The view joins these two objects, with the _B table supplying the bulk of the columns and the _TL table contributing the translation-dependent comment text and the SFWT_FLAG. Because both bases are referenced through synonyms in APPS, the view remains independent of the physical table owner and is available to any APPS-connected session with the appropriate privileges.

Key Columns

The view projects a broad set of columns that mirror the Receivables lockbox interface requirements. The most significant include:

• ID, XCB_ID, RCT_ID, ICR_ID — identifiers linking the external cash receipt row to its parent batch, receipt, and interface records.
• CUSTOMER_NUMBER and BILL_TO_LOCATION — the customer account and specific bill-to location against which the receipt is applied; BILL_TO_LOCATION is the column most commonly searched by users resolving customer remittance routing.
• REMITTANCE_AMOUNT, CURRENCY_CODE, RECEIPT_DATE, RECEIPT_METHOD, CHECK_NUMBER — the core remittance values used to construct the Receivables receipt.
• EXCHANGE_RATE_TYPE, EXCHANGE_RATE, EXCHANGE_RATE_DATE, GL_DATE — foreign-currency conversion and accounting date information.
• TRANSIT_ROUTING_NUMBER, ACCOUNT, CUSTOMER_BANK_NAME, CUSTOMER_BANK_BRANCH_NAME, REMITTANCE_BANK_NAME, REMITTANCE_BANK_BRANCH_NAME — banking details supporting lockbox and remittance processing.
• RECEIPT_TYPE, FULLY_APPLIED_FLAG, EXPIRED_FLAG — status and classification flags governing downstream application.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the descriptive flexfield columns available for client-specific extensions.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, ORG_ID — concurrent program and multi-organization context.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER — standard audit and optimistic-locking columns.

Common Use Cases and Queries

Typical scenarios include reconciling external receipts before lockbox submission, investigating remittance failures, and building extracts for Receivables. The BILL_TO_LOCATION column is frequently used to trace a remittance to a specific customer site.

• Listing pending receipts by bill-to location:

  SELECT id, customer_number, bill_to_location,
         remittance_amount, currency_code, receipt_date
  FROM   apps.okl_ext_csh_rcpts_v
  WHERE  bill_to_location = :p_location
  ORDER  BY receipt_date DESC;

• Identifying unapplied or expired receipts:

  SELECT id, customer_number, remittance_amount,
         fully_applied_flag, expired_flag
  FROM   apps.okl_ext_csh_rcpts_v
  WHERE  NVL(fully_applied_flag,'N') = 'N'
     OR  NVL(expired_flag,'N') = 'Y';

• Reviewing foreign-currency remittances:

  SELECT id, currency_code, exchange_rate_type,
         exchange_rate, exchange_rate_date, gl_date
  FROM   apps.okl_ext_csh_rcpts_v
  WHERE  currency_code <> functional_currency;

Each query should restrict on ORG_ID where multi-organization security applies, and access requires the OKL responsibility or equivalent APPS privileges.