Search Results site




The AUTOGL_TABLES Lookup Type in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical component of the General Ledger (GL) module, specifically designed to support the AutoAccounting functionality. AutoAccounting is a feature that automates the process of deriving accounting flexfield combinations for transactions originating from subledgers, such as Payables, Receivables, and Assets, before they are transferred to the General Ledger. The AUTOGL_TABLES Lookup Type serves as a reference mechanism that identifies the database tables involved in this process, ensuring accurate and efficient mapping of accounting segments.

Purpose and Functionality

The primary purpose of the AUTOGL_TABLES Lookup Type is to define the tables that store data used by AutoAccounting to derive accounting flexfield combinations. These tables typically contain information such as inventory items, suppliers, customers, and asset categories, which are referenced during the AutoAccounting process. The Lookup Type acts as a registry, listing all tables that AutoAccounting can query to retrieve relevant data for segment derivation. This ensures consistency and reduces manual intervention in the accounting process.

Technical Implementation

In Oracle EBS, Lookup Types are defined in the FND_LOOKUP_TYPES table, while the corresponding Lookup Codes are stored in the FND_LOOKUP_VALUES table. The AUTOGL_TABLES Lookup Type contains entries for each table that AutoAccounting may reference. Each entry includes a Lookup Code (the table name) and a description (the purpose of the table). For example, the AP_SUPPLIERS table might be listed to map supplier-related transactions to the correct accounting segments.

Key Tables Referenced

Some of the commonly referenced tables in the AUTOGL_TABLES Lookup Type include:
  • AP_SUPPLIERS: Maps supplier-related transactions to accounting segments.
  • AR_CUSTOMERS: Used for deriving segments for customer-related transactions.
  • FA_CATEGORIES: Maps asset categories to accounting segments in Fixed Assets.
  • MTL_SYSTEM_ITEMS: References inventory items for segment derivation in Inventory modules.

Configuration and Customization

Administrators can customize the AUTOGL_TABLES Lookup Type to include additional tables if the organization has custom subledgers or extended functionality. This is done via the Oracle Application Developer responsibility, where new Lookup Codes can be added to the AUTOGL_TABLES Lookup Type. Proper testing is required to ensure that the new tables integrate seamlessly with AutoAccounting rules.

Integration with AutoAccounting Rules

The tables listed in AUTOGL_TABLES are referenced in AutoAccounting rules defined in the GL_AUTOACCOUNTING_RULES table. These rules specify how segments are derived based on data in the referenced tables. For instance, a rule might specify that the "Account" segment for an invoice line should be derived from the AP_INVOICE_DISTRIBUTIONS table.

Impact on Performance

The efficiency of AutoAccounting depends on the proper configuration of the AUTOGL_TABLES Lookup Type. Overloading it with unnecessary tables can degrade performance, while omitting critical tables can lead to incorrect segment derivation. Regular maintenance, such as purging obsolete entries, is recommended to optimize performance.

Conclusion

The AUTOGL_TABLES Lookup Type is a foundational element in Oracle EBS AutoAccounting, enabling automated and accurate derivation of accounting flexfield combinations. Its proper configuration and maintenance are essential for ensuring seamless integration between subledgers and the General Ledger, thereby enhancing operational efficiency and financial reporting accuracy.