Reports
Discussion List
-
R12 HCM OTBI subject area database table mapping spreadsheetSummary R12 HCM OTBI subject areas to database tables mapping spreadsheetContent These spreadsheets are published by Oracle OTBI Development. The spreadsheets document F…User720640-Oracle 2.2K views 33 comments 30 points Most recent by Rishita Reporting and Analytics for HCM -
Workforce Management - Worker Assignment Real Time - position Management Business UnitSummary: Which fusion table can provide value for OTBI field "Workforce Management - Worker Assignment Real Time - position Management Business Unit" ? Need to create a …Rishita 33 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to use "Replace" function in BIP Report Excel TemplateSummary How to use "Replace" function in BIP Report Excel TemplateContent Hi Experts, How to use "Replace" function in BIP Report Excel Template. Could you please sugges…Bala Kasineedi 326 views 11 comments 0 points Most recent by Kishoor_R-Oracle Reporting and Analytics for HCM
-
I'm new to E-text template, how can I learn and How can we develop in Bi reportsSummary: Hi Team, I'm new to E-text template,how can I learn and How can we develop in Bi reports. Any suggestions . Thanks, Ajay Content (required): Version (include th…AjayKumar Maddipati 41 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Create Report from Tags and Experience sections in ConnectionsSummary: Content (required): Hello Experts, Is it possible to create a custom report for the fields in the Connections, more specifically for Tags, Experiences, Interest…Fabiana De Arruda 15 views 2 comments 0 points Most recent by Janine Brown Reporting and Analytics for HCM -
Which subject area gives the payslip earnings?Summary: Report pullings details from Pyalip Content (required): Does anyone know which subject area I can use to get the payslip details as per the screenshot attached?…Isabela Radivoi 71 views 5 comments 0 points Most recent by Isabela Radivoi Reporting and Analytics for HCM -
How to call a BI report when email id is created?Summary: How to call a BI report when email id is created? Content (required): Hi All, We got a requirement to send notifications to new joiners when their work email is…Venkatesan 41 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Can OTBI pull payment Method details e.g concatenated bank account No and Sort code ?Summary: I want to add to my audit bank details Report the payment methods details such as concatenated bank account and sort code. Content (required): Not sure if possi…Isabela Radivoi 51 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Reporting the termination screenHi, When I terminate the employee from the My Client Groups>>Termination>> screen, I want to report the part that opens in the screenshot below. I need a sql query for t…Cansel Karasoy 21 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Parameter's label in two different languages.We have a requirement to display the parameter's label as per the language who logs in. The actual requirement is to display the label as per the users who logs in . If …
-
Talent Profile: How can I make CLOB fields visible in a report?Summary: Talent Profile: How to make Job responsibility, - description and - qualifications visible in an analysis? Content (required): Dear all I need to create a repor…Matthias Essrich 72 views 4 comments 0 points Most recent by David Pham-Oracle Reporting and Analytics for HCM -
How to call OTBI report in a page using page composerSummary: Hi Experts , Can you please let me know the steps or document links to call OTBI report in a standard page using page composer. Content (required): Version (inc…MBApps 93 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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 856 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 23 views 3 comments 0 points Most recent by Julian Challenger-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 41 views 3 comments 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM -
Track IP AddressContent Hi All, Is there any way to track IP Address of the user who has made changes and accessing fusion system? Thanks, Visu
-
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 61 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…
-
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 31 views 7 comments 0 points Most recent by Sowdha Murugan 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…
-
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 21 views 4 comments 0 points Most recent by ROOPESH MADAN-Oracle 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 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
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
-
How to force repeat on rows in pivot tableSummary Trying to build a pivot table using the report editor with repeating valuesContent Has anyone been able to force a repeat on a row value in a pivot table? The ex… -
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 42 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 316 views 2 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM