Search Results fun_trx_headers




The FUN_TRX_HEADERS table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical data structure within the Fusion Accounting Hub (FAH) or Financials modules, primarily used to store transactional header information for accounting entries. This table serves as the foundation for recording financial transactions, ensuring data integrity, and facilitating downstream processing in General Ledger (GL), Accounts Payable (AP), and Accounts Receivable (AR). Below is a detailed breakdown of its structure, purpose, and integration within Oracle EBS.

Table Overview

The FUN_TRX_HEADERS table acts as the parent table for transactional data, storing metadata such as transaction identifiers, dates, statuses, and references to related entities. It is designed to support multi-org, multi-currency, and multi-ledger environments, aligning with Oracle EBS's architectural principles. Key columns include:
  • TRX_HEADER_ID: Primary key, uniquely identifying each transaction header.
  • TRX_NUMBER: User-friendly identifier for the transaction.
  • TRX_DATE: The date the transaction was created.
  • LEDGER_ID: References the ledger to which the transaction belongs.
  • STATUS: Indicates the transaction's lifecycle stage (e.g., "Draft," "Posted," "Completed").
  • SOURCE: Identifies the originating module (e.g., "AP_INVOICES," "AR_CASH_RECEIPTS").
  • CREATED_BY and CREATION_DATE: Audit columns tracking record creation.

Functional Role

The table serves as a central hub for transactional data, enabling:
  • Data Aggregation: Consolidates header-level details for downstream accounting entries.
  • Audit Trail: Maintains a history of transactional changes through status flags and timestamps.
  • Integration: Links to child tables (e.g., FUN_TRX_LINES) for line-level details and to subledger modules for reconciliation.

Integration with Oracle EBS Modules

  1. General Ledger (GL): Transactions from FUN_TRX_HEADERS are summarized and posted to GL journals via the Accounting Engine.
  2. Subledgers (AP/AR): Invoices or receipts reference TRX_HEADER_ID to maintain traceability.
  3. Multi-Org Access Control (MOAC): The LEDGER_ID column enforces data segregation per operating unit.

Technical Considerations

  • Indexing: Key columns like TRX_HEADER_ID and TRX_NUMBER are indexed for performance.
  • Partitioning: In high-volume environments, partitioning by TRX_DATE may be implemented.
  • API Usage: Oracle provides PL/SQL APIs (e.g., FUN_TRX_PUB) to interact with this table programmatically.

Customization and Extensions

Organizations often extend the table with custom columns (e.g., ATTRIBUTE1-15) to capture additional context. However, modifications should adhere to Oracle's support guidelines to avoid upgrade conflicts.

Conclusion

The FUN_TRX_HEADERS table is a cornerstone of Oracle EBS's financial architecture, ensuring transactional data is systematically captured, validated, and propagated across modules. Its design reflects Oracle's commitment to scalability, compliance, and integration, making it indispensable for organizations leveraging EBS 12.1.1 or 12.2.2 for financial management.

  • Table: FUN_TRX_HEADERS 12.2.2

    owner:FUN,  object_type:TABLE,  fnd_design_data:FUN.FUN_TRX_HEADERS,  object_name:FUN_TRX_HEADERS,  status:VALID,  product: FUN - Financials Common Modules ,  description: FUN_TRX_HEADERS stores the transactions that make up an Intercompany transaction batch. The INITIATOR_ID, RECIPIENT_ID, BATCH_ID together form a unique key. Each transaction is meant for 1 recipient however a batch can contain multiple tran ,  implementation_dba_data: FUN.FUN_TRX_HEADERS , 

  • Table: FUN_TRX_HEADERS 12.1.1

    owner:FUN,  object_type:TABLE,  fnd_design_data:FUN.FUN_TRX_HEADERS,  object_name:FUN_TRX_HEADERS,  status:VALID,  product: FUN - Financials Common Modules ,  description: FUN_TRX_HEADERS stores the transactions that make up an Intercompany transaction batch. The INITIATOR_ID, RECIPIENT_ID, BATCH_ID together form a unique key. Each transaction is meant for 1 recipient however a batch can contain multiple tran ,  implementation_dba_data: FUN.FUN_TRX_HEADERS , 

  • Table: FUN_TRX_LINES 12.1.1

    owner:FUN,  object_type:TABLE,  fnd_design_data:FUN.FUN_TRX_LINES,  object_name:FUN_TRX_LINES,  status:VALID,  product: FUN - Financials Common Modules ,  description: FUN_TRX_LINES stores some line level information for an intercompany transaction.Each row in FUN_TRX_HEADERS currently maps to 1 row in FUN_TRX_LINES. ,  implementation_dba_data: FUN.FUN_TRX_LINES , 

  • Table: FUN_TRX_LINES 12.2.2

    owner:FUN,  object_type:TABLE,  fnd_design_data:FUN.FUN_TRX_LINES,  object_name:FUN_TRX_LINES,  status:VALID,  product: FUN - Financials Common Modules ,  description: FUN_TRX_LINES stores some line level information for an intercompany transaction.Each row in FUN_TRX_HEADERS currently maps to 1 row in FUN_TRX_LINES. ,  implementation_dba_data: FUN.FUN_TRX_LINES ,