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…

Hi @User_VICIT, If you have the SQL ready to get user's preferred timezone, then you can use below function Data model and try: CAST(wlif.start_date AT TIME ZONE wlaf.time_zone AS DATE) actual_date_time where wlaf.time_zone —> timezone from user preferences. Thanks.

Hi @User_VICIT , Can you please elaborate a bit more? Are you trying to convert some date time from a backend table to a time in a timezone specified at "User >> Set Preferences >> Regional >> Time Zone specific" ? Thanks.

Hi @User_UNRLP , If the requirement is to send a static PDF, you can check the below blog post: https://fusionhcmknowledgebase.com/2020/10/adding-external-pdf-attachments-using-bursting/ Thanks.

Hi, This is not supported currently. Is It Possible To Enable Multiple Selection Setting For ESS Job Parameters (Doc ID 2871349.1) There is already an idea submitted, please upvote: Enable multi selection parameters in ESS job — Oracle Analytics Thanks.

Hi @User_UNRLP , The separate attachment which you want to deliver is that a static attachment or the contents change? Thanks.

Hi @User_UNRLP , This is supported. You can create an RTF template with all your header/footer and images and in the bursting definition use PARAMETER6 as False. This will use the RTF data as email body. Let me know if this suffice your requirements. Thanks.

Hi @Paulina Vega , As per the Oracle docs, employee role doesn't have access to this subject area: Workforce Management - Worker Assignment Real Time (oracle.com) Thanks.

You need to enable audit policies and then you can get the required data. Please check below thread for more details: Role Assignment history of users — Cloud Customer Connect (oracle.com) Thanks.

Hi @Ivony Ann Paula Salango , Is your question around OTBI analysis or a data model based BIP? If this is related to OTBI, please check the response on below thread: OTBI Analysis rearranging Column Order different in CVS and EXCEL — Cloud Customer Connect (oracle.com) Thanks.

Also, check if you can create something as suggested on below thread using REST APis: List of all Agents created in OTBI — Cloud Customer Connect (oracle.com) Thanks.

As per my knowledge, there is no direct way of doing it. However, you can use workaround as mentioned in below MOS note: Fusion OTBI - How to find all of your BI Agents in your system (Doc ID 1672432.1) Thanks.

Hi @Swsa , Can you please confirm if you are having ESS Monitor role? If no, please assign ESS Monitor role and retry: What Job Role Will Allow a Single Fusion User to View all ESS Scheduled Processes/Jobs? (Doc ID 1467664.1) Only the user who has scheduled the report will be able to see it in Manage Report Jobs by…

Yes, @Harald Jæger . Actually, I don't prefer that way. Instead of that, better to use BIP data model directly. Thanks.

Hi @Swsa , Can you remove the owner and see if you are able to see any scheduled jobs? Thanks.