Search Results ar_lockboxes_all




Overview
Explore in AI Chat

Overview

The AR_LOCKBOXES_ALL table is a core data repository within Oracle E-Business Suite Receivables (AR) that stores the master configuration details for all lockboxes. A lockbox is a service offered by banks to accelerate cash application by collecting customer payments directly and transmitting the remittance data electronically. This table defines the parameters used by the AutoLockbox program to process incoming transmission files. Its role is critical for automating the receipt creation and application process, ensuring that bank data is correctly interpreted and mapped to the appropriate customer transactions. As an "ALL" table, it is multi-organization enabled, storing records specific to each operating unit.

Key Information Stored

The table's structure is designed to define the relationship between a bank transmission and Oracle Receivables' internal processing rules. Its primary key is LOCKBOX_ID, a unique internal identifier. According to the provided metadata, a unique key constraint (AR_LOCKBOXES_UK1) also exists on the combination of LOCKBOX_NUMBER and BANK_ORIGINATION_NUMBER. The LOCKBOX_NUMBER is the identifier assigned by the bank, while the BANK_ORIGINATION_NUMBER is a routing code. Other essential foreign key columns include BATCH_SOURCE_ID, which links to AR_BATCH_SOURCES_ALL to determine the batch source for receipts created from this lockbox, and RECEIPT_METHOD_ID, which links to AR_RECEIPT_METHODS to define the receipt method. The table typically also contains columns for defining transmission formats, validation rules, and status controls.

Common Use Cases and Queries

This table is primarily referenced for setup validation, troubleshooting AutoLockbox executions, and generating operational reports. A common query involves joining to related setup tables to verify the configuration for a specific lockbox. For example:

  • Validation Query: To list all active lockboxes with their associated batch source and receipt method: SELECT lb.lockbox_number, lb.bank_origination_number, bs.name batch_source, rm.name receipt_method FROM ar_lockboxes_all lb, ar_batch_sources_all bs, ar_receipt_methods rm WHERE lb.batch_source_id = bs.batch_source_id AND lb.receipt_method_id = rm.receipt_method_id AND lb.org_id = :p_org_id;
  • Troubleshooting: Queries against AR_LOCKBOXES_ALL are often combined with AR_TRANSMISSIONS_ALL and AR_BATCHES_ALL to trace the processing lifecycle of a specific bank file, from transmission through to receipt batch creation.

Related Objects

As indicated by the foreign key metadata, AR_LOCKBOXES_ALL has integral relationships with several key Receivables tables. It is a parent table to AR_BATCHES_ALL (via LOCKBOX_ID) and AR_TRANSMISSIONS_ALL (via REQUESTED_LOCKBOX_ID), meaning a lockbox record is referenced by individual transmission and batch records. Conversely, it is a child table to AR_BATCH_SOURCES_ALL and AR_RECEIPT_METHODS, drawing its processing rules from these master setup entities. In practice, the AutoLockbox program (via various AR* APIs and the ARP_CTL_PKG package) heavily relies on the definitions in this table to govern its processing logic.