https://community.oracle.com/products/oracleanalytics/discussion/comment/73365#Comment_73365 If you pass the person number in the query I shared, what data you get? Are you able to share a screen shot of data? Thanks.

Congratulations All !!! Keep up the great work !!

https://community.oracle.com/products/oracleanalytics/discussion/27777/how-to-create-a-new-enhancement-request Hi Joyce, Welcome to Oracle Analytics Community. You can log an idea for FDI in the idea lab below: Oracle Fusion Data Intelligence Idea Lab — Oracle Check the Ideas tab on home page to access idea labs for other…

https://community.oracle.com/products/oracleanalytics/discussion/27773/how-should-i-schedule-my-certificate-exam Hi , Welcome to Oracle Analytics Community. This community is specific to queries/ideas related to Oracle Analytics products. For any certification related queries, please post it on sister OU community to get a…

https://community.oracle.com/products/oracleanalytics/discussion/27754/how-to-edit-groovy-script-and-test-in-pricing-algorithm Welcome to Oracle Analytics Community. Can you please elaborate a bit more on your requirement? Is your query related to reporting? If no, please post your query on the cloudcustomerconnect for…

https://community.oracle.com/products/oracleanalytics/discussion/27790/how-can-we-relate-doo-headers-or-with-fulfill-table-with-requisition-po-with-receipt-for-bip-report Hi Sophiya, I request you to search this topic on cloudcustomer connect to check if there is something available already? "doo_fulfill_lines" - Cloud…

Congratulations all !!!

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.