Search Results fv_debug_flag

Overview

The APPS.FV_AP_PREPAY_PKG package is a PL/SQL program unit in the Oracle E-Business Suite (EBS) Financials for Public Sector / Federal Financials (FV) module. It provides supporting logic for the processing of accounts payable prepayments in a funds-control environment. In the federal accounting model, prepayments disburse cash before goods or services are received, and the associated obligations and commitments must be tracked against budgetary authority. This package supplies the internal routines that reserve funds for prepayments, validate tolerance thresholds, create the corresponding prepayment distribution lines, and derive prorated amounts across multiple accounting distributions.

Although FV_AP_PREPAY_PKG is classified as an OTHER API, its presence in the APPS schema and its dependency on AP_APPROVAL_PKG, FND_PROFILE, and AP_INVOICE_DISTRIBUTIONS confirms it operates as an integration layer between Funds Reservation (FV) and Payables (AP). Its status is VALID in both EBS 12.1.1 and 12.2.2, meaning the same package contract is preserved across both releases.

Key Procedures and Functions

• FUNDS_RESERVE — Reserves budgetary funds for the prepayment prior to its approval and payment. It applies the FV funds-check model to the prepayment amount so that the expenditure is committed against the correct operating unit and budget line.
• TOLERANCE_CHECK — Validates whether the prepayment amount falls within configured tolerance limits. A failure here typically prevents the prepayment from being reserved or approved, protecting the organization from over-obligating outside policy.
• CREATE_PREPAY_LINES — Constructs the prepayment distribution lines that must exist on the AP invoice so downstream posting and liquidation functions can match the prepayment against later invoices.
• GET_PRORATED_AMOUNT — Computes the pro-rata share of the prepayment attributable to each invoice distribution. This supports splitting a single prepayment across multiple cost centres or accounting flexfields.

The documentation lists these four documented procedures/functions; no parameter signatures are reproduced here because the ETRM metadata does not expose them.

Tables Accessed

• AP_INVOICE_DISTRIBUTIONS — The primary Payables distribution table. The package reads existing distributions for proration and writes the new prepayment lines created by CREATE_PREPAY_LINES.
• FV_OPERATING_UNITS — Provides operating unit context and default ledger information required for funds reservation and tolerance evaluation.
• PO_LINE_LOCATIONS_ALL — Supplies purchase-order line/location details so that prepayment lines can be linked to the correct PO shipment, supporting the three-way match and later liquidation.

Additional dependencies include the profile option facility (FND_PROFILE) to obtain runtime settings, and AP_APPROVAL_PKG, which the package invokes as part of the invoice approval workflow.

Usage Notes

The package is not intended for direct invocation by end users. It is invoked internally during AP invoice processing when the invoice type identifies a prepayment, particularly within Oracle Federal Financials or Public Sector installations where budgetary funds control is enforced. Typical triggers are the Payables Invoice Workbench, the Payables Approval workflow, and any custom routine that programmatically creates prepayment invoices. Custom code may call the package where additional control over prepayment creation is needed, but this requires careful coordination with funds reservation, since a missed reservation causes posting failures. Because the package relies on AP_APPROVAL_PKG and profile-driven tolerances, it should not be copied or modified; extensions should be made through supported hooks. Corroborating the ETRM metadata, the package shows no referenced-by relationships to other documented packages, confirming it sits at the end of the dependency chain rather than serving as a shared utility.