Search Results igs_ps_sch_faclt_all_u1

Overview

IGS.IGS_PS_SCH_FACLT_ALL is an interface table within the Oracle E-Business Suite 12.1.1 / 12.2.2 environment, owned by the IGS schema and identified by FND Design Data reference IGS.IGS_PS_SCH_FACLT_ALL. Its display name is "Export Scheduling Facilities Detail," and it holds unit section occurrence facility information consumed by third-party scheduling processes. The table's documented business category is BUSINESS_ENTITY IGS_UNIT, confirming that the records it stores are semantically tied to the IGS Unit entity even though the row-level parent relationship is to a unit section occurrence in the scheduling interface.

The table is a staging interface object rather than a transactional production object. The documentation states explicitly that the corresponding production table is IGS_PS_USO_FACILITY, meaning rows flow from this interface into the production facility table during the scheduling export/import cycle. It resides in the APPS_TS_INTERFACE tablespace, consistent with its transient, batch-oriented role, and its lifecycle status is active with public scope.

From a Data Vault modeling perspective, the mined relationship structure classifies this object as satellite-leaning. It is not a standalone hub: FACILITY_ID is a sequence-generated surrogate key local to the interface, while INT_OCCURS_ID carries the true business relationship to the parent scheduling interface record. This suggests modeling the entity as a satellite hanging off the unit section occurrence hub (IGS_PS_SCH_INT_ALL) rather than as an independent hub.

Key Information Stored

The table contains ten documented columns. FACILITY_ID is a sequence-generated NUMBER that uniquely identifies a facility associated with a unit section occurrence; it is enforced by the unique index IGS_PS_SCH_FACLT_ALL_U1 and constitutes the documented primary key. FACILITY_CODE (VARCHAR2(10)) holds the short code of the facility, while FACILITY_DESCRIPTION (VARCHAR2(150)) holds its descriptive text. Together these two attributes form the practical business-key candidates for identifying a facility within a given occurrence context, though only FACILITY_ID is documented as unique.

INT_OCCURS_ID is the foreign key column linking each facility row to its parent unit section occurrence in IGS_PS_SCH_INT_ALL. ORG_ID (NUMBER(15)) holds the operating unit identifier, supporting multi-org data segregation. The remaining five columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — are the standard WHO audit columns present on nearly all EBS interface and transactional tables.

Common Use Cases and Queries

The primary operational scenario is validating and reconciling staged facility detail before the third-party scheduling extract runs. Typical checks include verifying that every INT_OCCURS_ID resolves to a valid scheduling interface row, and that ORG_ID is populated consistently with the parent occurrence.

• Export preparation: select FACILITY_ID, FACILITY_CODE, and FACILITY_DESCRIPTION for all rows belonging to a given INT_OCCURS_ID to build the scheduling payload.
• Multi-org reporting: aggregate facility counts by ORG_ID to confirm data distribution across operating units.
• Data quality auditing: identify rows where FACILITY_CODE is null or duplicated within the same INT_OCCURS_ID.
• Reconciliation: compare staged rows against IGS_PS_USO_FACILITY to confirm successful transfer to production.

A representative query, adapted from the documented query text, filters on the parent occurrence:

SELECT FACILITY_ID, FACILITY_CODE, FACILITY_DESCRIPTION, ORG_ID FROM IGS.IGS_PS_SCH_FACLT_ALL WHERE INT_OCCURS_ID = :p_occurs_id AND ORG_ID = :p_org_id;

Related Objects

The documented dependency data establishes the following significant relationships:

• IGS.IGS_PS_SCH_INT_ALL — parent table referenced through the foreign key IGS_PS_SCH_FACLT_ALL.INT_OCCURS_ID → IGS_PS_SCH_INT_ALL. This is the authoritative join path for establishing occurrence context.
• IGS.IGS_PS_USO_FACILITY — the corresponding production table that receives facility data after the interface stage, as stated in the object definition.
• APPS.IGS_PS_SCH_FACLT_ALL — the APPS-layer synonym or view, listed as referencing this table and the object applications typically query.

The table does not reference any database object other than the parent occurrence table, and no additional foreign keys are documented, reflecting its narrow staging responsibility within the IGS scheduling facility export flow.