Results for “ar_trans_record_formats_u1”

12 results




Overview
Explore in AI Chat

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

Overview

AR_TRANS_RECORD_FORMATS is a Receivables (AR) module table that stores the format definition of an individual record within a Lockbox transmission format. In the Oracle E-Business Suite lockbox architecture, a transmission format defines the overall structure of the flat file delivered by a bank, while each record type within that file (for example a header, detail, overflow, or trailer record) requires its own structural definition. AR_TRANS_RECORD_FORMATS holds precisely that record-level definition, acting as the intermediate layer between the transmission format header and the individual field-level format definitions. It is populated and maintained through the Lockbox transmission format setup, which is configured in Oracle Receivables and read at runtime by the Automatic Lockbox program when parsing incoming bank files.

From a Data Vault modeling perspective, the metadata relationship structure classifies this table as satellite-leaning. The foreign key from TRANSMISSION_FORMAT_ID to AR_TRANSMISSION_FORMATS places each record format in the context of its parent transmission format, while the foreign key received from AR_TRANS_FIELD_FORMATS establishes a hierarchical, dependent chain of descriptive attributes. This suggests the table behaves as a dependent descriptive satellite at the record level, subordinate to the transmission format hub.

Key Information Stored

The table contains 27 documented columns in the 12.2.2 release. The most significant columns are described below.

  • RECORD_FORMAT_ID — The surrogate primary key, enforced by AR_TRANS_RECORD_FORMATS_PK, uniquely identifying each record format row.
  • TRANSMISSION_FORMAT_ID — The foreign key to AR_TRANSMISSION_FORMATS, linking the record format to its parent transmission format.
  • RECORD_IDENTIFIER — The identifier that distinguishes this record type within the transmission file. It participates in the alternate unique key AR_TRANS_RECORD_FORMATS_UK1 together with TRANSMISSION_FORMAT_ID.
  • RECORD_TYPE_LOOKUP_CODE — The lookup code classifying the record type (such as header, detail, or trailer). It forms the second alternate unique key AR_TRANS_RECORD_FORMATS_UK2 together with TRANSMISSION_FORMAT_ID.
  • DESCRIPTION — A descriptive text for the record format, used in the setup user interface.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — The standard Oracle flexfield descriptive columns, providing extensible, context-sensitive attribute storage for the row.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns capturing who created and last modified the record.
  • ZD_EDITION_NAME — The editioning column supporting the EBS online patching (edition-based redefinition) architecture used in release 12.2. The business-key unique index AR_TRANS_RECORD_FORMATS_U1 is defined on RECORD_FORMAT_ID and ZD_EDITION_NAME.

Common Use Cases and Queries

This table is principally used when reviewing, troubleshooting, or migrating a bank's Lockbox transmission format configuration. A typical query retrieves all record formats belonging to a given transmission format:

  • SELECT r.RECORD_FORMAT_ID, r.RECORD_IDENTIFIER, r.RECORD_TYPE_LOOKUP_CODE, r.DESCRIPTION FROM AR_TRANS_RECORD_FORMATS r WHERE r.TRANSMISSION_FORMAT_ID = :p_transmission_format_id ORDER BY r.RECORD_IDENTIFIER;
  • To trace the complete field layout of a record format, join to the field-level table on RECORD_FORMAT_ID to retrieve the ordered fields that make up each record.
  • For auditing or upgrade comparison, query uses the audit columns and ZD_EDITION_NAME to distinguish the currently active edition of each row.

Reporting use cases include documenting bank file structures, validating that each transmission format contains the expected record types, and supporting data migration or configuration transport between environments.

Related Objects

The following objects are the most significant in relation to AR_TRANS_RECORD_FORMATS, based on the documented foreign key structure.

  • AR_TRANSMISSION_FORMATS — The parent table referencing this table. Joined on AR_TRANS_RECORD_FORMATS.TRANSMISSION_FORMAT_ID = AR_TRANSMISSION_FORMATS.TRANSMISSION_FORMAT_ID.
  • AR_TRANS_FIELD_FORMATS — The child table whose RECORD_FORMAT_ID column references AR_TRANS_RECORD_FORMATS, defining the individual fields within each record.
  • AR_TRANS_RECORD_FORMATS_PK, UK1, UK2, and U1 — The primary key and unique indexes enforcing uniqueness on RECORD_FORMAT_ID, TRANSMISSION_FORMAT_ID with RECORD_IDENTIFIER, TRANSMISSION_FORMAT_ID with RECORD_TYPE_LOOKUP_CODE, and RECORD_FORMAT_ID with ZD_EDITION_NAME respectively.
  • The Automatic Lockbox program and related bank file import processes within Receivables, which consume this configuration at runtime to parse incoming transmission files.