BI Publisher
Discussion List
-
Performance issue while fetching details from data_cache columnSummary I am facing performance issue while fetching details from data_cache column.Content Hi Team, I am using below query for fetching all kind of approval transaction… -
Looking for Quadrant view of dashboard for BSCContent Hi, I have a requirement to build Quadrant view of dashboard for BSC. Please let me know if anyone can help me on this. Thanks. JyotiUser_2025-02-06-14-37-05-233 23 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Looking for Transfer Compensation Change ReportContent Hi, I am in need of Transfer Compensation and Location Change report. Please help. Thanks, JyotiUser_2025-02-06-14-37-05-233 15 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Manager_type = Timecard_Approver in OTBISummary Manager_type = Timecard_Approver in OTBIContent Hi ALL, In OTBI when I see "Manager Type" ( "Workforce Management - Worker Assignment Real Time"."Worker"."Manage…User_2025-02-07-19-03-14-525 37 views 7 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Rename Column HeaderSummary BI Publisher Report Column HeaderContent Hi, The attached BI Publisher report has a typo in the column header where Annual is misspelt as Annaul. I have tried ed…User_2025-02-05-22-44-35-842 30 views 3 comments 2 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Salary reportSummary Salary reportContent I need a report which pulls current salary and previous salary details. Can any one have SQL to pull the data. PERSON_NUMBER OLD_SALARY_STAR…Reddykrishna 204 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Remove Pending Workers from BI Publisher ReportSummary Pending WorkersContent Hi, I have a BI Publisher report that is incorrectly including System Person Type: Pending Worker in the Headcount figures. Can someone te…User_2025-02-05-22-44-35-842 55 views 8 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
OTBI Matrix Manager ReportSummary OTBI Matrix Manager ReportContent Hi Team, We are working on a OTBI report where client want to add all matrix managers and should extract all manager in single …User_2025-02-01-03-43-13-079 118 views 2 comments 2 points Most recent by User_2025-02-01-03-43-13-079 Reporting and Analytics for HCM
-
How Extract flexfield attributes of departmentContent Hello Guys, I need to extract the flex-field attributes of department, but by using this query I don't find any things. Moreover, I have a lot of duplicate rows …Giuseppe Iacono 34 views 2 comments 1 point Most recent by Seiichiro Yasui Reporting and Analytics for HCM -
Role related issue while running a BIP report via HR Dashboard in HCM CloudSummary Role related issue while running a BIP report via HR Dashboard in HCM CloudContent Hi, I have a BIP report developed which is working fine as is when checking da… -
fields to use for employee bank account reportSummary what fields to use for employee bank account report?Content hi what are the correct fields and subject to use for getting a report of current employee bank accou…User_2025-01-29-02-09-34-137 140 views 11 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
SQL for report columnsSummary SQL for report columnsContent I want to be able to query an analysis and get a list of columns that are used in that analysis.Chris Campbell 39 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Is it possible to have email recipient in Agent based on Area of Responsibility?Summary I am creating an email notification for New Hires with benefits enrollment details using Subject Areas and I would like to have the email recipients based on the…Dana Resultay 55 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
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 36 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 135 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 74 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 69 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 22 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 54 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 -
how to get read only access to reports and analyticsSummary how to get read only access to reports and analyticsContent Hi Team - I need to grant only read access to Reports and Analytics page...With this grant,the user s…C.R.Balaji 383 views 3 comments 1 point Most recent by Rajasekhar Bandaru-Oracle 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 53 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 239 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 99 views 3 comments 0 points Most recent by Livia Popa-Oracle Reporting and Analytics for HCM