BI Publisher
Discussion List
-
how to get seniority date of a person from Oracle Fusion HCM tablesSummary how to get seniority date of a person from Oracle Fusion HCM tablesContent Hi, We are creating a BIP report to fetch seniority date of a person onto a Terminatio…User_MC37Q 1K views 1 comment 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Need inputs to fetch PBL batch start time and End timeContent Hi All, Please suggest in which table holds the when the PBL process started and end dated (i.e. completion time). Ex: If we submit PBL batch, we need to know co… -
Workflow table Fusion HCMSummary Need to extract notification historyContent Hi, Being saas customer do i have option to extract workflow data from Fusion HCM Br Azfar.Azfar.128 98 views 2 comments 0 points Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM
-
Need database table name that stores the Performance Goals that are present in subject area ""WorkfoSummary Need database table name that stores the Performance Goals that are present in subject area ""Workforce Goals - Goal Status Overview Real Time" "Content Hi. Need…
-
Personal Payment Methods Processing OrderContent HI All, In the Manage person payment method UI is having processing order as 1,2,3 and corresponding column in DB as “pay_person_pay_methods_f” and “priority”. T…Visu 298 views 11 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Cutting string at a certain character in SQL BI PublisherSummary i want to cut a string at a certain point of a string in BI PublisherContent Hi All, I have a department name however in the middle there is a . (full stop) and …User_2025-01-29-21-02-12-466 46 views 2 comments 0 points Most recent by User_2025-01-29-21-02-12-466 Reporting and Analytics for HCM -
New Hire Notifications to Manager, Payroll, HR Business Partner, EmployeeSummary Creating Individualized New Hire NotificationsContent Hello, We are currently transitioning to HCM Fusion and we need a New Hire alert that sends out to their Ma…User_2025-01-31-00-25-12-234 152 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Active\Inactive Employees with assigned Line ManagersSummary A requirement for a BIP report to show all employees and their Line ManagersContent Hi All, I have a requirement to create a BIP report to display all Active and…User_2025-01-30-03-54-32-528 453 views 12 comments 0 points Most recent by User_2025-01-30-03-54-32-528 Reporting and Analytics for HCM
-
Identifying if an assignment change was done with a future, retro or current dateSummary Having trouble finding a way to identify if an assignment change was done with a future date or retro date after the fact.Content Hello, My team is in the proces…Mak-Moose 180 views 4 comments 0 points Most recent by User_2025-01-29-21-12-23-173 Reporting and Analytics for HCM
-
Which table stores value set details used in fast formulaContent Hello everyone, Which table stores the information about the value set which is used in fast formula. if anyone knows which tabe defines the relationship between…
-
HCM infolets - include HC measures from records excluded from data role?Summary HCM infolets - can you include HC measures from records excluded from data role?Content We've put together a number of infolets showing basic HCM measures eg hea…User_0HYZ2 225 views 7 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Manager HiearchySummary Manager HiearchyContent Trying to get the Manager Hiearchy using CONNECT BY PRIOR on PER_ASSIGNMENT_SUPERVISORS_F. Noticed that there are flattened manager hiera…VijayaBaskar Ranganathan 104 views 4 comments 0 points Most recent by VijayaBaskar Ranganathan Reporting and Analytics for HCM -
Tell us how you use OTBI to inform our future product directionContent https://oraclehcm.influitive.com/challenges/486 Please use the above link to provide us with feedback on OTBI to help us improve our product. The short questionn…Julian Challenger-Oracle 44 views 0 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BI Report: Need help with Dependent parameter LOVSummary BI Report: Need help with Dependent parameter LOVContent Hi, I have a BI Report where there are 2 parameters: 1) Review Period: 2) Period_Month_Or_Week 1) Review…User_MC37Q 58 views 15 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Issue in "Workforce Performance - Performance Rating Real Time" Post Rel 13Summary Post Release 13 IssueContent Hi All, Attaching a report for performance tracking created on the "Workforce Performance - Performance Rating Real Time"(subject ar…User_2025-01-30-00-14-06-021 80 views 6 comments 0 points Most recent by User_2025-01-30-00-14-06-021 Reporting and Analytics for HCM
-
report show "no results" for specific roleSummary cant see results for person profile reportsContent hi, we created 2 reports from subject area "Workforce profiles: person profile real time" both report are work…User_2025-01-30-04-14-21-127 69 views 5 comments 1 point Most recent by User_2025-01-22-19-43-38-766 Reporting and Analytics for HCM
-
Adding Custom ColumnsSummary Adding Custom ColumnsContent Is it possible to add custom columns or custom logic to the existing subject area. If so, please share more detailsVijayaBaskar Ranganathan 54 views 4 comments 0 points Most recent by Mark_Daynes Reporting and Analytics for HCM
-
Custom Subject AreaSummary Custom Subject AreaContent Is it possible to create custom subject area with the custom columns. If so, please share more detailsVijayaBaskar Ranganathan 46 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BI Reports: Condition Region around tables are not working in RTFSummary BI Reports: Condition Region around tables are not working in RTFContent Hi, To explain in detail: We have a data model which has a parent and a child group. G_G…User_MC37Q 32 views 2 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
OOTB Statutory Deduction Register - BI Pub Template Wrong SubTotals RowsSummary OOTB Statutory Deduction Register - BI Pub Template Wrong SubTotals RowsContent Hi All, The data in OOTB Statutory Deduction Register Report (Loc: /Shared Folder…User_2025-07-18-02-05-33-261 42 views 1 comment 0 points Most recent by Allen D'Souza-Oracle Reporting and Analytics for HCM
-
BIP RTF Template - conditional display of textSummary BIP RTF Template - conditional display of textContent Hello, We are using BI Publisher to send emails to new hires (data model, bursting, RTF Template) I have a …User_2025-01-23-21-24-21-434 274 views 2 comments 0 points Most recent by User_2025-01-23-21-24-21-434 Reporting and Analytics for HCM
-
Dependent Parameter in BI Data Model does not work as expected.Summary Dependent Parameter in BI Data Model does not work as expected.Content Hi, Dependent Parameter in BI Data Model does not work as expected. The 2nd parameter's va…
-
Summation of worker category in OTBI ReportSummary Summation of worker category in OTBI ReportContent Hi Experts, I need a help. I have an OTBI report where I display the workers in each department, their job & w…Aloka Bhattacharya 51 views 15 comments 1 point Most recent by Aloka Bhattacharya Reporting and Analytics for HCM -
Error in BI Publisher Report:oracle.xdo.servlet.data.DataException: java.lang.RuntimeException&Summary Error in BI Publisher Report:oracle.xdo.servlet.data.DataException: java.lang.RuntimeException: FO processing stopped at 128MB memory usage; Large table in page …Aloka Bhattacharya 85 views 4 comments 0 points Most recent by Aloka Bhattacharya Reporting and Analytics for HCM
-
Position Action Reason field is not showing in the Workforce Management - Position Real Time SubjectSummary Position Action Reason field is not showing in the Workforce Management - Position Real Time Subject AreaContent Hi All, I am trying to include position action r…Vijaya Kumar Komari 35 views 2 comments 0 points Most recent by Vijaya Kumar Komari Reporting and Analytics for HCM
-
Fact FTE is not extracting correct data based on BU and Contract TypeSummary Fact FTE count value is repeating for every contract type base on BU but it should show FTE different value for each contract typeContent Hi All, I tried to crea…Vijaya Kumar Komari 19 views 2 comments 0 points Most recent by Vijaya Kumar Komari Reporting and Analytics for HCM
-
HCM SchedulesSummary Schedules are not showing active days & hours for departmentsContent Hi guys, I've been trying to create an OTBI analysis that will show person's department shif…Pavel Kartuz 204 views 4 comments 0 points Most recent by Pavel Kartuz Reporting and Analytics for HCM
-
Need to know the table storing the approver details in Person Management page, Oracle Fusion HCMSummary Need to know the table storing the approver details in Person Management page, Oracle Fusion HCMContent Hi, We have a requirement where we need to send transfer …User_MC37Q 59 views 6 comments 0 points Most recent by Riaz.S -Oracle Reporting and Analytics for HCM
-
Email Workflow Notifications - Task status not working properlySummary Email Workflow Notifications - Task status not working properly in customized email notification TemplateContent We have a requirement where we need to trigger e…Vijay Koyeda 61 views 1 comment 0 points Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM
-
Compare 2 columns in OTBI report & apply conditional formatting ( (Colors) on one of themSummary Compare 2 columns in OTBI report & apply conditional formatting ( (Colors) on one of themContent Hi, I'm new to OTBI. I have a requirement to display the Column …Aloka Bhattacharya 418 views 13 comments 1 point Most recent by Aloka Bhattacharya Reporting and Analytics for HCM