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.
  • Table: GL_ACCT_TTL 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCT_TTL,  object_name:GL_ACCT_TTL,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: This table contains the system defined Account Titles. User is not allowed to change them in OPM. ,  implementation_dba_data: GMF.GL_ACCT_TTL , 

  • Table: GL_ACCT_TTL 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCT_TTL,  object_name:GL_ACCT_TTL,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: This table contains the system defined Account Titles. User is not allowed to change them in OPM. ,  implementation_dba_data: GMF.GL_ACCT_TTL , 

  • Table: GL_SETU_ERR 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_SETU_ERR,  object_name:GL_SETU_ERR,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: GL mapping setup errors found during Subsidiary Ledger Update process. Not currently used. ,  implementation_dba_data: GMF.GL_SETU_ERR , 

  • Table: GL_SETU_ERR 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_SETU_ERR,  object_name:GL_SETU_ERR,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: GL mapping setup errors found during Subsidiary Ledger Update process. Not currently used. ,  implementation_dba_data: GMF.GL_SETU_ERR , 

  • Table: GL_SEVT_TTL 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_SEVT_TTL,  object_name:GL_SEVT_TTL,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: GL mapping subevent account titles. Account titles that are impacted by a subsystem subevent. ,  implementation_dba_data: GMF.GL_SEVT_TTL , 

  • Table: GL_SEVT_TTL 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_SEVT_TTL,  object_name:GL_SEVT_TTL,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: GL mapping subevent account titles. Account titles that are impacted by a subsystem subevent. ,  implementation_dba_data: GMF.GL_SEVT_TTL , 

  • Table: GL_SUBR_LED 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_SUBR_LED,  object_name:GL_SUBR_LED,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: GL subsidiary ledger. Liaison between subsystems and GL. Stores all the bookings of OPM subsystem transactions (documents). Updated by the OPM Subsidiary Ledger Update process. ,  implementation_dba_data: GMF.GL_SUBR_LED , 

  • Table: GL_SUBR_LED 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_SUBR_LED,  object_name:GL_SUBR_LED,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: GL subsidiary ledger. Liaison between subsystems and GL. Stores all the bookings of OPM subsystem transactions (documents). Updated by the OPM Subsidiary Ledger Update process. ,  implementation_dba_data: GMF.GL_SUBR_LED , 

  • Table: GL_ACCT_HRC 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCT_HRC,  object_name:GL_ACCT_HRC,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: This table contains the account selection priority for the companies and the account titles. These priorities are used by the GL Mapping program to retrieve the accounts for sub-ledger posting, in the order of account selection priority. In ,  implementation_dba_data: GMF.GL_ACCT_HRC , 

  • Table: GL_ACCT_HRC 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCT_HRC,  object_name:GL_ACCT_HRC,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: This table contains the account selection priority for the companies and the account titles. These priorities are used by the GL Mapping program to retrieve the accounts for sub-ledger posting, in the order of account selection priority. In ,  implementation_dba_data: GMF.GL_ACCT_HRC , 

  • Table: GL_ACCT_MAP 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCT_MAP,  object_name:GL_ACCT_MAP,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: GL Account Mapping information - contains the GL Account Mapping info. The Account mappings are defined for a Company, Account Title and attributes whose priority is >0 in gl_acct_hrc table. Note that these attributes are optional and a NU ,  implementation_dba_data: GMF.GL_ACCT_MAP , 

  • Table: GL_ACCT_MAP 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCT_MAP,  object_name:GL_ACCT_MAP,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: GL Account Mapping information - contains the GL Account Mapping info. The Account mappings are defined for a Company, Account Title and attributes whose priority is >0 in gl_acct_hrc table. Note that these attributes are optional and a NU ,  implementation_dba_data: GMF.GL_ACCT_MAP ,