Search Results transfer_fa_distribution




Overview
Explore in AI Chat

Overview

APPS.CSE_IFA_TRANS_PKG is a PL/SQL package in Oracle E-Business Suite that supports the transfer and adjustment of fixed asset distribution information as performed through the Internet Fixed Assets (IFA) module. The package name and its procedures indicate that it operates on intangible or capitalizable asset distributions, allowing a distribution line associated with an asset to be moved from a source location, expense account, or employee to a destination, or to be adjusted in place. The package is declared AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the calling schema and expect the calling session to have the necessary grants on the referenced Fixed Assets objects. The source header identifies revision 115.3, dated 2002, indicating the package has been stable across multiple EBS releases, including the 12.1.1 and 12.2.2 releases referenced in this documentation. The API classification in ETRM is listed as OTHER, reflecting that the package is a support utility rather than a fully public, documented open interface.

Key Procedures and Functions

  • TRANSFER_FA_DISTRIBUTION — Performs a transfer of a distribution quantity. It accepts the asset identifier, book type, number of units being moved, and the source and destination combinations of location, expense account (CCID), and employee. Optional employee parameters default to NULL. On completion it returns the newly created source and destination distribution identifiers together with a return status and error message. The procedure is the entry point invoked when a user moves part or all of an asset distribution from one assignment to another.
  • ADJUST_FA_DISTRIBUTION — Performs an in-place adjustment of an existing distribution. It accepts the asset identifier, book type, units, and the revised location, expense account, and optional employee, and returns the identifier of the newly created or revised distribution along with a return status and error message. This procedure is used when the target attributes of a distribution change without a corresponding source-to-destination transfer.

Both procedures return a status indicator and an error message, following the standard EBS API convention that allows the caller to inspect x_return_status and x_error_msg rather than relying solely on exceptions.

Tables Accessed

  • FA_DISTRIBUTION_HISTORY — Records the distribution history for assets. This is the principal table read and written by both procedures to create, update, or retire distribution rows and to preserve an audit trail of the change.
  • FA_MASS_EXTERNAL_TRANSFERS and FA_MASS_EXTERNAL_TRANSFERS_S — Staging tables for external transfer processing, accessed when transfers are processed in bulk or when the distribution change must be recorded for downstream mass transfer processing.
  • DUAL — Used for single-row computations, default assignments, and value validation.

Usage Notes

The package is typically invoked indirectly rather than by end users. It is called by the Internet Fixed Assets responsibility when a user edits an asset distribution in the IFA forms, and it is available for invocation from custom PL/SQL code that needs to replicate a transfer or adjustment programmatically. Because the API classifies the procedures as OTHER and the source header carries no explicit public API comment, callers should treat the package as an internal utility and not as a supported open interface; the standard practice is to call the Fixed Assets public APIs where they exist and to use this package only where no public alternative is available. The package is referenced by three other packages in the ETRM repository, confirming its role as a shared internal dependency within the CSE (Common Services Environment) asset integration layer. All calls should be made within a properly initialized EBS session with the correct organization and security context, and the returned status and error message should always be checked before committing the transaction.