Search Results dup_transcript_id

Overview

IGS_AD_TXCPT_INT is a reporting and integration view within the Oracle E-Business Suite IGS (Student System) product family. In the EBS 12.1.1 and 12.2.2 releases the IGS module is documented as obsolete, meaning the seeded forms, concurrent programs, and PL/SQL APIs that historically populated and consumed this view are no longer actively maintained or implemented in current databases. The ETRM implementation note for this object states plainly that it is "Not implemented in this database," confirming that the underlying object does not exist in a standard, freshly provisioned environment. Where present, typically only in upgraded legacy instances, IGS_AD_TXCPT_INT presents admission transcript exception and interface data staged for processing into the core transcript tables.

The view functions as a thin projection over the IGS_AD_TXCPT_INT_ALL single-table view, exposing a controlled column list for query and reporting purposes. It carries interface control columns alongside the academic payload columns, which is characteristic of EBS open-interface and staging tables that feed inbound data loads.

Underlying Base Objects

The view text defines IGS_AD_TXCPT_INT as a SELECT from IGS_AD_TXCPT_INT_ALL. No additional base tables or joins are documented in the ETRM metadata, and the reference list of underlying base objects is empty; the view is a direct one-to-one projection of the ALL-suffixed object. In EBS convention, a view named *_ALL applied over an interface or transaction table is generally built to support a multi-organization (ORG_ID) security wrapper, with a corresponding _V or _ORG view narrowing rows by the operating unit context. IGS_AD_TXCPT_INT sits in that layered namespace and should be treated as the unrestricted projection rather than the org-secured variant.

Key Columns

The column list combines academic transcript attributes with Oracle interface framework columns:

• TRANSCRIPT_ID — Primary identifier of the transcript record being interfaced.
• TRANSCRIPT_STATUS, TRANSCRIPT_TYPE, TRANSCRIPT_SOURCE — Classification of the transcript and the channel through which it was received.
• DATE_OF_RECEIPT — Date the transcript document was received by the institution.
• DATE_OF_ISSUE — Date the transcript was issued by the originating institution. This is the column most frequently searched by users and is central to admissions validation and elapsed-time reporting.
• ENTERED_GPA, ENTERED_GS_ID, CONV_GPA, CONV_GS_ID — Grade point averages and grading scheme references, in both as-entered and converted forms.
• TERM_TYPE, RANK_IN_CLASS, CLASS_SIZE, APPROXIMATE_RANK — Class-ranking context supplied on the source transcript.
• DECILE_RANK, QUARTILE_RANK, QUINTILE_RANK, PERCENTILE_RANK, WEIGHTED_RANK — Normalized ranking measures used in admissions scoring.
• MATCH_IND, STATUS, ERROR_CODE — Interface framework result columns indicating whether the row matched an existing entity and whether the load succeeded or failed.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent request and program audit columns.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS who-columns.
• INTERFACE_TRANSCRIPT_ID, INTERFACE_ACADHIS_ID, ORG_ID, DUP_TRANSCRIPT_ID — Foreign keys to the interface transcript, academic history, organization, and duplicate-detection records.

Common Use Cases and Queries

Typical reporting needs include reconciliation of inbound transcript loads, identification of failed interface rows, and analysis of issue-to-receipt turnaround times. Because the object is obsolete and often absent, queries should be guarded with an existence check or run only against legacy schemas that still carry the IGS staging tables.

• Failed interface rows: SELECT transcript_id, status, error_code, date_of_issue FROM igs_ad_txcp int WHERE status = 'E';
• Issue-to-receipt latency: SELECT transcript_id, date_of_issue, date_of_receipt, (date_of_receipt - date_of_issue) days_elapsed FROM igs_ad_txcp int ORDER BY days_elapsed DESC;
• Rank profile review: SELECT transcript_id, entered_gpa, percentile_rank FROM igs_ad_txcp int;
• Duplicate detection: SELECT transcript_id, dup_transcript_id, match_ind FROM igs_ad_txcp int WHERE dup_transcript_id IS NOT NULL;

All access should be read-only, and any integration activity should be redirected to currently supported Student System interfaces where the module has been replaced.