Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Hi Emanuele, This information is stored in metadata tables and is not directly accessible. However, there is a set of BIP audit reports provided by oracle which can give you this information. Check the below link to configure and use Oracle provided audit reports: wp-fusionbipaudit-5459609.pdf Also, below Support note will…
-
It will be great if you can share the query with community. Anyone needing it in future, can reuse. Thanks.
-
Hi Abhijeet, Does this mean that when passing the same parameters from ESS job, the output gets generated but not from data model? Thanks.
-
Can you check if you can see this information in PAY_PAY_RELATIONSHIPS_F table? If no, will you be able to provide the exact DFF name used to define these attributes? Oracle Application's Blog: Query to get payroll name in oracle fusion I don't see any particular subject area to get the additional DFF details of payroll…
-
Can you try below approach? Transactions Print Data Model Parameters — Cloud Customer Connect What values should be provided to lexical parameters for seeded BIP data model? — Cloud Customer Connect Thanks.
-
Hi Florian, This forum is dedicated to FDI. For any queries related to other products, please use customer connect for better response and traction: Payroll and Global Payroll Interface (GPI) — Cloud Customer Connect Thanks.
-
First check is about roles. Do you have same roles in prod as in test? Thanks.
-
Hi @Raghavendra Raghunath-Oracle , can you please advise here? Thanks.
-
Can you try setting the "Keep values in the column" - True under report properties → formatting → Excel 2007 output and try again? Thanks.
-
Upvoted.. It will really help !!!
-
This is strange. Can you confirm if display type is same for other attributes where you can see data? Thanks
-
Upvoted for idea !!!
-
I have created a detailed query with schedule interval and details. Check it on below link: https://fusionhcmconsulting.com/2025/01/bip-report-to-extract-bip-scheduled-jobs/ Thanks.
-
Are you running it from ESS? If yes, there is no way to send it to SFTP from scheduled processes. Thanks.
-
Please check below query: WITH schedule_history AS ( SELECT DISTINCT rh.username scheduled_user_name ,rp.value submitted_job_name ,rh.requestedstart schedule_start_date ,rh.requestedend schedule_end_date ,rh.scheduled next_run_date ,rh.parentrequestid ,rh.requestid ,(SELECT max(rh2.requestid) FROM…
-
You will not be able to update/edit the seeded values/logic coming from a subject area. Either you can create your custom BIP or check if there is any other column in the subject area that can give you the value you are looking for. Thanks.
-
Did the SR consultant advise why this is so? Or if there is any documentation support for this? Does it mean that that the custom SA's will always have a low performance? Thanks.
-
Hi Mani, There is no OOTB the way to achieve this in data model level. You may try to use requisition IDs and candidate IDs instead of numbers. Thanks.
-
Hi KDR, Yes, it is possible to embedded date timestamp in file name when transferring the file to SFTP but not possible when delivering the file to email. You can check the details on below link: Dynamic Output and Bursting for BI Report Thanks.
-
With more and more customers using FDI/OAC and OCI, this is increasingly becoming a must feature to have in fusion BIP.