Search Results get_prior_year_status

Overview

FV_SLA_UTL_PROCESSING_PKG is a utility package in the Oracle E-Business Suite Federal Financials (FV) product family, responsible for supporting Subledger Accounting (SLA) event processing, fund validation, and ledger/segment derivation for federal treasury transactions. The package is owned by APPS and executes with AUTHID CURRENT_USER, meaning it runs under the privileges of the calling schema rather than as a definer-rights package. Its primary role is to assemble the accounting attribute values and fund control information needed to create and validate SLA journal entries for treasury, payment, and confirmation events processed by the FV application.

Internally, the package declares strongly typed PL/SQL record and collection types — including LedgerRecType/LedgerTabType, OrgRecType/OrgTabType, BankRecType/BankTabType, and fv_ref_detail based on FV_EXTRACT_DETAIL_GT — that cache ledger, operating unit, and bank account attributes during processing. This caching design reduces repeated lookups against GL and CE tables while a batch of subledger events is being processed.

Key Procedures and Functions

The package exposes twenty documented procedures and functions, including helper routines such as TRACE, STACK_ERROR, DUMP_GT_TABLE, and CHECK_ERRORS that support diagnostics and error handling, and INSERT_FV_XLA_ACC_ERRORS, which records SLA accounting errors against an application, message name, entity, event, and ledger context.

Attribute derivation routines include GET_LEDGER_INFO, GET_SEGMENT_VALUES, GET_ORG_INFO, GET_BANK_ACCOUNT_INFO, GET_BANK_CASH_ACCOUNT, and GET_FED_NON_FED_IND, which populate ledger, accounting flexfield segment, operating unit, bank account, and federal/non-federal indicator values used in accounting rule evaluation.

Fund control logic is handled by GET_FUND_DETAILS, GET_FUND_INFORMATION, GET_PRIOR_YEAR_STATUS, GET_ANTICIPATED_TS_AMT, and PYA_PROCESSOR. GET_FUND_INFORMATION is the procedure most relevant to the searched term; it resolves fund parameter and treasury symbol attributes required for fund availability checking and budget execution within the FV module. Related procedures such as GET_ANTICIPATED_TS_AMT and PYA_PROCESSOR provide anticipated treasury symbol amounts and prior-year adjustment processing for federal fiscal-year mapping.

Rounding out the package are INIT_EXTRACT_RECORD and GET_SLA_DOC_BALANCES, which initialize the extract detail structure and compute document balances passed to SLA for journal creation.

Tables Accessed

The package reads configuration and reference data from GL_LEDGERS, FND_ID_FLEX_SEGMENTS, FND_SEGMENT_ATTRIBUTE_VALUES, and GL_CODE_COMBINATIONS to derive ledger and accounting flexfield attributes. Fund and treasury configuration is sourced from FV_FUND_PARAMETERS, FV_TREASURY_SYMBOLS, and FV_OPERATING_UNITS_ALL. Bank and cash information comes from CE_BANK_ACCT_USES_ALL and CE_GL_ACCOUNTS_CCID. Prior-year adjustment mapping uses FV_PYA_FISCALYEAR_MAP and FV_PYA_FISCALYEAR_SEGMENT, while balance and hierarchy lookups use GL_BALANCES, GL_ACCOUNT_HIERARCHIES, and GL_BC_PACKETS. Processing diagnostics are logged through FV_EXTRACT_DETAIL_GT_LOGS.

Usage Notes

FV_SLA_UTL_PROCESSING_PKG is not typically invoked directly by end users. It is called by higher-level FV subledger accounting and extract programs, and the metadata indicates it is referenced by six other packages. It executes within the context of SLA event processing and concurrent extract routines, using Temporary Global Temporary Table structures such as FV_EXTRACT_DETAIL_GT for intermediate results. Extensions or customizations should preserve the AUTHID CURRENT_USER behavior, as downstream SLA processing depends on the calling session's privileges and context.