BI Publisher
Discussion List
-
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 21 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 151 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 51 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 121 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 465 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 81 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 141 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 42 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 111 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 956 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 111 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 311 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. 91 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Chetana Pawar 121 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 296 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 21 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 265 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…
-
RTF Template creates incorrect word wrapping in output to PDFSummary: We have a company policy document that needs employees signature. We have an RTF template that contains all the verbiage and signature sections. When we output …Brian W 41 views 2 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
How do I exclude two question codes from the following query?Summary: Unfortunately I do not know SQL and am struggling with what I would think is a simple ask. I am trying to exclude two question codes from a query that I have. C…Tammy Hemmingson 21 views 2 comments 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM