Search Results disb_status_dt

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

• RFMD_ID — Primary disbursement identifier; RFMD is the RFMS disbursement record. The view also exposes RFMB_ID, the parent batch identifier.
• ORIGINATION_ID and DISB_REF_NUM — External identifiers used to correlate the EBS disbursement with the originating source system and reference number.
• DISB_DT, DISB_AMT, DB_CR_FLAG — Original disbursement date, amount, and debit/credit indicator.
• DISB_ACK_ACT_STATUS and DISB_STATUS_DT — Acknowledgment action status returned from RFMS and the date that status was recorded.
• ACCPT_DISB_DT, DISB_ACCPT_AMT, ACCPT_DB_CR_FLAG — Accepted disbursement date, amount, and debit/credit flag. ACCPT_DISB_DT is the column most directly relevant to the user query "accpt_disb_dt" and represents the date on which the disbursement was accepted by the downstream RFMS/award process; it is distinct from the original disbursement date.
• DISB_YTD_AMT — Year-to-date disbursement amount used in reconciliation and cumulative reporting.
• PYMT_PRD_START_DT and ACCPT_PYMT_PRD_START_DT — Payment period start dates for the original and accepted records, supporting period-level reconciliation.
• EDIT_CODE — Validation or error code generated during import/processing.
• ORG_ID — Operating unit identifier enforced by the multi-org view policy.
• Standard WHO/audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, and REQUEST_ID supporting audit and concurrent program traceability.
• ED_USE_FLAGS — Edit/usage indicator retained for downstream processing rules.

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.