What is your exact requirement? Do you want to create a report and provide a DOR in that or the requirement is to bulk download the DORs? If you want to create a report, then you can provide the link to DOR attachment stored on UCM: If you want to download all DORs in bulk, then check below: Let me know if you need any…

Hi Bala, I would suggest you to raise this query on customer connect → integration forum to hear from integration experts or people who may have faced a similar challenge: Integration — Cloud Customer Connect Thanks.

Are you using a standalone BIP or BIP as part of Fusion SaaS? Thanks.

Great resource !!!

Hi Abhijit, Your understanding is correct. It will not be possible to execute this DM standalone as confirmed in the post by Swapnil that I shared in my first post: Transactions Print Data Model Parameters — Cloud Customer Connect Thanks.

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: 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…