Hi Aleksandar, You are missing the catalog-index-info command in your template. Please check the report designer's guide to see how to implement PDF splitting: https://docs.oracle.com/cd/E17904_01/bi.1111/e13881/T527073T558232.htm#T545505 -> section "Implementing PDF Splitting for an RTF Template" Regards, Violeta

Hi, You cannot change the owner of the job, you can just reschedule it. Violeta

Rjebb, For an answer to your question, please open a SR with BI Publisher team. Regards, Violeta

Hi, DML/DDL keywords are not allowed as part of a SQL querys in BI Publisher data models. The error received is the intended functionality. To solve the issue, change the data model and remove all DML/DDL keywords from the sql selects, column names, and / or aliases in any sql query. Note: If any of the replies in this…

Hi Paul, In addition to what Venkat suggested, If you are on 64 bits, then please check if the note from below applies to you: After Template Builder Install Menu Labels Appear Like menu2007.<command name> (Doc ID 1528797.1) Note: If any of the replies in this thread were helpful/correct, kindly mark it accordingly as this…

Hi, You can generate more than 2 decimals only for .xlsx output, For the other formats, maximum number of decimals is 2. Note: If any of the replies in this thread were helpful/correct, kindly mark it accordingly as this would help others who can also benefit from it. Regards, Violeta

Hi, For which output format do you have the issue? Is it the same for other formats as well? Can you upload the template for review? You might also want to check the following documentation: How To Insert Images and Logo in the XML Publisher Reports and Documents? (Doc ID 550627.1) Regards, Violeta

Hi, In addition to the already mentioned best practices documents, you can refer to the Report Designer's Guide for Oracle Business Intelligence Publisher. 11g: https://docs.oracle.com/cd/E25178_01/bi.1111/e22254/toc.htm 12c: https://docs.oracle.com/middleware/1221/bip/BIPRD/toc.htm Note: If any of the replies in this…

Hi, You can try using the webservices to retrieve the scheduled jobs and their parameters. Please check: Oracle BI Publisher Web Services APIs - Common Use Case Examples (Doc ID 1344535.1) Note: If any of the replies in this thread were helpful/correct, kindly mark it accordingly as this would help others who can also…

Hi, It seems like the only supported data type is '.xdm'. Please check this note: Unable to Upload External Data Model of File Type '.xdmz' Into Unifier Custom Report Templates: Error : Select a XDM file. (Doc ID 2328240.1) Note: If any of the replies in this thread were helpful/correct, kindly mark it accordingly as this…

Hi Khaled, Please check the Data Modeling Guide https://docs.oracle.com/cd/E28280_01/bi.1111/e22258/create_data_sets.htm#BIPDM142 -> chapter "2.15 Using Data Stored as a Character Large Object (CLOB) in a Data Model" Note: If any of the replies in this thread were helpful/correct, kindly mark it accordingly as this would…

Hi, Please check the roles assigned to the users and make sure they have the 'BI Publisher Scheduler' role. Note: If any of the replies in this thread were helpful/correct, kindly mark it accordingly as this would help others who can also benefit from it. Regards, Violeta

Hi, You can use the API FND_REQUEST.ADD_DELIVERY_OPTION to deliver the output via email. Note: If any of the replies in this thread were helpful/correct, kindly mark it accordingly as this would help others who can also benefit from it. Regards, Violeta

Hi, Please try the following: 1. Open the report and click on Edit 2. Click on Properties button on top left 3. Select the Formatting tab 4. Scroll down to the bottom 5. Find the property 'Use 11.1.1.5 compatibility mode' and set it to FALSE 6. Click OK 7. Save the report. 8. Retest Note: If any of the replies in this…

Hi, You can use web services. Please check the following notes: Oracle BI Publisher Web Services APIs - Common Use Case Examples (Doc ID 1344535.1) BI Publisher - Using Web Services To Run A Report Job (Doc ID 1555809.1) and also Developer's Guide for Oracle Business Intelligence Publisher 11g Release 1 (11.1.1) E22259-04…

Hi Mohammad, There is no workaround. The functionality is brought bu the patch only. The patch has to be applied in the normal way, using opatch. Best Regards, Violeta

Hi Mohammad, It is possible to have HTML message body. For this you need to install the patch "20563624 - HTML LAYOUT EMAILS FROM BURSTING IN BIP STANDALONE" which is available for your BIP version. Note: If any of the replies in this thread were helpful/correct, kindly mark it accordingly as this would help others who can…

Hi, Depending on your version, I would make sure to be on the latest patch level: Overview of Available Update Patches for Oracle BI Publisher Enterprise 11g (Doc ID 1276869.1) Overview of Available Update Patches for Oracle BI Publisher Enterprise 12c (12.2.1.0) (Doc ID 2147699.1) If issue still reproduces and support has…

Hi Murugesan, Please check the chapters 2.9 Creating a Data Set Using an LDAP Query and 2.17.2.1 Creating Bind Variables from LDAP User Attribute Values from "Data Modeling Guide for Oracle Business Intelligence Publisher" 11g Release 1 (11.1.1) E22258-05 available here:…

Try also by replacing <?if: with <?if@inline: