Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Hello Ivony, If this is an OTBI analysis, you could set the column to HTML and it will display the content without the HTML tags. Here are the steps to do that. Edit the column in question by clicking on the gear icon and selecting Column Properties Click on the Data Format Tab Check the override default Data Format set…
-
Hello George, Please confirm the user data access assignment on business unit as follows : Go the setup and maintenance Search for the data access: "Manage Data Access for Users" for data security From the top change the button to User with Data Access and search for the user in question. Once found click on action…
-
Hi Nusrat, Are you running these processes immediately after you assign AOR to an employee: [Retrieve Latest LDAP Changes] [Send Pending LDAP Request] Thank you Hassan
-
Hello Marijana, The following is an example of converting a number to a char: CAST("Worker"."Work Terms Assignment ID" AS CHAR(40)) Thank you Hassan
-
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…