I have set this up many times ... 1 - make sure you pass in ALL the parameters (regardless if you are using them in your procedure) 2 - make sure your procedure is set up to accept ALL parameters (regardless if you are using them in your procedure) 3 - make a package spec similar to: create or replace PACKAGE CM_REPORT_PKG…

Your best bet is to have the DBA materialize a view that has the BLOB converted to varchar2 in and by the database ... CLOB is for CHARACTER LONG OBJECTS (text) - they have a data typing issue.

Do you get any error or just that column in your rows is blank or no rows?

why BLOB for text? ... why not CLOB? was this a custom add?

This post belong in the BI Publisher forum ...

[180115_11150016][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]XMLGEN:Exception while processing datamodel...:_PCLS_BI_BI_Publisher_Sample_Data_Model___CCL_xdm [180115_11150016][DATA PROCESSOR ID:1704132772][SCH JOB INFO:]Process Cancelled Stage:false [180115_11150016][DATA PROCESSOR ID:1704132772][SCH JOB…

^ what does the output here say?

Only alias columns you are going to change the name of ... try your query without aliases ...

what's the calendar/time configuration on the server?

If you are getting a Word plugin that is what you are installing - the Office add-in. If you want to build BI publisher reports (not in word) that's part of the web front end to BI Publisher server deployed in weblogic.

+1 ​ This link has a work around if your number is greater than: 5373,484 https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1407603857650

You can schedule the report via a script using a tool like Control-M and you could have a custom piece of code to assemble the xml for the SOAP call.

You will end up with a datatype issue ... non-ZEROs are numeric and you want to convert ZERO to non-numeric '-' ...

You gave him documentation for a really old version - unsupported version of BIP... Oracle Business Intelligence Publisher Installation Guide Release 10.1.3.4 Part Number E12690-01

in the advanced editor ... the link is down by the @Mention link

Sounds like a browser issue ...

Do it in your query ...

I second this ... do it in the SQL (if possible)

While logged into xmlpserver (BI Publisher, not OBIEE), enter the Catalog, then do the following: * Download the parent folder containing all the data models you will need. (download is under the more... option) * Once downloaded, rename the .xdmz file to a .zip. You can now view the contents of the files. * Write a script…

You have to filter on the full date + timestamp ... played with it a bit ...