Search Results summary

The JE_DE_FA_SUMMARY table in Oracle E-Business Suite (EBS) versions 12.1.1 or 12.2.2 is a critical repository for fixed asset summary data, primarily utilized by the Journal Entry (JE) and Fixed Assets (FA) modules. This table stores consolidated financial information derived from asset transactions, enabling efficient reporting, reconciliation, and general ledger integration. Below is a detailed analysis of its structure, purpose, and functional relevance in Oracle EBS.

Purpose and Functional Context

The JE_DE_FA_SUMMARY table acts as an intermediary between the Fixed Assets subledger and the General Ledger (GL). It aggregates asset-related transactions—such as additions, retirements, transfers, and depreciation—into summarized entries before they are posted to GL. This summarization reduces the volume of journal entries, optimizing performance during period-end close processes. The table is particularly significant in deployments where detailed asset transactions must be consolidated for compliance, audit, or reporting purposes.

Key Columns and Data Structure

While the exact schema may vary slightly between EBS 12.1.1 and 12.2.2, the table typically includes the following columns:

ASSET_ID: Unique identifier linking to the FA_ADDITIONS table.
BOOK_TYPE_CODE: Specifies the asset book (e.g., corporate, tax) for multi-book accounting.
PERIOD_NAME: The accounting period for which the summary is generated.
DEPRN_AMOUNT: Aggregated depreciation amount for the period.
YTD_DEPRN: Year-to-date depreciation total.
TRANSACTION_TYPE: Categorizes the transaction (e.g., 'ADDITION', 'RETIREMENT').
CODE_COMBINATION_ID: References the GL account combination from GL_CODE_COMBINATIONS.

Integration with Oracle EBS Modules

Fixed Assets (FA): The table sources data from asset transactions recorded in FA_DEPRN_DETAIL, FA_TRANSACTION_HEADERS, and related tables. Summarization logic is triggered during depreciation runs or manual journal entry generation.
General Ledger (GL): Summarized entries are transferred to GL via the Journal Import process, typically using the GL_INTERFACE table. This ensures alignment between subledger and GL balances.
Reporting: Tools like Oracle Financial Reporting or BI Publisher leverage this table for asset-related financial statements and tax reports.

Technical Considerations

Indexing: Columns like ASSET_ID, BOOK_TYPE_CODE, and PERIOD_NAME are often indexed to enhance query performance.
Partitioning: In high-volume environments, partitioning by PERIOD_NAME or BOOK_TYPE_CODE may be implemented.
Custom Extensions: Organizations may extend the table with custom columns (e.g., project ID) to support specialized reporting.

Common Use Cases

Period-End Close: Finance teams use the summarized data to validate depreciation postings before GL reconciliation.
Audit Compliance: Auditors trace GL entries back to asset-level details via this table.
Multi-Book Reporting Enables parallel reporting across corporate, tax, and statutory books.

Limitations and Best Practices

Data Volume: Large asset portfolios may require periodic archiving of older records to maintain performance.
Custom Logic: Overriding Oracle's summarization logic (e.g., for unique depreciation rules) demands careful testing to avoid GL discrepancies.
Upgrade Impact: Schema changes between EBS versions (12.1.1 to 12.2.2) should be validated during upgrades.

Lookup Type: JEFI_LPIP_SUMMARY_LEVEL 12.1.1
product: JE - European Localizations , meaning: JEFI LPIP SUMMARY LEVEL , description: JEFILPIP report summary-level parameters ,
Lookup Type: JEFI_LPIP_SUMMARY_LEVEL 12.2.2
product: JE - European Localizations , meaning: JEFI LPIP SUMMARY LEVEL , description: JEFILPIP report summary-level parameters ,
Concurrent Program: JEITPSSR 12.2.2
execution_filename: JEITPSSR , product: JE - European Localizations , user_name: JEITPSSR , description: Summary Vat Report , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Concurrent Program: JEITPSSR 12.1.1
execution_filename: JEITPSSR , product: JE - European Localizations , user_name: JEITPSSR , description: Summary Vat Report , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Lookup Type: JEBE_REPORT_FORMAT 12.1.1
product: JE - European Localizations , meaning: JEBE REPORT FORMAT , description: Report Format ,
Lookup Type: JEBE_REPORT_FORMAT 12.2.2
product: JE - European Localizations , meaning: JEBE REPORT FORMAT , description: Report Format ,
Lookup Type: JEIL_RPT_METHODS 12.1.1
product: JE - European Localizations , meaning: Israeli Report Methods , description: Israeli Report Methods ,
Lookup Type: JEIL_RPT_METHODS 12.2.2
product: JE - European Localizations , meaning: Israeli Report Methods , description: Israeli Report Methods ,
Lookup Type: JEBE_REPORT_FORMAT3 12.2.2
product: JE - European Localizations , meaning: JEBE REPORT FORMAT3 , description: REPORT_FORMAT (JOURNALS) ,
Lookup Type: JEBE_REPORT_FORMAT3 12.1.1
product: JE - European Localizations , meaning: JEBE REPORT FORMAT3 , description: REPORT_FORMAT (JOURNALS) ,
Concurrent Program: JEITPSSR_XMLP 12.2.2
product: JE - European Localizations , user_name: Italian Payables Summary VAT Report , description: Italian Payables Summary VAT Report , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: JEITPSSR_XMLP 12.1.1
product: JE - European Localizations , user_name: Italian Payables Summary VAT Report , description: Italian Payables Summary VAT Report , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: JEILWHTD 12.1.1
product: JE - European Localizations , user_name: Israeli Withholding Tax Summary/Detail Report , description: Israeli Withholding Tax Summary/Detail Report , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: JEILSVAT_XMLP 12.2.2
product: JE - European Localizations , user_name: Israeli Summary VAT to Tax Authorities , description: Israeli Summary VAT to Tax Authorities , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: JEILSVAT_XMLP 12.1.1
product: JE - European Localizations , user_name: Israeli Summary VAT to Tax Authorities , description: Israeli Summary VAT to Tax Authorities , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: JEILWHTD 12.2.2
product: JE - European Localizations , user_name: Israeli Withholding Tax Summary/Detail Report , description: Israeli Withholding Tax Summary/Detail Report , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Lookup Type: JEPT_TRIAL_BAL_TYPE 12.1.1
product: JE - European Localizations , meaning: JEPT TRIAL BAL TYPE , description: Portuguese Trial Balance Types ,
Lookup Type: JEPT_TRIAL_BAL_TYPE 12.2.2
product: JE - European Localizations , meaning: JEPT TRIAL BAL TYPE , description: Portuguese Trial Balance Types ,
Lookup Type: JEBE_REPORT_FORMAT2 12.2.2
product: JE - European Localizations , meaning: JEBE REPORT FORMAT2 , description: Report Format 2 (Facturiers) ,
Lookup Type: JEBE_REPORT_FORMAT2 12.1.1
product: JE - European Localizations , meaning: JEBE REPORT FORMAT2 , description: Report Format 2 (Facturiers) ,
Concurrent Program: JEPTGLTBS 12.2.2
execution_filename: JEPTGLTB , product: JE - European Localizations , user_name: JEPTGLTB , description: Portuguese General Ledger Trial Balance , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Concurrent Program: JEPTGLTBS 12.1.1
execution_filename: JEPTGLTB , product: JE - European Localizations , user_name: JEPTGLTB , description: Portuguese General Ledger Trial Balance , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Concurrent Program: JEESRPVC 12.2.2
execution_filename: JEESRPVC , product: JE - European Localizations , user_name: JEESRPVC , description: Spanish Modelo 349 Data Extract (Accounts Payable) , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Concurrent Program: JEESVEFT 12.2.2
execution_filename: JEESVEFT , product: JE - European Localizations , user_name: JEESVEFT , description: Spanish Modelo 349 Magnetic Format , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Concurrent Program: JEESVEFT 12.1.1
execution_filename: JEESVEFT , product: JE - European Localizations , user_name: JEESVEFT , description: Spanish Modelo 349 Magnetic Format , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Concurrent Program: JEESRRVC 12.1.1
execution_filename: JEESRRVC , product: JE - European Localizations , user_name: JEESRRVC , description: Spanish Modelo 349 Data Extract (Accounts Receivable) , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Concurrent Program: JEESRRVC 12.2.2
execution_filename: JEESRRVC , product: JE - European Localizations , user_name: JEESRRVC , description: Spanish Modelo 349 Data Extract (Accounts Receivable) , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Concurrent Program: JEESRPVC 12.1.1
execution_filename: JEESRPVC , product: JE - European Localizations , user_name: JEESRPVC , description: Spanish Modelo 349 Data Extract (Accounts Payable) , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Table: JE_DE_FA_SUMMARY 12.2.2
owner:FA, object_type:TABLE, fnd_design_data:JE.JE_DE_FA_SUMMARY, object_name:JE_DE_FA_SUMMARY, status:VALID, product: JE - European Localizations , description: Summary information on fixed assets , implementation_dba_data: FA.JE_DE_FA_SUMMARY ,
Table: JE_DE_FA_SUMMARY 12.1.1
owner:FA, object_type:TABLE, fnd_design_data:JE.JE_DE_FA_SUMMARY, object_name:JE_DE_FA_SUMMARY, status:VALID, product: JE - European Localizations , description: Summary information on fixed assets , implementation_dba_data: FA.JE_DE_FA_SUMMARY ,
Lookup Type: JEIT_REPORT_MODE 12.1.1
product: JE - European Localizations , meaning: Report Mode , description: Report Mode ,
Lookup Type: JEIT_REPORT_MODE 12.2.2
product: JE - European Localizations , meaning: Report Mode , description: Report Mode ,
Table: JE_IT_LIST_PARTIES_ALL 12.2.2
owner:JE, object_type:TABLE, fnd_design_data:JE.JE_IT_LIST_PARTIES_ALL, object_name:JE_IT_LIST_PARTIES_ALL, status:VALID, product: JE - European Localizations , description: JE_IT_LIST_PARTIES_ALL table contains Italian Annual Supplier and Customer listing extract summary data , implementation_dba_data: JE.JE_IT_LIST_PARTIES_ALL ,
Table: JE_IT_LIST_PARTIES_ALL 12.1.1
owner:JE, object_type:TABLE, fnd_design_data:JE.JE_IT_LIST_PARTIES_ALL, object_name:JE_IT_LIST_PARTIES_ALL, status:VALID, product: JE - European Localizations , description: JE_IT_LIST_PARTIES_ALL table contains Italian Annual Supplier and Customer listing extract summary data , implementation_dba_data: JE.JE_IT_LIST_PARTIES_ALL ,
Lookup Type: JEIT_REPORT_TYPE 12.1.1
product: JE - European Localizations , meaning: JEIT REPORT TYPE , description: Report Types ,
Lookup Type: JEIT_REPORT_TYPE 12.2.2
product: JE - European Localizations , meaning: JEIT REPORT TYPE , description: Report Types ,