Search Results int_pat_id




Overview
Explore in AI Chat

Overview

IGS.IGS_PS_SCH_PAT_INT is a public interface (staging) table in the Oracle E-Business Suite Student Systems (IGS) product family. It stores Unit Offering Pattern detail rows that are exported to a third-party scheduling interface, and it is explicitly documented as inactive when records exist at the section level; the corresponding production table is IGS_PS_UNIT_OFR_PAT_ALL. The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and its lifecycle status is active, with an FND Design Data entry of IGS.IGS_PS_SCH_PAT_INT.

The object’s display name, “Export Scheduling Unit Offering pattern Detail,” and its category classification (BUSINESS_ENTITY IGS_UNIT) confirm its role as a business-facing staging entity for unit offering patterns rather than a transactional master. Because the data vault classification is hub-leaning, the table is best modeled as a hub candidate keyed by its surrogate identifier, with descriptive attributes suggesting satellite treatment where the model is extended. In Oracle EBS 12.1.1 and 12.2.2, this table is populated by concurrent processes that extract scheduling data for external systems.

Key Information Stored

The table contains 20 documented columns. The most significant include:

Common Use Cases and Queries

Typical usage centers on staging validation, export reconciliation, and integration troubleshooting. A frequent pattern is retrieving all pattern rows for a given scheduling transaction:

  • SELECT INT_PAT_ID, UNIT_CD, VERSION_NUMBER, CALENDAR_TYPE, START_DATE, END_DATE FROM IGS.IGS_PS_SCH_PAT_INT WHERE TRANSACTION_ID = :p_transaction_id;
  • SELECT * FROM IGS.IGS_PS_SCH_PAT_INT WHERE IMPORT_DONE_FLAG = 'N' AND ABORT_FLAG = 'N'; — pending exports.
  • Joining the composite index columns (UNIT_CD, VERSION_NUMBER, CALENDAR_TYPE, SEQUENCE_NUMBER) to identify duplicate or overlapping calendar instances.
  • Comparing staging rows against the production table IGS_PS_UNIT_OFR_PAT_ALL to confirm that section-level records take precedence, since the interface is not used when section-level records exist.

Related Objects

The dependency structure identifies this table as a hub with incoming links from two interface children and one outgoing reference to a transaction header:

  • IGS_PS_SCH_HDR_INT_ALL — referenced by TRANSACTION_ID; the parent scheduling interface header.
  • IGS_PS_SCH_FAC_INT — references this table via INT_PAT_ID; holds scheduling facility detail.
  • IGS_PS_SCH_LOC_INT — references this table via INT_PAT_ID; holds scheduling location detail.
  • IGS_PS_UNIT_OFR_PAT_ALL — the corresponding production table for unit offering patterns.
  • FND Design Data entry IGS.IGS_PS_SCH_PAT_INT, used for concurrent/interface registration.