Search Results get_date_place_in_service

Overview

APPS.JAI_FA_ASSETS_PKG is an Oracle E-Business Suite PL/SQL package that supports India-localized Fixed Assets and tax-related processing. It is classified under the ETRM as an "OTHER" API, meaning it is not a formally published open interface but rather an internal utility package used within the Oracle Assets and India tax (JAI) functional flows. Its principal responsibilities include mass asset additions, excise duty tracking on asset retirements, and a utility function that returns the date an asset was placed in service. The package header carries a revision lineage (jai_fa_ast.pls 120.1, dated 2005), indicating it has been maintained over multiple India localization releases and remains relevant across 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes three documented program units:

• MASS_ADDITIONS — A procedure invoked with standard concurrent program out-parameters (errbuf, retcode) plus a parent request identifier. It drives the mass addition of assets, coordinating the FA mass additions tables with India-specific tax and receipt data so that multiple assets can be loaded and costed in a single run.
• CLAIM_EXCISE_ON_RETIREMENT — A procedure that handles excise (CENVAT) claim processing when an asset is retired, taking organization, location, receipt and shipment line, book type, and asset identifiers. It reverses or claims excise credit that was originally capitalized with the asset.
• GET_DATE_PLACE_IN_SERVICE — A function accepting an asset identifier and returning a VARCHAR2 value representing the date the asset was placed in service. Although the return is character-typed rather than a DATE, the semantic intent is to supply the in-service date for downstream depreciation, reporting, or tax validation logic.

Tables Accessed

The referenced tables span Payables, Assets, Purchasing, Receiving, and India tax schemas. Payables integration uses AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, and AP_INVOICE_LINES_ALL to source invoice cost and tax lines, while FA_ASSET_INVOICES links those invoices to assets. Core Assets tables include FA_BOOKS, FA_MASS_ADDITIONS, FA_MASS_ADDITIONS_S, and the India-specific JAI_FA_MASS_ADDITIONS, which store mass addition staging and book information. Excise and CENVAT handling relies on JAI_CMN_TAXES_ALL, JAI_RCV_CENVAT_CLAIM_T, JAI_RCV_CENVAT_CLAIM_T_S, and JAI_RCV_LINE_TAXES. Procurement context is provided by PO_HEADERS_ALL, RCV_SHIPMENT_HEADERS, and RCV_TRANSACTIONS, allowing the package to trace an asset back to its receiving receipt and shipment line. This broad table footprint confirms the package is a bridge between procurement, payables, assets, and India excise reporting.

Usage Notes

The package is typically invoked from Oracle Assets concurrent programs, India-localized asset forms, or custom extensions rather than called directly by users. MASS_ADDITIONS aligns with standard mass addition concurrent processing, using errbuf and retcode for concurrent manager integration and parent_request_id for logging or dependency tracking. CLAIM_EXCISE_ON_RETIREMENT is called during asset retirement workflows where CENVAT credit recovery is required. GET_DATE_PLACE_IN_SERVICE is a utility used by reporting or validation logic needing the in-service date. Because the metadata indicates the package is referenced by zero other packages, it functions as a leaf-level utility rather than a shared library, and any custom code should be treated as unsupported and regression-tested against 12.2.2.