Hi Harish, Starting with Fusion Application Release 19A PB4 , BI Publisher Audit is available to SaaS. To know how use this feature, please review the following notes: Fusion Application: How to access BI Publisher XML scheduler tables : How to access table fusion_biplatform.XMLP_SCHED_JOB (Doc ID 2037166.1) Fusion…

Hi Rahul, This is a known issue identified in 19C/19D. The fix has been delivered in Fusion 20A. Are you still encountering the same error message? Kind regards, Robert

Hi Mawahid, Currently, there is no VO for ASE tables. You can use below query to extract data via BI Publisher: SELECT per_details.GUID, per_details.LAST_LOGIN_DATE LAST_LOGIN_DATE, per_details.DAYS_SINCE_LAST_LOGIN, per_details.USERNAME, per_details.PERSON_ID, per_details.SUSPENDED, per_details.active_flag from (SELECT…

Hi Ruzwan, You can try increasing the Query timeout in the Data model parameters. Open the Data model for this report Click on Properties on the Left bar in the data model Increase the Query Timeout to 1800 (or 3600) and retest. If this is resolved, you should take a look in your data model and redesign it as per BI…

Hi Suyoung, In SaaS, the audit report is only capturing the "DELETE" event if the action is made from the /xmlpserver. If it's done from the /analytics server, this will not be reflected in the report. We suggest you to create a new idea in Idea Lab on Customer Connect to have this functionality considered in the future.…

Hi Sivaram, Please check below KM which includes some sample audit reports as well: Fusion Applications BI Publisher : BI Publisher Report Execution Auditing In Cloud Environment (Doc ID 2059102.1) Kind regards, Robert

Hi Charan, Here is a KM note with the sample audit reports available for download: Fusion Applications BI Publisher : How To Configure And Use Audit In BI Publisher For Fusion SaaS Cloud Customers? (Doc ID 2059102.1) Best regards, Robert

Hi Prudence, Can you please provide some details about the setup of this BIP report? What template are you using? How did you design it etc. Best regards, Robert

Hi Parmit, You should start from: https://docs.oracle.com/en/cloud/saas/index.html and navigate to the required Fusion Module/Pillar and Release. You will find the "Analyze and Report" section under each one of them with up-to-date technical and bussiness information. Best regards, Robert

Hi Steph, At this moment this is not possible self-service by the customers and we already have an enhancement request. I would suggest for the time being to raise an SR with Oracle Support, maybe we can provide this information on-demand, (at least some bulk data extracted from the back-end). I think it's better than…

Hi Gadigeppa, Did you test with other browsers? Is this issue happening only on this browser? Are you accessing the report via the .../analytics or .../xmlpserver link? Did you try and provide some values to the report parameters and check again the results? Are you facing the same issue? Kind regards, Robert

Hi Jon, You can use the RANK function on a custom column/formula. The RANK function calculates the rank for each value satisfying the numeric expression argument. The highest number is assigned a rank of 1, and each successive rank is assigned the next consecutive integer (2, 3, 4,...). If certain values are equal, they…

Hi Jyoti, The limitation of BI Publisher bursting parameter OUTPUT_NAME is 100 chars. Best regards, Robert

Hi Alberto, Currently, this can be achieved via RFT or XPT templates; guide: Fusion BI Publisher - Time Zones Display - Best Practices of Coding (Doc ID 2256176.1) Excel cannot recognize canonical date format. If the date format in the XML data is in canonical format, that is, YYYY-MM-DDThh:mm:ss+HH:MM, you must apply…

Hi Jon, This is not possible for BIP Interactive View - If this is a functionality that you would like to have in the feature, you can raise it as an Idea on the BI Technology page: https://cloudcustomerconnect.oracle.com/resources/b2df648d2a/summary If I'm in a hurry and don't necessarily need a BIP report with…

Hi Niketa, The "Compress output prior to delivery" option will zip the output of the whole report scheduled output and not at individual chunks that are delivered separately via the bursting logic. The customer should check the XML Data Chunking option for extremely large data sets. The XML data chunking capability in BI…

SELECT TO_CHAR(SYSDATE,'W') FROM DUAL; WW+ - Week of year (1-53) where week 1 starts on the first day of the year and continues to the seventh day of the year. W+ - Week of month (1-5) where week 1 starts on the first day of the month and ends on the seventh.