Results for “igi_exp_cancellations”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGI_EXP_CANCELLATIONS is a transactional table in the IGI (Public Sector Financials International) product family within Oracle E-Business Suite 12.1.1 and 12.2.2. It records Exchange Protocol numbers that have been cancelled by an accounts officer when a dialog unit is voided or rescinded. The Exchange Protocol mechanism underpins the expenditure cycle in IGI installations, assigning sequential protocol identifiers to commitments, obligations, and payments subject to public-sector fiscal controls. When an accounts officer cancels a dialog unit, the associated protocol number is retired and written to this table, preserving an auditable record of the cancellation event rather than physically deleting the reference.

From a dimensional modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification for this object. Its single documented foreign key to IGI_EXP_NUMBERING_ALL places it as a dependent, attribute-bearing extension keyed to the numbering hub, rather than a hub or a link in its own right. This classification is heuristic and should be treated as a modeling suggestion rather than an authoritative Data Vault designation.

Key Information Stored

The table comprises thirteen documented columns. The most significant include:

• NUMBER_ID — The surrogate identifier and foreign key to IGI_EXP_NUMBERING_ALL. This is the primary join column and the principal structural attribute of the row.
• APPLICATION — Identifies the application context (for example, the source IGI module or product) under which the cancelled protocol was generated.
• SEQ_NUM — The sequence number component of the cancelled protocol, forming part of the human-readable reference along with PREFIX and SUFFIX.
• PREFIX and SUFFIX — Formatting components that combine with SEQ_NUM to reconstruct the displayable Exchange Protocol number.
• CANCELLATION_DATE — The effective date on which the cancellation was recorded by the accounts officer.
• FISCAL_YEAR — The fiscal year to which the cancelled protocol belonged, enabling period-based reporting and reconciliation.
• TRANSACTION_DATE — The date of the underlying transaction whose dialog unit was cancelled.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns capturing who last touched the row and when.
• CREATION_DATE, CREATED_BY — Insertion audit trail identifying the originating session and user.

NUMBER_ID serves as the documented surrogate key, while the combination of APPLICATION, FISCAL_YEAR, PREFIX, SEQ_NUM, and SUFFIX represents the strongest business-key candidate, reconstructing the full cancelled protocol reference.

Common Use Cases and Queries

Typical usage centers on audit and reconciliation reporting. A recurring pattern joins the cancellations table back to the numbering table to display the original protocol alongside its cancellation date:

• Listing all protocols cancelled within a fiscal year for a given application.
• Auditing cancellations performed by a specific accounts officer within a date range.
• Reconciling cancelled dialog units against the underlying commitments or obligations.
• Period-close reporting to confirm that voided protocol numbers were properly retired.

A representative query joins on NUMBER_ID: SELECT c.SEQ_NUM, c.PREFIX, c.SUFFIX, c.CANCELLATION_DATE, n.* FROM IGI.IGI_EXP_CANCELLATIONS c JOIN IGI.IGI_EXP_NUMBERING_ALL n ON c.NUMBER_ID = n.NUMBER_ID WHERE c.FISCAL_YEAR = :year. Filtering by CREATED_BY or LAST_UPDATED_BY isolates individual officer activity.

Related Objects

The documented foreign key links this table to IGI_EXP_NUMBERING_ALL via NUMBER_ID, making that numbering table the single most significant related object. Beyond this documented relationship, functional dependencies typically extend to the Exchange Protocol generation and dialog unit processing objects within the IGI expenditure suite, including the protocol header and detail tables that carry the original transaction, the dialog unit definitions, and the accounts officer security and approval objects. Reporting views over IGI_EXP_CANCELLATIONS frequently union or join to the active numbering table to present a complete protocol lifecycle picture, distinguishing live protocol numbers from those retired through cancellation.