Search Results transcript_upd_event
Overview
IGS_AD_WF_001 is the Oracle Admissions (IGS_AD) Workflow integration package within Oracle E-Business Suite. It provides the PL/SQL layer through which admissions business events are raised to the Oracle Workflow engine. The package encapsulates the logic required to invoke the Workflow Event System (WF_EVENT), publish admissions-specific business events, and propagate the corresponding event attributes into the workflow subscriptions defined for the institution's admissions processes. In EBS 12.1.1 and 12.2.2 it is owned by the APPS schema and classified as an OTHER API.
Its principal role is to translate row-level changes in admissions entities—applications, transcripts, test scores, academic history, entry qualifications, offers, waitlists and fees—into named workflow events. This decoupling allows workflow designers to subscribe custom notifications, approval routings and provisioning logic without modifying the admissions forms or tables themselves.
Key Procedures and Functions
The package exposes approximately twenty-six documented procedures. They fall into three broad groups.
- Generic event raisers. WF_RAISE_EVENT raises an admissions event for a person and application context, and WF_ADM_ACADEMIC_INDEX publishes changes to the academic index value, capturing both the old and new index values for downstream consumers.
- Entity creation events. TRANSCRIPT_ENTRD_EVENT, TESTSCORE_CRT_EVENT, TESTSEG_CRT_EVENT, ACADHIST_CRT_EVENT, CREATE_APPLICATION_EVENT, ASSIGN_REQUIRMENT_DONE_EVENT and FEE_PAYMENT_CRT_EVENT announce that a new transcript, test score, test segment, academic history record, application, requirement assignment or fee payment has been created. The TESTSCORE_CRT_EVENT additionally carries the active indicator of the new score.
- Entity update events. TRANSCRIPT_UPD_EVENT (the procedure surfaced by the search term transcript_upd_event), TESTSCORE_UPD_EVENT, TESTSEG_UPD_EVENT, ACADHIST_UPD_EVENT, APPCOMP_STATUS_UPD_EVENT, ENTRY_QUAL_STATUS_UPD_EVENT, LATE_ADM_FEE_STATUS_UPD_EVENT, COND_OFFER_STATUS_UPD_EVENT, OFFER_DEFER_STATUS_UPD_EVENT, WAITLIST_STATUS_UPD_EVENT and FEE_PAYMENT_UPD_EVENT announce modifications to existing records. Where a status value is meaningful, the procedures carry both old and new values so that subscribers can detect transitions such as a change from "conditional" to "unconditional" offer, or a revision to a test score.
Transaction identifiers (person, application, course, sequence, education and transcript IDs) recur across the procedures and provide the correlation keys used by event subscriptions.
Tables Accessed
The package reads and writes staging tables that back the workflow event subscriptions, including IGS_AD_ACADINDEX_WF_S, IGS_AD_WF_ACADHIST_CRT_S, IGS_AD_WF_ACADHIST_UPD_S, IGS_AD_WF_APPLCOMP_UPD_S, IGS_AD_WF_APP_INST_STAT_UPD_S, IGS_AD_WF_APP_PROC_STAT_UPD_S, IGS_AD_WF_APP_QUAL_CODE_S, IGS_AD_WF_APP_RECONS_REQ_S, IGS_AD_WF_ASSREQ_S, IGS_AD_WF_CNDOFFER_UPD_S and IGS_AD_WF_CRT_APPL_S. These _S (staging) tables hold the event payload until the Workflow background engine processes the subscription.
It also references IGS_AD_APPL_ALL and IGS_AD_BE_PRESUB_APPL_S for application context, together with the Workflow infrastructure tables FND_NEW_MESSAGES and FND_USER when generating notifications.
Usage Notes
IGS_AD_WF_001 is normally invoked from the database triggers and form-level logic of the Admissions module rather than called directly by end users. The documented procedures are referenced by seventeen other packages, which confirms its position as a shared integration point. Customisations that need to participate in admissions workflow should subscribe to the events it raises rather than modify the package, preserving supportability. When troubleshooting missing notifications, verify that the corresponding _S staging table is receiving rows and that the Workflow background engine is running.