Search Results psa_fa_invoice_distributions




Overview
Explore in AI Chat

Overview

PSA_FA_INVOICE_DISTRIBUTIONS is an Oracle EBS PL/SQL package owned by the APPS schema and defined with AUTHID CURRENT_USER. It is a supporting component of the Payables/Purchasing (PSA) to Fixed Assets integration, providing the server-side logic used to evaluate Accounts Payable invoice distributions and determine which ones qualify as asset acquisitions. In this role the package bridges the Payables subledger and the Fixed Assets module, ensuring that capitalized invoice lines are identified and tracked before they are transferred to asset records. The package contains both data-manipulation logic and report-formatting routines, indicating that it is invoked both by batch processes and by printed output such as the Asset Tracking report. The source header identifies the file as PSAFATAS.pls (version 120.3.12010000.2, last modified 2009/04/17), consistent with the 12.1.1 and 12.2.2 code lines.

Key Procedures and Functions

The package exposes three documented procedures:

  • UPDATE_ASSETS_TRACKING_FLAG — The core business routine. It accepts selection criteria covering the ledger, chart of accounts, a GL date range, and an account range, and returns an error buffer and return code to the caller. Its purpose is to scan the relevant Payables invoice distribution data for the specified ledger and accounting period range and set the asset tracking indicator on qualifying distributions, thereby marking them for asset processing in Fixed Assets.
  • PRINT_HEADER_INFO — A reporting helper that renders the header portion of the Asset Tracking report output. It receives the GL date range and account range as DATE and VARCHAR2 values respectively so that the printed report reflects the same selection criteria passed to the update routine.
  • PRINT_INVOICE_DETAILS — A reporting helper that prints the detailed invoice and distribution lines for a single invoice, keyed by invoice identifier. It is called repeatedly by the report driver to produce line-level output.

The caller-facing parameters that are documented include p_ledger_id, p_chart_of_accounts, p_from_gl_date, p_to_gl_date, p_from_account, and p_to_account on UPDATE_ASSETS_TRACKING_FLAG; note that this procedure declares the date parameters as VARCHAR2, whereas PRINT_HEADER_INFO declares them as DATE. The searched term p_from_gl_date is the lower bound of the accounting date range used to restrict which invoice distributions are evaluated or reported.

Tables Accessed

The package operates against the Payables invoice tables through APPS synonyms:

Reads are used to identify candidate distributions within the ledger, account, and GL date range; writes are directed at the distribution rows to set the asset tracking indicator.

Usage Notes

PSA_FA_INVOICE_DISTRIBUTIONS is not a public API and is not referenced by any other package, so it is normally invoked indirectly rather than through direct custom calls. Typical invocation paths are the Payables to Fixed Assets integrity and transfer processes and the associated Asset Tracking report, where UPDATE_ASSETS_TRACKING_FLAG performs the flag maintenance step before asset transfer and PRINT_HEADER_INFO and PRINT_INVOICE_DETAILS supply the report layout. Custom code should reference the package only after confirming the exact signature in the target release, since the date parameters differ in datatype between procedures. Because it is declared AUTHID CURRENT_USER, effective privileges derive from the invoking schema, and the package should be called within the APPS or a suitably privileged context with the correct ledger, chart of accounts, and GL date range supplied.