I'm amazed that at almost 200 upvotes and getting on for 6 years of requesting this that Oracle have not even responded to say its on the Roadmap, or even, given the high number of upvotes, just said its never going to be implemented.

Hi, Yep. I think a lot of mine ideas may be directed more towards the ERP/HCM aspects. A good example which I went over with the FDI person was the whole JWT tokens for connectivity. The guide goes into OCI docs for writing great swathes of Java code when all it needed was "download putty, generate a new key using the…

The one big area which I think is a great potential is actually not the product but the documentation set. That needs a major revamp as I don't think it keeps up with the options available, e.g. at times tick boxes in setup are either not documented or the documentation just references their name and not what they do or…

How do you delete a subject area that is published? On the semantic model there are options to add or modify but nothing for delete. We have an empty semantic model (partially due to some issues with a customization branch getting in a mess) but are unable to remove the subject area. We can't promote production back to dev…

Thanks for that, I've got some nice usages of data sets and custom measures in there as well as the graphical aspects. It'll make a nice reference for us :)

HI,. May be worth just doing a sanitised .dva file here (e.g. export removing permissions etc so that it doesn't contain user details) if that works? Feels like good art that should be shared :)

Is there a .dva file available for this? It looks like a great reference example to paw through for use of formatting options and presentation.

Thanks, I think the answer I got to was pulling in customer rather than paying customer as looking at the SQL is seems to go to XLA tables with paying customer and I guess it makes sense as an unpaid invoice won't have a paying customer only billing customer.

I think I have got to an answer looking at the SQL developed and its because of using Paying Customer. It looks like that focuses the query on sub ledger accounting, so if I use the customer and for site bill to site from AR transactions I can then pull in the invoice details. So now I can do a customer account…

I've not had any limit on how many I can run other than how long it takes to get a processing slot and run the incremental. With your pipeline you can set frequent refresh for some tables as hourly as an example and I can see in there you can select DFFs (though I would expect your need to have the related table in…

As Ashish says, for reloading data from source. Reload in effect wipes the warehouse and repopulates for that data entity, where as refresh is an incremental load. If I'm doing any development, e.g. meta data changes such as enabling multiple DFFs and especially disabling DFFs I'll do a reload just so I know I have a known…

I;m getting a little further there: I created another custom calculation MIN(CASE WHEN "Financials - AR Transactions"."Facts - Analytics Currency"."Remaining Amount" <> 0 THEN "Financials - AR Transactions"."Transaction Creation Date"."Transaction Creation Date" ELSE CAST('2049-12-31' AS Date ) END) I now get the earliest…

Hi When I right click I can only do aggregate on count/count distinct on Transaction Date My thinking was to start with MIN("Financials - AR Transactions"."Transaction Date"."Transaction Date") but filter the rows returned for the min aggregate by "Financials - AR Transactions"."Facts - Analytics Currency"."Remaining…

@Veera Raghavendra Rao Koka-Oracle Given that code is for OAC (and hence I am assuming should work with FAW/FDI) does it also work with Fusion Applications OTBI? If so then it should be fairly straight forwards to build an Excel spreadsheet downloader to fetch the ACLs (or indeed build a redwood VBCS page to view them).

I'd agree, we are stating our FAW implementation and one item we can't get directly is the customer profile and associated collector too. I guess it can be done via an XMLP report but it would better if it was in a more supportable method.

Its desperately needed for OTBI under fusion SaaS. Its vital to be able to audit security for anyone who does finance reporting, but having to drill down to each object and folder then view permissions in OTBI is painfully slow and can take days if not weeks.