R12 - Receiving Error When Selecting Lines In Invoice Review ORA-00904: "GLOBAL_ATTRIBUTE30": invalid identifier (Doc ID 1455308.1)

Last updated on APRIL 29, 2016

Applies to:

Oracle Grants Accounting - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Project Billing - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When drilling into the invoice lines in the Invoice Review form (PAXINRVW), the following error is received:

ORA-00904: "GLOBAL_ATTRIBUTE30": invalid identifier

Select the 'Details' button:

FRM-40505: ORACLE error: unable to perform query.
ORA-00904: "GLOBALIZATION_FLEXFIELD": invalid identifier

Changes

<Bug 13585292>: ER:FEDERAL FINANCIAL:ADD GLOBAL DESCRIPTIVE FLEXFIELDS TO CAPTURE TAS/BETC CODES
Added new columns(global_attribute) in tables pa_summary_project_fundings &  pa_draft_invoice_items the the various files to allow the form to work correctly.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms