Search Results canceled_flag

Overview

GMS_DRAFT_INVOICES_V is a Grants Accounting (GMS) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents draft invoices generated against awards and projects, enriching the core Project Accounting draft invoice records with award, project, customer, organization, currency, and workflow status attributes. The view is a reporting and integration vehicle: it consolidates data that would otherwise require joins across Award Management, Project Accounting, Receivables, Human Resources, and Trading Community Architecture tables into a single queryable structure.

The view is especially relevant in grants environments, where invoice processing must be tied to award terms, bill-through dates, retention percentages, and recipient accounting. Its status derivation logic (generation error, unapproved, unreleased, released, rejected, transferred, accepted) supports operational monitoring of the draft invoice lifecycle.

Underlying Base Objects

The view is defined over a substantial set of documented base objects. Core invoice data comes from PA_DRAFT_INVOICES, PA_DRAFT_INVOICES_ALL, and PA_DRAFT_INV_ITEMS_BAS. Award context is supplied by GMS_AWARDS. Project data originates from PA_PROJECTS_ALL, PA_PROJECT_STATUSES, PA_PROJECT_TYPES, PA_DISTRIBUTION_RULES, PA_PROJECT_CUSTOMERS, and PA_PROJECT_PARTIES. Customer and party information is drawn from HZ_CUST_ACCOUNTS, HZ_CUST_SITE_USES, and HZ_PARTIES. Organization and personnel data come from HR_ALL_ORGANIZATION_UNITS and PER_ALL_PEOPLE_F. Currency and conversion information is provided by GL_SETS_OF_BOOKS and PA_CONVERSION_TYPES_V, supported by the PA_MULTI_CURRENCY package. Security and access control rely on GMS_SECURITY and PA_SECURITY packages, with role restrictions enforced through PA_ROLE_CONTROLS and PA_PROJECT_ROLE_TYPES_B. Lookups and language handling use PA_LOOKUPS, PA_IMPLEMENTATIONS_ALL, FND_LANGUAGES, and RA_TERMS. Miscellaneous support objects include DUAL, PA_AGREEMENTS_ALL, and PA_OUTPUT_TAX.

Key Columns

• ROW_ID — row identifier derived from the draft invoice record ROWID.
• AWARD_ID, AWARD_NUMBER, AWARD_SHORT_NAME — award identification and naming from GMS_AWARDS.
• PROJECT_ID, PROJECT_NUMBER — project linkage from PA_PROJECTS_ALL.
• DISTRIBUTION_RULE, DISTRIBUTION_RULE_M — distribution rule code and its meaning.
• PROJECT_STATUS_M, PROJECT_STATUS_CODE — project status description and code.
• PROJECT_ORGANIZATION_ID, PROJECT_ORGANIZATION_NAME — owning organization details.
• CUSTOMER_ID, ACCOUNT_NUMBER, PARTY_NAME — customer and party information from HZ tables.
• DRAFT_INVOICE_NUM, TRANSFER_STATUS_CODE, INVOICE_STATUS_CODE, INVOICE_STATUS_M — invoice number and status derivation.
• CHK_STATUS — computed status such as ERROR, UNAPPROVED, UNRELEASED, RELEASED, REJECTED, TRANSFERRED, or ACCEPTED.
• BILL_THROUGH_DATE, APPROVED_DATE, RELEASED_DATE, INVOICE_DATE, PA_DATE, GL_DATE — key lifecycle dates.
• APPROVED_BY_PERSON_NAME, RELEASED_BY_PERSON_NAME — approver and releaser identities.
• INV_CURRENCY_CODE, INV_EXCHANGE_RATE, PROJECT_CURRENCY_CODE — currency and conversion attributes.
• RETENTION_PERCENTAGE, CANCELED_FLAG, WRITE_OFF_FLAG, CONVERTED_FLAG — financial handling flags.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE5 — descriptive flexfield values.

Notably, the view does not expose a RECEIVABLE_CODE_COMBINATION_ID column in the documented excerpt; receivable accounting references are not part of this projection.

Common Use Cases and Queries

Typical uses include monitoring unbilled or unapproved draft invoices, auditing transfer status to Receivables, and validating funding against award terms. A representative query:

SELECT draft_invoice_num, award_number, project_number, customer_id, chk_status, bill_through_date, inv_currency_code FROM apps.gms_draft_invoices_v WHERE chk_status = 'UNAPPROVED' AND bill_through_date >= SYSDATE - 30;

Another common query filters by award or project to reconcile generated invoices and retention amounts:

SELECT award_number, project_number, draft_invoice_num, retention_percentage, approved_date, released_date FROM apps.gms_draft_invoices_v WHERE award_number = :award_number ORDER BY invoice_date DESC;

For integration, the view supports extracting released or transferred invoices for downstream accounting processes, using INVOICE_STATUS_CODE and TRANSFER_STATUS_CODE as selection criteria.