Hi Bushra, This is more of an HCM Extract/Payroll issue instead of reporting issue. While this forum category is specifically for Fusion Data Intelligence, I highly recommend you to visit cloud customer connect and see if someone has already encountered a similar issue or raised a similar idea. Idea Lab – Payroll,…

Hi, Can you please share some more details on the product for which you are looking for this enhancement? Thanks.

Just remove other two and keep only the concatenated one.

I can see data is coming as expected in Test column. What is the expectation? Thanks.

Can you paste a screen shot of what you see after using CONCAT? Thanks.

Hi, To answer your first question related to delivery details, these details are not stored in any fusion tables. So, you can't query these. Fusion BIP: Tables that Stores SFTP Details And How A BIP Bursting Query Can Get Default SFTP Details (Doc ID 2804172.1) There is already an idea submitted for same, please evaluate…

On the special folder, you need to give Open permission to role X. If you just give traverse permission, this is the same scenario as previous. Thanks.

You will need to create a separate new folder under 'Finance' and put Sales Report under that. Nos with Traverse permission, user X should be able to see new folder and report under it. https://docs.oracle.com/cd/E12096_01/books/AnyWebAdm/AnyWebAdm_SecPermPriv8.html Thanks.

Duplicate of below post and posted in incorrect forum. Please post it in Customer connect to get proper response: The Issue In the FBDI Process — Oracle Analytics Thanks.

Hi Prasanna, This forum is specifically for Oracle analytics. For any queries related to ERP, please post on below community: Receivables & Collections — Cloud Customer Connect Thanks.

This really is becoming a bottleneck now where organizations are using both ERP and HCM on same fusion environment due to the data security breach. A specific HCM/ERP/SCM role should be required to see the datasource for that particular module. Thanks.

I think that should be possible. From the ESS job you can create a LOV parameter and tie it to BIP parameter which can have a similar query but with ID passed in the backend. Have you tried this? Thanks.

Can you try below? Add a field to the report > Field Settings > Edit Formula. Edit the formula and use concat function to concatenate the columns: CONCAT("Processed Time Entry Details"."Payroll Time Type Name","Expenditure Type"."Resource Type Name") Set the column header from Column properties: Thanks.

Duplicate of below: Hi, I need a query to split the salaried hours as 8 hrs/day from the state of earnings. — Oracle Analytics Thanks.

Also, you can check the ready to use query on below link: https://fusionhcmknowledgebase.com/2022/03/how-to-get-the-offerings-and-opt-in-features-in-cloud-applications/ Thanks.

Hi Pooja, I don't see this idea is related to FDI. Can you please post it on cloud customer connect which is more appropriate for fusion apps: Idea Lab – Receivables & Collections — Cloud Customer Connect And close this idea down. Thanks.

Hi, You can check about the dimension elements from MOS note which I mentioned in my post. For other one customer connect, create an account on customer connect and provide CSI of your customer and you should be able to access. Thanks.

Please check if below helps: How to join Cost Accounting Real Time and Inventory Transactions Real Time in OTBI reporting? — Cloud Customer Connect Check below MOS for more details on cross SA reports: Fusion Applications OTBI: Guidelines for creating cross subject area analyses in Oracle Transactional BI (Doc ID…

In your main select clause: add below: Pay_Run_Balances.Balance_Value num_of_hours ,(Pay_Run_Balances.Balance_Value/10) per_day_hours FROM ….. add a new line in from clause: , (select level lvl from dual connect by level <= (Pay_Run_Balances.Balance_Value/10) ) in where clause: and lvl <=…

Please check if below helps: SQL Query for Time Card Data and Absence Details — Cloud Customer Connect Thanks.