Search Results igf_sl_edit_orig_chg_code

Overview

IGF_SL_EDIT_REPORT_V is a reporting view in the Oracle E-Business Suite Financials and Student Systems integration layer, owned by the APPS schema and delivered as part of the ETRM (Enterprise Technology Reference Model) 12.2.2 documentation set. The view surfaces the contents of the IGF_SL_EDIT_REPORT table in a decoder-ready form, presenting the outcome of validation and edit processing applied to student loan data flowing through the Oracle Student Loan (SL) subsystem toward external servicing and disbursement partners.

The view occupies a distinct role in EBS reporting and integration architecture. Rather than exposing raw code values that require downstream interpretation, it resolves enumerated values at query time through calls to IGF_AW_GEN.LOOKUP_DESC, a PL/SQL lookup utility in the Oracle Awards subsystem. This means each report row carries both a machine code and a human-readable description, making the view suitable for direct consumption by BI Publisher reports, Oracle Reports, concurrent program outputs, and external integration extracts where a developer or functional user must interpret the meaning of an edit failure without joining to lookup tables manually.

The view is read-only and inherits the security and performance characteristics of the underlying base table. Because IGF_SL_EDIT_REPORT is populated by the student loan edit and validation processes, the view reflects the state of validation exceptions at the time a query is executed, with no independent persistence of its own.

Underlying Base Objects

The documented definition is a single-table view. The sole base object is IGF_SL_EDIT_REPORT, aliased EDTR in the view text. No joins to other tables are present in the DDL; the denormalized descriptions are produced by scalar function calls rather than by relational joins.

The view therefore has a strict one-to-one row correspondence with IGF_SL_EDIT_REPORT. Every row returned by the view maps directly to one edit report row, including audit columns carried through unchanged. ETRM metadata for this object documents no additional referenced base objects, which is consistent with the view text as published.

Key Columns

• ROW_ID — Unique identifier of the edit report record.
• EDTR_ID — Edit report identifier, the principal business key of the row.
• LOAN_NUMBER — Student loan identifier to which the edit result applies.
• ORIG_CHG_CODE — Originating change code, accompanied by its decoded description returned by LOOKUP_DESC against the IGF_SL_EDIT_ORIG_CHG_CODE lookup type.
• SL_ERROR_TYPE — Error classification for the student loan edit.
• SL_ERROR_CODE — Specific error code within the error type. The view returns the decoded combination of SL_ERROR_TYPE and SL_ERROR_CODE as a second LOOKUP_DESC column, since the lookup type passed is the dynamic error type value itself.
• FIELD_NAME — Technical name of the loan attribute that failed validation.
• FIELD_VALUE — The actual value present in that attribute at validation time.
• Decoded FIELD_NAME — The configured description for FIELD_NAME retrieved from the IGF_SL_LOAN_FIELDS lookup type. This is the column most relevant to the user search term "igf_sl_loan_fields."
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns carried through from the base table.

Common Use Cases and Queries

The view is most commonly used to report loan edit failures by loan, by field, and by error type, and to reconcile the descriptive meaning of error and field codes without additional lookup joins.

To list all edit failures for a specific loan:

• SELECT edtr_id, loan_number, field_name, field_value, sl_error_type, sl_error_code FROM igf_sl_edit_report_v WHERE loan_number = :p_loan_number;

To summarize failures by loan field and decoded description:

• SELECT field_name, COUNT(*) FROM igf_sl_edit_report_v GROUP BY field_name ORDER BY 2 DESC;

To inspect the decoded originating change and error descriptions alongside the raw codes:

• SELECT edtr_id, loan_number, orig_chg_code, sl_error_type, sl_error_code, field_name, field_value, last_update_date FROM igf_sl_edit_report_v WHERE TRUNC(creation_date) = TRUNC(SYSDATE);

Because LOOKUP_DESC executes per row, queries returning large result sets from this view should be filtered and constrained before projection to avoid excessive function call overhead. Joins to IGF_LOOKUPS or the underlying FND lookup tables are unnecessary, since the view already supplies decoded values for ORIG_CHG_CODE, the error type/code pair, and FIELD_NAME.