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
1 answer

How to Remove Parameters coming in ETEXT in BI Publisher

i am using delimiter based template to generate CSV file all output is fine except the parameters which are showing up even without adding them explicitly in the ETEXT how can i disable these parameters following is the…
abdulrahman Mohammed
  • 49
  • 1
  • 8
0
votes
2 answers

SQL Query to find the historical data in a table as of a date

I have to find historical data for a report until the effective date. There is a date tracked table that has the following data - person_number start_date end_date name position 10 01/01/2016 …
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
0 answers

How can I add a checkbox in BI Publisher Report?

I am using Bi Publisher 12.2.1.4 . I am trying to add checkboxes to a BI Publisher report . I am using a basic Portrait template when creating the report From lots of resources on the web I found out that I should be able to either use "Rich Text"…
Alex Lemesios
  • 522
  • 9
  • 22
0
votes
0 answers

how to create BIP report data model to get data for ScpApprovedSupplierListImportTemplate.xlsm FBDI template

I am not able to identify the base tables for this query I checked MSC_ITEM_SUPPLIER, MSC_ITEMS, POZ_SUPPLIER_SITE_ALL_M, INV_ITEM_SUB_INVENTORIES and MSC_ST_ITEM_SOURCING but I am not sure if these are the correct tables or not
vikash
  • 1
  • 1
0
votes
1 answer

BI-Publisher RTF Template: Repeat colums or rows horizontally first before new page

I have a table that's 2x2. First row is just the header. The second row is pulling info from DB. The first column is For-each loop and getting Account number The second column is getting Balance for that account then ending for-each There are so…
Andrew Gendy
  • 3
  • 2
0
votes
3 answers

Formula to use to convert the hours entered to 1/4th hour

I am creating a Oracle fast formula where I am trying to round the time entered by employee to the nearest 1/4 hour. 15-22 minutes = 0.25 hours 23- 37 minutes = 0.50 hours 38-52 minutes = 0.75 hours 53 to 1 hr 7 mins = 1 hour I am able to get the…
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
1 answer

Oracle apex report does not get printed when I click the button but gets printed when I test It from shared components

I am trying to use BI publisher as the printing server on my APEX app, but when I try to use the generated link (f?p=&APP_ID.:0:&SESSION.:PRINT_REPORT=COUNTRY%20INFO) on a button it does not work and gives a error as "Contact your application…
himesh kaveesha
  • 3
  • 6
0
votes
0 answers

Dynamic header in Oracle Bi Publisher rtf template

In my report I have two for-each and each one must have a static text as a header. I try this solution: `
Marlon
  • 1
  • 1
0
votes
0 answers

Not able to input any Excel formulas in BIP Excel Template

I am trying to build a report using Oracle BI Publisher Excel Template. However, I also want use few excel formulas in that to enhance more functionalities. But I am unable to do that. When the report is getting executed, the formulas are getting…
Manas Dash
  • 1
  • 1
0
votes
2 answers

Sum field in condition (IF field = 'something' Then SUM (field) - BI Publisher

I need to sum a value based on a condition on BI Publisher on RTF format. This is what's intended: IF FIELD1 = 'THIS' THEN SUM(FIELD2) So far, i have the current formula: if FIELD = 'THIS' THEN 'N/A? else sum(FIELD2) end if The problem is that the…
Luska
  • 1
  • 1
0
votes
0 answers

How to solve Oracle BI Publisher Template compatibility issue - xsl-fo template - encountering Completed warning in EBS

I've created an XSL-FO template using Oracle BI Publisher Add-in for Microsoft Word I have define it on BI publisher template. Type: XSL-FO Default File: .xsl Default Output Type: Excel However, upon running the concurrent program, I encountered…
Eyei
  • 1
  • 4
0
votes
2 answers

How to put 0 instead of blank in rtf template

see sample report output with blank fields I tried this code see imagethis is the code I used But the 0 was added to the end of each values. See the image below it's looks like this
Eyei
  • 1
  • 4
0
votes
1 answer

Can :xdo_user_name be used in list of value in Oracle bi publisher? Or just works in data set

I am making a data mode. Involve a list of values to bind with parameter. Just want to ask if adding :xdo_user_name as the list of value sql parameter is possible? I am hoping that user login， the menu will only show related data to him. Many…
Carson Hung
  • 1
0
votes
2 answers

Correct Syntax for optional multi-select parameter in BIP

I have a query that was written as a Data Analysis in Oracle OTBI, and I am using it inside of BIP Data Model and I am structuring parameters for the Oracle BI EE logical SQL. The below parameter :P_Item_Number I would like to use as an optional…
Nick
  • 268
  • 8
  • 33
0
votes
2 answers

How to get sum in group wise (group left) in Oracle BI publisher Reports

Please check the image below. I want a group wise sum for each group. group wise sum of Oracle BI Publisher Need the summary at the summary level
Assaduzzaman Sarker
  • 1
  • 1
1 2 3
…
35 36