Hi Khalid, Please check if any of the below links help: Query for joining inventory transaction tables to costing transaction tables — Cloud Customer Connect (oracle.com) Is there a table for Depletion Layer? — Cloud Customer Connect (oracle.com) Need Tables for Cost Transactions Depletion Layer Details — Cloud Customer…

Hi @User_UNRLP , Okay, then this is not supported. I have upvoted your idea. Thanks.

Hi @User_VICIT Can you try below format in your template? <?xdoxslt:current_time('ja-JP', 'Asia/Tokyo')?> Thanks.

Hi @sailesh_cloudare , Did you check below comment? How to embed an OTBI analysis into HCM Cloud UI - Page 2 — Cloud Customer Connect (oracle.com) Thanks.

Hi @Kauan_Bohn , If the LSQL from SA doesn't satisfy the requirements, I normally prefer to go via SQL using tables as that : Gives me more control on filters/attributes No need to create different data sets for diff data sources. Thanks.

Hi @Xavier H. , The solution to this is to edit the data model using text editor instead of BIP. Follow the steps mentioned in below MOS note: Fusion BI Publisher - How to Get Around Lexical References When Customizing a Seeded Data Model (Doc ID 2318462.1) Thanks.

Hi @Kartik Mali-Oracle , I couldn't find a way to remove it when viewing the report using link. But once you add it in the navigator, it shouldn't see xdo: https://fusionhcmconsulting.com/2021/06/bip-providing-link-of-bip-report-on-self-service/ Thanks.

Hi @Victor H, Unfortunately, there is no documentation available for this except for DOR deep links. I had raised an idea already for DOR and Oracle delivered: https://community.oracle.com/customerconnect/discussion/581938/21c-parameter-list-for-document-records-deep-links#latest But for other than DOR, no documentation…

Hi @Susan Anderson , Which subject are you are using? Thanks.

Check if below thread helps: https://community.oracle.com/customerconnect/discussion/32951/how-to-embed-an-otbi-analysis-into-hcm-cloud-ui Thanks.

Hi @Mohamed Mohsen, This is not possible. Once the user have access to BIP data model and select from a table, they can access data from all tables. @user10597052, Secured views work well for end user who just has access to run a report. But for a person with create data model access, this is not possible to restrict data…

Hi @user10597052, There is no way to restrict the access only to certain tables for a specific user. If a user has access to any table, he/she will get access to all the tables. However, in HCM, there are few tables which are marked as sensitive data which will not retrun any data if the user doesn't have appropriate…

Hi @Kauan_Bohn , You may create a different data set in your data model based on tables and then try to join it with data set created using OBI EE source. In the same data set, you will not be able to add columns from direct tables. Thanks.

Hi @Jefry Carpio , This is not possible currently. Please evaluate the below idea and upvote: https://community.oracle.com/products/oracleanalytics/discussion/20052/expose-table-for-bursting-output-results Thanks.

Hi @Suprit , There is no option to get these details from backend. Only option is to check from Reports Job history which is not viable in case the expected count is too high. There is an idea raised already to expose backend tables:…

Please check below MOS notes: FA BICCC : Data Lineage Document for DFFs and Their Associated VOs (Doc ID 2463485.1) How to Review Database Lineage Mappings, Check For Columns and View Objects for BICC PVOs? (Doc ID 2626555.1)…

Hi @Shanmukhi , Unfortunately, there is no way of getting these details from backend currently. There is an idea submitted for same: Expose Table for Bursting Output Results — Oracle Analytics Please upvote the idea so that it can be considered for future enhancements. Thanks.

I agree @User_VICIT. XDOTIMEZONE should work as well. But what I shared was a workaround from SQL side. Can you share the syntax you are using in your template? Thanks.

If you just want to pass multiple values, instead of giving an option to choose multiple values from a list, then you can use the workaround mentioned in below MOS note: Fusion Applications - How to Pass Multiple Values in a Single Parameter to Custom ESS Job that Submits Custom BI Publisher Report (Doc ID 2774925.1)…

Hi @User_WBLBP , The status is same still i..e multi select is not supported through ESS jobs. Once it is available, the MOS doc which I shared earlier either will get an update or will be archived by Oracle. Also, the idea link I shared still doesn't say that the functionality is available. The idea status changes when…