R12: AP: It Is Not Possible to Query Invoices By Legal Entity. (Doc ID 1592332.1)

Last updated on MARCH 01, 2016

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

 In  AP Invoice Workbench it is not possible to query by legal entity.

Query By Example ignores any values passed, and returns records for all
legal entities.
 
The business case is that users can raise queries about AP invoices for a particular Legal entity:
"What are the outstanding invoices to this supplier", "Which invoices are awaiting payment".

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