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

Current year in RTF Template

I am using the condition to find if the date is in the year 2022, How to tweak this to get current year instead of 2022, so that next year the tag checks in 2023 ?
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
1 answer

Getting Oracle Error While trying to convert varchar2 column and retrieve data using BIP report

We have column (field) attribute14 in the oracle table which is of data type VARCHAR2 and is storing date in format '20-MAY-22' (DD-MON-YY). We have a requirement to develop a BIP report in oracle fusion and get output based on the parameter date…
NerdFredrick
  • 71
  • 4
0
votes
1 answer

SQL query to find the count of number of same absences for an employee

I have a table: PERSON_NUMBER ABS_DATE ABS_TYPE_NAME ABS_DAYS ----------------------------------------------------------------------------- 1010 01-01-2022 PTO 1 1010…
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
1 answer

SQL QUERY- How to remove repetitive days in sum function in "PIVOT" clause

I have a table abs_details that give data like follows - PERSON_NUMBER ABS_DATE ABS_TYPE_NAME ABS_DAYS 1010 01-01-2022 PTO 1 1010 01-01-2022 …
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
1 answer

SQL Query to return absence date from 1-31 according to parameter passed

I have table PERSON_NUMBER ABS_DATE ABS_TYPE_NAME ABS_DAYS 1010 01-01-2022 PTO 1 1010 06-01-2022 PTO 0.52 1010 …
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
1 answer

SQL Query to pass multiple parameter with <= instead of in

I am passing two parameters - Month and year Month can be 01/2022, 02/2022, 03/2022 etc Year can be 2022, 2021,2020 Year is mandatory I have a condition in the query that compares these dates - SELECT Max(acrl2.accrual_period) FROM …
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
1 answer

(SQL)How to Get absence "day" from date under 1-31 column using PIVOT

I have a table abs_details that give data like follows - PERSON_NUMBER ABS_DATE ABS_TYPE_NAME ABS_DAYS 1010 01-01-2022 PTO 1 1010 06-01-2022 …
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
2 answers

SQL query to find the last day of a particular formatted month - YYYY/MM

I have months in the following format - 2022 / 12 2021 / 03 2020 / 02 YYYY / MM I want to find out the last day of these months. i.e. 2022/12/31, 2021/03/31 , 2020/02/28 I am using the below code - to_date(to_char(:p_month||'01/', 'yyyy /…
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
1 answer

SQL Query to fetch data as of the year,quarter or month passed in parameter

I have the following query- (SELECT DISTINCT accrual_period FROM anc_per_accrual_entries a, anc_per_plan_enrollment b WHERE a.per_plan_enrt_id = b.per_plan_enrt_id --AND a.accrual_period = b.last_accrual_run …
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
1 answer

All quarters, Month year for pas 10 years in sql

I want to retrieve all the quarters in the past 10 years using the query - SELECT TO_CHAR(sysdate, 'yyyy" Q "')||level AS QuarterDate FROM dual CONNECT BY level <= 4 Using above query I will get quarter for current year. I want for past 10…
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
2 answers

All quarters in current year in Oracle SQL

I want to display the quarters in the current year like - 2022 Q 1 2022 Q 2 2022 Q 3 2022 Q 4 Is there any way to do this ? When I am using the below query, I am only getting current quarter - select to_char(sysdate, 'yyyy" Q "q') as QuaterDate…
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
1 answer

How to get alternate background color as a particular color in RTF

In the RTF template, I want the alternate rows to have a light green color, when I am using the below tag, I am getting all rows with green and text background as green, not the entire row-
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
1 answer

Remove accent/special characters in columns in SQL

Is there anyway we can remove the accent in columns? Example: per_names table has following column names: Name Arévalo Chère I want this column to have values as follows: Name Arevalo Chere Is this possible ?
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
2 answers

Extracting SQL Queries of all Oracle BI Publisher Reports

I have a catalog of OBIEE reports which include many BI Publisher Reports. I want the SQL queries (and eventually the list of physical tables) used in the data models of all the BIP Reports in my catalog. I don't want to do it by manually going into…
Junaid Ahmad
  • 41
  • 1
  • 9
0
votes
1 answer

SUM a column, then ADD and DIVIDE in XML (BI Publisher template), weird value?

looking for a little help with calculating a value from XML data in a BI Publisher template. I'm trying to say "If percentage column isn't null, then Sum up the cost column and multiply by 1 + percentage column/100" I thought it would be this…
ScottHillierDstl
  • 1
  • 1
1 2 3
…
35 36