Search Results fa_afe_transactions_pkg




Overview
Explore in AI Chat

Overview

FA_AFE_TRANSACTIONS_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports Oracle Assets (Fixed Assets) processing for Authorizations for Expenditure (AFE) related transactions. The package encapsulates the business logic used to convert capital, expensed, and dry-hole AFE expenditure into asset transactions within the FA module. In the EBS 12.1.1 and 12.2.2 releases the package is classified as an "OTHER" API rather than a formally published public interface, meaning it is primarily intended for internal consumption by other Oracle Assets components and by extension code, but it remains accessible to custom development where AFE-style capitalization logic must be replicated or extended.

The package depends on FA_API_TYPES, the shared record and table type definitions used across the Oracle Assets API layer, which confirms that its procedures are designed to operate on the standard inline API structures rather than on ad-hoc parameter sets. It is itself referenced by FA_AFE_TRANSACTIONS_PKG (recursive internal reference) and by FA_TRANSACTION_ITF_PKG, the transaction interface package that populates and validates records prior to asset creation.

Key Procedures and Functions

The package exposes three documented procedures:

  • PROCESS_CAPITALIZE — Handles AFE expenditure that is to be capitalized, driving the creation or adjustment of asset records for amounts that qualify as capital cost.
  • PROCESS_DRY_HOLE — Handles dry-hole expenditure, the portion of exploration cost that is written off rather than capitalized, applying the appropriate accounting treatment through the assets subledger.
  • PROCESS_EXPENSE — Handles AFE amounts to be expensed, routing them through the expense rather than capitalization path.

Consistent with ETRM documentation, no parameter lists are reproduced here; the procedures are named and described by purpose only. In practice each procedure consumes the shared FA_API_TYPES structures and the source interface data to determine the correct routing of the AFE transaction.

Tables Accessed

The documented table references (via APPS synonyms) are:

  • FA_BOOKS — The depreciation books holding asset cost and adjustment rows; capitalized and expensed AFE amounts are written here.
  • FA_BOOK_CONTROLS — Book-level control information that governs period and posting status during the AFE transaction.
  • FA_DEPRN_PERIODS — Depreciation period definitions used to identify the open period into which the transaction is posted.
  • FA_DISTRIBUTION_HISTORY — Distribution lines recording the account and amount detail for the generated asset transactions.
  • GL_CODE_COMBINATIONS — The chart of accounts segments used to resolve the accounting flexfield for distributed amounts.
  • PLITBLM — The standard Oracle Applications PL/SQL table used for array processing during the transaction.

Together these tables support the full lifecycle: selecting the target book and period, creating or updating asset cost rows, and recording distribution and accounting detail.

Usage Notes

FA_AFE_TRANSACTIONS_PKG is typically invoked from within the Oracle Assets transaction pipeline rather than directly from a form or concurrent program. It is referenced by FA_TRANSACTION_ITF_PKG, indicating that AFE transaction processing is triggered as part of the transaction interface and post-processing flow. Custom code that needs to replicate AFE capitalization, expensing, or dry-hole logic can call the package from PL/SQL, but because it is classified as "OTHER" and is not part of the published public API set, callers should expect signature changes across patches and releases. Direct invocation should therefore be limited to controlled extensions, and any such call should be validated against the FA_API_TYPES structures and the current open depreciation period established in FA_DEPRN_PERIODS and FA_BOOK_CONTROLS.