I got bunch of mdl folders that contains mdl files and when I try to query rpd subject area using the option you mentioned it didn't give all the objects that tied to subject area.

I have tried MDS XML but the original requirement is to get the logical join information and if possible physical join information also in to the csv format to all the subject areas and business models in the rpd. our business analysts doesn't like the xml format. @Gianni Ceresa @christian berg

I have already mentioned you that this is not giving the joins information

I am not sure if any of the patches released but I believe this is most updated version and this was not an issue as my rpd corrupted.I really appreciative you for being so helpful for the oracle community

version 12.2.1.3.0

This is obiee 12c env and I did consistancy check it looks good without any issues