Search Results ax_trans_programs

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:

APPLICATION_ID — Identifies the source application whose transactions are translated. Part of the primary key and the foreign-key target for dependent tables.
MAIN_SET_OF_BOOKS_ID — The set of books from which accounting events originate.
POSTING_SET_OF_BOOKS_ID — The destination set of books into which translated entries are posted.
PROGRAM_APPLICATION_ID and PROGRAM_ID — Together identify the concurrent program (translator) responsible for carrying out the posting.
PROGRAM_UPDATE_DATE — Timestamp of the last change to the associated program definition.
FROZEN_FLAG and FROZEN_DATE — Indicate whether the translator configuration has been frozen and when, preventing further modification.
RULE_NAME, RULE_VERSION, RULE_SUB_VERSION, and RULE_REVISION — Capture the translation rule identity and versioning used by the program.
LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID — Standard Oracle WHO and concurrent-request audit columns.

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.

Table: AX_TRANS_PROGRAMS 12.1.1
owner:AX, object_type:TABLE, fnd_design_data:AX.AX_TRANS_PROGRAMS, object_name:AX_TRANS_PROGRAMS, status:VALID, product: AX - Global Accounting Engine , description: Translator programs information , implementation_dba_data: AX.AX_TRANS_PROGRAMS ,
Table: AX_TRANS_PROGRAMS 12.2.2
owner:AX, object_type:TABLE, fnd_design_data:AX.AX_TRANS_PROGRAMS, object_name:AX_TRANS_PROGRAMS, status:VALID, product: AX - Global Accounting Engine , description: Translator programs information , implementation_dba_data: AX.AX_TRANS_PROGRAMS ,
Table: AX_SETUP_POSTING_BOOKS 12.2.2
owner:AX, object_type:TABLE, fnd_design_data:AX.AX_SETUP_POSTING_BOOKS, object_name:AX_SETUP_POSTING_BOOKS, status:VALID, product: AX - Global Accounting Engine , description: Posting sets of books information per main set of books , implementation_dba_data: AX.AX_SETUP_POSTING_BOOKS ,
Table: AX_EVENT_TYPES 12.1.1
owner:AX, object_type:TABLE, fnd_design_data:AX.AX_EVENT_TYPES, object_name:AX_EVENT_TYPES, status:VALID, product: AX - Global Accounting Engine , description: Event types information , implementation_dba_data: AX.AX_EVENT_TYPES ,
Table: AX_EVENT_TYPES 12.2.2
owner:AX, object_type:TABLE, fnd_design_data:AX.AX_EVENT_TYPES, object_name:AX_EVENT_TYPES, status:VALID, product: AX - Global Accounting Engine , description: Event types information , implementation_dba_data: AX.AX_EVENT_TYPES ,
Table: AX_SETUP_POSTING_BOOKS 12.1.1
owner:AX, object_type:TABLE, fnd_design_data:AX.AX_SETUP_POSTING_BOOKS, object_name:AX_SETUP_POSTING_BOOKS, status:VALID, product: AX - Global Accounting Engine , description: Posting sets of books information per main set of books , implementation_dba_data: AX.AX_SETUP_POSTING_BOOKS ,
View: AX_TRANS_PROGRAMS_V 12.2.2
product: AX - Global Accounting Engine , implementation_dba_data: Not implemented in this database ,
View: AX_TRANS_PROGRAMS_V 12.1.1
product: AX - Global Accounting Engine , implementation_dba_data: Not implemented in this database ,