Search Results total_gross




Overview
Explore in AI Chat

Overview

APPS.IGF_DB_YTD_DTL is a multi-org view in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, owned by the APPS schema and registered under FND Design Data as IGF.IGF_DB_YTD_DTL. The view stores data loaded through the Year-To-Date (YTD) disbursement data file and is a component of the Oracle Student Financial Aid / Direct Loan processing functionality delivered by the IGF product family. Its role is to expose YTD and monthly disbursement records for reporting, reconciliation, and downstream integration—typically in the context of Title IV Direct Loan processing for educational institutions.

Because the view is documented as a multi-org view, it filters data by the current operating unit and ignores records belonging to other operating units, ensuring operating-unit context is respected during queries.

Underlying Base Objects

The ETRM metadata for this object does not enumerate any referenced base objects or tables. No documented dependency list was provided for IGF_DB_YTD_DTL. Consequently, the view's underlying table(s) are not explicitly identified in the supplied metadata; the view is described as storing data loaded through the year-to-date disbursement data file, which implies a set of staging or detail tables internal to the IGF schema supporting file-load processing. When precise lineage is required, the view definition in the APPS schema should be inspected directly to confirm the base tables and join conditions, as this information is not captured in the available metadata.

Key Columns

The view exposes a mixture of identifiers, dates, and monetary amounts:

Common Use Cases and Queries

Typical scenarios include reconciling loaded YTD files, auditing disbursement amounts by process date or batch, and validating school-level totals against expected figures. The process date column (PROCESS_DT) is frequently used to isolate records from a specific processing run.

Example: retrieve records processed on a given date.

  • SELECT ytdd_id, batch_id, school_code, loan_number, disb_num, disb_net, process_dt FROM apps.igf_db_ytd_dtl WHERE process_dt = :p_process_dt;

Example: summarize net disbursements by school.

  • SELECT school_code, SUM(disb_net) net_total FROM apps.igf_db_ytd_dtl GROUP BY school_code;