You see the length as 90 chars, indeed, but the size in bytes is over 100. You can test directly in BI Publisher, data model, using the below function: select lengthb('Lettre de cessation d’emploi (EXT.) – Cessation d’emploi à l’intérieur du période_07326771') as test_column_len_in_bytes from dual

At the physical level, the first example actually has 101 characters, because of the special chars:

Try using {$SYSDATE()$} in the scheduling parameters values and add/subtract hours: Fusion BI Publisher - Scheduling With Date Parameter as SYSDATE Runs With the Same Date as Original Date (Doc ID 2019035.1)

Please find below documentation on how to work with Audit data in Cloud environments using BI - the KM note includes some sample reports as well. Fusion Applications BI Publisher : BI Publisher Report Execution Auditing In Cloud Environment (Doc ID 2059102.1)…

You can use password protect as of Release 19C for PPTX, DOCX, XLSX, PDF (the password protection will apply to both online viewed reports and scheduled jobs): TO APPLY PASSWORD PROTECTION * To apply password protection at server level (i.e. for all reports that generates the output in PPTX, DOCX, XLSX, PDF) * Navigate to…

Nice workaround!

Hi Sudhesh, 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…

HA HA :)

Hi Jon, Tables ending with _ are auditing table. If audit is enabled on the table, then table will have those records. The only difference is the primary key (PK) between the table ending with letter and the one ending with _. The PK for the table ending with _ consists of the same columns in PK of table ending with letter…

Hi Jon, You need to use the logical expressions instead of explicit OR / AND. e.g.: * OR is || * AND is && So on your particular case below expression should work: G_1.ITEM_NUMBER == ABC || G_1.ITEM_NUMBER == DEF Best regards, Robert

Hi Jon, Can you please try the same steps for a very simple data model? e.g. SELECT 1 AS COL_A , 2 AS COL_B FROM DUAL I want to isolate the case and see if the issue is with the RTF generation or with your particular data model. Best regards, Robert

Hi Mohit, Are you still having this issue? If yes, can you please provide step-by-step navigation and what object are you trying to setup? Regards, Robert

Hi Lee, You can use password protect as of Release 19C for PPTX, DOCX, XLSX, PDF (the password protection will apply to both online viewed reports and scheduled jobs): TO APPLY PASSWORD PROTECTION * To apply password protection at server level (i.e. for all reports that generates the output in PPTX, DOCX, XLSX, PDF) *…

Hi Jon, This topic was opened for the "How to pick multiple fields into table box when building report using data model?" question and my solution was for this question. Regarding your last reply, please open a new thread and provide full description of what exactly are you trying to do in the data model. Best regards,…

Hi Anil, Parameters 2 and 3 in FTP Bursting query are not mandatory. You already have the credentials saved in the FTP connection, thus you just need to call the FTP connection in your bursting query, without filling in the credentials in the bursting query. Kind regards, Robert

Hello, Please find below documentation on how to work with Audit data in Cloud environments using BI - the KM note includes some sample reports as well. Fusion Applications BI Publisher : BI Publisher Report Execution Auditing In Cloud Environment (Doc ID 2059102.1)…

Hi Geraud, This feature is not available in any OBIEE 11g environment. This is currently scheduled to be introduced in a future version. Until then, the following workarounds can be used. If using Internet Explorer browser, you may try to do the following: * Place the mouse cursor in area outside the view and click once to…

Hi Giorgio, Do you have the Italian language pack installed on your environment? Are you able to login using Italian in Fusion and in BI? Kind regards, Robert

Hi Rob, This is a known issue with the BI Publisher Scheduled Reports.' The only workaround(s) at this time are to: - Reschedule the report - Edit the Schedule then re-save it without making any changes Scheduled BI Publisher Reports Are One Hour Off After Daylight Savings Change (Doc ID 2648608.1) Best regards, Robert

Hi Shashi, Emails setup (be it at Oracle or Third party) expect to receive emails from a valid source. Valid source is determined by the below factors: - Domain used in FROM: email address - Sending server domain matches the domain used in FROM: address Fusion BI Publisher from e-mail address values: - ONLY supports…