BI Publisher
Discussion List
-
Email Notification when Employee Changes Their NameSummary: I would like to setup an email notification to go out to a particular address each time an employee changes their name. Or optionally one email per day with a l…User_2025-02-12-02-38-00-520 22 views 4 comments 0 points Most recent by Vinayak | Camptra Tech Reporting and Analytics for HCM -
How to get a PTO Accruals report with ONE line of data for balance per EE?Summary: We are using a 3rd Party for our PTO Accruals (UKG). Primary issue: Some EE's are in 2 plans, so they have 2 lines of data. The issue is that UKG will only pick… -
How to get a details of Clock Entries missing for 3 days or more (OTL Module)Hello all (Report Description: The list of employees who have missing clock entries for 3 days or more should appear in the custom report) can anyone please tell me wher…
-
Table name to query the Delegation Approval rule and categorySummary Table name to query the Delegation Approval rule and categoryContent I have a requirement to create a report for Delegation Approval Rule and category informatio…Sricharan Monigari 444 views 5 comments 0 points Most recent by Visu Reporting and Analytics for HCM -
OTBI Filter CriteriaSummary: Need help to add a filter criteria in OTBI analysis. I am using the below filter criteria which is working in payroll subject area: "Balance Types"."Balance Nam…Mohan Murali 23 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Organization Audit ReportSummary BIP Audit Query to tract the mutations happened with respect to Departments.Content Hi All, We have a BIP requirement to tract down the mutations that are happen…User_2025-02-10-16-28-01-402 48 views 4 comments 1 point Most recent by Karen Costakes Reporting and Analytics for HCM
-
SQL to return all job roles where a particular duty role is usedSummary: SQL to return all job roles where a particular duty role is used Content (required): Hi Team, Please share SQL to return all job roles where a particular duty r… -
DFF value is not coming in the OTBI reportSummary: Content (required): Hi Expert, We have created a DFF in the document of record and when we are using the OTBI report to fetch the data for this specific dff the…Faizan Rashid 426 views 2 comments 0 points Most recent by Faizan Rashid Reporting and Analytics for HCM -
HCM reporting on hours and average hours workedSummary HCM reporting on hours and average hours workedContent Hello Does anyone have any ideas about tracking average hours worked for hourly associates, as it relates … -
Adding data element to a data model (Adding Full_Name to EEO-1 report)Summary: Assistance requested in adding Full_Name to a data model Content (required): We have some EEO-1 reports that were built by someone else prior to my arrival. One…
-
OTBI Report for a list of OTBI ReportsContent I'm looking for a way to report on our current OTBI reports in their respective folders. I'm not sure if BI Publisher is the only route, but I couldn't find any …
-
Not getting any data when opening the reportSummary: Content (required): Hi Expert, We have built a report and it is an Individual Compensation report, I have all the roles but when I am assigning payroll admin an…Faizan Rashid 34 views 11 comments 0 points Most recent by Faizan Rashid Reporting and Analytics for HCM
-
Need inputs to get the Target Element Name under Status Processing RulesSummary: Need inputs to get the Target Element Name under Status Processing Rules in Element UI Content (required): We can have a link between Pay_Element_types_vl and P…
-
Termination Report needed (workflow initiated date vs the actual termination date)Summary: We are in need of a report which will help us catch "late terminations". Report should have a date in which the workflow was initiated, and then the termination…
-
Denied the delete option from everywhere.Summary: Hi Team, I have created a custom role, and I want to denied the delete option from which function need to denied for my custom role and only the "BI Author Role…User_2025-02-12-18-16-01-181 42 views 3 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
Manage Report Jobs screen shows owner as fusion_apps_prov_patch_appidSummary: Manage Report Jobs screen shows owner as fusion_apps_prov_patch_appid Content (required): Hi, The Manage Report Job screen shows the Owner as "fusion_apps_prov_…Christopher Jothi - HCM-Oracle 103 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
How to Add Documents of Record from HCM Employment Flow to Approval BIP NotificationSummary: Has anyone had success adding the DoR added during an HCM employment flow to the approval BIP workflow notification? If so, what needs to be added? Thanks! Upda… -
Not able to hide the delete button from a reportSummary: Content (required): Hi Expert, We have a requirement to hide the delete button from a report. But we are not able to delete the button. We are using a custom ro…Faizan Rashid 21 views 1 comment 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
SQL to calculate overall tenureSummary: Content (required): I am working on a BIP report and I would really appreciate if I get some help with the SQL to calculate the overall tenure of the employee w…Prajna Hegde 43 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
In BIP, when clicking on the download button in PDF output, an HTML file is downloadedSummary: The issue is when clicking on the download button in PDF output, an HTML file is downloaded instead of a PDF. Would there be any setting to set in the BIP repor…notautomni9 265 views 3 comments 0 points Most recent by Paidiparthi Ravindra Reporting and Analytics for HCM -
Report on scheduled Extracts and BI reportsHow to get a report on all the extract and BIP reports scheduled in system with frequency of schedule? Regards, NivyaNivya Mathire 21 views 1 comment 2 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Issue-Line Manager getting employee's all assignments performance documents details in OTBI reportSummary: I am working on one OTBI report to fetch the details of performance document for line manager. Employee who are having two Active assignments and both assignmen…Kamini Kaushik-Oracle 29 views 3 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
How to fetch details of bypassed task for performance document in OTBI reportSummary: I have requirement to fetch the details of bypassed task in performance document in column Content (required): In our instance for performance document the work…Kamini Kaushik-Oracle 11 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM
-
BIP Report- Need to Create Report based on User Access or Security Access.Summary: Need to Create BIP Report for performance , Which shows data based on User Access. Content (required): I need to create report for performance Module which show…Alok Ranjan 11 views 7 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
How to restrict OTBI report output based on employee assignments details for Line Managers loginSummary: Hi, I have created one OTBI report to view the details of PD but line managers are getting two rows for both the active assignments of employees .Ideally the li…Kamini Kaushik-Oracle 33 views 1 comment 0 points Most recent by Preston Schultz Reporting and Analytics for HCM
-
How to restrict OTBI report output based on employee assignments details for Line Managers loginSummary: Hi, I have created one OTBI report to view the details of PD but line managers are getting two rows for both the active assignments of employees .Ideally the li…Kamini Kaushik-Oracle 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Person number of employee/contingent worker of a successful referred candidateSummary: Customer is looking for a report with the person number of the employee/contingent worker who has been successfully hired after being referred by an internal em…
-
OTBI with Personal Payment Method DeeplinkSummary: Team, I am working on a Personal payment method OTBI analysis with Deeplink enabled. I am finding one issue like while I am selecting then it I select the assig…Mohan Murali 32 views 3 comments 0 points Most recent by Julian Challenger-Oracle Human Capital Management
-
How to generate a report for HCM users who are not using SSO loginSummary: HI Team, We would need to generate a BI report which will contain all the users who are not using SSO login instead they are using their username and credential… -
BIP report: Users with HR and line manager role should only see their direct/indirect reportsSummary: BIP report: How can we make sure that when an HR User, who is also a Line manager, is only seeing their own reports (direct and indirect) when pulling the repor…Franziska Reichel 187 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM