Search Results fv_ccr_reg_status

Overview

FV_CCR_GRP is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Federal Financials product family and supports the Central Contractor Registration (CCR) integration that is mandatory for U.S. federal government transactions. CCR requirements obligate agencies to verify that vendors, grantees, and payees hold an active registration before awards, contracts, or payments are issued. FV_CCR_GRP provides the shared low-level lookup logic that other Oracle modules call to determine CCR registration status, federal vendor classification, and the suitability of a vendor's bank account for federal payment processing.

The package is classified as a GRP object, meaning it functions as a grouping or utility layer rather than a standalone business API. Its value lies in centralizing CCR validation rules so that Payables, Purchasing, Receivables, and third-party payment flows apply identical criteria. It resides in the APPS schema, depends on SYS.STANDARD, and is exposed to other applications through standard APPS synonyms.

Key Procedures and Functions

• FV_IS_CCR — Primary CCR evaluation routine. Determines whether a given vendor or party is subject to Central Contractor Registration requirements and returns the corresponding indicator.
• FV_CCR_REG_STATUS — Returns the CCR registration status for a supplier, allowing callers to distinguish active, expired, or unregistered entities before proceeding with federal transactions.
• IS_VENDOR_FEDERAL — Classifies a vendor as federal or non-federal. This classification drives downstream decisions about whether CCR and third-party payment rules apply.
• FV_IS_BANK_ACCOUNT_USES_CCR — Evaluates whether a specific bank account is governed by CCR requirements, typically based on the owning vendor's federal status and registration state.
• SELECT_THIRD_PARTY — Retrieves third-party payment designation data associated with a supplier, supporting third-party payment (TPP) processing.
• SELECT_BANK_ACCOUNT — Retrieves bank account information required for CCR and third-party payment validation.

Tables Accessed

The package references two application tables through APPS synonyms:

• FV_CCR_ORGS — Stores CCR organization-level registration data, including registration status and effective information used by FV_CCR_REG_STATUS and FV_IS_CCR.
• FV_CCR_VENDORS — Holds vendor-level CCR registration and federal classification data, queried by IS_VENDOR_FEDERAL and related routines.

Bank account selection logic in SELECT_BANK_ACCOUNT also draws on bank account data exposed through the Oracle Payments and Payables schema, filtered by the CCR rules evaluated in FV_IS_BANK_ACCOUNT_USES_CCR.

Usage Notes

FV_CCR_GRP is a dependency-level utility rather than a user-invoked program. It is referenced by seven other packages, including AP_UTILITIES_PKG, ARP_TRX_UTIL, FV_CCR_UTIL_PVT, POS_UTIL_PKG, PO_FV_INTEGRATION_PVT, and PO_VAL_HEADERS2, as well as the FV_TPP_ASSIGNMENTS_V view. This reference pattern shows that CCR validation is triggered indirectly during supplier entry, invoice validation, purchase order validation, and payment processing within Oracle Federal Financials.

Custom code extending federal financials should call these functions instead of querying FV_CCR_ORGS or FV_CCR_VENDORS directly, because the package encapsulates registration and federal-classification logic that must remain consistent across modules. Because the metadata does not publish parameter signatures, integrators should inspect the package specification in the target environment before coding against it.