Search Results extract_account

Overview

JL_CO_FA_ACCOUNTING_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite (12.1.1 / 12.2.2). It implements the Colombian localizations for Fixed Assets accounting and for the transfer of accounting entries into Oracle General Ledger. The header comments indicate the package was originally delivered for Oracle Applications Release 11.0 and carries a version stamp of jlcofgas.pls 120.2. It is therefore a country-specific (JL = Latin America / Colombia) extension that coordinates the creation and posting of depreciation and adjustment entries for assets governed by Colombian tax books.

The package focuses on the interaction between the corporate depreciation book and the tax depreciation book, ensuring that the Colombian statutory ledger receives the correct natural account segments derived from the Accounting Flexfield. It serves as the bridge between the Fixed Assets module and the General Ledger interface for Colombian legal reporting.

Key Procedures and Functions

The package exposes four documented procedures:

• ACCOUNT_TRANSACTIONS — the main entry point. It executes the Colombian accounting process that transfers transaction data to General Ledger. It is designed to be called by a concurrent program, accepting the standard ERRBUF and RETCODE out parameters plus a tax book parameter that identifies the tax depreciation book type code.
• EXTRACT_ACCOUNT — derives the natural account segment from an input Accounting Flexfield (AFF) combination. Its documented parameters include the chart of accounts identifier, the application short name, the key flexfield code, the account segment number, a default account CCID, and an output account segment. Per the inline comment by LER dated 18-Jun-99, the procedure became obsolete in Release 11.5 because the natural account segment is now stored directly in FA_BOOK_CONTROLS.GDF.
• CHANGE_ACCOUNT — adjusts or replaces account information associated with Colombian fixed asset accounting records, supporting account reassignment during reclassification or corrections.
• INSERT_ADJUSTMENT — inserts adjustment records into the Colombian FA adjustments table that feed subsequent accounting and reporting cycles.

Tables Accessed

The package references a broad set of Fixed Assets and General Ledger tables through APPS synonyms. Core asset definition data is read from FA_ADDITIONS, FA_BOOKS, FA_BOOK_CONTROLS, FA_CATEGORY_BOOKS, and FA_ASSET_HISTORY. Depreciation-related data is sourced from FA_DEPRN_DETAIL, FA_DEPRN_PERIODS, and FA_DEPRN_SUMMARY. Transactional and lifecycle information is obtained from FA_TRANSACTION_HEADERS, FA_ADJUSTMENTS, FA_DISTRIBUTION_HISTORY, and FA_RETIREMENTS. Colombian-specific adjustments are written to and read from JL_CO_FA_ADJUSTMENTS. Currency conversion context is drawn from FND_CURRENCIES, and the General Ledger journal category values are validated against GL_JE_CATEGORIES.

Usage Notes

JL_CO_FA_ACCOUNTING_PKG is normally invoked through the Oracle Assets concurrent manager and through the Colombian localization menus. The ACCOUNT_TRANSACTIONS procedure is designed for concurrent program execution, as evidenced by the ERRBUF and RETCODE parameters. Customizations or extensions that require the natural account segment for a given AFF combination should call EXTRACT_ACCOUNT, although in release 11.5 and later the preferred source is FA_BOOK_CONTROLS.GDF. The package is referenced by at least one other package in the APPS schema, so modifications must be regression-tested against dependent objects. Because the package is tightly coupled to FA accounting tables and to GL journal categories, changes should be validated in a cloned environment with a full accounting cycle before promotion to production.