Search Results ax_trans_programs




Overview
Explore in AI Chat

Overview

AX_TRANS_PROGRAMS is a reference table within the AX schema, owned by the Global Accounting Engine (AX) product in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented description is "Translator programs information," and it serves as the control record that binds a translator (posting) program to a specific triad of Application, Main Set of Books, and Posting Set of Books. In practical terms, this table answers the question: "which posting program translates and posts accounting events for this source application into this target ledger?"

Under the heuristic Data Vault classification derived from its foreign-key structure, AX_TRANS_PROGRAMS is hub-leaning. It behaves as a central reference point whose composite key is referenced by dependent tables, rather than acting as a transactional link or an attribute-history satellite. This suggests that the table functions primarily as a stable registry of posting configurations, with event and setup tables hanging off it.

Key Information Stored

The table contains 18 documented columns. The most significant are:

The primary key, AX_TRANS_PROGRAMS_PK, is the composite of APPLICATION_ID, MAIN_SET_OF_BOOKS_ID, and POSTING_SET_OF_BOOKS_ID. A unique index, AX_TRANS_PROGRAMS_U1, covers the same three columns, confirming this triad as the business-key candidate that uniquely identifies each translator program row.

Common Use Cases and Queries

Functional and technical consultants query this table when diagnosing posting failures, validating translator configuration, or auditing which programs process a given ledger combination. A typical lookup resolves the program for a source-to-target ledger pair:

  • SELECT application_id, main_set_of_books_id, posting_set_of_books_id, program_application_id, program_id, frozen_flag FROM ax.ax_trans_programs WHERE application_id = :app AND posting_set_of_books_id = :sob;
  • Reporting frozen versus active translator configurations: SELECT rule_name, rule_version, frozen_flag, frozen_date FROM ax.ax_trans_programs WHERE frozen_flag = 'Y';
  • Auditing recent changes using LAST_UPDATE_DATE and LAST_UPDATED_BY to trace configuration drift.
  • Identifying orphaned or missing translator rows by comparing expected ledger combinations against actual entries.

Related Objects

Two foreign-key relationships are documented, both referencing this table through dependent columns:

  • AX_EVENT_TYPES — joins on APPLICATION_ID, SET_OF_BOOKS_ID, and POSTING_SET_OF_BOOKS_ID, linking each event type to its translator program.
  • AX_SETUP_POSTING_BOOKS — joins on APPLICATION_ID, MAIN_SET_OF_BOOKS_ID, and POSTING_SET_OF_BOOKS_ID, tying posting-book setup to the translator configuration.
  • AX_TRANS_PROGRAMS_PK / AX_TRANS_PROGRAMS_U1 — the primary key and unique index that enforce the business key and support joins from both dependent tables.

These relationships make AX_TRANS_PROGRAMS the anchor for the AX setup chain, and joins from AX_EVENT_TYPES or AX_SETUP_POSTING_BOOKS should always include the full three-column key to preserve accuracy in EBS 12.1.1 and 12.2.2 environments.