So, what you are experiencing is the timezone difference. A datetime attribute is always stored in UTC time in your database, and the app will take care of displaying it in the users time if the attribute is set to 'localised'. For your user this would be UTC+2 as shown in the datagrid. When creating a pdf, the default UTC time is used since this is what's actually stored in the database, which explains the difference in time you are seeing. There's a number of workarounds for this which includes storing the date as a string, checking the users timezone in the PDF create flow.
Your session time also says UTC, so your microflow is not executed in the users context.
You probably have used the following query → select * from tableX where name=’...’. This query will retrieve all information from tableX (also your ID in the Oracle DB). This ID cannot be completed in your entity X, because it’s not described as an atribute of your entity.
To retrieve the correct data from the Oracle DB you need to specify all necessary attributes in the select query.
E.g. select name,email from tableX where name=’...’
ok, apparently I edited a existing question.. But non the less: any ideas? :)