Search Results gms_default_reports_u2

Overview

GMS.GMS_DEFAULT_REPORTS is a transactional table within the Oracle E-Business Suite Grants Management (GMS) schema. It stores the definition of reports that are associated with an award and functions as a blueprint from which installment-level report obligations are derived. The table records report delivery frequency and due-date offset information, which the application uses to compute the reports that fall due at the installment level.

From a Data Vault modeling perspective, the heuristic classification for this object is standalone, meaning the mined foreign-key structure does not expose a dense network of relationships that would suggest a classic hub, link, or satellite pattern. This classification should be treated as a modeling suggestion rather than a normative statement. Its single documented foreign key — AWARD_ID referencing IGF_AW_AWARD_ALL — indicates that the award is the principal business parent, and that default report definitions are established in the context of a specific award and report template combination.

Key Information Stored

The table is documented with 32 columns. The most significant are summarized below.

• DEFAULT_REPORT_ID — the surrogate primary key, a NUMBER(15). It is the single column of the unique index GMS_DEFAULT_REPORTS_U1 and the basis of the primary key constraint GMS_DEFAULT_REPORTS_PK.
• AWARD_ID — the award identifier, NUMBER(15), foreign key to IGF_AW_AWARD_ALL. Part of business-key candidate GMS_DEFAULT_REPORTS_U2.
• REPORT_TEMPLATE_ID — the report template identifier, NUMBER(15). Part of GMS_DEFAULT_REPORTS_U2.
• SITE_USE_ID — identifier of the site where the report is to be delivered. Part of GMS_DEFAULT_REPORTS_U2.
• FREQUENCY — VARCHAR2(30), the default delivery frequency for the report.
• DUE_WITHIN_DAYS — NUMBER(15), a date offset establishing how many days before the due date the report obligation is triggered.
• COPY_NUMBER — NUMBER(15), the number of copies to be delivered.
• ATTRIBUTE_CATEGORY — VARCHAR2(30), the descriptive flexfield structure-defining column.
• ATTRIBUTE1 through ATTRIBUTE15 — VARCHAR2(150) descriptive flexfield segment columns.
• Standard Who columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE provide audit and concurrent-program provenance.

The distinguishing surrogate key is DEFAULT_REPORT_ID, while the combination of AWARD_ID, REPORT_TEMPLATE_ID, and SITE_USE_ID (GMS_DEFAULT_REPORTS_U2) represents the documented business-key candidate, preventing duplicate default report definitions for the same award, template, and delivery site.

Common Use Cases and Queries

Typical applications include award reporting setup, generation of installment-level report schedules, delivery-site analysis, and validation of report defaults prior to award activation.

• Listing all default reports for an award: SELECT default_report_id, report_template_id, frequency, due_within_days FROM gms_default_reports WHERE award_id = :award_id;
• Joining to the award to enrich reporting: SELECT a.award_number, d.frequency, d.due_within_days FROM gms_default_reports d, igf_aw_award_all a WHERE d.award_id = a.award_id;
• Identifying delivery sites: query SITE_USE_ID and COPY_NUMBER grouped by award for distribution reporting.
• Auditing setup changes by filtering on LAST_UPDATE_DATE, CREATED_BY, or PROGRAM_UPDATE_DATE.
• Reporting on descriptive flexfield values by selecting ATTRIBUTE_CATEGORY and the ATTRIBUTE1–15 segments for organization-specific report metadata.

Related Objects

The following are the most significant objects associated with GMS_DEFAULT_REPORTS, based on the documented foreign-key relationship.

• IGF_AW_AWARD_ALL — referenced through AWARD_ID; the award is the principal parent entity.
• GMS_REPORT_TEMPLATES — referenced conceptually through REPORT_TEMPLATE_ID, defining the report structure used by each default report.
• GMS_INSTALLMENTS — downstream consumer of the frequency and due-date offset to derive installment-level report obligations.
• GMS_REPORTS — the derived report instances generated from these defaults.
• FND_FLEX_VALUES / FND_DESCR_FLEX_COLUMN_USAGES — supporting structures for the ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 descriptive flexfield segments.
• FND_CONCURRENT_REQUESTS — parent of the REQUEST_ID column used by concurrent programs that create report definitions.

Because the table is classified as standalone, direct dependencies are narrow; most functional linkage flows through AWARD_ID and the report template reference. Administrators and developers should treat GMS_DEFAULT_REPORTS as the authoritative source of award report defaults, with the unique index GMS_DEFAULT_REPORTS_U1 cited in the user's search terms serving as the primary key enforce mechanism.