Please check sample given on below support note to convert it as per User preferences: How To Set Date As Per User Preference Time zone in Fusion Applications BI Publisher Report (Doc ID 2864734.1) Thanks.

The dates by default are shown in date timestamp format as stored in DB. If you need any particular format, you need to define that in your BI data model query. Thanks.

I am able to find it under Calculation Component Details: In your original post, you mention about PAYE scheme reference attribute. Thanks.

Not all the data is translated in fusion HCM. Only the base tables having a name ending with _TL contains translated data. So, what this essentially means is not all the objects are translatable. Thanks.

Can you please share navigation and screen shot pls? Thanks.

Thank you for sharing it with the community !!!

Hi Babs, You can try connecting using PAY_ELE_CLASSIFICATIONS_TL.CLASSIFICATION_ID. Thanks.

Hi Babs, In Oracle, we have element classification - Earnings/Deductions (Voluntary/Involuntary)/Information etc. Gross Pay/Basic Pay are both elements of type classification Earnings. For salaries calculation, the Payroll engine works a lot behind the scenes using fast formulas, element types and other factors as well. If…

This will be a great enhancement. Simple export to PPT output will not be a workable solution in all the cases. Formatting is definitely needed to present data.

Thanks for sharing the details but can you share the value of "FK" from Q1. Also, can't you select legal_entity_id as an attribute in Q1 and Q2 and do a direct join? Thanks.

can you share sample data for both? hou.name || rcta.attribute15 and inv.organization_code AS CODIGO_FILIAL, xl.registration_number AS CNPJ_FILIAL, inv.organization_name AS NOME_FILIAL Also, can you link from q1 to q2 instead from q2 to q1. Thanks.

My apologies. I still didnt understand. You get the legal entity id from your Q1 but when you link it to legal_entity_id from Q2 (XLE_ENTITY_PROFILES), you don't get any data? Thanks.

You can bookmark the below link and always get the latest file: R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet — Cloud Customer Connect Thanks.

You mean legal_entity_id is blank in ra_customer_trx_all ? Thanks.

Below post should be helpful as well: How to embed BIP report in OTBI dashboard with Date Prompt/parameter? — Cloud Customer Connect Thanks.

What is the type of output file txt or csv? Attached document should help. BI Publisher : Double Quotes Get Added To Some Values by Default When Generating CSV Output (Doc ID 2081010.1) Thanks.

I am not aware of any secured views for ERP/SCM. But user department should be from based on HCM data, no? If no, then you need to put a custom security crtieria. Thanks.

I have raised an idea for same. Please upvote if you think it will be helpful: Enable PGL Deduction Start Date and End Date fields in 'Payroll - Calculation Cards Real Time' SA — Oracle Analytics Thanks.

Hi Venkat, If the security is implemented in UI, then you can use secure views. Using secured views will restrict data as per the data roles in application. If the requirement is to implement security only in report, then you need to write a custom security criteria at report query level. Thanks.

These roles have access to learning duty roles as you can see below: Thanks.