Search Results gl_acct_ttl




Overview
Explore in AI Chat

Overview

The GL_ACCT_TTL table is a core reference table within the Process Manufacturing Financials (GMF) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the master repository for system-defined account titles, which are fundamental classifications used in the financial setup and transaction processing of Oracle Process Manufacturing (OPM). As explicitly stated in the documentation, these titles are predefined by the system, and users are prohibited from modifying them within the OPM application interface. This enforcement ensures data integrity and consistency across the complex financial hierarchies and mappings used in manufacturing accounting.

Key Information Stored

The primary data stored in this table is the account title type code and its associated descriptive information. While the full column list is not detailed in the provided metadata, the structure is defined by its primary and foreign key relationships. The central column is ACCT_TTL_TYPE, which serves as the unique identifier (primary key) for each system-defined account title. This code is referenced extensively by other GMF and related tables. Typical columns in such a reference table would also include a description or name field (e.g., ACCT_TTL_DESC) to provide the human-readable meaning of the code, and potentially columns for creation date and user. The table's primary key constraint is named GL_ACCT_TTL_PK.

Common Use Cases and Queries

This table is primarily used for validation, reporting, and as a lookup source. Common scenarios include validating account titles during the setup of financial hierarchies (GL_ACCT_HRC) or account mappings (GL_ACCT_MAP), and generating reference reports for audit or configuration review. A typical query would join GL_ACCT_TTL to its related transactional or setup tables to retrieve the descriptive title for a code. For example, to list all account titles used in the account hierarchy setup:

  • SELECT hrc.*, ttl.acct_ttl_desc FROM gmf.gl_acct_hrc hrc, gmf.gl_acct_ttl ttl WHERE hrc.acct_ttl_type = ttl.acct_ttl_type;

Direct manipulation of data in this table via SQL is strongly discouraged, as it houses system-controlled reference data critical for application functionality.

Related Objects

The GL_ACCT_TTL table is a pivotal reference point for several key tables in the GMF and Purchasing (PO) modules, as indicated by its foreign key relationships. Key dependent objects include:

  • GL_ACCT_HRC: References account titles in defining the account hierarchy.
  • GL_ACCT_MAP: Uses account titles in financial mapping rules.
  • GL_SEVT_TTL & GL_SUBR_LED: Associated with subledger accounting and setup.
  • GL_SETU_ERR: References account titles in setup error records.
  • PO_DIST_DTL: Demonstrates integration with the Purchasing module, where purchase order distributions can be associated with specific GMF account titles.