You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Query for Business Units and Legal Entities mapping for Payables.

Received Response
edited Jul 15, 2020 1:32AM in Reporting and Analytics for ERP 4 comments


Need query to fetch Business Units and associated Legal Entities mapping for Payables.


Hi All,

I am having requirement to fetch all the Legal Entities available for the Business Unit while creating Payable Invoices manually.

Whenever we select specific Business Unit from the list the Legal Entities are being populated accordingly,Need to get this mapping between Business Unit and Legal Entity with respect to Cloud Payables.

Attached is the screenshot for the same screen mentioned above.Please help with the query or if any standard report available then that will too work,


Thanks in advance. 


Oracle Cloud Application 20B (

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!