BI Publisher
Discussion List
-
I want SQL query to fetch data from 9 Box Matrix dashboard in Talent Review MeetingsHi team I hope you are doing well. I want SQL query to fetch data from 9 Box Matrix dashboard in Talent Review Meetings (Box label, Rating, and manager name) Kind regard,Mohamed_Shafay 32 views 4 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Birthday Notification to be sent with Custom text on ImageWe have requirement to send birthday notification to employee by keeping RM , HRRM , Employee direct reportee and RM direct reportee in CC The content of email is :- Dea…Surbhi Jat-Oracle 70 views 0 comments 0 points Started by Surbhi Jat-Oracle Reporting and Analytics for HCM
-
Looking for query to fatch the specific security profileSummary: Content (required): Hi Expert, We are looking for a SQL query to get the list of roles that are attached with a specific security profile like a document securi… -
Report to get active staff as end of actual month vs their situation in the previous monthSummary: I want to create a BI Publisher report each month that allows me to track the situation of each employee if there is any changes between end of actual month vs … -
How to connect Person Table with Audit table - HWM_TM_AUDITSSummary: Hi, I am trying to create a Timecard Audit BI report. Need to connect Person table Per_all_people_f with HWM_TM_AUDITS table. Not finding a common ground betwee…Abhishek Bhaskar 65 views 2 comments 0 points Most recent by Abhishek Bhaskar Reporting and Analytics for HCM -
ora_pay_transform_file_type_list is not provided. use max seq num from pay_file_detailsSummary: ora_pay_transform_file_type_list is not provided. use max seq num from pay_file_details This is fusion HCM extarct BIP report related issue, Can anyone please h…User_2025-07-18-07-07-18-338 3K views 6 comments 0 points Most recent by Stefan v. Glabbeek HCM Extract
-
table/view to list all users with assigned role namesSummary: table/view to list all users with assigned role names Content (please ensure you mask any confidential information): I am looking for an Oracle Table/View name …Naved Khan 761 views 5 comments 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM -
BIP Report to get Employees with Bank Accounts not assigned in a Payment MethodSummary: Hello everyone, I am trying to create a report where I want to get a list of employees who have bank accounts that are not tied to any Personal Payment Method. …Tom John Bontoyan 58 views 1 comment 0 points Most recent by Bharat Agrawal Reporting and Analytics for HCM
-
Need help to build a sql to get approval transaction historySummary: We have a requirement to capture approval transactions and the respective data like what changed in the transaction. For example If it is for Location Change,wh…Praveen D 136 views 5 comments 0 points Most recent by Hrushikesh Pentewad Reporting and Analytics for HCM
-
BI report paramters not working in DasboardSummary I attached BI report to dashboard and created date paramter in dasboard prompt with same name as BI parameter.But not getting ouputContent Hi, I attached BI repo…User_6I33I 29 views 4 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
How to see from front end or fetch data through query for schedule information of hcm extractSummary: How can we see from front end or fetch data through query for schedule information of hcm extract like the schedule date, frequency etc.
-
New/Pending approval/requires approval goals in the tableContent Hi Team, We were able to get the details of the new/pending approval/requires approval from the table HRG_GOALS . In 20B we are not able to find the same. Is the…Nivya Mathire 138 views 8 comments 0 points Most recent by HasnatHRT Reporting and Analytics for HCM -
Line Manager Hierarchy with Active/Inactive employeesContent I am looking for a BIP report which shows all the active/inactive employees to a Line Manager Hierarchy. When Manager run the report then they can see all the ac…User_2025-02-10-21-21-05-328 199 views 19 comments 0 points Most recent by Revathi Thangaraj Reporting and Analytics for HCM -
Aor QuerySummary: Hi Expert, I have to add an AoR query in my almost five different BI reports. As of now, it shows all data, however, we need to reduce the results based on the …
-
Add New Pay Rate and Old Pay Rate to existing reportSummary: I've been working on making an adjustment to a report (linked below) to add columns for current pay rate and old pay rate. Right now, the sql in the report is r…Henry Imgrund 13 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Multiple School Districts and Multiple Cities per GeocodeSummary: When trying to build an OTBI Data Model for Tax Withholding, we are finding multiple cities in a Geocode (HZ_GEOGRAPHIES, HZ_GEOGRAPHY_IDENTIFIERS), and multipl…ChicagoConsultant 22 views 2 comments 0 points Most recent by ChicagoConsultant Reporting and Analytics for HCM
-
what is the diffrence between reports and extracts where we can we the extractsSummary: Hi Team, what is the diffrence between reports and extracts where we can we the extracts ? How can we learn, i'm new to extracts. Thanks, Ajay Content (please e…AjayKumar Maddipati 26 views 6 comments 0 points Most recent by VijayKumar R Reporting and Analytics for HCM -
Which tables stores the information for Manage Benefit ProvidersSummary: Which tables stores the information for Manage Benefits Provider Content (please ensure you mask any confidential information): Which tables stores the informat…
-
How to automate the distribution of reports weekly to specific roles within the specific department?We need an automated system to distribute reports on a weekly basis to all users holding the Line Manager role within the Head Office department. How would I do that? Th… -
Need help on Payroll Pension Summary BI reportSummary: These are the columns that I am not able to find the exact table name from Oracle fusion Plan Annual Pension Pension Date Pension Year % Vested Fiscal YTD Conte…Deepak Bhatt 21 views 1 comment 0 points Most recent by Asmita Barman Reporting and Analytics for HCM -
Query to extract employee grade ladder in the assignment pageSummary: Content (please ensure you mask any confidential information): Hello experts, we built the following query to retrieve the employee current grade ladder. Howeve…Valerio Curzi 387 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Need help with SQL query for Time and LaborI have a query which times out with a single view, even after creating a report with it and scheduling it. When I raised this with Oracle support, I got to know that its…
-
Disable and Migrating BI Publisher JobsGood Day, For OTBI Agents, we can set it to disable if we do not want it to run. How about for BI Publisher Jobs? Is there a way to disable it? I cannot find any option …
-
OTBI agent monitoringSummary: We have scheduled OTBI agents, We cannot able to find a way to monitor the agent status - whether its active? - Whether its still running? - how long its runnin…Prabhu Krishnamoorthy 125 views 7 comments 5 points Most recent by Louis K.Emezina Reporting and Analytics for HCM -
Customer wanted to automate the process to send payslip over personal email for terminated employeesSummary: Hi Team, Would you please help us to get the steps how to achieve the requirement "automate the process to send payslip over personal email for terminated emplo…Rama123-Oracle 82 views 3 comments 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
report about changes the employee has madeSummary: Content (required): Good morning, Is it possible to have a report about changes the employee has made to Personal details, Additional personal details, and Bank…
-
Is there any seeded report for Payroll Analytics Initiative?Summary: Is there already Oracle seeded report for this? Content (please ensure you mask any confidential information): Version (include the version you are using, if ap…Cherry Carpo 21 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
Is it possible get a output in text format from bip report oracle fusionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nagendra Chitra-Oracle 141 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
SQL query needed to fetch "Calculate Payroll", "Make EFT Payments" process and employee detailsSummary: We want to create a BIP report in Oracle Fusion cloud to get the "Payroll Flow" name for "Calculate Payroll" and "Make EFT Payments" i.e. to get the payroll flo…
-
Advantages and Disadvantages of OTBI seeded dashboardsI'd like to know how the seeded Line Manager Dashboard works when it was copied to the Custom folder. If Oracle made some changes on the seeded Line Manager Dashboard, d…