Search Results jl_co_fa_adjustments

Overview

JL_CO_FA_ADJUSTMENTS is a Latin America Localizations (JL) table that stores accounting information pertaining to Colombian Oracle Assets. It resides in the JL schema and is classified as VALID within Oracle EBS 12.1.1 and 12.2.2. The table captures the adjustment and journal-entry detail generated when fixed asset transactions in Colombian asset books are revalued, adjusted for inflation, or otherwise reconciled to local statutory accounting requirements. Each row represents a discrete accounting adjustment line tied to a specific asset, asset book, and general ledger code combination.

Under the heuristic Data Vault classification mined from its foreign-key structure, this object behaves as a link table rather than a hub or satellite. It does not introduce a natural business key of its own; instead it associates existing hubs — assets, books, distributions, and GL accounts — through foreign keys, and layers descriptive measures (adjustment amounts, adjustment type, posting flags) onto those associations. This makes it a suitable candidate for modeling as a link construct with an associated satellite for the transactional attributes.

Key Information Stored

The table contains 27 documented columns. The following are the most significant:

TRANSACTION_HEADER_ID — Surrogate identifier for the adjustment header; the primary key candidate for this table.
ASSET_ID — Foreign key to FA_ADDITIONS_B, identifying the asset to which the adjustment applies.
BOOK_TYPE_CODE — Foreign key to FA_BOOK_CONTROLS, identifying the asset book (typically the Colombian tax or statutory book).
CODE_COMBINATION_ID — Foreign key to GL_CODE_COMBINATIONS, specifying the accounting distribution account.
DISTRIBUTION_ID — Foreign key to FA_DISTRIBUTION_HISTORY, linking the adjustment to the source asset distribution line.
ADJUSTMENT_TYPE — Classifies the nature of the adjustment (for example, revaluation or inflation adjustment).
SOURCE_TYPE_CODE and JE_CATEGORY_NAME — Identify the originating transaction source and journal entry category used for GL posting.
DEBIT_CREDIT_FLAG — Indicates whether the line is a debit or credit entry.
ADJUSTMENT_AMOUNT and ANNUALIZED_ADJUSTMENT — The adjustment amount and its annualized equivalent, the core financial measures of the row.
POSTING_FLAG — Indicates whether the line has been posted to General Ledger.
PERIOD_COUNTER_ADJUSTED and PERIOD_COUNTER_CREATED — Identify the accounting period adjusted and the period in which the record was created.
JE_HEADER_REFERENCE_ID and SEQUENCE_LINE — Tie the row to its journal entry header and line sequence.
Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) plus REQUEST_ID, PROGRAM_ID, and related program columns for concurrent request auditing.

Common Use Cases and Queries

Typical uses include Colombian statutory reporting, reconciliation of asset book balances to GL, and audit of inflation or revaluation adjustments. A common query joins the table to its parent entities:

Listing all adjustments for an asset and book: SELECT * FROM JL_CO_FA_ADJUSTMENTS WHERE asset_id = :asset_id AND book_type_code = :book;
Posting status review: filter on POSTING_FLAG and PERIOD_COUNTER_CREATED to find unposted adjustments pending GL transfer.
Account analysis: aggregate ADJUSTMENT_AMOUNT by CODE_COMBINATION_ID to reconcile Colombian asset accounts.
Tracing back to source distributions via DISTRIBUTION_ID for drill-down from reporting to asset transaction detail.

Related Objects

FA_ADDITIONS_B — joined on ASSET_ID; supplies asset identity.
FA_BOOK_CONTROLS — joined on BOOK_TYPE_CODE; supplies book definition and calendar.
GL_CODE_COMBINATIONS — joined on CODE_COMBINATION_ID; supplies account description.
FA_DISTRIBUTION_HISTORY — joined on DISTRIBUTION_ID; supplies source distribution detail.
FA_JOURNAL_HEADERS / GL_JE_HEADERS — referenced through JE_HEADER_REFERENCE_ID for journal traceability.

Table: JL_CO_FA_ADJUSTMENTS 12.1.1
owner:JL, object_type:TABLE, fnd_design_data:JL.JL_CO_FA_ADJUSTMENTS, object_name:JL_CO_FA_ADJUSTMENTS, status:VALID, product: JL - Latin America Localizations , description: Accounting information pertaining to Colombian Oracle Assets , implementation_dba_data: JL.JL_CO_FA_ADJUSTMENTS ,
Table: JL_CO_FA_ADJUSTMENTS 12.2.2
owner:JL, object_type:TABLE, fnd_design_data:JL.JL_CO_FA_ADJUSTMENTS, object_name:JL_CO_FA_ADJUSTMENTS, status:VALID, product: JL - Latin America Localizations , description: Accounting information pertaining to Colombian Oracle Assets , implementation_dba_data: JL.JL_CO_FA_ADJUSTMENTS ,
SYNONYM: APPS.JL_CO_FA_ADJUSTMENTS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:JL_CO_FA_ADJUSTMENTS, status:VALID,
VIEW: JL.JL_CO_FA_ADJUSTMENTS# 12.2.2
owner:JL, object_type:VIEW, object_name:JL_CO_FA_ADJUSTMENTS#, status:VALID,
SYNONYM: APPS.JL_CO_FA_ADJUSTMENTS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:JL_CO_FA_ADJUSTMENTS, status:VALID,
VIEW: JL.JL_CO_FA_ADJUSTMENTS# 12.2.2
TABLE: JL.JL_CO_FA_PURGE 12.2.2
owner:JL, object_type:TABLE, fnd_design_data:JL.JL_CO_FA_PURGE, object_name:JL_CO_FA_PURGE, status:VALID,
TABLE: JL.JL_CO_FA_PURGE 12.1.1
owner:JL, object_type:TABLE, fnd_design_data:JL.JL_CO_FA_PURGE, object_name:JL_CO_FA_PURGE, status:VALID,
PACKAGE: APPS.JL_CO_FA_ACCOUNTING_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:JL_CO_FA_ACCOUNTING_PKG, status:VALID,
PACKAGE: APPS.JL_CO_FA_ACCOUNTING_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:JL_CO_FA_ACCOUNTING_PKG, status:VALID,
APPS.JL_CO_FA_PURGE_PKG SQL Statements 12.1.1
APPS.JL_CO_FA_PURGE_PKG SQL Statements 12.2.2
Table: FA_DISTRIBUTION_HISTORY 12.2.2
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_DISTRIBUTION_HISTORY, object_name:FA_DISTRIBUTION_HISTORY, status:VALID, product: OFA - Assets , description: Employee, location, and Accounting Flexfield values assigned to each asset , implementation_dba_data: FA.FA_DISTRIBUTION_HISTORY ,
TABLE: JL.JL_CO_FA_ADJUSTMENTS 12.1.1
owner:JL, object_type:TABLE, fnd_design_data:JL.JL_CO_FA_ADJUSTMENTS, object_name:JL_CO_FA_ADJUSTMENTS, status:VALID,
TABLE: JL.JL_CO_FA_ADJUSTMENTS 12.2.2
owner:JL, object_type:TABLE, fnd_design_data:JL.JL_CO_FA_ADJUSTMENTS, object_name:JL_CO_FA_ADJUSTMENTS, status:VALID,
PACKAGE: APPS.JL_CO_FA_POST_PKG 12.1.1
PACKAGE BODY: APPS.JL_CO_FA_POST_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JL_CO_FA_POST_PKG, status:VALID,
PACKAGE: APPS.JL_CO_FA_POST_PKG 12.2.2
APPS.JL_CO_FA_POST_PKG SQL Statements 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.JL_CO_FA_POST_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JL_CO_FA_POST_PKG, status:VALID,
PACKAGE BODY: APPS.JL_CO_FA_PURGE_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JL_CO_FA_PURGE_PKG, status:VALID,
Table: FA_DISTRIBUTION_HISTORY 12.1.1
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_DISTRIBUTION_HISTORY, object_name:FA_DISTRIBUTION_HISTORY, status:VALID, product: OFA - Assets , description: Employee, location, and Accounting Flexfield values assigned to each asset , implementation_dba_data: FA.FA_DISTRIBUTION_HISTORY ,
PACKAGE BODY: APPS.JL_CO_FA_PURGE_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JL_CO_FA_PURGE_PKG, status:VALID,
APPS.JL_CO_FA_POST_PKG SQL Statements 12.1.1
12.1.1 DBA Data 12.1.1
APPS.JL_CO_FA_TA_REVAL_PKG SQL Statements 12.2.2
12.1.1 FND Design Data 12.1.1
PACKAGE BODY: APPS.JL_CO_FA_TA_REVAL_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JL_CO_FA_TA_REVAL_PKG, status:VALID,
APPS.JL_CO_FA_TA_REVAL_PKG SQL Statements 12.1.1
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.JL_CO_FA_ACCOUNTING_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JL_CO_FA_ACCOUNTING_PKG, status:VALID,
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.JL_CO_FA_TA_REVAL_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JL_CO_FA_TA_REVAL_PKG, status:VALID,
PACKAGE BODY: APPS.JL_CO_FA_ACCOUNTING_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JL_CO_FA_ACCOUNTING_PKG, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 FND Design Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
VIEW: APPS.JL_CO_FA_AEL_SL_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:JL.JL_CO_FA_AEL_SL_V, object_name:JL_CO_FA_AEL_SL_V, status:VALID,
Table: FA_ADDITIONS_B 12.2.2
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_ADDITIONS_B, object_name:FA_ADDITIONS_B, status:VALID, product: OFA - Assets , description: Descriptive information about assets (base MLS table) , implementation_dba_data: FA.FA_ADDITIONS_B ,
VIEW: APPS.JL_CO_FA_AEL_GL_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:JL.JL_CO_FA_AEL_GL_V, object_name:JL_CO_FA_AEL_GL_V, status:VALID,
VIEW: APPS.JL_CO_FA_AEL_SL_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:JL.JL_CO_FA_AEL_SL_V, object_name:JL_CO_FA_AEL_SL_V, status:VALID,
VIEW: APPS.JL_CO_FA_AEL_GL_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:JL.JL_CO_FA_AEL_GL_V, object_name:JL_CO_FA_AEL_GL_V, status:VALID,
Table: FA_BOOK_CONTROLS 12.2.2
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_BOOK_CONTROLS, object_name:FA_BOOK_CONTROLS, status:VALID, product: OFA - Assets , description: Control information that affects all assets in a depreciation book , implementation_dba_data: FA.FA_BOOK_CONTROLS ,
Table: FA_ADDITIONS_B 12.1.1
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_ADDITIONS_B, object_name:FA_ADDITIONS_B, status:VALID, product: OFA - Assets , description: Descriptive information about assets (base MLS table) , implementation_dba_data: FA.FA_ADDITIONS_B ,
Table: FA_BOOK_CONTROLS 12.1.1
owner:FA, object_type:TABLE, fnd_design_data:OFA.FA_BOOK_CONTROLS, object_name:FA_BOOK_CONTROLS, status:VALID, product: OFA - Assets , description: Control information that affects all assets in a depreciation book , implementation_dba_data: FA.FA_BOOK_CONTROLS ,
PACKAGE BODY: APPS.JL_CO_FA_PURGE_PKG 12.2.2
VIEW: APPS.JL_CO_FA_AEL_GL_V 12.1.1