Search Results jai_fa_mass_additions

Overview

The JAI_FA_MASS_ADDITIONS table is a core data object within the Asia/Pacific Localizations (JA) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It functions as a specialized extension to the standard Fixed Assets mass additions process, specifically designed to capture and store detailed payable invoice information associated with assets imported in bulk. Its primary role is to maintain the critical link between an asset's capitalizable cost in Fixed Assets and its originating invoice distribution in Payables, ensuring accurate financial tracking and compliance for localized requirements in supported regions.

Key Information Stored

The table stores transactional details that tie asset additions to their source payables transactions. The primary key is MASS_ADDITION_ID, which directly references the standard FA_MASS_ADDITIONS table. Crucially, it holds foreign key columns that link to the Payables module: INVOICE_ID and DISTRIBUTION_LINE_NUMBER reference AP_INVOICE_DISTRIBUTIONS_ALL, pinpointing the exact source of the cost. The PAYABLES_CODE_COMBINATION_ID column links to GL_CODE_COMBINATIONS, storing the accounting flexfield from the invoice distribution. Additional columns, such as CREATE_BATCH_ID (linked to FND_CONCURRENT_REQUESTS), track the batch process responsible for creating the mass addition records, facilitating audit trails and process management.

Common Use Cases and Queries

A primary use case is tracing the payable origin of a capitalized asset for audit or reconciliation purposes. Analysts often query this table to resolve discrepancies between Payables and Fixed Assets or to generate reports on asset procurement sourced from specific invoices. Common SQL patterns involve joining to core EBS tables to create a comprehensive asset-invoice view. For example:

• Identifying assets from a specific invoice batch: SELECT fa_mass.asset_number, jai.invoice_id FROM jai_fa_mass_additions jai, fa_mass_additions fa_mass WHERE jai.mass_addition_id = fa_mass.mass_addition_id AND jai.invoice_id IN (SELECT invoice_id FROM ap_invoices_all WHERE invoice_num LIKE 'INV-BATCH-2024%');
• Reconciling the total invoice cost to mass additions cost for a period by joining JAI_FA_MASS_ADDITIONS to AP_INVOICE_DISTRIBUTIONS_ALL and FA_MASS_ADDITIONS.

Related Objects

This table is central to a network of key EBS objects. Its defining relationships are established through foreign key constraints. It is a child of FA_MASS_ADDITIONS, extending the standard mass addition record. It has a direct dependency on AP_INVOICE_DISTRIBUTIONS_ALL to source its payable details and on GL_CODE_COMBINATIONS for the accounting context. The CREATE_BATCH_ID links to FND_CONCURRENT_REQUESTS for process tracking. Consequently, any data integrity or reporting operation involving localized asset-invoice linkage will involve these related tables, with JAI_FA_MASS_ADDITIONS serving as the critical junction.