@User_2EC4C , Do you mean Oracle SQL Developer Data Modeler? If yes, then you are in the wrong forum. Because it's a different platform your question can't be moved to the right place. You will need to repost it in https://forums.oracle.com/ords/apexds/domain/dev-community/category/sql-developer

And you don't even need * in the name, just leave it empty and click "Query". Without a name you search for it return all of them by default (at least in the 2023 Jan Admintool, but I doubt somebody did change the behavior in the meantime).

Please do not triple post. https://community.oracle.com/products/oracleanalytics/discussion/20653/i-want-query-otbi-for-below-columns-ar-invoice-integration-exception-report-using-interface-tables#latest

Please do not (double or) triple post. https://community.oracle.com/products/oracleanalytics/discussion/20653/i-want-query-otbi-for-below-columns-ar-invoice-integration-exception-report-using-interface-tables#latest

You can easily export a list into a CSV if you open your RPD in the Model Administration Tool. Go in the "Tools" menu and select the "Query Repository". There you will need to make 2 queries. One for the type "Physical Foreign Key" to get the the "simple joins". You can export the result into a CSV and you can click on…

@Sumanth V -Oracle , all the old threads like this one being 3 years old that have been imported from the old OTN forum are abandoned, no need to post anything as nobody will really come back to look at it (they should never have been imported like that, if they really had to be here they had to be locked when not having…

Wrong tool for the job: OAC is not an ETL tool. It can do part of it, but shouldn't be used as purely an ETL tool...

So .... is this Fusion? If you are using Fusion Analytics Warehouse (now called Fusion Data Intelligence Platform), which one of these is your question about? ERP, SCM, HCM, CX (these are categories in this forum where the question can be moved) If you aren't using Fusion Analytics Warehouse, then you should ask in the…

@Alex111 , What product (full name and version) is this about? I suspect it's posted in the wrong category (and this is an abandoned thread by the author 6 years ago). Based on your reply, the post can be moved or we could point you to the right forum.

There are some Oracle product managers and some Oracle support employees in this forum (not sure about developers). But no idea about the users of the Fusion forum, because you clearly expect an answer from them. In the end your question is really more about the Fusion data and the Fusion business rules, not the technical…

Well, I don't remember having seen that kind of question because there are (to make it very generic) 2 possible situations: 1) you don't build or maintain the reports and just run reports that are part of the tool 2) you do build reports yourself In the case of 1), you often have no way to say if it's the case or not,…

Well, if it's really about fusion, then you should look in a "parallel" forum: https://community.oracle.com/customerconnect While if it's about Fusion Analytics Warehouse or Fusion Data Intelligence Platform (the new name for FAW), it's just moving this to a different category (and this can be done easily). But those…

Hi, Is this a question about FAW (Fusion Analytics Warehouse or the new name that I can't remember right now for it) or purely a Fusion question? Fusion is covered in a parallel forum: https://community.oracle.com/customerconnect , while if it's about a FAW report your question can be moved in one of the FAW categories…

@User_KAST0 , no need to post again (which would be double posting, against the forum rules), it has been moved to the right category already.

If you aren't getting an answer fixing your issue from the SR, keep working on it with Oracle Support. There you have the best chances to get an answer (mostly because you can share all the details of your environment in a private way, while here it's still a public forum).

You did tag "HCM" and your question seems to be more about data than about a BIP report. Is your question about Fusion HCM Analytics? If it is, it will be moved in that category. If it's about another product, if you provide the full name we could maybe point you in the direction of the right place where to ask.

Didn't you get an answer to your question? You marked the thread as answered with an accepted answer. Also, keep in mind that a forum doesn't replace Oracle Support: if you don't get what you need from a public, community, forum you can always raise an SR.

Hi Jean-Pierre, Is that simple datasets in DV or you are doing the work via the RPD? As you talk about "fact table", I assume there is the RPD (Semantic Model) somewhere. If you add a measure being a MIN() and another being a MAX() on your date, you can then have a derived column being the difference between the 2. If you…

As you have SQL Developer on the same host, is that a Windows OS? (I assume you are using a certified OS, right?) What version of OAS are you installing? Did you try with the graphical interface of the RCU just to work on your connection details? The RCU in silent mode can be a bit "picky" on how your provide the password…

How can I check for firewalls? You don't need to do it... You said you have SQL Developer on the host where you are running the RCU comment (and I assume you aren't connected remotely somewhere else to run the RCU but it's really executed locally) and you can connect to your ATB database just fine.