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