R12 - Receiving Error When Selecting Lines In Invoice Review ORA-00904: "GLOBAL_ATTRIBUTE30": invalid identifier
Last updated on FEBRUARY 15, 2018
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.
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
<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.
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