https://community.oracle.com/products/oracleanalytics/discussion/comment/73351#Comment_73351 Yes, this query will return you the same. Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/27750/how-to-get-the-last-incumbent-date-for-vacant-positions Hi Nivya, You can write a query based on per_all_assignments_m position_id. Get the latest effective start date from assignments table when a position was assigned. Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/27788/need-employee-human-resources-representative-and-hr-business-partner Hi, You need to get it from area of responsibilities tables. Check the query on below thread: Query to find the HRBP Representative of an Employee in HCM Database — Oracle Thanks.

In addition, please make sure you run Refresh Manager Hierarchy. Manager Name not updating in Analysis — Cloud Customer Connect Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/comment/73098#Comment_73098 Hi Nivya, This only works for PDF. Thanks, Mandeep.

https://community.oracle.com/products/oracleanalytics/discussion/27722/how-to-use-attachment-tab-in-datamodel You will need to upload the FAQ to content server and then write a SQL to pull it from there in attachments section. Please check the step by step instructions on below link: Adding External PDF attachments to…

https://community.oracle.com/products/oracleanalytics/discussion/27548/report-retrive-data-well-by-user-who-developed Hi Arafat, Welcome to Oracle Analytics community. Can you give some more details on what the report does? Does the report query use any secured views? Can you check if the other user trying to run the…

https://community.oracle.com/products/oracleanalytics/discussion/27501/bip-report-dynamically Hi Mayur, You can write a with clause CTE in your query which will give you the schedule start date and time and then use that in your main query. Thanks.

If you are talking about Flexfields available on Data model screen, please go through the below documentation: 6 Adding Flexfields Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/27508/what-is-the-use-of-flexfields-in-oracle-bip Hi Flying, Welcome to Oracle Analytics community. You don't need any special steps to display flexfields in BIP. Once the DFF attribute is configured, relevant table column will be populated with data. You can…

Hi @Shounese A , Welcome to Oracle Analytics community. You can add per_person_secured_list_v in your query. It will restrict the data based on role data security. Please add and retry. Thanks, Mandeep.

Hi Prithvi, As confirmed by Kevin, JWT token authentication is not yet support: JWT Token Support for Fusion Applications BIP Webservice (Doc ID 2772939.1) I have submitted an idea for same. Please upvote if you think it will be helpful: Enable JWT token-based authentication for BIP web service calls — Oracle Thanks,…

https://community.oracle.com/products/oracleanalytics/discussion/27422/global-transfers-reporting Hi Gina, Are you looking for a report in FDI? Or in fusion BIP/OTBI? Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/27418/cannot-open-or-schedule-a-custom-bip-report-in-oracle-fusion-analytics Hi, Can you please ask the concerned users to clear browser cache? This should resolve the issue. Thanks, Mandeep.

https://community.oracle.com/products/oracleanalytics/discussion/27428/context-value-in-work-relationship-subject-area Hi Oriana, Can you please check data for these two workers in per_periods_of_service table and scan through the context and other attributes if there is any existing data? Thanks, Mandeep.

https://community.oracle.com/products/oracleanalytics/discussion/27427/race-to-the-certification Hi Manjunath, Welcome to Oracle Analytics community. This community is specific to Oracle Analytics tools. For any other questions, I would suggest you to log your query on Oracle University forum. Oracle University Learning…

https://community.oracle.com/products/oracleanalytics/discussion/27227/hi-all-please-help-me-to-find-the-exact-table-mapped-to-the-demand-planning-data-from-oracle-fusion Welcome to Oracle Analytics community. This forum is specific to Oracle Analytics products. Your query seems to be more on the Fusion SaaS side. So, I…

https://community.oracle.com/products/oracleanalytics/discussion/27231/users-cant-see-data-or-only-their-information Welcome to Oracle Analytics community. Can you please provide more details on the product where you are experiencing this issue? Is it in Fusion Data Intelligence or OTBI? Check if the user have access to…

https://community.oracle.com/products/oracleanalytics/discussion/27242/excel-template-not-generating-out-properly-for-nested-table-joins Hi Simi, Is this a BIP report? And are you using excel template? If possible, please upload the catalog files to review? Check section 6.4.4 of below document: 6 Creating Excel Templates…

https://community.oracle.com/products/oracleanalytics/discussion/27211/customizing-compensation-workbench-report-subject-line Hi Roopa, Welcome to the community. The subject lines are stored at the BPM task level not at notification level. Please check there. This forum is dedicated to Oracle Analytics. So, cloud customer…