Search Results igs_as_doc_dlvy_fee




Overview
Explore in AI Chat

Overview

The table IGS_AS_DOC_DLVY_FEE is a data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically belonging to the now-obsolete Student System (IGS) module. Its primary function is to store fee information associated with different document delivery methods. This table would have been designed to support a system where students or institutions could be charged varying fees based on the chosen method for delivering official documents, such as standard mail, courier, or electronic delivery. The provided ETRM metadata explicitly states this table was "Not implemented in this database," indicating it was defined but never populated or actively used in standard deployments, serving as a placeholder for potential custom functionality.

Key Information Stored

The table's structure is centered around linking a delivery method to a specific fee type. The primary key is the DFEE_ID column, a unique identifier for each fee-delivery method association. Two critical foreign key columns define the relationship: DELIVERY_METHOD_TYPE, which references a valid document delivery type in the IGS_AS_DOC_DLVY_TYP table, and FEE_TYPE, which references a specific fee code in the IGS_FI_FEE_TYPE_ALL table. This design allows the system to define and retrieve the applicable fee for any given delivery option.

Common Use Cases and Queries

As the table was not implemented, there are no standard Oracle EBS processes or user interfaces that interact with it. Its use would have been entirely hypothetical or custom-built. In a scenario where it was active, typical use cases would include calculating the total cost for a document order inclusive of delivery fees or providing a list of available delivery options with their associated costs during a checkout process. A sample query to retrieve this information might be:

  • SELECT dft.delivery_method_code, ft.fee_code, ft.description FROM igs_as_doc_dlvy_fee df JOIN igs_as_doc_dlvy_typ dft ON df.delivery_method_type = dft.delivery_method_type JOIN igs_fi_fee_type_all ft ON df.fee_type = ft.fee_type;

Reporting would focus on listing configured delivery fees or auditing the fee rules applied to historical document orders.

Related Objects

The ETRM documentation specifies two direct foreign key relationships for the IGS_AS_DOC_DLVY_FEE table, linking it to master data tables. These relationships are fundamental to its intended purpose.

  • IGS_FI_FEE_TYPE_ALL: This table is referenced via the FEE_TYPE column. It defines the valid fee types (e.g., "Courier Fee," "Electronic Delivery Surcharge") that can be assigned to a delivery method.
  • IGS_AS_DOC_DLVY_TYP: This table is referenced via the DELIVERY_METHOD_TYPE column. It holds the definition of available delivery methods (e.g., "AIRMAIL," "EXPRESS," "PDF"), for which a fee can be configured.

The table itself is the child in these relationships, relying on the parent tables for valid data. There is no documented information on other objects that might have referenced IGS_AS_DOC_DLVY_FEE.