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.

Can you check below: How do I define the dashboard prompt to include date range on the same column — Cloud Customer Connect Similar to what Bhaskar has suggested but with some more details. Thanks.

This is one of the common requirements and should be implemented.

Hi Gilson, Can you please elaborate a bit more? Like which module is this and what version and are you looking to report unprocessed transactions for a subject area? Thanks.

Happy New year, Matt. Thanks for sharing. It really helps with screen shots. Thanks.

Upvoted !!!