Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

edited Jul 2, 2019 11:22AM in Reporting and Analytics for ERP 7 comments

Summary

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

Content

Team,

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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