Search Results fnd_log




Overview
Explore in AI Chat

Overview

FV_SLA_PROCESSING_PKG is the Subledger Accounting (SLA) processing engine for Oracle Federal Financials fund value accounting within Oracle E-Business Suite 12.1.1 and 12.2.2. It coordinates the posting of accounting events originating in fund value transactions to the Subledger Accounting model. The package name "FVXLAACB" in its header reveals its role: Fund Value (FV) to XLA (Subledger Accounting) Accounting (A) Cost/Accounting (B) bridging. It functions as the glue that connects source fund value transactions to SLA event processing, extracts fund value detail, and hands event data to the Subledger Accounting engine for journal creation.

The package body declares a comprehensive FND logging framework that references FND_LOG at multiple severity levels, making this relevant to the user's fnd_log search. Standard logging declarations include statement, procedure, event, exception, error, and unexpected levels, along with the current runtime level and a qualified path name of fv.plsql.fvxlaacb.fv_sla_processing_pkg.

Key Procedures and Functions

  • PREACCOUNTING — Prepares the fund value source data and event information ahead of the accounting extraction phase. It establishes the processing context that subsequent procedures consume.
  • EXTRACT — Extracts fund value detail into the processing structures. The body declares a FV_EXTRACT_DETAIL_GT rowtype collection and an FV_EXTRACT_REC record type carrying event ID, line number, fund value, fund category, fund expired status, fund time frame, and prior year flag. This procedure drives that extraction.
  • POSTPROCESSING — Handles cleanup and state management after extraction but before or around accounting creation.
  • POSTACCOUNTING — Executes finalization steps once accounting has been generated.

Tables Accessed

The most directly documented structure is FV_EXTRACT_DETAIL_GT, a global temporary table whose %ROWTYPE anchors both the fv_ref_detail collection and the fv_extract_rec record. This table temporarily stages fund value extraction detail—fund value, category, expired status, time frame, and prior year flag—before SLA processing consumes it. The package's ETRM entry lists no additional table references via APPS synonyms, indicating that the documented interaction is concentrated on the extraction staging structure and SLA event interfaces rather than direct base-table DML.

Usage Notes

This package is invoked as part of the fund value Subledger Accounting flow, typically from concurrent programs or the Create Accounting process rather than from a user-facing form. It is referenced by one other package, confirming it is a subordinate component in a larger processing chain. Because it emits diagnostics through the FND_LOG hierarchy with a fixed path name, DBAs and developers troubleshoot issues by enabling FND logging at the appropriate level for the fv.plsql.fvxlaacb.fv_sla_processing_pkg module and reviewing the corresponding FND_LOG_MESSAGES entries. The internal g_log_enabled flag and staged g_stage/g_rownum/g_func_name tracking variables indicate cycle-level instrumentation useful when tracing extraction anomalies such as unexpected fund categories or expired fund statuses.