https://community.oracle.com/products/oracleanalytics/discussion/comment/62180#Comment_62180 Can you paste a screen shot of what you see after using CONCAT? Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/24152/table-name-with-delivery-configuration-details 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…

https://community.oracle.com/products/oracleanalytics/discussion/comment/62171#Comment_62171 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.

https://community.oracle.com/products/oracleanalytics/discussion/24151/traverse-permission-access-to-folder 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://community.oracle.com/products/oracleanalytics/discussion/24149/assistance-required-with-oracle-fbdi-process-for-multiple-transactions 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.

https://community.oracle.com/products/oracleanalytics/discussion/24148/the-issue-in-the-fbdi-process 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.

https://community.oracle.com/products/oracleanalytics/discussion/23931/ess-job-we-need-to-submit-the 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.

https://community.oracle.com/products/oracleanalytics/discussion/24146/how-to-show-two-columns-as-one 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…

https://community.oracle.com/products/oracleanalytics/discussion/comment/62115#Comment_62115 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.

https://community.oracle.com/products/oracleanalytics/discussion/comment/62118#Comment_62118 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.

https://community.oracle.com/products/oracleanalytics/discussion/24143/ar-user-approval-limits-using-api 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…

https://community.oracle.com/products/oracleanalytics/discussion/comment/62130#Comment_62130 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.…

https://community.oracle.com/products/oracleanalytics/discussion/24140/can-we-create-inventory-transaction-costs-report 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:…

https://community.oracle.com/products/oracleanalytics/discussion/comment/62124#Comment_62124 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 <=…

https://community.oracle.com/products/oracleanalytics/discussion/24138/sql-query-to-get-recorded-absences-on-their-time-cards-in-oracle-fusion-cloud Please check if below helps: SQL Query for Time Card Data and Absence Details — Cloud Customer Connect Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/comment/62120#Comment_62120 That was just an example. Instead of below: '80' num_of_hours, to_number('80')/to_number('10') per_day_hours Use your actual table.column names. If you are not able to replicate, share the table name and column name, I can try to…

https://community.oracle.com/products/oracleanalytics/discussion/24135/what-are-the-database-tables-for-opt-in-features-in-oracle-fusion-cloud Also, duplicate of below post: What are the database Tables for Opt in Features in Oracle Fusion Cloud? — Oracle Analytics Can you please close one? Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/24134/what-are-the-database-tables-for-opt-in-features-in-oracle-fusion-cloud You can get these details in ASM_FILTER_OPTIONS_FILTERS table. Please check below MOS note for other related tables: What are the tables or views related to Offerings And Opt In…

https://community.oracle.com/products/oracleanalytics/discussion/comment/62114#Comment_62114 You can write something like below: select papf.person_number ,'80' num_of_hours, to_number('80')/to_number('10') per_day_hours from per_all_people_f papf, (select level lvl from dual connect by level <=…