Search Results fa_cip_pub




Overview
Explore in AI Chat

Overview

FA_CIP_PUB is a public PL/SQL API package in the Oracle E-Business Suite Fixed Assets (FA) product, owned by the APPS schema and classified as a PUB (public) interface. Its stated purpose, per the package header comment, is to "capitalize assets and reverse capitalization of assets." The package therefore serves the construction-in-process (CIP) lifecycle within Oracle Assets, providing a programmatic interface for moving a CIP asset into capitalized status and for undoing that capitalization when it was performed in error or must be rolled back. The package is declared with AUTHID CURRENT_USER, meaning that privileges are evaluated against the invoking schema rather than the package owner. It is registered with a compatibility level of "S" (supported) and carries a business entity category of FA_ASSET. The header identifies the package as originating from the FAPCIPS.pls script (version 120.3) and references MetaLink note 206480.1, the CIP API Documentation Supplement, as its supporting documentation.

Key Procedures and Functions

The package exposes two documented public procedures.

  • DO_CAPITALIZATION — Capitalizes a CIP asset. It is the forward operation of the CIP lifecycle, converting an asset that has been accumulated in a construction-in-process state into a capitalized asset. Its parameter signature follows the standard Oracle EBS API conventions, accepting an API version, initialization and commit flags, a validation level, and a calling-function name, and returning standard return status, message count, and message data outputs. It operates on three IN OUT record structures: a transaction record, an asset header record, and an asset financial information record. The display name registered for this procedure is "Capitalize Asset."
  • DO_REVERSE — Reverses the capitalization of a CIP asset. This is the procedure matched by the user's search term. It performs the inverse of DO_CAPITALIZATION, undoing a prior capitalization transaction so that the asset returns to its pre-capitalization CIP state. As with DO_CAPITALIZATION, the ETRM metadata documents the standard API control parameters and the transaction, asset header, and asset financial record structures, though the excerpt truncates the full parameter list. No parameters are invented here; only the documented control and record conventions are described.

Tables Accessed

The package operates against the following Fixed Assets tables through APPS synonyms:

  • FA_BOOKS and FA_MC_BOOKS_RATES — the asset book and multiple-reporting-currency book rate tables, which store the financial balances affected when capitalization is posted or reversed.
  • FA_BOOK_CONTROLS — the book control definitions, used to validate the target book and its accounting rules during the transaction.
  • FA_CATEGORY_BOOK_DEFAULTS — category/book default rules that determine the accounting and depreciation setup applied to the capitalized asset.
  • FA_TRANSACTION_HEADERS and FA_TRANSACTION_HEADERS_S — the transaction header tables that record the capitalization or reversal transaction itself.
  • DUAL and PLITBLM — used for single-row selection and for PL/SQL table (index-by table) handling within the package logic.

Usage Notes

FA_CIP_PUB is invoked programmatically rather than through direct form entry. Typical callers include Oracle Assets forms that process CIP capitalization, concurrent programs that batch-capitalize or reverse-capitalize CIP assets, and custom PL/SQL code that must integrate CIP capitalization into a broader business flow. Because it is a public API with a compatibility rating of "S," it is the supported integration point for this function. Callers should expect to populate the FA_API_TYPES transaction, asset header, and asset financial records before invocation and to inspect the returned status and message data for error handling. The ETRM metadata records that the package is referenced by three other packages within the APPS schema, confirming its role as a shared dependency in the Fixed Assets API layer. Version-specific behavior should be confirmed against the CIP API Documentation Supplement (MetaLink 206480.1) when implementing on EBS 12.1.1 or 12.2.2.