BI Publisher
Discussion List
-
How to I achieve DD-MON-RRRR in output of BI publisher report for a dateSummary How to I achieve DD-MON-RRRR in output of BI publisher report for a dateContent Hi, I transform my date column in the required format using TO_CHAR(effective_sta… -
Can we limit the selection from the LOV in BI reports?Summary I want a functionality of my report to behave in a way where it should give me an error if I select more than 4 values from the LOV of 8 values.Content Hi, I wan…User_2025-02-07-18-15-37-534 39 views 2 comments 2 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
BI Table Name to fetch Data Type under Column Assignment of Global SegmentContent Hi Team, I am trying to fetch Data Type under Column Assignment of the Global Segment Details. Please let me know the backend table name which stores that. Thank…Sandip Karmakar 34 views 2 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Any way to restrict BIP output file either with Datamodel name or Template nameContent Hi All, When we click on OPEN on BIP report and enter required parameters and then click on apply button it will generate output in Excel format as DatamodelName… -
Need tables in fusion that store the Salary Details and Salary Component Breakup detailsSummary Need tables in fusion that store the Salary Details and Salary Component Breakup detailsContent Hi, Can anyone please provide me the table names that store the s…User_MC37Q 131 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Adding parameters for BIP Report built using OTBI AnalysisSummary How to add parameters within BIP Data Model built using for OTBI Analysis data set ?Content We have built a BI publisher report using a OTBI Analysis in the data… -
Master reports for Job, grade, location, department, position, active and ex-employee headcountContent Any Master reports available for Job, grade, location, department, position, active and ex-employee headcount?User_2025-02-06-14-37-05-233 71 views 4 comments 1 point Most recent by User_2025-02-06-14-37-05-233 Reporting and Analytics for HCM
-
HCM BI Report - table to extract value set data (table type)Summary HCM BI Report - table to extract value set definition (table type)Content Hi, I'm creating a BI report to show Value Set Definition (Table Type) and wonder which…
-
Need to have Bar code on Oracle Fusion HCM BIP ReportsSummary Need to have Bar code on Oracle Fusion HCM BIP Reports - methods used not workingContent Hi, We have tried 2 methods for displaying bar code in BIP report follow…User_MC37Q 65 views 5 comments 0 points Most recent by User_2025-02-04-19-25-35-076 Reporting and Analytics for HCM
-
Table name for Comments in a Learning CommunityContent For every learning community, members can comment using the seeded Comments functionality. We have a requirement to report on the comments made by the users. We …Venkata Sumanam 21 views 1 comment 1 point Most recent by Akash Kiran Jana Reporting and Analytics for HCM -
Deriving IS Manager column in OTBISummary Deriving IS Manager column in OTBIContent Hi ALL, I'm building OTBI Report. And I want to derive column "IS MANAGER" ( Note we are not maintaining in WorkerAssig…User_2025-02-07-19-03-14-525 53 views 4 comments 1 point Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
How to get SalaryId information from ReportingContent Hello experts, I have noticed that in Compensation subject areas I cannot retrieve the SalaryId information. I need this information to massively correct Salary …Valerio Curzi 37 views 1 comment 2 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Reporting on Active User Role EmailSummary Email address for non-employee active user.Content Hi, I am developing a BIP report for Non-Employee Active User. But cannot find the table email address that wa…User_2025-02-04-07-19-57-588 51 views 4 comments 1 point Most recent by User_2025-02-04-07-19-57-588 Reporting and Analytics for HCM
-
Duplicate Rows on DM/ReportContent Hi all - We want to build one data model and then use that to build multiple reports. This will help us ensure that if we update the code, we are updating all of…Prudence K 51 views 7 comments 0 points Most recent by User_2025-02-04-07-19-57-588 Reporting and Analytics for HCM -
BI Publisher Report - Disable Schedule Report option for ESS/Employee roleSummary Ways to disable Schedul Report option for the users with only ESS/EmployeeContent Hi, We have developed a custom BI Publisher Report, the access to which, will b…Kalyan Amaravathi 237 views 14 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Listagg Function on Business Intelligence Subject AreasSummary How to use Listagg Function on Subject areas on BI ReportsContent Hi Team, I have converted an OTBI an analysis to a BI Report. I would like to use Listagg funct…Kalyani Koylada 105 views 3 comments 0 points Most recent by Livia Popa-Oracle Reporting and Analytics for HCM
-
OTBI Catalog and Data Model Management Best PracticeSummary Trying to find Best Practice on storing Data Models within Custom FolderContent Hello, New to the forum and I have a question regarding Management of Data Models…Tony Chan 101 views 8 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Pay Period Start & End Date IN BI ReportSummary Pay Period Start & End Date IN BI ReportContent Hi ALL, Can someone help me, I'm looking for Pay Period Start and END Date. Which table do i need to refer to get…User_2025-02-07-19-03-14-525 38 views 4 comments 1 point Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Dashboard BI Publisher Report SecuritySummary Dashboard not retaining user securityContent I have created a dashboard report from a BI Publisher report using a data model. During testing, I have noticed the …Shelly Feyerherm 108 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
How to: Translate BI Publisher Report ParametersSummary I wish to know if it is possible to translate BI Reports parameters based on user environment language.Version Oracle BI 11.1.1.9Nalinee Uppiah 108 views 7 comments 0 points Most recent by Nalinee Uppiah Reporting and Analytics for HCM
-
Can we query the list of custom BI reports and OTBI analysis in our instanceSummary The requirement is to pull the report name,report path, parameters and other corresponding attributes of a reportContent Hi, The requirement is to pull the repor…User_2025-02-07-18-15-37-534 61 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Salaries in WordsSummary I Need to put in Word Template the Salaries in wordContent I need to put in template WORD (bi publisher) , the salary in full (Words) can someone help me?Jorge Donaire-229567 54 views 8 comments 1 point Most recent by Sahil Makhiza Reporting and Analytics for HCM
-
Employee, Manager, Department Head ( Director & up ) and Division Head ( VP & up) in a report.Summary Employee, Manager, Department Head ( Director & up ) and Division Head ( VP & up) in a report.Content HI, I'm planning to build a BI Report having Employee, Mana…User_2025-02-07-19-03-14-525 51 views 9 comments 0 points Most recent by Mishra Ankit Reporting and Analytics for HCM
-
Dashboard Prompt from BI ReportSummary Dashboard Prompt from BI Report does not workContent I have created a dashboard from a BI Report. I have attempted to set up a prompt but it isn't working. Can s…Shelly Feyerherm 98 views 1 comment 0 points Most recent by Sahil Makhiza Reporting and Analytics for HCM
-
Onboarding ReportSummary BI Publisher Onboarding ReportContent Hello. We have surveys under Onboarding and we need to report on the results. I have written this in BI Publisher but I am …User_F1ZIP 96 views 5 comments 0 points Most recent by Aries Gacias-84224 Reporting and Analytics for HCM
-
Need Sample Query on Head Count BIP ReportSummary Need Sample Query on Head Count BIP ReportContent Hi All, I am trying to build a Headcount Summary Report in BIP to achieve the below results, Head Count Summary…
-
Manager name for the CEOSummary After promoting an associate to CEO, the former CEO is still seen as his managerContent When our previous CEO retired, he was replaced by an associate within the…User_2025-02-05-12-06-38-063 49 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
sql to use to find out if someone is a line a manager ?Summary sql to use to find out if someone is a line a manager ?Content What sql to use to find out if someone is a line a manager ? We dont use the manager flag at assig…Ruzwan Akram 52 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Adding Case Statement to Existing Data ModelSummary Need assistance with case statementContent I am in need of assistance with the following: (1) case statement syntax and (2) adding a case statement to an existin…Shelly Feyerherm 47 views 9 comments 1 point Most recent by Shelly Feyerherm Reporting and Analytics for HCM
-
Schedule a BI Report based on custom logic (makes use of Payroll Flow Pattern and Custom Fast FormulSummary Schedule a BI Report based on custom logic (makes use of Payroll Flow Pattern and Custom Fast Formula)Content Many a times we may have a requirement that we woul…AshishERPCloud 92 views 2 comments 7 points Most recent by Sahil Makhiza Reporting and Analytics for HCM