Search Results igs_as_doc_fee_pmnt

Overview

The IGS_AS_DOC_FEE_PMNT table is a core data structure within the Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2, specifically belonging to the IGS (Student System) product family. As indicated by its description, its primary role is to store transactional details related to payments made for document fees. This table would typically support processes such as transcript requests, diploma issuance, or other academic document services where a fee is assessed. It is critical to note the metadata explicitly classifies the IGS - Student System module as "Obsolete," indicating this table and its associated functionality are part of a legacy code stream that may be deprecated or replaced in more recent application versions or deployment strategies.

Key Information Stored

While the provided metadata does not list the specific columns of IGS_AS_DOC_FEE_PMNT, its documented foreign key relationships reveal several critical data points it must contain. The table stores a foreign key reference (PLAN_ID) to the IGS_AS_SERVIC_PLAN table, linking each payment record to a specific service plan or request. Furthermore, it holds foreign key columns for CAL_TYPE and CI_SEQUENCE_NUMBER, which reference the IGS_CA_INST_ALL (Calendar Instance) table. This indicates that each document fee payment is associated with a specific academic calendar instance, providing essential context for the term or period in which the transaction occurred. Other columns, not detailed in the excerpt, would logically store payment amounts, payment dates, payment method identifiers, and a unique primary key for the payment record itself.

Common Use Cases and Queries

This table serves as the system of record for financial transactions related to document services. Common operational and reporting use cases include reconciling payments received for transcript orders, generating receipts, auditing revenue from academic document services, and verifying student payment status before processing a document request. A typical analytical query might join this table to the service plan and student tables to report on fee collection by academic period. A sample SQL pattern to retrieve payment details for a specific plan would be:

• SELECT * FROM IGS_AS_DOC_FEE_PMNT pmnt WHERE pmnt.plan_id = :p_plan_id;

Given the module's obsolete status, direct interaction with this table for new customizations is generally discouraged in favor of supported public APIs, where available.

Related Objects

The IGS_AS_DOC_FEE_PMNT table maintains defined relationships with two other key tables in the Student System, as per the provided foreign key metadata:

• IGS_AS_SERVIC_PLAN: This is a parent table, linked via the PLAN_ID column in IGS_AS_DOC_FEE_PMNT. It contains the master record for the document service request for which the fee is being paid.
• IGS_CA_INST_ALL: This calendar instance table is a parent table, linked via a composite foreign key using the CAL_TYPE and CI_SEQUENCE_NUMBER columns in IGS_AS_DOC_FEE_PMNT. This relationship ties the payment to the relevant academic calendar period.

The metadata also explicitly states this table is "Not implemented in this database," which suggests that in the specific ETRM instance queried, the table DDL was not deployed, though its definition is retained in the repository for reference.