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 !!!

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, 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…