Hello, Not sure of what you want exactly. The desired final output would be a line with: SLI---2112 11 and other line with: SLI---0770 46 ? Can you clarify, pls (maybe provide an accurate example). Regards Carlos

Hello, It seems to me you´re problem is alike the one i had in: ​ (perhaps when you read the post you´´ll think is not, but i assure you it is, cause the error is the same; i just did not wrote it). Can you try to create a new rtf from scratch (with desired new layout) and run it? Regards, Carlos

One step a time. It´s necessary to understand how things work, first. Lets try a simple example: select languagecode --someColumn; i used languagesfrom ng_languages; --yourTableNamecreate or replace PACKAGE packageTest AS --declare a simple package with a function (no parameters for now) TYPE refcursor IS REF CURSOR;…

Hello, As referred in previous reply, the procedures you declare in package to be called in event trigger must return boolean type. Check this for more info: https://www.rittmanmead.com/blog/2011/12/event-triggers-in-bi-publisher-11g/ The parameters are passed in data set (you must declare them in package spec) if you…

In data set you pass the parameters to package as in image above (where is 'set value' in blue) and click 'view' to run the query and get a sample. Just be sure to have ALL parameters in package spec.

Hello, Just adding a little more info to @Youssef_B_82 reply: Add the variables (parameters) in package spec and the procedure must return boolean type. Regards, Carlos

Hello, As questioned by ​ about template, which one are you calling. I remember once i was calling (and e-mailing) a report from within bip and from outside too. The problem was that i had 2 layouts in that report and i was calling different layout on each side, so i was having different output (one of them was blank) and…

Hello, The error you´re getting it´s because as you said: Added a new parameter "P_ORDER_BY_TXT" to an existing concurrent program and it started failing with the aforementioned error message. I added the parameter to the XML file (.ie. Data defintion). and on the beforetrigger, it's calling a PLSQL package. therefore you…

Hello, Not sure if this is the correct forum for this post (should´t be or , rigth?). Supposing the column is vachar2 try: <span class="kwd" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit; color: #101094;">select</span><span class="pln" style="font-style: inherit; font-weight:…

Yeah, i´m aware of that, but was the only one refering 'MAC' ...

Hello, According to: https://docs.oracle.com/cd/E12844_01/doc/bip.1013/e12690/T434820T487781.htm it says: Environment Requirements The Oracle BI Publisher installer supports numerous operating system, including, but not limited to:Oracle Enterprise Linux 5Oracle Enterprise Linux 4, Update 4Microsoft Windows 2000…