Results for “budget_authority_type”
2 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
FV_BE_XLA_PKG is the Budget Execution subledger accounting integration package for Oracle E-Business Suite Public Sector / Federal Financials (FV) applications. Its core responsibility is to create and manage Subledger Accounting (SLA) events for Budget Execution transactions and Reprogram Budget Execution transactions. The package maps budget execution business activities to the Oracle Subledger Accounting (XLA) event model, specifically supporting Budget Authority (BA) reserve events and Fund Distribution (FD) reserve events. The constant definitions at the top of the package body reveal its accounting event taxonomy: the BUDGET_AUTHORITY_TYPE constant is set to 'BA_RESERVE' and the FUND_DISTRIBUTION_TYPE constant is set to 'FD_RESERVE', which directly corresponds to the search term fund_distribution_type that surfaced this object. Parallel constants exist for reprogram activity: RPR_BUDGET_AUTHORITY_TYPE ('RPR_BA_RESERVE') and RPR_FUND_DISTRIBUTION_TYPE ('RPR_FD_RESERVE'). The package thus functions as the bridge between Federal Financials budget execution tables and the GL Subledger Accounting engine, ensuring that budgetary reserve activity is properly captured, accounted, and transferred to General Ledger.
Key Procedures and Functions
- BUDGETARY_CONTROL — The principal processing routine of the package. It performs budgetary control validation and drives the creation of Subledger Accounting events for budget execution and reprogram transactions. It is the mechanism through which BA Reserve and FD Reserve event types are populated into the XLA event infrastructure.
- GET_CCID — A helper function that resolves a Code Combination ID (CCID) for the accounting flexfield, returning the identifier required to build the accounting entry lines associated with budget execution events.
The package also declares extensive global state used across its routines, including g_event_class, g_application_id, g_event_type, g_doc_type, g_entity_code, g_doc_id, g_entity_id, g_ledger_id, and g_accounting_date. These variables carry context between calls, and the header comment indicates the source version from 2007, consistent with the 12.1.1 lineage carried into 12.2.2.
Tables Accessed
The package operates against both Federal Financials and Subledger Accounting tables through APPS synonyms. On the budget execution side it reads and processes FV_BE_TRX_DTLS and FV_BE_RPR_TRANSACTIONS, the detail and reprogram transaction sources that define budget execution activity. On the SLA side it works with XLA_EVENTS, which stores the accounting events generated, and the global temporary table PSA_BC_XLA_EVENTS_GT, used to stage or process budget execution events. GL_BC_PACKETS supports the budgetary control packet mechanism, while GL_LEDGERS supplies ledger context. Supporting lookups against FND_APPLICATION, FND_RESPONSIBILITY, and FND_USER are used to resolve application identifiers and audit information. The GET_CCID function works against the accounting flexfield combination tables to resolve the CCID required for accounting entries.
Usage Notes
FV_BE_XLA_PKG is an internal integration package, classification OTHER, and is not intended to be invoked directly by end users. It is referenced by four other packages, indicating it sits within a call chain driven by the Budget Execution and Subledger Accounting event creation processes. It is typically invoked when budget execution transactions are processed, when reprogram transactions are submitted, or when Create Accounting is executed for the FV subledger application. Customizations that extend Federal Financials budgetary accounting should extend rather than modify this package, since the constants such as FD_RESERVE and RPR_FD_RESERVE are referenced by the SLA event model and changing them would break event classification. The GET_CCID function may be called independently where custom logic needs an accurate accounting flexfield combination identifier for a budget execution entry.