Search Results check_auto_asset

Overview

IPA_ASSET_MECH_APIS_PKG is an Oracle EBS Applications (APPS) schema PL/SQL package that supports the automatic creation of fixed assets from project expenditure within the Oracle E-Business Tax / Project Manufacturing and Projects (PA) and Assets (FA) integration flow. In Release 12.1.1 and 12.2.2 it forms part of the Capital Projects and asset generation infrastructure, where capitalized project costs must be transferred into Oracle Assets as asset lines and corresponding asset records. The package encapsulates the mechanical (programmatic) logic that evaluates project data, applies asset naming conventions, and drives automated asset creation without manual intervention.

The package classification is OTHER, indicating it is a supporting internal utility rather than a public, fully documented open interface. Its status is VALID in the APPS schema, and it depends on FND_GLOBAL for session context (user, responsibility, application) and PA_NL_INSTALLED, which is used to detect whether specific feature configurations or installed modules are present before executing logic.

Key Procedures and Functions

Two documented units are exposed by this package:

• IPA_AUTO_ASSET_CREATION — The primary driver that performs automatic asset creation for eligible project expenditure. It applies the configured asset naming conventions and persists the resulting asset assignments against the project asset structures.
• CHECK_AUTO_ASSET — A validation routine that determines whether automatic asset creation is applicable for a given context, allowing callers to gate the creation logic before invoking the main procedure.

Only these two units are documented in the ETRM metadata; the internal helper logic is not exposed as a public API, and no parameter lists are documented here.

Tables Accessed

The package reads and writes across the Projects and Assets schemas via APPS synonyms:

• Project tables: PA_PROJECTS_ALL, PA_PROJECT_TYPES, PA_TASKS, PA_EXPENDITURE_ITEMS_ALL, PA_IMPLEMENTATIONS, and DUAL are used to resolve eligible projects, project types, tasks, and expenditure items.
• Project asset tables: PA_PROJECT_ASSETS, PA_PROJECT_ASSET_ASSIGNMENTS, PA_PROJECT_ASSET_LINES, and PA_PROJECT_ASSET_LINE_DETAILS hold the generated asset records, assignments, and capitalized line detail.
• Assets tables: FA_BOOK_CONTROLS, FA_CATEGORIES, FA_CATEGORY_BOOKS, and FA_LOCATIONS supply the asset book, category, and location defaults required to construct assets.
• Naming configuration: IPA_ASSET_NAMING_CONVENTIONS provides the rules used to generate asset names.

Usage Notes

IPA_ASSET_MECH_APIS_PKG is typically invoked indirectly rather than directly by end users. It is referenced by two other packages, PA_CLIENT_EXTEN_CIP_GROUPING and PA_CLIENT_EXTN_GEN_ASSET_LINES, which are client extension points in the Projects asset generation flow. This indicates that the package is called during the CIP (Construction-in-Process) grouping and asset line generation processes, commonly triggered through concurrent programs such as Generate Asset Lines and Interface Assets.

Because it relies on FND_GLOBAL for session context and on PA_NL_INSTALLED for configuration detection, it must be executed within an initialized EBS session with the correct responsibility. Custom code should avoid calling the procedures directly; instead, extensions should be registered through the supported PA client extension points so that CHECK_AUTO_ASSET and IPA_AUTO_ASSET_CREATION are invoked in the correct sequence. Direct invocation in R12.1.1 or 12.2.2 risks bypassing the standard validations and naming convention enforcement applied by the parent processes.