Search Results c_success
Overview
FV_SLA_PO_PROCESSING_PKG is an Oracle E-Business Suite PL/SQL package that belongs to the Federal Financials (FV) module and integrates purchasing transactions into the Subledger Accounting (SLA) architecture. Its principal business role is to create, populate and finalize the accounting events and journal entries generated from purchasing documents — purchase orders, purchase order distributions and their associated budgetary commitments — so that these transactions can be transferred into the General Ledger through the standard SLA posting process. The package forms part of the EBS Federal Funds and Treasury reporting flow, where each PO distribution must be tied to a treasury symbol and fund before its accounting can be recognized.
The package declares two numeric constants, c_FAILURE (value -1) and c_SUCCESS (value 0), which are returned by the public procedures to signal processing outcome. The c_success reference encountered by users searching for this term refers to this constant: a return value of zero indicates that the requested subledger accounting step completed without exception. The body also sets up FND_LOG levels and a diagnostic path name (fv.plsql.fvxlaacb.fv_sla_po_processing_pkg) and defines a record type, fv_pya_doc_info_rec, used to carry prior-year adjustment information such as ledger, event, fund, treasury symbol and currency amounts.
Key Procedures and Functions
Four documented entry points are exposed by this package, each corresponding to a stage in the subledger accounting lifecycle:
- PREACCOUNTING — Performs the setup work required before journal entries are created for a PO-derived event, including validation of the source transaction and the assembly of the accounting event data that the SLA engine will later process.
- EXTRACT — Extracts the purchasing transaction data required for accounting, mapping document, distribution and event identifiers to the SLA event structure so that downstream processing can generate headers and lines.
- POSTPROCESSING — Runs after the main accounting generation to apply any completion, reconciliation or cleanup logic to the processed events and their resulting entries.
- POSTACCOUNTING — Executes the steps that finalize accounting for the PO transactions, including any commitment adjustment handling controlled by the
g_ppo_commitment_flagglobal variable, and returns the success or failure status.
No parameter lists are reproduced here; the documented metadata identifies only the procedure names and their ordering in the accounting flow.
Tables Accessed
The package reads and writes the following objects through APPS synonyms:
- FV_FUND_PARAMETERS and FV_TREASURY_SYMBOLS — supply the fund and treasury symbol attributes required for federal accounting classification.
- PO_BC_DISTRIBUTIONS — the purchasing distribution detail that is the source of the accounting amounts and document references.
- XLA_EVENTS_GT and XLA_AE_HEADERS — the Subledger Accounting event and journal header structures that the package populates for downstream creation of accounting entries.
- PLITBLM — the standard EBS global temporary structure used for extended character handling during instruction processing.
Usage Notes
FV_SLA_PO_PROCESSING_PKG is invoked by the Subledger Accounting program infrastructure rather than by end users directly. In practice it is called when purchasing activity must be accounted and transferred to the General Ledger, normally through the SLA concurrent programs that drive the preaccounting, extraction, postprocessing and postaccounting phases in sequence. It is also referenced by one other documented package, indicating that it participates as a supporting component in a larger Federal Financials accounting chain. Customizations should avoid calling individual procedures out of order, because each phase depends on the event data prepared by the preceding step; the returned c_success value should be checked after every call to confirm that processing continued correctly. Review the FND_LOG output at the stated path name when diagnosing failures, since exception-level messages are written there.
-
PACKAGE BODY: APPS.FV_SLA_PO_PROCESSING_PKG
12.2.2
-
PACKAGE BODY: APPS.FV_SLA_FV_PROCESSING_PKG
12.2.2
-
PACKAGE BODY: APPS.FV_SLA_AR_PROCESSING_PKG
12.2.2
-
PACKAGE BODY: APPS.FV_SLA_UTL_PROCESSING_PKG
12.2.2
-
PACKAGE BODY: APPS.FV_SLA_AP_PROCESSING_PKG
12.2.2
-
PACKAGE BODY: APPS.FV_SLA_CST_PROCESSING_PKG
12.2.2
-
APPS.FV_SLA_AR_PROCESSING_PKG SQL Statements
12.2.2
-
PACKAGE: APPS.MSD_CONC_LOG_UTIL
12.2.2
-
PACKAGE: APPS.MSD_CONC_LOG_UTIL
12.1.1
-
PACKAGE: APPS.FEM_GLOBAL_VS_COMBO_UTIL_PKG
12.1.1
-
PACKAGE: APPS.FEM_HELPER_RULE_UTIL_PKG
12.1.1
-
PACKAGE: APPS.FEM_DIM_HIER_LOADER_PKG
12.1.1
-
PACKAGE BODY: APPS.FEM_DIM_SNAPSHOT_UTIL_PKG
12.1.1
-
PACKAGE BODY: APPS.FEM_ALLOC_BR_UTIL_PKG
12.1.1
-
PACKAGE: APPS.FEM_FACTOR_TABLES_UTIL_PKG
12.1.1
-
PACKAGE BODY: APPS.FEM_DIM_CAL_UTIL_PKG
12.1.1
-
PACKAGE: APPS.FEM_DIM_SNAPSHOT_UTIL_PKG
12.1.1
-
PACKAGE: APPS.FEM_GENDEFAULTS_ENG_PKG
12.1.1
-
PACKAGE: APPS.FEM_DIM_CAL_UTIL_PKG
12.1.1
-
PACKAGE: APPS.FEM_REFRESH_ENG_PKG
12.1.1
-
PACKAGE BODY: APPS.MSD_CONC_LOG_UTIL
12.2.2
-
PACKAGE BODY: APPS.MSD_CONC_LOG_UTIL
12.1.1
-
PACKAGE BODY: APPS.FEM_DIM_HIER_UTIL_PKG
12.1.1
-
PACKAGE: APPS.FEM_SETUP_PKG
12.1.1
-
PACKAGE: APPS.FEM_DIM_SNAPSHOT_ENG_PKG
12.1.1
-
PACKAGE BODY: APPS.FND_LOG_UTIL
12.2.2
-
PACKAGE BODY: APPS.FND_LOG_UTIL
12.1.1
-
PACKAGE BODY: APPS.FEM_DIM_SNAPSHOT_ENG_PKG
12.1.1
-
PACKAGE: APPS.FEM_DATA_LOADER_PKG
12.1.1
-
PACKAGE BODY: APPS.FEM_SETUP_PKG
12.1.1
-
PACKAGE: APPS.FEM_DIM_HIER_UTIL_PKG
12.1.1
-
PACKAGE BODY: APPS.FEM_DIMENSION_UTIL_PKG
12.1.1
-
PACKAGE BODY: APPS.FEM_HELPER_RULE_UTIL_PKG
12.1.1
-
PACKAGE BODY: APPS.FEM_GLOBAL_VS_COMBO_UTIL_PKG
12.1.1
-
PACKAGE BODY: APPS.FEM_DATABASE_UTIL_PKG
12.1.1
-
PACKAGE: APPS.FEM_DATABASE_UTIL_PKG
12.1.1
-
PACKAGE: APPS.FEM_COL_TMPLT_DEFN_API_PUB
12.1.1
-
PACKAGE: APPS.FEM_ALLOC_BR_UTIL_PKG
12.1.1
-
PACKAGE: APPS.FEM_TABLE_REGISTRATION_PKG
12.1.1
-
PACKAGE: APPS.FEM_COMP_DIM_MEMBER_LOADER_PKG
12.1.1
-
PACKAGE BODY: APPS.FEM_COL_TMPLT_DEFN_API_PUB
12.1.1
-
PACKAGE: APPS.XLA_ANALYTICAL_CRITERIA_PKG
12.2.2
-
PACKAGE: APPS.XLA_ANALYTICAL_CRITERIA_PKG
12.1.1
-
PACKAGE BODY: APPS.FEM_ADMIN_UTIL_PKG
12.1.1
-
PACKAGE: APPS.FEM_ENGINES_PKG
12.1.1
-
PACKAGE BODY: APPS.FND_LOG_ADMIN
12.2.2
-
PACKAGE BODY: APPS.FEM_ENGINES_PKG
12.1.1
-
PACKAGE: APPS.OPI_DBI_WMS_UTILITY_PKG
12.1.1
-
PACKAGE BODY: APPS.IBY_SCHED
12.1.1
-
PACKAGE: APPS.OPI_DBI_CURR_INV_EXP_PKG
12.1.1