Search Results igc_cbc_po_year_end_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGC_CBC_PO_YEAR_END_PKG package is a PL/SQL database object in the Oracle EBS Applications (APPS) schema that supports fiscal year-end processing for Commitment Budgetary Control (CBC) as applied to purchase orders and their associated payables activity. It belongs to the IGC (Internet Government Contracting) product family, which provides the commitment control and budgetary accounting infrastructure used by public sector and government-oriented implementations of Oracle E-Business Suite. In EBS 12.1.1 and 12.2.2, this package is documented as a VALID package owned by APPS, with a classification of OTHER rather than a formal public API, indicating it is primarily an internal processing utility invoked during period-close and year-end routines.

The package addresses the requirement to reconcile and carry forward commitment balances at fiscal year end. It gathers purchase order distribution data, matches it against invoice and payment activity recorded in Payables, validates the open accounting period via General Ledger, and produces budgetary control packets for the affected periods. Its single documented entry point encapsulates the entire year-end execution path.

Key Procedures and Functions

The ETRM metadata documents one procedure or function for this package:

  • YEAR_END_MAIN — The primary driver procedure of the package. It orchestrates the year-end commitment control process, coordinating the reading of purchase order, invoice, and payment data, applying period and currency validation, writing exception records where data problems are detected, and generating or updating budgetary control packet information. As an internal routine, it is not intended for direct invocation by external custom code without a full understanding of the surrounding concurrent program context and the state it expects in the CBC staging tables.

No additional procedures or functions are documented in the ETRM metadata; the package's logic is therefore concentrated in this single controlling routine.

Tables Accessed

The package references the following tables through APPS synonyms, which reveal the scope of its processing:

Usage Notes

IGC_CBC_PO_YEAR_END_PKG is referenced by no other documented package, confirming that it sits at or near the top of its call hierarchy rather than serving as a shared utility. Invocation is normally expected through a concurrent program or a period-close/year-end processing menu function within the IGC/CBC module, scheduled as part of the standard fiscal close calendar. Because the ETRM record classifies it as OTHER and exposes only the YEAR_END_MAIN entry point, customizations should generally avoid calling it directly; instead, the supported approach is to run the parent concurrent request and to monitor IGC_CBC_PO_PROCESS_EXCPTS_ALL for exceptions generated during execution. Administrators should confirm that the relevant GL period is open and that Payables data is complete before initiating the run, since the logic depends on current invoice and payment information to resolve commitment balances correctly.