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

Unable to use 2 Subject Areas in the OTBI report

Accepted answer
edited Jun 28, 2019 6:20AM in Payables, Payments & Cash Management 1 comment


OTBI error while using Payables Payments - Disbursements Real Time and Payables Invoices - Transactions Real Time



We have created an OTBI report using the Payables Payments - Disbursements Real Time subject area for displaying the invoice details, payment details and Invoice distribution details distinguished by the Location and Legal entity.

But the distribution not splits to give in detail. Instead of that actual invoice amount is printed in all the lines. Hence I have added Payables Invoices - Transactions Real Time to display the invoice distribution Location and Legal entity as separate column.

After added the columns the report completed in error as "You may be able to evaluate this query if you remove one of the following column references:". I have attached the error details.


Howdy, Stranger!

Log In

To view full details, sign in.


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