Search Results dfee_id

Overview

The IGS_AS_DOC_DLVY_FEE table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Oracle Student Management) product family. It functions as a master reference table that stores the financial charges associated with different methods of document delivery. Its primary role is to define and maintain a fee schedule, linking specific delivery methods (e.g., standard mail, express, electronic) with a monetary amount and a corresponding fee type for accounting and transaction processing. This enables the automated calculation of delivery-related charges within student administrative processes.

Key Information Stored

The table's structure is designed to capture the essential elements of a delivery fee rule. The DFEE_ID column serves as the unique primary key, typically populated by a sequence generator. The DELIVERY_METHOD_TYPE column defines the applicable delivery service. The AMOUNT column holds the numeric charge for that method. A critical attribute is the FEE_TYPE, which categorizes the fee for integration with the financial modules, ensuring payments are posted against the correct accounting classification. Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) provide audit trails. The two unique indexes enforce data integrity: one on the primary key (DFEE_ID) and another on the DELIVERY_METHOD_TYPE, preventing duplicate fee rules for the same delivery method.

Common Use Cases and Queries

This table is central to scenarios involving the ordering or issuance of official documents, such as transcripts or diplomas. When a student selects a delivery option during a request, the application queries this table to determine the associated fee, which is then added to the student's account. Common reporting and validation queries include retrieving the current fee schedule for all delivery methods or identifying the specific charge for a selected method. A typical operational query would be:

• SELECT DELIVERY_METHOD_TYPE, AMOUNT, FEE_TYPE FROM IGS.IGS_AS_DOC_DLVY_FEE WHERE DELIVERY_METHOD_TYPE = 'EXPRESS';

Administrative use cases involve maintaining this fee matrix via the application's user interface, which internally performs INSERT or UPDATE operations on this table. Data fixes or bulk updates may also be performed directly via SQL against this table, contingent on change control procedures.

Related Objects

The IGS_AS_DOC_DLVY_FEE table is integrated into the application's data model through defined foreign key relationships. It references two key lookup tables to maintain referential integrity. The FEE_TYPE column is a foreign key to the IGS_FI_FEE_TYPE_ALL table, linking the delivery charge to the broader fee type master in the financial subsystem. The DELIVERY_METHOD_TYPE column is a foreign key to the IGS_AS_DOC_DLVY_TYP table, which contains the valid list of configured delivery methods. The table's primary key, DFEE_ID, is referenced by other application objects, as indicated by its status in the dependency information, though the specific referencing tables are not enumerated in the provided metadata. The table is a foundational object for the APPS.IGS_AS_DOC_DLVY_FEE synonym.