Search Results cse_asset_wip_pkg




Overview
Explore in AI Chat

Overview

APPS.CSE_ASSET_WIP_PKG is a PL/SQL package body in the Oracle E-Business Suite Applications schema that supports asset-related processing within the Enterprise Asset Management and Oracle Fusion Assets (fixed assets) integration flow. Its role centers on managing the linkage between Oracle Assets and work-in-process (WIP) asset cost structures, allowing capitalized asset components to be updated and their fixed asset costs and units adjusted in a controlled manner. The package is classified as an "OTHER" API and is not referenced by any other database object, indicating that it is typically invoked directly from forms, concurrent programs, or custom extensions rather than as a dependency of other packaged code.

Key Procedures and Functions

The package body exposes two documented procedures:

  • UPDATE_COMP_ASSETS — Updates the component assets that have been associated with a parent asset or asset structure. This procedure is used to synchronize component-level asset records so that the composite asset definition reflects the latest component information held in the instance and asset interfaces.
  • ADJUST_FA_COST_N_UNIT — Adjusts the cost and the unit quantity associated with fixed asset records. It handles corrections or recalculations of capitalized cost and number of units, ensuring the Oracle Assets side of the record remains consistent with the originating asset data.

No parameter lists are documented in the ETRM metadata; the procedures are identified by name and purpose only.

Tables Accessed

The package interacts with both the Oracle Assets and Oracle Installed Base / Enterprise Asset Management data models. The documented dependencies include:

  • CSI_ITEM_INSTANCES — the core installed base instance table, providing component and instance identity.
  • CSI_I_ASSETS — the interface between Installed Base instances and Oracle Assets asset records.
  • FA_ADDITIONS, FA_BOOKS, FA_DISTRIBUTION_HISTORY, FA_MASS_ADDITIONS — the Oracle Assets tables holding asset additions, book assignments, distribution history, and mass additions required to update or adjust asset cost and unit values.
  • DUAL and PLITBLM — used as a scalar select source and PL/SQL table type utility, respectively.

The package also references supporting packages such as CSE_ASSET_UTIL_PKG, CSE_IFA_TRANS_PKG, CSE_UTIL_PKG, CSI_DATASTRUCTURES_PUB, CSI_II_RELATIONSHIPS_PUB, FND_API, FND_GLOBAL, FND_MSG_PUB, and FND_PROFILE for utility, messaging, and profile-option handling.

Usage Notes

Because APPS.CSE_ASSET_WIP_PKG is not referenced by any other database object, invocation occurs through external callers. Typical scenarios include:

  • Asset component updates triggered from Enterprise Asset Management or Installed Base forms where component-level asset definitions must be refreshed.
  • Cost and unit corrections run as concurrent programs or custom scripts during asset reconciliation between Installed Base and Oracle Assets.
  • Custom EBS extensions requiring a supported entry point to adjust fixed asset cost and unit values based on source instance data.

Consistent with its status as a non-API package, direct use should be limited to environments where the underlying asset and Installed Base data relationships are well understood. The package relies on FND_MSG_PUB and FND_API conventions for error and message handling, and it respects FND_PROFILE settings for environment-sensitive behavior. It is valid in both Oracle EBS 12.1.1 and 12.2.2, with dependency structures reflecting the respective CCP and table definitions of each release.