Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
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.
-
Hi Harald, I think this is possible, Please check the below worked out example from Oracle team: Report Delivery Example Using an Agent — Cloud Customer Connect (oracle.com) Thanks.
-
You can share the catalog folders by roles. Are you facing any challenges with this? Thanks.
-
Hi Martin, Can you share how the dates look in backend? Can you share an example of ARRIVAL_DATE_ISO and DEPOSIT_DUE_DATE from backend? Thanks.
-
Hi Nagendra, Please check below threads: How to remove setting icon from BI report — Oracle Analytics Thanks.
-
Hi Harald, Can you be bit more specific with your question? Do you want to use it in Fusion BIP or OAC? Thanks.
-
Hi @Kauan_Bohn , You need to explore below path: INV_ORGANIZATION_DEFINITIONS_V -> LEGAL_ENTITY join to XLE_ENTITY_PROFILES.NAME and then XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID should map to XLE_REGISTRATIONS.SOURCE_ID Can you try this? Thanks.