Search Results insert_adjustment

Overview

The APPS.JL_CO_FA_ACCOUNTING_PKG package body implements the Colombian localization accounting bridge between Oracle Assets (FA) and the General Ledger. Its principal responsibility is to execute the Colombian statutory accounting process, reading depreciation, adjustment, retirement, and distribution data from the Oracle Assets schema, transforming those transactions into the Colombian chart-of-accounts representation, and passing the resulting journal entries to General Ledger for posting. The package header comment identifies account_transactions as the main entry point, describing it as the procedure responsible for executing Colombian accounting to General Ledger. Internally the package depends on the multilingual/localization (JL) schema objects — most visibly JL_CO_FA_ADJUSTMENTS, from which its WHO-column variables derive their data types — and it is registered in ETRM with an API classification of OTHER. The package body includes standard Oracle EBS FND logging infrastructure, with package name, current runtime level, and statement/procedure/event/exception/error/unexpected levels declared as constants, allowing diagnostic logging to be controlled through the FND profile option without code changes.

Key Procedures and Functions

Four documented procedures make up the package interface:

• ACCOUNT_TRANSACTIONS — the primary driver procedure. It executes the Colombian accounting extraction and transfer to General Ledger, and is invoked as a concurrent process, accepting the standard concurrent-manager parameters (error buffer, return code) plus the tax book type code that identifies the depreciation book to be processed.
• EXTRACT_ACCOUNT — extracts the account (chart-of-accounts combination) associated with a given asset transaction so that the correct Colombian accounting string can be derived.
• CHANGE_ACCOUNT — updates or reassigns account information for a transaction, supporting account corrections required by Colombian localization rules.
• INSERT_ADJUSTMENT — inserts adjustment records into JL_CO_FA_ADJUSTMENTS. This is the object matching the user search term "insert_adjustment"; it is the write path through which Colombian asset adjustments, including the WHO columns (last updated by, last update login, request ID, program application ID, program ID), are persisted and later consumed by the accounting process.

Tables Accessed

The package reads from the core Oracle Assets tables — FA_ADDITIONS, FA_BOOKS, FA_BOOK_CONTROLS, FA_CATEGORY_BOOKS, FA_DEPRN_DETAIL, FA_DEPRN_PERIODS, FA_DEPRN_SUMMARY, FA_ADJUSTMENTS, FA_ASSET_HISTORY, FA_DISTRIBUTION_HISTORY, FA_RETIREMENTS, and FA_TRANSACTION_HEADERS — to build the depreciation and transaction populations to be accounted. It reads FND_CURRENCIES and GL_JE_CATEGORIES to resolve currency and journal category information for the generated entries. It reads and writes JL_CO_FA_ADJUSTMENTS, the Colombian localization adjustment table, which is populated by INSERT_ADJUSTMENT and consumed by ACCOUNT_TRANSACTIONS. All tables are referenced through APPS synonyms, so the package runs with the standard EBS APPS schema privileges.

Usage Notes

JL_CO_FA_ACCOUNTING_PKG is licensed and used specifically for Colombian localizations. In Oracle EBS 12.1.1 and 12.2.2 it is normally invoked through the concurrent program that submits Colombian asset accounting to General Ledger, rather than directly from a form. Because ACCOUNT_TRANSACTIONS follows the concurrent-manager calling convention, custom code should submit it as a concurrent request or call it without expecting a return value. INSERT_ADJUSTMENT is the documented insertion point for customization or supplementary Colombian adjustment loaders. The package is referenced by one other package, so changes to its signature should be assessed for downstream impact. The body is marked $Header: jlcofgab.pls 120.15 2007/11/21, which indicates the shipped version; customers should not modify the seeded body but should use the documented procedures or supported extensions.