BI Publisher
Discussion List
-
SQL Query for Time Card Data and Absence DetailsSummary: Content (please ensure you mask any confidential information): Dear All We have requirement to create OTL Time Card Punch in and Punch out Report if the Employe…Shameer Muhammed P M 369 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management -
'The page has no content' error messageSummary: Hi All, We have a reports dashboard that is generated by clicking on a custom tile as per the below screenshot. For new users (sometimes even for repeat users),…Anne Fonseca 11 views 2 comments 0 points Most recent by Anne Fonseca Reporting and Analytics for HCM
-
Better alternative for not like operatorSummary: Better alternative for not like operator Content (please ensure you mask any confidential information): Hello , I am trying to exclude certain checklist names f…Nikhila 23 views 2 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
feasibility check of triggering Manager's direct and indirect reportees dataHi Team, Requirement: I have a requirement to trigger the report to managers as an attachment. The report should include data from both direct and indirect reporters. Co…Haritha 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to send a report to a network folderSummary: Is there a way to schedule a report or Agent to send directly to a network folder? Content (please ensure you mask any confidential information): Version (inclu…THawkins_LGI 115 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Showing error in BIP report ScheduleSummary: Hi Experts, we are facing following error during report scheduling. Content (please ensure you mask any confidential information): Version (include the version …
-
Goal Status Overview Real Time is not reporting Review Period NameSummary: Created a OTBI Report using the Subject area "Workforce Goals - Goal Status Overview Real Time". but not getting the data for "Review Period Name" and we have a…
-
BI tables to retrieve employee assignment country and departmentSummary: Content (please ensure you mask any confidential information): Hello experts, we need to configure custom person security profile based on employee assignment c…Valerio Curzi 46 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Report submitted in Scheduled Process going to Error stateSummary: Content (required): Hi All, BI report configured under 'Manage Enterprise Scheduler Job Definitions and Job Sets for Human Capital Management and Related Applic…Anil Pillaresetty 126 views 1 comment 0 points Most recent by larachalak Reporting and Analytics for HCM -
Which table holds the HR Representative Data for a particular employee?Summary Which table holds the HR Representative Data for a particular employee?Content Hi, Can anyone please let me know, which table holds the HR Representative Data fo… -
How to Test/preview etext templateSummary Have you ever created etext template to create delimited or fixed length files? Have you faced issues with debugging the template with ????? characters on the ou…Sricharan Monigari 441 views 3 comments 6 points Most recent by Shilpa Varghese Reporting and Analytics for HCM -
payroll report with gross pay showing element entry deductionsSummary: I need to create a report (OTIBI or BIP) that shows a person name, person number, pay period, pay period week, gross pay (for the pay period), add-in bonuses, (…
-
Seeded Termination Report in HCMSummary: Good morning everyone, Does anyone know if there is a seeded termination report in Oracle HCM. Also, is there a best practice for verifying inactive employees? …Daniel McMillian 73 views 8 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Create Security Report in OTBI with details of roles both past and present with dates and statusI tried submitting this question in the HCM Report Sharing Center that was discussed during yesterdays HCM Customer Connect but was getting an access denied error so pos…
-
Run Payroll Costing Report flow relation with Payroll Costing Report Extract?Hi All, I'm trying to understand if there is any relation between Run Payroll Costing Report flow and Payroll Costing Report Extract? My requirement is to modify Payroll…
-
What is the BICC PVO (View Object) to extract data for pay_bank_accounts?Summary: I would like to extract bank accounts number from personal payment method. Examples of PVO are HcmTopModelAnalyticsGlobalAM.CompensationAM.PreSalaryPVO, HcmTopM…Babatunde Ayodele 124 views 3 comments 0 points Most recent by Babatunde Ayodele Reporting and Analytics for HCM
-
Getting extra employees in BI report those are not direct or indirect reports of logged in managerSummary: Created BIP report to get direct indirect reports of manager however we are getting few extra employee those are not direct or indirect of logged in user (line …Swati U 31 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Table details for My Public Info-->About Me SectionSummary Table details for My Public Info-->About Me SectionContent Hi All, Could you please help me with the table/Column details for employee 'About me' Section. I am a…nitin Sharma 95 views 10 comments 0 points Most recent by Amee Patel Reporting and Analytics for HCM
-
Fusion BIP Reports Permissions Changes AuditHi, Is it possible to know the person name/ID/number who updates the permission of various reports/folders in Reports and Analytics for BIP. Thanks!Shilpa Varghese 31 views 5 comments 1 point Most recent by Shilpa Varghese Reporting and Analytics for HCM -
Join between HR_ORGANIZATION_UNITS_F_TL and per_all_assignments_m table in Oracle Fusion HCMSummary: Join between HR_ORGANIZATION_UNITS_F_TL and per_all_assignments_m table in Oracle Fusion HCM for fetching employee division. Content (please ensure you mask any…Hitha Harikumar 839 views 16 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to convert data rich text format to plain text in BIP.Summary: Am getting below output for one of Field format,:1. Words: 17Characters (with HTML): 897challa praveen 100 views 3 comments 0 points Most recent by challa praveen Reporting and Analytics for HCM
-
Query to fetch EOSB (End of Service Benefit) details from Oracle Fusion HCMSummary: Query to fetch EOSB (End of Service Benefit) details from Oracle Fusion HCM like : Hire date Hiring position Hiring grade Current grade Current position End of …Hitha Harikumar 269 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to retrieve the job req status for BIPSummary: How to retrieve the job req status for BIP Content (please ensure you mask any confidential information): Hello experts, we would like to build a BIP report wit…Oriana L. 90 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Chetana Pawar 104 views 4 comments 0 points Most recent by Chetana Pawar Reporting and Analytics for HCM
-
Query to extract second manager level (under top manager) for all employeesSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample query to retrieve for each employee the second level manager …Valerio Curzi 240 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Query/ table to find the new joiners detailsSummary: Hi team, Please help to find the Query/ table to find the new joiners details in Oracle Fusion HCM such as: Current Job Title Last Title (Designation from previ…Hitha Harikumar 22 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Employee Dates History ReportSummary: I have been asked to build a report showing an employees employment dates history; showing hire date, rehire date (if applicable), term date, and 2nd or 3rd ter… -
How do I re-enable download functionality of BI Publisher output when using Firefox?Summary: After Firefox updated to version 123 yesterday, Feb 20, 2024, we can no longer download BI Publisher output anymore. Content (please ensure you mask any confide…BeachDreamer 11 views 2 comments 0 points Most recent by BeachDreamer Reporting and Analytics for HCM -
Workflow Transactions Detail BI ReportContent Hi All, We have a requirement to create a report to fetch all the details of all workflow transactions going through approval. Is there a way to create a single …User_Z7BKU 270 views 4 comments 0 points Most recent by Neysan Mohajer Reporting and Analytics for HCM
-
query to get the vendor email id by vender id in publish report..?Summary: query to get the vendor email id by vender id in publish report..? Content (please ensure you mask any confidential information): Version (include the version y…