Search Results ack_date

Overview

IGF_AW_DB_CHG_DTLS_V is a database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the IGF (Financial Aid) product family. Its stated purpose, as documented in the ETRM metadata, is to present "disbursement change details" for financial aid awards. The view is defined over a single base table, IGF_AW_DB_CHG_DTLS, and exposes the full set of change-detail attributes alongside a small number of derived, human-readable description columns.

In EBS 12.1.1 and 12.2.2 the object carries a VALID status and is used primarily as a reporting and integration surface. Rather than querying the underlying change-detail table directly, downstream reports, extracts, and interfaces reference the view so that coded values such as disbursement activity and disbursement status are returned with their corresponding lookup descriptions already resolved. The user search term "ack_date" corresponds to a column defined within this view, reflecting the acknowledgement date that a disbursement change received from an external processing partner or disbursement agent.

Underlying Base Objects

According to the documented view text, the view is defined over exactly one base object: IGF_AW_DB_CHG_DTLS, aliased as CHGDTL. The ETRM metadata lists the referenced base objects as "none documented"; however, the view definition published in the same documentation clearly identifies IGF_AW_DB_CHG_DTLS as the sole source table. The "none documented" entry should therefore be treated as a metadata gap rather than as evidence that the view has no base table.

The view does not perform joins to lookup tables in the conventional sense. Instead, it invokes the stored function IGF_AW_GEN.LOOKUP_DESC twice, passing lookup type names IGF_DB_DL_ACTIVITY and IGF_DB_DL_DISB_STATUS together with the corresponding code columns from the base table. This function call is the mechanism by which the derived description columns are produced. Because the function is called at query time, performance characteristics differ from a join-based view, and the returned descriptions reflect the lookup values current at execution.

Key Columns

The view exposes the base table's primary identifiers and descriptive attributes, including AWARD_ID, DISB_NUM, and DISB_SEQ_NUM, which together identify the award and the specific disbursement schedule line. Financial values include DISB_ACCEPTED_AMT, ORIG_FEE_AMT, DISB_NET_AMT, and INTEREST_REBATE_AMT.

• ACK_DATE — the acknowledgement date for the disbursement change; central to the "ack_date" search that surfaced this object.
• DISB_ACTIVITY and DISB_ACTIVITY_DESC — the coded disbursement activity value and its resolved description.
• DISB_STATUS and DISB_STATUS_DESC — the coded disbursement status and its resolved description.
• DISB_STATUS_DATE, DISB_DATE, BOOKING_DATE, and PYMNT_PRD_START_DATE — key date attributes for the change record.
• DISB_REL_FLAG, FIRST_DISB_FLAG, and DISB_CONF_FLAG — indicator flags for release, first disbursement, and confirmation.
• BATCH_ID_TXT and BOOKING_ID_TXT — text identifiers for the batch and booking associated with the change.
• NOTE_MESSAGE — a free-text note attached to the change detail.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, and REQUEST_ID — standard EBS audit columns.
• ROW_ID — the ROWID of the underlying base-table row, exposed in place of a synthetic primary key.

Common Use Cases and Queries

The view is typically queried to report on disbursement changes for a given award or disbursement, to reconcile acknowledgement and booking activity, and as a source for integration extracts. A representative query retrieving acknowledgement information for a specific award is:

• SELECT AWARD_ID, DISB_NUM, DISB_SEQ_NUM, DISB_STATUS_DESC, ACK_DATE, BOOKING_DATE, DISB_NET_AMT FROM IGF_AW_DB_CHG_DTLS_V WHERE AWARD_ID = :p_award_id AND ACK_DATE IS NOT NULL ORDER BY DISB_NUM, DISB_SEQ_NUM;
• SELECT DISB_ACTIVITY_DESC, DISB_STATUS_DESC, COUNT(*) FROM IGF_AW_DB_CHG_DTLS_V WHERE TRUNC(ACK_DATE) BETWEEN :p_from AND :p_to GROUP BY DISB_ACTIVITY_DESC, DISB_STATUS_DESC;
• SELECT ROW_ID, BATCH_ID_TXT, ACK_DATE, NOTE_MESSAGE FROM IGF_AW_DB_CHG_DTLS_V WHERE BATCH_ID_TXT = :p_batch;

Because ROW_ID is exposed, the view can be used within an EBS forms block or an update-capable context that keys on the underlying IGF_AW_DB_CHG_DTLS row, although the view should be treated as read-oriented for reporting purposes. Callers should also note that the description columns are computed through IGF_AW_GEN.LOOKUP_DESC and therefore add function-call overhead to every execution.