Search Results igs_as_order_hdr_pk

Overview

The IGS_AS_ORDER_HDR table is a core data object within the Oracle E-Business Suite Student System (IGS) module. It functions as the primary header table for managing orders, which are typically associated with the procurement of academic documents, such as official transcripts, diplomas, or certificates. This table stores the master record for an order, capturing high-level transactional information that is then detailed in related line-level tables. Its existence is critical for the order-to-fulfillment workflow, linking the student or requester's intent to the financial and logistical processes managed by the integrated EBS applications.

Key Information Stored

While the provided metadata does not list all columns, the documented primary and foreign keys reveal the essential data points. The central column is ORDER_NUMBER, which serves as the unique identifier for each order record. The table links to external entities through key foreign key columns: ORDER_PLACED_BY references a party in HZ_PARTIES, identifying the individual or organization who placed the request. The INVOICE_ID column links the order to a financial transaction in the IGS_FI_INV_INT_ALL table, integrating the academic order with the invoicing and accounts receivable processes. Other typical data points in such a header table would include order date, status, total amount, delivery method, and requester contact information.

Common Use Cases and Queries

This table is central to reporting and process management for academic service orders. Common operational use cases include tracking the status of transcript requests, generating fulfillment reports, and reconciling orders with issued invoices. For technical and functional analysis, frequent queries involve joining the header to its detail lines and related entities. A foundational reporting query would retrieve order headers along with the associated party information: SELECT hdr.order_number, hdr.order_date, party.party_name FROM igs_as_order_hdr hdr, hz_parties party WHERE hdr.order_placed_by = party.party_id;. Another critical pattern is joining to invoice data to analyze the financial lifecycle of orders: SELECT hdr.order_number, inv.invoice_number FROM igs_as_order_hdr hdr, igs_fi_inv_int_all inv WHERE hdr.invoice_id = inv.invoice_id;.

Related Objects

The IGS_AS_ORDER_HDR table maintains defined relationships with several other EBS objects, forming a key part of the data model. The documented relationships are:

• Primary Key: IGS_AS_ORDER_HDR_PK on ORDER_NUMBER.
• Foreign Key (Parent): References HZ_PARTIES via the ORDER_PLACED_BY column, linking the order to a Trading Community Architecture (TCA) party record.
• Foreign Key (Parent): References IGS_FI_INV_INT_ALL via the INVOICE_ID column, linking the order to an invoice interface record.
• Foreign Key (Child): Referenced by IGS_AS_DOC_DETAILS via its ORDER_NUMBER column. This is the primary relationship where the header record is associated with one or more line items detailing the specific documents or services ordered.