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.

https://community.oracle.com/products/oracleanalytics/discussion/24032/how-restrict-custom-bi-report-data-based-on-flexfield-segment-value 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…

https://community.oracle.com/products/oracleanalytics/discussion/comment/61687#Comment_61687 These roles have access to learning duty roles as you can see below: Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/comment/61693#Comment_61693 It should be under offerings only. You can check the attached PDF for step by step guide. Thanks. https://us.v-cdn.net/6037859/uploads/23JTDNS2NMQH/blog-bicc-vendor-extract-ver4.pdf

https://community.oracle.com/products/oracleanalytics/discussion/24037/generate-report-for-transactional-tables-in-ap I don't think there exist any such view. There are views available but you need to modify based on your requirement: AP_INVOICE_EXTRACT_HEADER_V Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/24027/i-am-trying-to-build-an-otbi-report-that-shows-prs-with-the-status Hi, Are you talking about purchase requisitions? Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/comment/61662#Comment_61662 This looks like a BUG and is not supported currently. These two attributes are non enabled for BI reporting as you can see in below screen shot: Hence not available in SA. You may want to log an idea for same. This is similar to…