BI Publisher
Discussion List
-
Bar graph using BIP reportI have a bar graph in my BIP report , but the values are coming in decimal. In the Data model it is coming without decimal. Is it possible to have the values display on …Shreya Datir 11 views 1 comment 0 points Most recent by Shreya Datir Reporting and Analytics for HCM -
Is it possible to track who changed user roles and when it happened in Security Console?Summary: Content (required): Hello experts, is there a way by OTBI or SQL to retrieve who changed user roles in security console and when it occured? Thanks in advance f…Valerio Curzi 698 views 6 comments 0 points Most recent by Pavan Kumar Thummalapalli Reporting and Analytics for HCM -
Report for a Salary basis of the type "Salary amount is determined by simple components"Summary: We have a Salary Basis defined of the type "Salary amount is determined by simple components" and we have hired an employee with this salary basis. There are 5 …Sachin_Shirke 324 views 4 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to get Phone number, Email Address, Home Address and Bank details old values using BIP ReportSummary How to get Phone number, Email Address, Home Address and Bank details old values using BIP ReportContent Hi Team, We are creating new HCM BIP Report to Fetch the…User_2025-02-01-06-07-07-886 831 views 7 comments 0 points Most recent by Ridma Karunanathan Reporting and Analytics for HCM -
Query to Display the Roles with their Data Security Profiles NameContent Hi Team, Has anyone created any report to display the List of Roles along with their assigned Data Security Profiles. Regards, Harish Vummidi Version 21CHarish Vummidi 165 views 15 comments 1 point Most recent by Mohit_Pal Reporting and Analytics for HCM -
Table for Additional Statuses (Timecard)We have a requirement to get Earned Date, Value, Unit of Measure, Payroll Time Type , Absence Type , Payroll Transfer Status & Payroll Processing Status. We are trying t…Manoharan 48 views 2 comments 0 points Most recent by Nagaraju Godasi Reporting and Analytics for HCM
-
Transpose rows to columns in OTBISummary I need to build a report that shows every employee as a column. Convert all rows to Columns in OTBIContent Hi I hope you can help me. I need to build a report th…
-
How to remove Blank Rows in a report?Summary: Once we export the report there are a few Blank rows at the bottom, is there a way to remove them? Content (please ensure you mask any confidential information)…THawkins_LGI 75 views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
PDF output is not giving the correct fontContent Hi, we are trying to generate a PDF output with custom font. While downloading RTF output, it is giving correct font, but PDF is not giving the same font. How do…Nivya Mathire 88 views 8 comments 0 points Most recent by David --Oracle Reporting and Analytics for HCM -
How do you display the run date, time (AM/PM), and timezone. Example 11/28/23 11:57 AM ESTSummary: When running a BIP report I am trying to show the timezone of the run date and time being displayed. I am using an RFT template. Content (please ensure you mask…
-
How to use an OTBI analysis to create a data model with a parameter (prompted?)Summary: I am trying to use an OTBI analysis to create a data model. My data model will be refrenced by Oracle Journeys so there is a requirement that I attach a specifi…Amy Wilson 758 views 7 comments 0 points Most recent by Stefan v. Glabbeek Reporting and Analytics for HCM -
Reporting Prior Month Data SQLSummary: Can we add SQL to the formula to look at the Prior Month data? So tell it to look at the System date - 1(for prior month) and pull 1st to last date of that prio…THawkins_LGI 42 views 12 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM
-
Business Unit Hierarchy looking for Parent Business Unit NameSummary: I would like to know what table Parent Business Unit Name is in for a BI publisher SQL Content (please ensure you mask any confidential information): Version (i…
-
Need to create a BI report to See What Jobs Are Scheduled Along With Frequency, Start and End dateSummary: Hi All, We've a requirement from the customer where they need to create a report to See What Jobs Are Scheduled Along With Frequency, Start and End date. Can so…Sandeepan Rana-Oracle 22 views 3 comments 0 points Most recent by Sandeepan Rana-Oracle Reporting and Analytics for HCM
-
What table is storing Change working hoursHi Team, Which table is storing change working hours information? Any sample will be helpful.
-
how to bulk download the attachments in report job historyHi Team, I have a requirement to download the output name (attachments) in the Job History. But when I download the files it's coming in the XML Format. can anyone tell …Haritha 22 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Unable to get the proper count for Assignment Count when I am using two subject AreasSummary: Hi Team, we have requirement to get the count for Nationality to get this column we are using 'Person Real time' Subject Area. and we also have to filter this c…Ashok Dhara 13 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
I need query to get expense approver nameDoes any one have query to get expense approver nameSwati U 199 views 2 comments 0 points Most recent by Stephen Westerfield-Oracle Reporting and Analytics for HCM
-
Subject area/database table for historical manager hierarchySubject area/database table for historical manager hierarchy Client is interested in building dashboards to show different HR metrics for which historical manager hierar…
-
Data Model throws a nullpointer exception while trying to retrieve dataSummary: I have created a data model with 2 data sets (one for employees and one for Contingent workers) - I have created an Excel Template that has 2 tabs for the data …User_2025-02-04-08-51-08-912 258 views 3 comments 0 points Most recent by John Peter Noble-Oracle Reporting and Analytics for HCM
-
How to setup dynamic filters in BIP report?The dynamic filter should adhere to the following logic: Year: If today falls between February and December, use the current year. If today is in January, use the previo…Janardhan ACS-Oracle 27 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM
-
Calling an external image in bursting using tokensHi We need to call an external image in the bursting query. by passing token. Please help in achieving this. Regards, ShanmukhiShanmukhi 12 views 3 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM
-
Profile id not available for some employeesSummary: Profile id not available for some employees Content (please ensure you mask any confidential information): Hi experts, we want to create a report that retrieve … -
BIP Report Job History RetentionSummary: Hi, How far back can we view Report Job History in Oracle Fusion? Is this the right answer? I want to be able to download the reports like in first picture. I h…
-
Pull a list of custom OTBI and BIP reportsSummary: Hello everyone, Is there a way to pull a list of custom OTBI and BIP reports? Thanks and REgards Content (please ensure you mask any confidential information): …
-
is there any way to hide the rows in excel using bi publisherSummary: Hi, I am new to bi publisher and wanted to have this in my report template using excel. is there any way to hide the rows in excel using bi publisher that is be…
-
DOJ from date and to date , DOE from date and to date parameter not working in BIP reportHello , I have create Date of Joining date parameter and Date of Exit parameter, however when user try to select dates and filter records , records are not getting filte…
-
Report detailsHi, There are lot of reports we are using and we want to know security of each report. Is there any way to find out below details from system 1)List of reports 2)Roles/p…Namrata_20 22 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM
-
can we use fetch multiple columns using single case statementHi Team, i am using the case statements as below to retrive the data for a single person but it is giving me the 4 rows for same person is there any way to group them al…Chetana Pawar 22 views 1 comment 0 points Most recent by Swathi Shetty Reporting and Analytics for HCM
-
Costing of PositionContent Hi All, I am trying to get the Costing of position in SQL query. Does any have the SQL which can give the costing details of position. Thanks,Misbahul Khair-266763 427 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM