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

OTBI display duplicates while query don't

edited Oct 24, 2025 5:54PM in Reporting and Analytics for ERP 1 comment

Hi everyone,

We use OTBI to extract some data in Excel to feed an home-made FBDI requisition process. The report included 11 queties, linked by their record_number to get a multi-column Excel list as output.

The issue we face is that for some reason, one of the queries return duplicates in the generated XML, while the result is OK when we run the query in CloudMiner. It's also OK in the report if we use only a single Supplier (ex: TELUS).

Example with all suppliers ("MONTREAL - CAD - 103383" is duplicated) :

TELUS

BURLINGTON - CAD

CAD

TELUS

MONTREAL - CAD - 103383

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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