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…

https://community.oracle.com/products/oracleanalytics/discussion/comment/61660#Comment_61660 Can you share a screen shot of what information you are looking for? Thanks.

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

https://community.oracle.com/products/oracleanalytics/discussion/24022/otbi-analysis-for-history-records You may find below thread useful: Historical assignment changes tracked in OTBI report — Cloud Customer Connect Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/24023/where-to-find-postgraduate-loan-information 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…

https://community.oracle.com/products/oracleanalytics/discussion/24015/rtf-preview-failed-why-do-i-get-preview-failed-when-trying-to-preview-an-rtf 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…

https://community.oracle.com/products/oracleanalytics/discussion/23217/guidance-required-for-configuring-otbi-reports-with-multiple-subject-areas 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.

https://community.oracle.com/products/oracleanalytics/discussion/24006/create-primary-mailing-address-column 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.

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

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

https://community.oracle.com/products/oracleanalytics/discussion/comment/61601#Comment_61601 Thanks Dimple. I have gone through the documentation and only CRM/ERP/SCM are supported and HCM is not supported. But again, it doesn't help on adding a new column in existing SA instead of creating a completely custom SA. Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/comment/61599#Comment_61599 Thanks Dimple. But can you share a document which shows step by step guide to create a custom subject area in Fusion SaaS.? Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/24003/how-to-add-a-new-columns-in-otbi-subject-area If you are talking about Fusion SaaS subject areas, you can't really add any new columns in that. Oracle delivers the columns in a subject area. Only possibility is to have DFF attributes. Once you create a…