Category 81
Discussion List
-
Entity Relationship Diagram between ALL PVOs in Fusion HCM ModulesSummary: Entity Relationship Diagram between ALL PVOs in Fusion HCM Modules Content (required): Dear all - can we get ERDs for All PVOs from different HCM Modules from O…Nilanjan Biswas-Oracle 801 views 2 comments 4 points Most recent by Nilanjan Biswas-Oracle Reporting and Analytics for HCM -
Display Employee information as per attached imageHi All, I have developed an OTBI analysis to get employee emergency information. The requirement is to display the data pulled from the Emergency info OTBI report simila…Aditya Jadhav 22 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
requirement to restrict the parameter display for BIP report.Summary: For an e.g for role ABC logged in user we want to display one parameter and the user with role XYZ we don't want to display the parameter. Is it possible to ach…Sayali Pawar-Oracle 42 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
Is it feasible to restrict the folders using custom roles in reports and analyticsHi Team, I have the requirement that only a few sets of employees will be able to see some folders on the reports and analytics page. Ex: our requirement is only custom …Haritha 43 views 3 comments 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM -
Fast Formula to get lookup description in specific languageSummary: Fast Formula to get lookup description in specific language Content (required): Hi team, we are trying to create a fast formula to get the lookup description in… -
we have issue in OTBI report CANDIDATE REJECTION REASONS but we miss the latest records in scheduleSummary: Hi Team, we have OTBI report thta is CANDIDATE REJECTION REASONS report for particular country when we schedule the report it's fecthing(Candidate Job Applicati…AjayKumar Maddipati 64 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
How can we get the IP Address of a candidate after they have completed a Journey Checklist Task?Summary: Content (required): I need to get the IP Address for a person who has completed a checklist task. I understand that there is IP Address stored in IRC_CHECKLIST_…User_2025-07-18-13-29-11-469 61 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
EEO - Recruiting ReportSummary: Hello, I am hoping our community can share an HCM BI Publisher report that lists all applicant data for requisitions that had a hire within the past year. It mu…
-
White paper to load an HDL through BIP reportSummary: Please let me know if there is a white paper indicating the configuration for creating an HDL file and further load it through HDL through a payroll flow. I am …
-
Unable to restrict results with workschedule filters when it is blank or non primarySummary: Issue: There are multiple subject areas combined together to generate results which is embedded in dashboard. A new change has been requested to include employe…Sowdha Murugan 33 views 7 comments 0 points Most recent by Sowdha Murugan Reporting and Analytics for HCM -
How can we hide edit link on analysis?Summary: Content (required): How can we hide edit link on analysis. I know how to do this from a dashboard by using the page report links but how can we achieve this fro…
-
How to get - when the employee was created in the applicationSummary: Hi Everyone! Is there any way via (BIP/OTBI) to fetch when the employee was created in the application ? Version (include the version you are using, if applicab…ShawShankk 22 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Helen Tilling 11 views 5 comments 0 points Most recent by Helen Tilling Reporting and Analytics for HCM
-
Error when Combine 2 Subject AreasSummary: Hi All, I am trying to create an OTBI analysis by merging 2 Subject Areas: Worker Assignment Real Time and Person Real Time. The report will display employee wo… -
Show all Lines in Report ExportSummary: I have a large OTBI report that I need to export, and I need it to show all lines. Usually I just change the Data Viewing under Table Properties to Content Pagi…
-
Audit Report using BIP and shadow tables for Assignment ChangesSummary: Looking for a custom BIP report query for Audit purpose using shadow tables. Content (required): We enabled the Audit for multiple products using the task 'Mana…
-
Tables to find workflow attachmentsSummary: Content (required): Hi All, how to find the workflow attachments. I used the below query but not getting any result. SELECT wat.* FROM Fusion.Hrc_Txn_Header txn…Venkatesan 141 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Facing issue in performance goal dashboard reportsSummary: Facing issue in performance goal dashboard reports Content (required): Hi All, We are facing the issue in performance goal dashboard report. Even employee has e…Venkatesan 22 views 4 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
where to add parameter effective date conditions to OTBIHi All, Requirement: Added Effective date as a parameter in prompt and report should fetch all active employees as of that date which is given in the effective date para…
-
How to know recipients of bursting report that is not job history?Hi, we have many scheduled BI Publisher reports leveraging Bursting functionality to send emails to many recipients. Our client has the requirement to report on those pe…Fabio_Testa 112 views 9 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
In OTBI report when I schedule the report through agent to me or others all records not coming?Summary: HI Team, We have head count details report with nearly 41000 records and we are used only one subject area(worker assignement real time ) with 25 cloumns so iss…AjayKumar Maddipati 43 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Sick Leave Duration greater than XX days over a rolling periodSummary: We are trying to report on employees who have recorded more than 40 days of sick leave in a rolling 365 day period. Content (required): We have used Leave Durat…Emily Robinson 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Default Language in OTBI subject areasSummary: Hello, Do you know which subject area contains employee's "Default Language"? I've created a report presenting default languages in BIP, but it needs to be recr… -
How to send attachments from BI publisher?Summary: How to send attachments from BI publisher? Content (required): Hi All, We got a requirement to send a onboarding notifications for the new hired employees with …Venkatesan 22 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
OTBI Agent Sender Name ChangeHello Experts, Need your help & suggestions for the below issue that we are facing recently. We changed the OTBI Agent Sender Name by raising an SR to Oracle Support. It…Bhaskar Konar 41 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Need OTBI report showing all active employees AND whether or not they are enrolled in MedicalSummary: I have been asked to develop a report that shows all active employees (Assignment Status Type = Active) and include a column showing the medical plan name they …JHaden3 304 views 2 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
Need help with CASE formulaSummary: I'm using this formula in an OTBI report (using WFM Worker Assignment Real Time subject area). The formula should do this: If an employee hire date is
-
Not able to add the BI report in View Analytic pageSummary: Content (required): Hi All, We have created a BI report and we want to add this report in the talent review meeting in View Analyst option, but when we are tryi…Faizan Rashid 23 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Serial numbering in the reportHello, In a notification I prepared, I would like to give a serial number to the document that will be sent to the people in that month. For example, document no;01 docu…Sinem Kara 22 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
Subject areas to make analysis of BPM Transactions in OTBISummary: Subject areas to make analysis of BPM Transactions in OTBI Content (required): I need to make an OTBI Report to show the detail of BPM Transactions, including t…Hameed 68 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM