Search Results igf_sl_cl_setup




Overview
Explore in AI Chat

Overview

IGF_SL_CL_SETUP is a financial aid view belonging to the IGF (Financial Aid) product family, a module documented in Oracle E-Business Suite as obsolete. The view exposes student loan configuration and setup data, specifically the parameters that govern how a loan "CL setup" record is processed for a given operating unit. It is defined over the table IGF_SL_CL_SETUP_ALL and is filtered by the current organization via the ORG_ID column.

The view is relevant in Oracle EBS 12.1.1 and 12.2.2 primarily for reporting and integration rather than for live transaction processing. Because the underlying module carries an obsolete status and the object is marked "Not implemented in this database," the view is most useful as a reference object when analyzing legacy Financial Aid customizations, migrated data, or historical reporting extracts. The column PLUS_PROCESSING_TYPE_CODE, which is the term users most frequently search against this object, is one of the loan-processing control attributes surfaced by the view.

Underlying Base Objects

The view is defined over a single documented base object: IGF_SL_CL_SETUP_ALL. No additional base tables or joined objects are documented in the ETRM metadata. The view text performs a SELECT against IGF_SL_CL_SETUP_ALL, aliased as CLSET, returning CLSET.ROWID along with the configured columns.

The row-level filter relies on the Multi-Org mechanism. The view restricts output using a comparison of the ORG_ID column against the operating unit derived from USERENV('CLIENT_INFO'). Specifically, it applies NVL(CLSET.ORG_ID, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) equality. This pattern is typical of partitioned, org-striped Financial Aid setup tables, where each operating unit maintains its own CL setup configuration.

Several columns listed in the view's column inventory (for example SCH_NON_ED_BRC_ID, LENDER_ID, GUARANTOR_ID, RECIPIENT_ID, LOAN_AWARD_METHOD, MEDIA_TYPE) appear as NULL placeholders in the view text, while others map directly to CLSET columns. This indicates the view presents a consolidated column layout for compatibility, with certain attributes not populated from the base table.

Key Columns

Common Use Cases and Queries

The most common scenario is retrieving loan setup configuration for an operating unit or identifying records by PLUS processing type. Because the view is secured by ORG_ID through CLIENT_INFO, queries executed under a valid Multi-Org session return only the rows for the active organization.

  • List all CL setup records for the current operating unit.
  • Filter by PRC_TYPE_CODE or PLUS_PROCESSING_TYPE_CODE to review loan processing configuration.
  • Review fee percentages and fund return methods for reconciliation or migration.

Sample query:

SELECT clset_id, ci_cal_type, ci_sequence_number, prc_type_code, plus_processing_type_code, est_orig_fee_perct, est_guarnt_fee_perct, fund_return_method_code, org_id FROM igf_sl_cl_setup WHERE plus_processing_type_code IS NOT NULL;

A second common query inspects default and party-level setup rows: SELECT clset_id, default_flag, party_id, relationship_cd, pnote_delivery_code, eft_authorization FROM igf_sl_cl_setup WHERE default_flag = 'Y';

Because the module is obsolete and the object is not implemented in the reference database, these queries should be validated against the target environment before use in production reporting or integration logic.