Procurement Tab Customer Query Errors with The Search cannot be Executed because the Table has Pending Changes that would be Lost.

(Doc ID 1954651.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Planning and Control - Version 12.1.3 and later
Information in this document applies to any platform.


After drilling into a customer invoice amount and querying for a particular invoice, the following error is received:

Error The search cannot be executed because the table has pending changes that would be lost.

This error is received if you are querying on the AR Invoice Number, the Invoice Number or both.

Also note that when trying to choose the invoice number from the list of values (LOV), there are multiple rows returned for each invoice number.

Steps to Reproduce:

1.  Responsibility:  Projects Super User
2.  Query project | Procurement Tab
3.  Select the first customer in the 'Customer' section and drill into the amount
4.  Query for a specific AR invoice number


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