Stack Overflow
Stack Overflow

Questions tagged [bi-publisher]

Business Intelligence Publisher - Oracle's reporting application.

First released in 2003 as part of Oracle's E-Business Suite it has now been integrated into many of the Oracle products and is also available as a standalone application. It is capable of generating XML data from SQL queries, XML files, web services, LDAP, MDX queries, Excel files and Oracle ADF View objects.

532 questions
0
votes
0 answers

search parameter in Oracle BI Publisher 10g

Search list(list of values) for a search parameter in Oracle BI Publisher (10g) works fine when the query doesn't contain a bind variable (parameter identifier) but when a bind variable is introduced in the constraint of search list query, it keeps…
chemicalkt
  • 816
  • 5
  • 16
  • 33
0
votes
1 answer

List reports in BI Publisher 11g Web Service

Is there a way to list available reports in BI Publisher 11g using web service it provides (ReportService)? I don't find anything basing on the methods names, but maybe I am missing something. I tried googling something, but I mostly find tutorials…
Paperback Writer
  • 1,995
  • 2
  • 16
  • 27
0
votes
1 answer

PeopleSoft XML Publisher - Hide empty rowsets

I have a report that I am building which uses a rowset with six child rowsets. I am generating this report via pplcode on a button. I declare the rowsets: rs_resp = CreateRowset(Record.AVZ_JD_RESP_TBL); &rs_expr =…
Chip
  • 1,653
  • 2
  • 20
  • 27
-1
votes
2 answers

Query to get count of periods in current month

I have a tabl pay_time_period with following detail PAYROLL_ID START_DATE END_DATE PERIOD_NUM 10 01-MAY-2023 10-MAY-2023 1 10 11-MAY-2023 …
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
-1
votes
1 answer

Oracle fast formula condition to compare only the timestamp part

I am creating an Oracle fast formula, I need to check the time between 06:00 AM and 12:00 AM i.e. when the PAY_TIME > 06:00 AM and less than 12:00 AM. I am using the following - L_STARTmin = TO_CHAR(AISTOPTIME,…
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
-1
votes
1 answer

Bi Publisher Traversing thru XML tags

I have a data structure of this format. I am looking to see if I can retrieve each tag in the xml. (There may be additional tags also) & check if there is value for it, if so, put it on a counter. This is something I can come up with. But I am not…
Arunachaleswaran L
  • 1
-1
votes
1 answer

BI Publisher - How to separate values by comma

I have this row that I'll be showing as comma separated: Name1 number1, Name2 number2, Name3 number3, Name4 number4 I put this in a for-each loop like: In the RTF, it is shown as: for-each …
quodsolis
  • 7
  • 3
-1
votes
2 answers

SQL query to remove the comma at the end with no characters beyond

I have created a query to get the output like from table IRC_TABLE- Requistion_number Name 12 John Mayer, Andrew, 11 Swastak, I want if the…
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
-1
votes
3 answers

SQL Query to fetch data after 01-01-2022

I have a date coming in the format 2022-05-26T13:50:44.000Z, 2018-10-05T18:14:00.000Z. I want the date to be picked after 2022 only from this column. But when I am using the below query it is not working at all. …
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
-1
votes
2 answers

Passing comma seperated parameter values through Oracle SOAP request

I running a BI Publisher report through SOAP request. the BI Publisher data model contain the following condition : WHERE PERIOD_NAME IN ( :P_PERIOD_NAME ) when i pass single period like "Jan-21" it works fine but then when i pass "Jan-21, Feb-21"…
Shlomo
  • 21
  • 5
-1
votes
1 answer

Missing "OK" button and some on Insert Table/Form in BI Publisher

There is no OK button on the Table/Form. I tried restarting Microsoft Word but nothing happens.
stocke
  • 21
  • 3
-1
votes
1 answer

Dynamic Column selection in BI Answers/views based on Dashboard prompt selections

I need to have a BI Dashboard where the columns(eg, Brand) or group of columns ( eg, Company, Company site) have to hide/show in all analysis of dashboard based on check box selections with Brand and Company respectively. I am able to pass the…
Dhamu
  • 1
  • 2
-1
votes
1 answer

Guest access is disabled in oracle bi publisher

I've connected through bi publisher with sys account which have admin privilage, but I'm not be able to define guest folder name, because allow guest access check box and guest folder name are disabled.
ali yousef
  • 87
  • 2
  • 6
  • 15
-1
votes
1 answer

How can i create an account on oracle cloud application?

I need to create an account on oracle cloud applications , i am studying a course of BI publisher and i need to try examples by myself , i searched for something to help me but no result . Is that possible creating account on oracle cloud…
besho_Demian
  • 31
  • 1
  • 9
-1
votes
1 answer

How do I display a "No Results" message for each input parameter in OBIEE BIP RTF?

Suppose I have 3 input parameters in my OBIEE data model: A, B, C. Suppose the SQL query only returns results for parameter A. Thus, my XML only has results for A. In my RTF word document, I want to display a "No Results" message for parameters B…
ColoradoBanana
  • 1
  • 4
1 2 3
…
35
36