BI Publisher
Discussion List
-
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 448 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 22 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 47 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 452 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 32 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 101 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 41 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 274 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 24 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 12 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 12 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 32 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 31 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 188 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Workforce Learning - Learning Management Real TimeSummary: Can anyone please help me with the table names that is being used in this subject.we have requirement to convert the OTBi to BIP Reportminati_behera-Oracle 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Need an Oracle documentation which list changes done to database or TablesOracle agreed to share a documentation which will help customer identify changes done to Tables which might affect BI Publisher reporting. But, Oracle said there is no d…Vamsi Kuchipudi 11 views 2 comments 0 points Most recent by Vamsi Kuchipudi Reporting and Analytics for HCM
-
Does anyone know which process populates this Benefits table?Summary: Content (required): I'm looking at table BEN_PRTT_RT_VAL and wondering if this is getting updated by a Benefits process vs. Payroll process? We see mismatches w…Scott Paulin 21 views 2 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM