Search Results check_agreement_dates

Overview

FV_PO_VALIDATE_GRP is a PL/SQL package body owned by the APPS schema within Oracle E-Business Suite. Its name and documented contents indicate that it belongs to the Federal Financials (FV) module family, specifically supporting agreement and commitment validation for Purchasing documents. The package provides server-side validation logic that verifies whether a purchasing agreement is valid against date and funding criteria before commitment or obligation data is accepted. Its header revision (FVPOVALB.pls 120.1) reflects a long-standing component of the FV codebase and is present in both Oracle EBS 12.1.1 and 12.2.2.

The central business purpose of the package is to confirm that agreement dates are consistent with commitment start and end dates, fund expiration dates, and reimbursement eligibility. It is the enforcement point that prevents users from obligating funds against stale or expired agreements during purchasing activity in federal implementations.

Key Procedures and Functions

The documented metadata lists a single procedure, CHECK_AGREEMENT_DATES. Based on the source excerpt, it accepts a code combination identifier, an organization identifier, a ledger identifier, a caller indication, and a set of attribute values, and returns an output status and message. Its logic retrieves the FV_VERIFY_REIMBURSABLE_DATES and FV_WARNING_MESSAGE profile options and returns immediately unless reimbursable date verification is enabled.

Once enabled, the procedure determines the balancing segment for the ledger, resolves the agreement number, start date, and end date columns, and compares agreement dates against commitment start and end dates and fund expiration. It classifies the outcome as success, warning, or error and populates the out parameters with the resulting status and message. An internal helper, get_balance_segment, is declared to resolve the balancing segment name for a given ledger.

Tables Accessed

• FV_FUND_PARAMETERS — supplies fund category and related funding parameters used to evaluate agreement validity.
• FV_TREASURY_SYMBOLS — provides treasury symbol information associated with the funding source.
• GL_CODE_COMBINATIONS — resolves the accounting flexfield combination and derives the balancing segment.
• RA_CUSTOMER_TRX — referenced to correlate agreement and reimbursement context within the receivables transaction data.
• DUAL — used for single-row evaluations and profile or expression checks.

Usage Notes

The package is classified as a group (GRP) API, meaning it is not intended for direct external calls but rather is invoked internally by other FV components. The metadata indicates it is referenced by one other package, consistent with its role as a subordinate validation service. It is typically triggered from purchasing or commitment entry flows, where the caller passes the code combination, organization, ledger, and descriptive flexfield attributes and evaluates the returned status and message. Because behavior is gated by the FV_VERIFY_REIMBURSABLE_DATES profile option, administrators control whether date validation and warning messaging are active. Custom code should invoke CHECK_AGREEMENT_DATES only through the supported validation flow and must handle the returned status and message rather than assuming a hard error.