Results for “batch_file_id”
16 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGFFV_DL_ORIGINATION_CHANGES is an Oracle E-Business Suite (EBS) view owned by the APPS schema and registered under the IGF — Financial Aid product. It presents a full, read-only view of the entity that holds Financial Aid Direct Loan origination changes. In the Oracle EBS 12.1.1 and 12.2.2 architectures, views in the IGF schema typically serve as the reporting and integration layer over the underlying transaction tables used by the Financial Aid Direct Loan processing modules. This view consolidates change records for Direct Loan origination together with the batch context in which those changes were transmitted or received, exposing both surrogate keys and descriptive attributes in a single queryable object.
The view is defined with the WITH READ ONLY clause, which enforces that all access is for query purposes only and no DML can be issued against it. This is characteristic of ETRM (Electronic Transaction Reporting/Management) and Financial Aid integration views, which are intended to support reporting, reconciliation, and downstream data extraction rather than transactional updates.
Underlying Base Objects
The view text is defined over two base tables joined on the batch identifier:
- IGF_SL_DL_CHG_SEND_ALL — aliased as
CHG; the Financial Aid Direct Loan change records table, holding the loan number, change code, new value, change number, and audit columns. - IGF_SL_DL_BATCH_ALL — aliased as
BATCH; the Direct Loan batch table, holding batch-level attributes such as batch ID, creation date, batch type, rejection code, status, and response indicator.
The join condition is CHG.DBTH_ID = BATCH.DBTH_ID, meaning each change record is linked to its parent batch through the internal batch identifier. The view therefore returns one row per change record enriched with the corresponding batch attributes. The ETRM metadata notes that no referenced base objects are separately documented, and the owner is not restated, but the view text supplies the authoritative definitions.
Key Columns
The view exposes a mixture of physical columns and lookup-descriptor columns. The lookup-descriptor columns are expressed as literal strings of the form '_LA:<column>:IGF_LOOKUPS_VIEW:<lookup_type>:MEANING', which instruct the reporting layer to resolve coded values to their lookup meanings.
- LOAN_NUMBER — the Direct Loan identifier associated with the change.
- CHANGE_CODE / NEW_VALUE — the type of origination change and its new value.
- BATCH_FILE_ID — the batch file identifier exposed by the view; this is the column users frequently search for when reconciling change records against transmitted batch files.
- BATCH_FILE_CREATION_DATE and BATCH_FILE_TYPE — attributes describing the batch file.
- "_LA:CHANGED_RECORD_STATUS" — lookup-resolved status of the changed record.
- "_LA:BATCH_REJECTION_CODE" — lookup-resolved rejection code (resolves via IGF_SL_DL_BATCH_REJ).
- "_LA:BATCH_STATUS" — lookup-resolved batch status (resolves via IGF_SL_DL_BATCH_STATUS).
- BATCH_ID, CHANGE_RECORD_ID — surrogate identifiers for the batch and change record.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard EBS audit columns.
Common Use Cases and Queries
Typical uses include reconciling origination changes against batch transmission, troubleshooting rejections, and building integration extracts. Because BATCH_FILE_ID is a documented column, queries frequently filter or group on it.
- Retrieve all changes for a given batch file:
SELECT loan_number, change_code, new_value, batch_file_id, batch_file_type, batch_file_creation_date FROM apps.igffv_dl_origination_changes WHERE batch_file_id = :p_batch_file_id; - Review rejection status by batch:
SELECT batch_file_id, "_LA:BATCH_REJECTION_CODE", "_LA:BATCH_STATUS", loan_number, change_code FROM apps.igffv_dl_origination_changes WHERE "_LA:BATCH_REJECTION_CODE" IS NOT NULL; - Audit recent change activity:
SELECT loan_number, change_code, new_value, batch_id, creation_date, last_update_date FROM apps.igffv_dl_origination_changes ORDER BY last_update_date DESC;
These queries support the view's purpose as a read-only reporting and reconciliation object within Oracle EBS Financial Aid Direct Loan processing.
-
Full View for the Entity that holds Financial Aid Direct Loan Origination Changes
APPS.IGFFV_DL_ORIGINATION_CHANGES·↳ IGF_SL_DL_BATCH_ALL·↳ IGF_SL_DL_CHG_SEND_ALL·Explore IGF module →
-
Full View for the Entity that holds Direct Loan Origination Batch Responses
APPS.IGFFV_DL_ORIG_BATCH_RESPONSES·↳ IGF_SL_DL_BATCH_ALL·↳ IGF_SL_DL_LOR_RESP_ALL·Explore IGF module →
-
Full View for the Entity that holds Financial Aid Direct Loan Origination Change Batch Responses
APPS.IGFFV_DL_ORI_CHG_BAT_RESPONSES·↳ IGF_SL_DL_BATCH_ALL·↳ IGF_SL_DL_CHG_RESP_ALL·Explore IGF module →
-
Full View for the Entity that holds Financial Aid Direct Loan Origination Credit Responses
APPS.IGFFV_DL_ORIG_CREDIT_RESPONSES·↳ IGF_SL_DL_BATCH_ALL·↳ IGF_SL_DL_LOR_CRRESP_ALL·Explore IGF module →
-
Full View for the Entity that holds Financial Aid Direct Loan Promissory Note Responses
APPS.IGFFV_DL_PROM_NOTE_RESPONSES·↳ IGF_SL_DL_BATCH_ALL·↳ IGF_SL_DL_PDET_RESP·↳ IGF_SL_DL_PNOTE_RESP_ALL·Explore IGF module →
-
Full View for the Entity that holds Direct Loan Origination Batch Responses
Not implemented in this database·Explore IGF module →
-
Full View for the Entity that holds Financial Aid Direct Loan Origination Changes
Not implemented in this database·Explore IGF module →
-
Full View for the Entity that holds Financial Aid Direct Loan Origination Change Batch Responses
Not implemented in this database·Explore IGF module →
-
Full View for the Entity that holds Financial Aid Direct Loan Origination Credit Responses
Not implemented in this database·Explore IGF module →
-
Full View for the Entity that holds Financial Aid Direct Loan Promissory Note Responses
Not implemented in this database·Explore IGF module →
-
eTRM - IGF Tables and Views 12.1.1
Holds pays only unit details for a pays only program