https://community.oracle.com/products/oracleanalytics/discussion/comment/61862#Comment_61862 Is it possible to share the navigation from application and a screen shot showing data in UI? You can mask the sensitive data in your screen shot. Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/comment/61861#Comment_61861 That's right. Thanks.

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.

https://community.oracle.com/products/oracleanalytics/discussion/24086/oracle-bi-reports-in-report-output-the-dates-are-not-coming-as-per-the-format-set-in-user-preference 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…

https://community.oracle.com/products/oracleanalytics/discussion/comment/61856#Comment_61856 I am able to find it under Calculation Component Details: In your original post, you mention about PAYE scheme reference attribute. Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/24083/how-to-translate-the-data-in-a-bip-report-to-another-language 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…

https://community.oracle.com/products/oracleanalytics/discussion/24085/uk-paye-scheme-reference-number-location Can you please share navigation and screen shot pls? Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/comment/61817#Comment_61817 Thank you for sharing it with the community !!!

https://community.oracle.com/products/oracleanalytics/discussion/comment/61797#Comment_61797 Hi Babs, You can try connecting using PAY_ELE_CLASSIFICATIONS_TL.CLASSIFICATION_ID. Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/24063/understanding-oracle-payroll-element-mapping 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…

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.

https://community.oracle.com/products/oracleanalytics/discussion/comment/61783#Comment_61783 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.

https://community.oracle.com/products/oracleanalytics/discussion/comment/61780#Comment_61780 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…

https://community.oracle.com/products/oracleanalytics/discussion/comment/61776#Comment_61776 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.

https://community.oracle.com/products/oracleanalytics/discussion/24054/can-you-please-let-me-know-the-table-names-for-the-below-pvos 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.

https://community.oracle.com/products/oracleanalytics/discussion/24044/need-help-on-creating-otbi-dashboard-for-bi-publisher-reports-with-date-from-and-date-to-parameter Below post should be helpful as well: How to embed BIP report in OTBI dashboard with Date Prompt/parameter? — Cloud Customer Connect Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/24050/report-with-all-text-fields-double-quoted-and-double-quotes-escaped 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)…

https://community.oracle.com/products/oracleanalytics/discussion/comment/61718#Comment_61718 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.

https://community.oracle.com/products/oracleanalytics/discussion/comment/61665#Comment_61665 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.