Search Results disb_ref_num




Overview
Explore in AI Chat

Overview

The IGF_GR_RFMS_DISB_ALL table is a core data repository within the Oracle E-Business Suite (EBS) Grants (IGF) module, specifically for versions 12.1.1 and 12.2.2. It serves as the definitive store for disbursement data that must be transmitted to an external Recipient Financial Management System (RFMS), typically a government entity. This table is critical for managing the lifecycle of grant disbursements, from creation and transmission to tracking acceptance and status updates received from the external system. Its "ALL" suffix indicates it is a multi-organization access control (MOAC) enabled table, storing data for all operating units.

Key Information Stored

The table's columns are designed to capture the complete disbursement transaction and its subsequent processing status. The primary identifier is the RFMD_ID, a system-generated unique key. Essential disbursement details include the ORIGINATION_ID, DISB_REF_NUM, DISB_DT, and DISB_AMT. The table also stores the response and reconciliation data from the RFMS, such as DISB_ACK_ACT_STATUS, ACCPT_DISB_DT, DISB_ACCPT_AMT, and EDIT_CODE. The DB_CR_FLAG and ACCPT_DB_CR_FLAG indicate whether the disbursement amount is a debit (positive) or credit (negative). Standard EBS "Who" columns (CREATED_BY, CREATION_DATE, etc.) are present for auditing.

Common Use Cases and Queries

Primary use cases involve generating disbursement reports, reconciling sent data with accepted amounts from the government, and troubleshooting transmission errors. Common SQL queries include identifying disbursements by status, batch, or origination, and reconciling amounts.

  • Finding disbursements in a specific batch for transmission: SELECT * FROM igf.igf_gr_rfms_disb_all WHERE rfmb_id = <batch_id> ORDER BY rfmd_id;
  • Identifying disbursements with errors (EDIT_CODE) for a given origination: SELECT origination_id, disb_ref_num, edit_code, disb_amt, disb_accept_amt FROM igf.igf_gr_rfms_disb_all WHERE origination_id = '<ID>' AND edit_code IS NOT NULL;
  • Reconciling proposed versus accepted disbursement amounts: SELECT disb_ref_num, disb_amt, disb_accept_amt, (disb_amt - disb_accept_amt) AS variance FROM igf.igf_gr_rfms_disb_all WHERE disb_ack_act_status = 'ACCEPTED' AND disb_amt != disb_accept_amt;

Related Objects

The table maintains defined foreign key relationships with other critical RFMS staging tables, forming a key data model for grant disbursement processing.

  • Primary Key: The table's primary key is IGF_GR_RFMS_DISB_ALL_PK on the RFMD_ID column.
  • Foreign Key References:
    • IGF_GR_RFMS_BATCH_ALL: The RFMB_ID column references this table to associate each disbursement record with a specific transmission batch sent to the external RFMS.
    • IGF_GR_RFMS_ALL: The ORIGINATION_ID column references this table, linking the disbursement to its parent grant origination record.