Search Results igi_cis_ci36_data_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGI_CIS_CI36_DATA_PKG package is a component of the Oracle E-Business Suite public-sector reporting infrastructure known as IGI (International Government Information). Its name and structure associate it with the CIS (Construction Industry Scheme) statutory reporting requirements used in the United Kingdom, specifically the Inland Revenue form CI36. In the context of Oracle EBS 12.1.1 and 12.2.2, the package provides the data extraction layer that gathers withholding-tax and payment information from the Payables application and populates dedicated extract tables that subsequently feed the CI36 report format.

The package is classified in the ETRM metadata as an API classification of OTHER, meaning it is not a fully published, supported public API but rather an internal extract utility. It is owned by the APPS schema and declared with AUTHID CURRENT_USER, so it executes with the privileges of the calling session rather than as definer-rights code. This design is consistent with a concurrent-program-driven extract whose runtime authority is governed by the requesting user and the Payables security model rather than a hard-coded schema.

Key Procedures and Functions

The ETRM metadata documents a single procedure within the package:

  • EXTRACT_DATA — The sole documented entry point. It is responsible for orchestrating the extraction of CI36-relevant data for a requested reporting scope. The signature visible in the source excerpt accepts an error buffer and return code (standard concurrent-program completion outputs), a report identifier, an operating unit, a low and high date range, and a vendor identifier. The date and vendor parameters allow the extraction to be restricted to a specific reporting period and, optionally, a single supplier.

No additional procedures or functions are documented for this package in the supplied metadata. Consumers should treat EXTRACT_DATA as the only supported callable interface and should not assume the existence of other public routines.

Tables Accessed

The package reads and writes the following objects, referenced through APPS synonyms:

  • AP_INVOICES and AP_INVOICE_DISTRIBUTIONS — Source of invoice-level and distribution-level amounts, used to determine the payments and tax-relevant lines attributable to each supplier.
  • AP_CHECKS — Provides payment information, including payment dates and amounts, needed to reconcile invoices against disbursements.
  • AP_AWT_GROUPS — Supplies withholding-tax group definitions that govern how tax is calculated and reported for the affected transactions.
  • IGI_CIS_CI36_EXTRACT and IGI_CIS_CI36_PAYMENTS — Destination extract tables. The first receives the consolidated CI36 extract rows; the second holds the associated payment detail that supports the statutory return.

Collectively, these tables reinforce the identification of the package as a Payables withholding extraction utility whose output is formatted specifically for the CI36 return.

Usage Notes

IGI_CIS_CI36_DATA_PKG is typically invoked from the concurrent manager rather than from a data-entry form. Its parameters — error buffer, return code, report name, operating unit, date range, and vendor identifier — map cleanly onto concurrent program arguments and standard completion outputs, indicating that the package is registered as, or called by, a concurrent program. The extract is run on a periodic reporting cycle, most commonly at month-end or quarter-end, to build the CI36 dataset for submission to the tax authority.

Because the package is not documented as a public API and is referenced by zero other packages, it should be treated as an internal component of the IGI CIS reporting flow. Customizations that call EXTRACT_DATA directly should be limited and carefully regression-tested against both 12.1.1 and 12.2.2, since the package lacks a formally supported interface contract and any signature details beyond those shown are not guaranteed across patches or upgrades.