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.

It should be under offerings only. You can check the attached PDF for step by step guide. Thanks.

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.

Hi, Are you talking about purchase requisitions? Thanks.

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 below: Field 'Initial Fee Taken' DDFs - Development Descriptive Flexfields Missing (For…

Can you share a screen shot of what information you are looking for? Thanks.

You are right. It is not there in the note. I would suggest you to raise an SR and get a confirmation from Oracle if that is expected or the document needs a revision. If expected, you may need to add it manually as outlined in the note. Thanks.

You may find below thread useful: Historical assignment changes tracked in OTBI report — Cloud Customer Connect Thanks.

Do you have Payroll Manager role? Payroll - Calculation Cards Real Time Thanks.

Please check the step by step guide on below blog: BI Cloud Connector – Custom Object Data Extraction Below links can be useful as well: How to create custom PVO and add it in BICC — Cloud Customer Connect How to Review Database Lineage Mappings, Check For Columns and View Objects for BICC PVOs? (Doc ID 2626555.1) How to…

Can you pls check if any of below help? BI Publisher Desktop Unable to Find the File to Preview: oracle.xdo.XDORuntimeException: Failed in creating XLSX tmp file (Doc ID 2592686.1) BIP RTF Preview Failed — Oracle Analytics Thanks.

Below should be helpful as well: Fusion Applications OTBI: Guidelines for creating cross subject area analyses in Oracle Transactional BI (Doc ID 1567672.1) Thanks.

Please check the query on below link: How do I pull an employee's Primary address in a data model? — Cloud Customer Connect Thanks.

Upvoted !!! this is definitely a good addition.

Currently, it is system limitation. If any of the base table attribute is not available, you can create an idea to bring it in the subject area. Only solution is to create a BIP report in this case. You can create multiple SA reports with conditions. Please check below document for details on cross subject area report…

Hi, As mentioned in my earlier post, it is not possible to extend the seeded subject area. You can't bring any additional columns from base tables into this SA. Thanks.