There is no way to get this information unfortunately. If you are having only financials , you can try looking on GL_FRC_REPORTS_B table but again it won't give you exactly what you are looking for. GL_FRC_REPORTS_B and Custom Folder and Report List — Cloud Customer Connect Thanks.

Hi, For a standalone HCM application, no need to run - Create Rules XML File for BI Extender Automation job. Only the second ESS job should be run. Have you tried running that after checking HCM parameter checkbox? Thanks.

Can you please share some more details on the subject area name, DFF name , attribute name and type of value set attached? Is the attached value set of type table? Thanks.

You should see two attributes one with Description. Try to use the description column. Thanks.

Isn't this for UK Statutory plans? Hi @BFell , Looks like these details are calculated in UI and are not stored in DB to be auto reported: Absence OTBI or query to fetch qualification plan use details with entitlements — Cloud Customer Connect Thanks.

This forum is dedicated to Oracle analytics. Please post your query on customer connect for better response: Human Capital Management — Cloud Customer Connect Thanks.

In which product what you are trying to do? What is the exact requirement? Thanks.

Did you check the query on the link? It shows links to RA_CUSTOMER_TRX_LINES_ALL/ra_cust_trx_types_all tables which are finance tables. Thanks.

Check if below helps: Link between DOO_HEADERS_ALL and INV_PICK_SLIP_NUMBERS — Cloud Customer Connect

So, basically you are looking for a customer PO number and the invoice against that? Can you share your complete requirement? Thanks.

Is Customer_po_number same as Invoice_num ? If yes, you can create two data sets - one with SCM data source and one with FIN data source and join them using the mentioned columns. Thanks.

Hi Vrinda, The issue lies in the underlined: The 'E' is end for loop which is ending before your newly added column. Please cut the 'E' part and paste it under Type, next to Transaction_type tag and it should work. Thanks.

Hi, Were you able to achieve this requirement? If no, can you try below approach: RTF file Configuration for Eliminating Null Value Column — Oracle Analytics Thanks.

There is no straightforward way of achieving it. However, you can try below approach: Create an RTF template with 4 different tables. First table will have only the 3 columns which are always displayed. Second table shall have 3 mandatory + one optional column and so on. Create 4 temporary variable at RTF level. Initialize…

Hi, This is the expected behavior when downloading the data as csv directly. There is already an idea submitted for similar requirement. Please go through the idea, evaluate it and upvote if you will it will be helpful: Allow report with eText template to output a report to csv with the same structure — Oracle Analytics…

This would definitely be a great enhancement. But it will require a major overhaul in the current reporting structure.

Can you check if below helps? Purchase Order PDF Using Sub Templates — Cloud Customer Connect Thanks.

Are you talking about Semantic Model extensions? In case you have some extensions, you need to add security configurations under Fusion Data Intelligence Console, click Semantic Model Extensions under Application Administration. Does that help? Add Security Configurations Or if your question is different, can you please…

It doesn't work exactly the same way as we have a difference in terminology. But data will be secured as per roles in FA. Check below blog for more details: Implementing Data Level Security in Oracle Analytics Cloud Using Identity Cloud Service Thanks.

Can you please confirm the document type and show a screen shot from UI for DOR? Thanks.