Search Results fun_inter_accounts




The FUN_INTER_ACCOUNTS table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical repository for intercompany accounting entries, primarily used by the Oracle Subledger Accounting (SLA) and Oracle General Ledger (GL) modules. This table stores transactional data that facilitates intercompany accounting, ensuring proper financial reporting and compliance with accounting standards. Below is a detailed breakdown of its structure, purpose, and integration within Oracle EBS.

Purpose and Functional Overview

The FUN_INTER_ACCOUNTS table serves as a staging area for intercompany accounting entries before they are transferred to the General Ledger. It captures details such as source transaction identifiers, accounting dates, currency amounts, and intercompany balancing rules. This table is essential for organizations with multiple legal entities that require automated intercompany reconciliation and elimination entries during consolidation.

Key Columns and Data Structure

The table comprises several critical columns that define intercompany transactions:
  • INTER_ACCOUNT_ID: Primary key, uniquely identifying each intercompany entry.
  • SOURCE_TRANSACTION_ID: References the originating transaction (e.g., AP invoice, AR receipt).
  • ACCOUNTING_DATE: The date when the entry is posted to GL.
  • CURRENCY_CODE: Transaction currency (e.g., USD, EUR).
  • ENTERED_DR and ENTERED_CR: Debit and credit amounts in transaction currency.
  • ACCOUNTED_DR and ACCOUNTED_CR: Debit and credit amounts in functional currency.
  • FROM_LE_ID and TO_LE_ID: Legal entity identifiers for the sender and receiver.
  • STATUS: Indicates whether the entry is "Pending," "Processed," or "Posted."

Integration with Oracle Subledger Accounting (SLA)

The FUN_INTER_ACCOUNTS table is tightly integrated with SLA, which generates accounting entries based on predefined rules. SLA populates this table during the "Create Accounting" process, ensuring that intercompany transactions adhere to corporate accounting policies. The entries are then transferred to GL via the "Transfer to GL" program.

Role in Intercompany Reconciliation

Intercompany transactions must balance across legal entities to avoid discrepancies during financial consolidation. The FUN_INTER_ACCOUNTS table enables automated reconciliation by:
  • Storing mirrored entries for sender and receiver entities.
  • Providing audit trails for troubleshooting mismatches.
  • Supporting elimination entries in consolidation reports.

Technical Considerations

In Oracle EBS 12.2.2, the table may leverage Oracle's Online Patching (ADOP) framework, allowing zero-downtime maintenance. Performance can be optimized by indexing frequently queried columns like SOURCE_TRANSACTION_ID and STATUS. Additionally, custom workflows or triggers may reference this table for advanced intercompany validations.

Conclusion

The FUN_INTER_ACCOUNTS table is a cornerstone of intercompany accounting in Oracle EBS, ensuring accurate financial reporting and compliance. Its integration with SLA and GL streamlines the accounting lifecycle, while its structured data model supports auditability and reconciliation. Understanding this table is crucial for functional consultants and technical developers working on intercompany processes in Oracle EBS 12.1.1 or 12.2.2.

  • Table: FUN_INTER_ACCOUNTS 12.2.2

    owner:FUN,  object_type:TABLE,  fnd_design_data:FUN.FUN_INTER_ACCOUNTS,  object_name:FUN_INTER_ACCOUNTS,  status:VALID,  product: FUN - Financials Common Modules ,  description: FUN_INTER_ACCOUNTS table stores the Intercompany receivables and payables accounts defined for each transacting and trading legal entity relationship. The accounts can be defined either at the legal entity level or at the balancing segment ,  implementation_dba_data: FUN.FUN_INTER_ACCOUNTS , 

  • Table: FUN_INTER_ACCOUNTS 12.1.1

    owner:FUN,  object_type:TABLE,  fnd_design_data:FUN.FUN_INTER_ACCOUNTS,  object_name:FUN_INTER_ACCOUNTS,  status:VALID,  product: FUN - Financials Common Modules ,  description: FUN_INTER_ACCOUNTS table stores the Intercompany receivables and payables accounts defined for each transacting and trading legal entity relationship. The accounts can be defined either at the legal entity level or at the balancing segment ,  implementation_dba_data: FUN.FUN_INTER_ACCOUNTS ,