Search Results trans_request_if_hold_ind

Overview

IGS.IGS_AS_DOCPROC_STUP is the institutional setup table for general Document Request Processing in Oracle E-Business Suite. It is part of the Student Systems (IGS) schema, which underpins Oracle Student System and the transcript/enrollment certification features exposed through Self-Service and Administrative flows. Each row represents one setup record, keyed by TPSET_ID, that governs the options controlling how document requests are raised, validated, charged, and delivered. In ETRM 12.1.1 the table is documented with 19 columns and resides in the APPS_TS_TX_DATA tablespace; the unique index IGS_AS_DOCPROC_STUP_U1 lives in APPS_TS_TX_IDX. The object is registered in FND Design Data as IGS.IGS_AS_DOCPROC_STUP.

From a Data Vault modeling perspective, the mined FK structure suggests a satellite-leaning classification. The table is not a high-volume transactional hub; it holds relatively stable configuration attributes that modify the behavior of downstream document request entities. Treating it as a satellite of the governing setup context (TPSET_ID) aligns well with how the application reads these flags at runtime.

Key Information Stored

The primary key is IGS_AS_DOCPROC_STUP_PK on TPSET_ID, a sequence-generated NUMBER(15). The unique index IGS_AS_DOCPROC_STUP_U1 on TPSET_ID is the business-key candidate for this setup record.

• TPSET_ID — surrogate primary key and unique identifier for the setup row.
• PROVIDE_TRANSCRIPT_IND — controls whether a transcript request is permitted at all; this is the flag most commonly searched for.
• PROVIDE_DUPLICATE_DOC_IND — when unchecked, all "Duplicate" processing is disabled; defaults to "N".
• TRANS_REQUEST_IF_HOLD_IND — controls whether transcript requests may be raised while a transcript hold exists; defaults to "N".
• HOLD_DELIV_IND — allows the request to be created but holds delivery of the document until the hold clears; defaults to "N".
• ALL_ACAD_HIST_IN_ONE_DOC_IND — indicates whether all academic history is consolidated into a single transcript document.
• ALLOW_ENROLL_CERT_IND — indicates whether enrollment certification is permitted.
• LIFETIME_TRANS_FEE_IND — indicates whether the lifetime transcript fee has been paid.
• BILL_ME_LATER_IND — controls deferred billing behavior for document requests.
• EDI_CAPABLE_IND and ALWAYS_SEND_DOCS_VIA_EDI — govern EDI delivery capability and whether documents are always routed to designated EDI partners.
• CHARGE_DOCUMENT_FEE_IND and CHARGE_DELIVERY_FEE_IND — determine whether document and delivery fees are charged.
• ADMINISTRATOR_ID — VARCHAR2(100) user ID receiving administrative notifications; the FK references FND_USER.
• WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN provide standard audit tracking.

Common Use Cases and Queries

Typical scenarios include verifying whether transcript requests are enabled for a given setup, auditing which institutions enforce holds, and reporting on fee-charging configuration. A common query pattern checks the transcript indicator alongside related hold flags:

• SELECT tpset_id, provide_transcript_ind, trans_request_if_hold_ind, hold_deliv_ind FROM igs.igs_as_docproc_stup WHERE provide_transcript_ind = 'Y';
• Joining to FND_USER on administrator_id = user_name to identify notification recipients.
• Reporting EDI capability: SELECT tpset_id, edi_capable_ind, always_send_docs_via_edi FROM igs.igs_as_docproc_stup;
• Validating duplicate-processing policy via provide_duplicate_doc_ind.

Because setup rows are read at request time, queries against this table are frequently embedded in concurrent programs and OAF-based setup pages rather than ad-hoc reporting.

Related Objects

• FND_USER — referenced through ADMINISTRATOR_ID; join on user_name or user_id depending on implementation.
• IGS_AS_DOCPROC_STUP_PK / IGS_AS_DOCPROC_STUP_U1 — primary and unique indexes on TPSET_ID.
• IGS_AS_DOC_REQUEST — the transactional document request entity whose validation and delivery logic consults these setup flags.
• IGS_AS_DOC_REQUEST_ITEM — line-level document items affected by duplicate and fee indicators.
• IGS_AS_STUDENT_HOLD — hold records evaluated against TRANS_REQUEST_IF_HOLD_IND and HOLD_DELIV_IND.
• IGS_AS_TRANS_DETAIL / transcript views — transcript content and delivery processes governed by PROVIDE_TRANSCRIPT_IND and ALL_ACAD_HIST_IN_ONE_DOC_IND.
• EDI partner configuration — used with EDI_CAPABLE_IND and ALWAYS_SEND_DOCS_VIA_EDI.