R12 PAXINRVW Invoice Review Screen Show Duplicate Draft Invoices (Doc ID 1453447.1)

Last updated on JULY 01, 2016

Applies to:

Oracle Grants Accounting - Version 12.1.3 and later
Oracle Project Billing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

The Invoice review form (PAXINRVW) shows duplicate draft invoice numbers. 

The number of duplicates seem to correspond with the number of active key members on the project as of the bill through date. For example: If there are 3 active key members on the project as of 03-MAR-2012 then a draft invoice billed through that date will show up 3 times.

You may also experience the following errors in the form when drilling into invoice lines:

ORA-00904: "GLOBAL_ATTRIBUTE30": invalid identifier

Click on the 'Details' button

FRM-40505: ORACLE error: unable to perform query.

Another error received is:

ORA-00904: "GLOBALIZATION_FLEXFIELD": invalid identifier

 

Changes

 Applied patch:13345756

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