You are very welcome. Hassan

Hello Nusrat, If you are referring to an OTBI analysis, you could force it to fetch directly from the database and bypass the caching mechanism. To do that, navigate to the analysis in question: 1. Edit the analysis 2. Click on Advanced Tab 3. In the Prefix input box, add the following and click Apply and Save the…

Hi Vaibhav, Could you elaborate more on what you meant by API. Thanks Hassan

Hello, Please post this in the ERP CCC. Thank you Hassan

Hi Nipun, Please refer to this KM Note: Data Lineage Document for DFFs and Their Associated VOs (Doc ID 2463485.1) Thank you Hassan

Hello Nipun, DFF exposure in BICC are handled differently than in OTBI Subject Areas. Some products would provide specific PVOs for DFFs. Incentive Compensation is a case in point. Refer to KM Note 2444493.1. Projects have an ER for the BICC DFFs. See KM Note 2990418.1 Which product are you referring to? Thank you Hassan

Hi Haritha, Please log an SR to address the issue. BI Admin user should have these buttons when you first open the FTP page: Thank you Hassan

Hello Haritha, You already have the BI Admin role, otherwise, you will not be able to go to Manage Publisher ⇒ FTP. Please share screenshot of your FTP setup for further review. Thank you

Hello Rama, I checked the LOV you created and it is referring to the following: "A"."Requisition_Number" You may want to edit the LOV and drag and drop the correct column for the Requisition Number. Thank you Hassan

Hello Gaurav, Oracle Fusion BI provides the following catalog webservices that handle moving the catalog items to and from the BI Catalog. It is called WebCatalogService: https://<Your POD Info>.com/analytics-ws/saw.dll/wsdl/v12 Thank you Hassan

Hello Bala, The BIP webservice calls are not meant for large data retrieval. If the report is rendering a large data set, you may have to schedule the report and then use the chunking feature. Refer to the following document for further information:…

Hi Vinoth, I used the Cast as Date and the export shows the date without the time as shown below: Thank you Hassan

Hello Arun, Navigate to the BI Catalog with a user that has the BI Admin role. Click the More ⇒ Permission on the report in question. Ensure that the fusion_apps_hcm_ess_appid user has the proper permissions. Repeat the same steps for the data model. Thank you Hassan

Thank you for keeping us posted. Hassan

Hello JEngalan, Please raise an SR and Support will work with you on how to get the logs. Thank you Hassan

Hello JEngalan, If the server removes diffie-hellman-group14-sha1, we will still be good as both client and server have these in common and one of them will be used: diffie-hellman-group-exchange-sha256 diffie-hellman-group16-sha512 diffie-hellman-group18-sha512 diffie-hellman-group14-sha256 If there are any issues after…

Hello JEngalan According to the snippet you shared, the connection was successful and the negotiated Kex was established as diffie-hellman-group14-sha1. Could you share the log where the negotiation failed. Oracle's existing Algos are shared in the documentation and only those will be used in the negotiation. Thank you…

Hello JEngalan, Please schedule the report with diagnostics turned on and upload the diagnostics log for review: Review Doc ID 2126699.1 for more details on how to run this process Thank you Hassan

Hello Dhevina, Please follow the steps in this documentation: https://docs.oracle.com/en/middleware/bi/analytics-desktop/bidvd/change-display-names-tables-and-pivots.html Thank you Hassan

Hello Himanshu, Please refer to this KM Note: Security Reports in Fusion Application (Doc ID 2210883.1) Thank you Hassan