Procurement Tab Customer Query Errors with The Search cannot be Executed because the Table has Pending Changes that would be Lost.
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