Results for “jai_fa_mass_additions”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JAI_FA_MASS_ADDITIONS is a table owned by the JA schema (Asia/Pacific Localizations) in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores payable invoice details for assets that are created as part of a bulk import process. In effect, it acts as a staging and cross-reference table that links Oracle Payables invoice distribution information to Fixed Assets mass additions, allowing localization-specific processing to reconcile invoiced asset costs against the fixed asset records generated by a mass addition run.

From a Data Vault modeling perspective, the heuristic classification for this object is link. This is consistent with its structure: rather than serving as a standalone master entity (hub) or a purely descriptive attribute store (satellite), JAI_FA_MASS_ADDITIONS primarily connects several independent entities — the Payables invoice distribution, the asset mass addition, the payables accounting flexfield, and the concurrent request that created the batch. The surrogate key MASS_ADDITION_ID anchors these associations.

Key Information Stored

The table contains 24 documented columns. The most significant are described below.

• MASS_ADDITION_ID — The surrogate primary key defined by the unique index JAI_FA_MASS_ADDITIONS_PK. It also serves as a foreign key to FA_MASS_ADDITIONS, tying each row to the underlying Fixed Assets mass addition.
• INVOICE_ID and DISTRIBUTION_LINE_NUMBER — Foreign keys to AP_INVOICE_DISTRIBUTIONS_ALL, identifying the payable invoice distribution from which the asset cost is derived.
• INVOICE_NUMBER, INVOICE_DATE, INVOICE_LINE_NUMBER — Descriptive Payables invoice attributes captured for reporting and reconciliation.
• PAYABLES_CODE_COMBINATION_ID — Foreign key to GL_CODE_COMBINATIONS, representing the payables accounting flexfield used in the localization.
• CREATE_BATCH_ID — Foreign key to FND_CONCURRENT_REQUESTS, identifying the concurrent program run that created the batch of mass additions.
• PROCESS_FLAG and PROCESS_MESSAGE — Control and diagnostic columns indicating processing status and any error text.
• BOOK_TYPE_CODE, DATE_PLACED_IN_SERVICE, ASSET_TYPE, ACCOUNTING_DATE — Fixed Assets attributes describing the asset being added.
• VENDOR_NUMBER and PO_NUMBER — Supplier and purchase order references supporting source-document traceability.
• DEPRECIATE_STATUS — Indicates whether the associated asset is subject to depreciation.
• OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns for concurrency control and change tracking.

Common Use Cases and Queries

Typical uses include reconciling Payables invoices against capitalized assets, validating the outcome of a bulk import concurrent request, and reporting on assets pending or failed processing.

• Identify rows not yet processed: filter on PROCESS_FLAG to find pending or errored mass additions.
• Trace an asset back to its invoice: join to AP_INVOICE_DISTRIBUTIONS_ALL on INVOICE_ID and DISTRIBUTION_LINE_NUMBER.
• Isolate records from a specific import run: join to FND_CONCURRENT_REQUESTS using CREATE_BATCH_ID.

A representative pattern follows:

• SELECT m.MASS_ADDITION_ID, m.INVOICE_NUMBER, m.VENDOR_NUMBER, m.PROCESS_FLAG, m.PROCESS_MESSAGE FROM JA.JAI_FA_MASS_ADDITIONS m WHERE m.PROCESS_FLAG = 'ERROR';
• SELECT m.MASS_ADDITION_ID, a.ASSET_ID FROM JA.JAI_FA_MASS_ADDITIONS m JOIN FA_MASS_ADDITIONS a ON m.MASS_ADDITION_ID = a.MASS_ADDITION_ID;

Related Objects

The table participates in several documented referential relationships:

• FA_MASS_ADDITIONS — joined on MASS_ADDITION_ID; the Fixed Assets interface holding the asset additions.
• AP_INVOICE_DISTRIBUTIONS_ALL — joined on INVOICE_ID and DISTRIBUTION_LINE_NUMBER; source of payable invoice cost.
• GL_CODE_COMBINATIONS — joined on PAYABLES_CODE_COMBINATION_ID; resolves the payables accounting flexfield.
• FND_CONCURRENT_REQUESTS — joined on CREATE_BATCH_ID; identifies the creating concurrent request.

These relationships establish JAI_FA_MASS_ADDITIONS as a localization bridge between Payables, General Ledger, Fixed Assets, and concurrent processing.