Results for “ax_trans_programs_v”

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

Overview

The view AX_TRANS_PROGRAMS_V belongs to the Global Accounting Engine (AX) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents configuration data for transaction programs that drive the creation and posting of accounting entries under the Global Accounting Engine architecture. Each row in the view represents a transformation or posting program definition, linking an application, a main set of books, and a corresponding posting set of books.

The view is a reporting and inquiry construct rather than a transactional table. It denormalizes the numeric identifiers stored in the base configuration table AX_TRANS_PROGRAMS by joining to GL_SETS_OF_BOOKS and FND_APPLICATION_VL. This allows report writers, integration developers, and support analysts to read human-readable application names and set of books names without writing multiple joins against the underlying tables. In the ETRM metadata, the view is documented as "Not implemented in this database," which is common for AX Global Accounting Engine views that exist only in environments where the AX module has been installed and configured.

Underlying Base Objects

Although the ETRM metadata lists no referenced base objects explicitly, the view text identifies the exact objects involved:

• AX_TRANS_PROGRAMS P — the primary configuration table holding transaction program definitions, including the frozen flag, rule name, and frozen date attributes.
• GL_SETS_OF_BOOKS S1 — joined on P.MAIN_SET_OF_BOOKS_ID = S1.SET_OF_BOOKS_ID, supplying the main set of books name.
• GL_SETS_OF_BOOKS S2 — joined on P.POSTING_SET_OF_BOOKS_ID = S2.SET_OF_BOOKS_ID, supplying the posting set of books name.
• FND_APPLICATION_VL A — joined on P.APPLICATION_ID = A.APPLICATION_ID, supplying the translated application name.

The view therefore surfaces one row for every valid combination of transaction program, application, and set of books pairing present in AX_TRANS_PROGRAMS.

Key Columns

• ROW_ID — the rowid of the base AX_TRANS_PROGRAMS record, useful for direct updates.
• APPLICATION_ID / APPLICATION_NAME — the owning application identifier and its descriptive name from FND_APPLICATION_VL.
• MAIN_SET_OF_BOOKS_ID / MAIN_SET_OF_BOOKS — the primary set of books against which the transaction program is defined.
• POSTING_SET_OF_BOOKS_ID / POSTING_SET_OF_BOOKS — the target set of books to which entries are posted.
• FROZEN_FLAG — indicates whether the transaction program configuration is frozen, preventing modification.
• RULE_NAME — the accounting rule or template applied by the program.
• FROZEN_DATE — the date on which the program was frozen, which is the attribute most commonly queried when users search for frozen_date.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

A frequent requirement is to identify which transaction programs have been frozen and when. The following query returns program configurations along with their freeze status:

SELECT application_name,
       main_set_of_books,
       posting_set_of_books,
       rule_name,
       frozen_flag,
       frozen_date
FROM   ax_trans_programs_v
WHERE  frozen_flag = 'Y'
ORDER BY frozen_date DESC;

Analysts also reconcile the main and posting set of books for each application to validate global accounting setups. The view's denormalized names make such reconciliation straightforward without additional lookups.