Results for “fv_be_xla_pkg”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The APPS.FV_BE_XLA_PKG package is a component of the Oracle E-Business Suite Federal Budget Execution (FV) module, operating within the Subledger Accounting (XLA) integration layer. Its principal business function is to bridge budget execution transaction data with the Oracle Subledger Accounting engine, ensuring that budgetary events originating in the FV module are captured, evaluated, and accounted for in a manner consistent with the Accounting Methods Builder (AMB) definitions configured for the ledger. In Oracle EBS 12.1.1 and 12.2.2, this package participates in the flow by which budgetary control packets and transaction details are transformed into subledger accounting events and journal entries.
The package is classified as a custom/OTHER API within the APPS schema and holds a VALID status in the ETRM metadata. It demonstrates bidirectional dependencies across the FV module and the XLA infrastructure, indicating that it is tightly coupled to both budgetary control processing and the subledger accounting event model.
Key Procedures and Functions
The documented interface for FV_BE_XLA_PKG consists of two callable units:
- BUDGETARY_CONTROL — Encapsulates the budgetary control logic used when processing Federal Budget Execution transactions for subledger accounting purposes. This routine is responsible for applying the budgetary control rules and determining the accounting treatment of the budgetary event before it is forwarded to the XLA engine.
- GET_CCID — Returns or resolves the Code Combination Identifier (CCID) associated with a budgetary accounting line. This supports the mapping of budgetary transaction attributes to the appropriate general ledger accounting flexfield combination, enabling correct accounting derivation.
The metadata does not disclose parameter signatures for either routine; therefore no parameter lists are asserted here. Both units are exposed within the APPS schema and are referenced by dependent views and packages.
Tables Accessed
The package reads from and writes to the following documented tables via APPS synonyms:
- FV_BE_RPR_TRANSACTIONS and FV_BE_TRX_DTLS — Source budget execution transactions and their detail lines, forming the input to budgetary control and accounting derivation.
- GL_BC_PACKETS — Stores budgetary control packet data that links budgetary events to accounting events for the Subledger Accounting engine.
- XLA_EVENTS and PSA_BC_XLA_EVENTS_GT — The subledger accounting event table and its global temporary staging table, used to register and stage accounting events for processing.
- GL_LEDGERS — Ledger definition data used to resolve the accounting configuration applicable to the transaction.
- FND_APPLICATION, FND_RESPONSIBILITY, and FND_USER — Standard application and security context tables used for auditing and contextual lookups.
Usage Notes
FV_BE_XLA_PKG is typically invoked indirectly rather than by end users. It is referenced by the FV_BE_BA_FD_DTL_V, FV_BE_BA_FD_HDR_V, and FV_BE_RPR_DTL_V views, which surface derived budgetary and accounting attributes to forms and reports, and by the FV_BE_FUND_PKG package, which coordinates fund-level budget execution processing. It is also referenced by four other packages within the ETRM ecosystem.
Invocation generally occurs during budgetary control processing and Subledger Accounting event creation, either as part of the standard FV budget execution concurrent programs or as a dependency resolved through view access in the Budget Execution forms. Customizations and extensions should call the documented procedures rather than manipulating the underlying tables directly, preserving the integrity of the XLA event flow and the budgetary control accounting derivation.
-
PACKAGE: APPS.FV_BE_XLA_PKG 12.1.1
-
PACKAGE: APPS.FV_BE_XLA_PKG 12.2.2
-
PACKAGE: APPS.FV_BE_XLA_PKG 12.1.1
-
SYNONYM: APPS.FV_BE_TRX_DTLS 12.2.2
-
12.1.1 DBA Data 12.1.1
-
PACKAGE: APPS.FV_BE_XLA_PKG 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
SYNONYM: APPS.FV_BE_TRX_DTLS 12.1.1
-
12.2.2 DBA Data 12.2.2
-
SYNONYM: APPS.GL_BC_PACKETS 12.2.2
-
SYNONYM: APPS.GL_BC_PACKETS 12.1.1
-
PACKAGE: APPS.FV_BE_FUND_PKG 12.1.1
-
PACKAGE: APPS.FV_BE_FUND_PKG 12.2.2
-
View: FV_BE_BA_FD_HDR_V 12.2.2
The main purpose of this view is used as Transaction extract headers for SLA to identify the sources
APPS.FV_BE_BA_FD_HDR_V·↳ FV_BE_TRX_DTLS·↳ FV_BE_TRX_HDRS·↳ FV_BE_XLA_PKG·Explore FV module →
-
View: FV_BE_RPR_DTL_V 12.1.1
The main purpose of this view is used as RPR Transaction Extract lines for SLA to identify the sources.
APPS.FV_BE_RPR_DTL_V·↳ FND_FLEX_EXT·↳ FV_BE_ACCOUNT_PAIRS·↳ FV_BE_RPR_TRANSACTIONS·Explore FV module →
-
SYNONYM: APPS.XLA_EVENTS 12.1.1
-
View: FV_BE_BA_FD_HDR_V 12.1.1
The main purpose of this view is used as Transaction extract headers for SLA to identify the sources
APPS.FV_BE_BA_FD_HDR_V·↳ FV_BE_TRX_DTLS·↳ FV_BE_TRX_HDRS·↳ FV_BE_XLA_PKG·Explore FV module →
-
SYNONYM: APPS.XLA_EVENTS 12.2.2
-
View: FV_BE_BA_FD_DTL_V 12.1.1
The main purpose of this view is used as Transaction Extract lines for SLA to identify the sources
APPS.FV_BE_BA_FD_DTL_V·↳ FV_BE_ACCOUNT_PAIRS·↳ FV_BE_TRANSACTION_TYPES·↳ FV_BE_TRX_DTLS·Explore FV module →
-
View: FV_BE_RPR_DTL_V 12.2.2
The main purpose of this view is used as RPR Transaction Extract lines for SLA to identify the sources.
APPS.FV_BE_RPR_DTL_V·↳ FND_FLEX_EXT·↳ FV_BE_ACCOUNT_PAIRS·↳ FV_BE_RPR_TRANSACTIONS·Explore FV module →
-
View: FV_BE_BA_FD_DTL_V 12.2.2
The main purpose of this view is used as Transaction Extract lines for SLA to identify the sources
APPS.FV_BE_BA_FD_DTL_V·↳ FV_BE_ACCOUNT_PAIRS·↳ FV_BE_TRANSACTION_TYPES·↳ FV_BE_TRX_DTLS·Explore FV module →
-
VIEW: APPS.FV_BE_BA_FD_DTL_V 12.2.2
-
VIEW: APPS.FV_BE_BA_FD_DTL_V 12.1.1
-
VIEW: APPS.FV_BE_BA_FD_HDR_V 12.1.1
-
VIEW: APPS.FV_BE_BA_FD_HDR_V 12.2.2
-
VIEW: APPS.FV_BE_RPR_DTL_V 12.2.2
-
VIEW: APPS.FV_BE_RPR_DTL_V 12.1.1