Search Results orig_fee_perct_plus

Overview

IGF_SL_DL_SETUP is a reporting view within the Oracle EBS Financial Aid (IGF) product family, a module classified as obsolete in Oracle E-Business Suite 12.1.1 and 12.2.2. The view exposes direct loan (DL) setup configuration data, which in the original Financial Aid implementation governed the parameters used by institutions to originate and disburse Federal Direct Stafford and Direct PLUS loans. The presence of the ORIG_FEE_PERCT_PLUS column—the search term that surfaced this object—confirms its role in storing origination fee percentages applied to PLUS loans at the school setup level.

Because IGF is documented as obsolete, this view is retained primarily for historical, archival, or migration reporting. It should not be treated as an actively maintained integration point in a current 12.1.1 or 12.2.2 deployment. ETRM metadata explicitly records the implementation status as "Not implemented in this database," meaning the view and its base table may or may not exist depending on whether the Financial Aid product was ever installed.

Underlying Base Objects

The view is defined over a single documented base table, IGF_SL_DL_SETUP_ALL. No other referenced base objects are documented in the ETRM metadata. The view selects a curated subset of columns from that table and applies a row-level security predicate based on the session's ORG_ID, using the standard Oracle multi-org mechanism:

WHERE NVL(DLSET.ORG_ID, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

This predicate restricts rows to the current operating unit (or to rows with a NULL ORG_ID), consistent with the _ALL table naming convention. The view also surfaces the physical ROWID as ROW_ID, an EBS convention allowing the view to be used in certain Forms-based or updatable contexts.

Key Columns

• DLSET_ID — Primary identifier for the Direct Loan setup record.
• CI_CAL_TYPE / CI_SEQUENCE_NUMBER — Calendar type and sequence that scope the setup to an academic period.
• SCHOOL_ID — Identifier of the school or institution the setup applies to.
• ORIG_FEE_PERCT_STAFFORD — Origination fee percentage applied to Direct Stafford loans.
• ORIG_FEE_PERCT_PLUS — Origination fee percentage applied to Direct PLUS loans.
• INT_REBATE — Interest rebate percentage configuration.
• PNOTE_PRINT_IND / PNOTE_PRINT_COPIES — Promissory note printing flag and copy count.
• ACC_NOTE_FOR_DISB, AFFIRMATION_REQD, INTERVIEW_REQD, DISCLOSURE_PRINT_IND — Flags controlling disbursement note acceptance, affirmation, interview, and disclosure printing requirements.
• SPECIAL_SCHOOL, DL_VERSION, RESPONSE_OPTION_CODE, FUNDING_METHOD — Special school indicator, Direct Loan program version, response handling option, and funding method.
• ORG_ID — Operating unit, driven by the view's multi-org predicate.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Since the view is not implemented on all databases, the first practical step is a data dictionary check. If present, typical reporting queries retrieve origination fee percentages and loan-processing flags by school and operating unit.

SELECT DLSET_ID, SCHOOL_ID, ORIG_FEE_PERCT_STAFFORD, ORIG_FEE_PERCT_PLUS, INT_REBATE, FUNDING_METHOD FROM IGF_SL_DL_SETUP;

To isolate setups for a specific school:

SELECT SCHOOL_ID, ORIG_FEE_PERCT_PLUS, ORIG_FEE_PERCT_STAFFORD FROM IGF_SL_DL_SETUP WHERE SCHOOL_ID = :school_id;

Historical and migration reports may join the view back to its base table to compare current versus archived values. Because the module is obsolete, no new functional use cases should be built on this object; existing reports should be reviewed for decommissioning in 12.1.1 and 12.2.2 environments.