Take a look through this: https://gerardnico.com/wiki/dat/obiee/bisystemuser

Oracle Business Intelligence Publisher 12.2.1.1.0 http://docs.oracle.com/middleware/12211/bip/bip-administer.htm specifically: FO Processing Properties

You can do it with Action Links from OBIEE ... not sure about BI Publisher.

BI Publisher (even in the old days of 10g) wasn't/isn't certified on any desktop OS - only on server OS. Your best bet is to install and run it on a Linux VM ...

I think you might be stuck pivoting the query first, then displaying the data. There is a pivot function in the RTF (Word) template, but I've not seen any Excel. The WYSIWYG template builder also has a Pivot object, then that report could be rendered in Excel as output.

Can you post the details you get when you click on one of those "Requested layout null not found: Default Layout"

I noticed the Interactive Mode Icon is the active one in your screen shot ... your Send action is inactive because: From the documentation.... Send enables you to schedule the report for immediate delivery to an e-mail address, printer, or other destination. The Send action launches the Schedule Report Job page where you…

Make sure when looking in the job history, you are filtering for the same user you are attempting to send with ... this catches me from time to time ... ALSO: make sure you've entered an appropriate email user/password in the Bi Publisher - > Administration -> Delivery -> Email settings page. 

Here's a query I use against these tables ... SELECT user_job_name, issuer, start_date, end_date, CASE WHEN a.status = 'S' THEN 'Job Success' WHEN a.status = 'H' THEN 'Job Held/Waiting' WHEN a.status = 'R' THEN 'Job Running' WHEN a.status = 'D' THEN 'Job Document Delivery Failed' WHEN a.status = 'O' THEN 'Job Document…

apologies ... this query was inner joining the output and job (you have no output yet!) ... PS: adjust the where clause to suit your needs ... I use it in BIP report to pull details so I use the Days parameter. SELECT user_job_name, issuer, start_date, end_date, CASE WHEN a.status = 'S' THEN 'Job Success' WHEN a.status =…

Select your parent ... and set the grouping options as shown above ... if you want the summary row only, write your query to summarize before you visualize (then you aren't shipping the full volume of rows around).

What template are you using? RTF, Excel, Interactive?

Looks like it's from calling a sub-template ... take a look through this thread - they got it to work.

I didn't have to mucky with datatypes ... I've done this between with dates and chars and numbers ... see if swapping it to "A01-00 AQUISITIONS"."Aquisition Number" >= :acq_from AND "A01-00 AQUISITIONS"."Aquisition Number" <= :acq_to Do you get an error? Also check the datatype on the parameter itself ... FLOAT,STRING or…

Need more details ... what version BIP and what database are you going after? Using BIP in Oracle Business Intelligence 11.1.1.7.140527 I was able to get this to work without issue. My initial thoughts are you need to make sure you've got datatypes right and that you aren't using values that are space padded (char versus…

ok ... clearer now ... in any case ... SUM() won't sum the values in to_number(1111) to 4 ... but something like this will: SELECT SUM (TO_NUMBER (SUBSTR (TO_CHAR (123456, 'TM9'), LEVEL, 1))) "RESULT" FROM DUAL CONNECT BY LEVEL <= LENGTH (TO_CHAR (123456, 'TM9'); want to check it: SELECT 1+2+3+4+5+6 "PROOF" FROM DUAL; So I…

He wants digit-sum ... 6900161931 into 6+9+0+0+1+6+1+9+3+1 = 36

Where to do it? Not sure ... I was just going after the 1111 into 1+1+1+1 = 4 ...

SUM() won't do ... - Step 4: Add up all numbers from Step 3. Why not just simply use the builtin ORA_HASH? https://docs.oracle.com/cd/B28359_01/server.111/b28286/functions112.htm#SQLRF06313 then make it a consistent left zero padded string of what ever length you want?

We call BI Publisher Scheduling Service from Control-M ... use it to put in a scheduled run once job daily. Here's the Oracle Docs ... https://docs.oracle.com/cd/E28280_01/bi.1111/e22259/webservices.htm#BIPDV002