Search Results ar_transmission_formats




Overview
Explore in AI Chat

Overview

The AR_TRANSMISSION_FORMATS table is a core reference table within the Oracle E-Business Suite Receivables (AR) module, specifically for the Lockbox processing feature. It serves as the master repository for defining the structural formats of electronic payment files (transmissions) received from banking institutions. Each record in this table represents a unique, predefined format specification that instructs the AutoLockbox program on how to parse an incoming data file, ensuring remittance details are correctly extracted and applied to customer accounts. Its role is critical for the automated cash application process, acting as the blueprint that links a physical bank file to the logical processing rules within the system.

Key Information Stored

The table's primary purpose is to store format definitions, which are identified by a system-generated surrogate key and a unique name. The most critical columns include TRANSMISSION_FORMAT_ID, the primary key, and FORMAT_NAME, a user-defined unique identifier for the transmission format (e.g., 'BANK_OF_AMERICA_STD'). While the provided metadata does not list all columns, typical attributes stored would define high-level file characteristics such as the record delimiter type (e.g., fixed-length vs. variable), character set, and other format-level control parameters. The table does not store the detailed parsing rules itself; instead, it acts as a header, with the specific field and record layouts defined in related child tables.

Common Use Cases and Queries

The primary use case is the setup and maintenance of Lockbox formats during implementation and when onboarding new banks. System administrators query this table to review existing formats or verify names before creating a new one. Common reporting needs include listing all configured formats and identifying which formats are actively assigned to transmission requests. Sample queries include fetching a list of all formats or checking for a specific format's existence before submission in a concurrent request.

  • Listing all transmission formats: SELECT transmission_format_id, format_name FROM ar_transmission_formats ORDER BY format_name;
  • Verifying a format for a Lockbox submission: SELECT transmission_format_id FROM ar_transmission_formats WHERE format_name = '&FORMAT_NAME';

Related Objects

As indicated by the foreign key relationships, AR_TRANSMISSION_FORMATS is a parent table with several key dependencies. The AR_TRANS_FIELD_FORMATS and AR_TRANS_RECORD_FORMATS tables store the detailed, format-specific parsing rules (e.g., start/end positions, data types for each field) and are child tables linked via TRANSMISSION_FORMAT_ID. The AR_TRANSMISSIONS_ALL table references this table via REQUESTED_TRANS_FORMAT_ID, logging which format was used for each specific Lockbox transmission processed by the system. This structure ensures that a single format definition can be reused across multiple bank files and is linked to the actual processing history.