Search Results pymt_prd_start_dt




Overview
Explore in AI Chat

Overview

The view APPS.IGF_GR_RFMS_DISB is a reporting and integration object within the Oracle E-Business Suite Financial Aid / Grants (IGF) module, owned by the APPS schema and documented in the ETRM repository under the FND Design Data name IGF.IGF_GR_RFMS_DISB. Its role is to expose disbursement information exchanged between Oracle EBS and the federal RFMS (Recipient Financial Management System) environment used for grant and student aid processing. The view is registered as VALID and is defined as a multi-org secured view: queries return data for the current operating unit only, and rows belonging to other operating units are automatically excluded via the ORG_ID policy. This makes it suitable for reporting that must respect organizational data segregation without requiring explicit ORG_ID predicates in user SQL.

Underlying Base Objects

The dependencies section of the ETRM metadata identifies a single base object for this view: APPS.IGF_GR_RFMS_DISB_ALL. The _ALL table holds the unpartitioned (all-org) disbursement records, and IGF_GR_RFMS_DISB is the multi-org secured projection over it. The view inherits the ORG_ID column from the base table and applies the standard EBS operating unit security so that a session operating under a given organization sees only matching rows. Because the view is referenced by a substantial set of program units — including IGF_AW_CANCEL_AWD, IGF_DB_DISB, IGF_GR_GEN, IGF_GR_LI_IMPORT, IGF_GR_PELL, and IGF_GR_REPACKAGE — it functions as a central read layer for grant disbursement processing rather than a purely ad hoc reporting object.

Key Columns

Common Use Cases and Queries

Typical uses include reporting accepted versus original disbursements, reconciling RFMS acknowledgments, and debugging grant disbursement interfaces. Because the view is multi-org secured, no ORG_ID filter is required.

SELECT disb_ref_num,
       disb_dt,
       disb_amt,
       accpt_disb_dt,
       disb_accpt_amt,
       disb_ack_act_status
FROM   apps.igf_gr_rfms_disb
WHERE  accpt_disb_dt IS NOT NULL
  AND  disb_dt BETWEEN :start_date AND :end_date;

SELECT rfmd_id, rfmb_id, origination_id, disb_ref_num,
       disb_dt, accpt_disb_dt, edit_code
FROM   apps.igf_gr_rfms_disb
WHERE  edit_code IS NOT NULL
ORDER  BY last_update_date DESC;

For cumulative reconciliation, aggregating DISB_AMT and DISB_ACCPT_AMT by PYMT_PRD_START_DT and comparing against DISB_YTD_AMT provides a period-level control report. Joins back to IGF_GR_RFMS_DISB_ALL via RFMD_ID allow unrestricted cross-org analysis when operating outside the multi-org policy.