OTBI
Discussion List
-
Sort breaking RCOUNT in logical SQL analysisHello, I have a fairly complex logical SQL report combining 5 subject areas. Overall, the information is displaying correctly with no issues. However, I have a need to R…Nick Dorfner 51 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Oracle Recruiting Cloud (ORC) Requisition Submission events history trackingSummary: IRC_SUBMISSIONS table holds a snapshot of a last step in process but a complete history of submission processing events is required. Content (required): Is it p…Valeriy Gorbunov 141 views 3 comments 0 points Most recent by Deepa Venkatesan Reporting and Analytics for HCM -
How can we view an employees current department in performance document reporting?Summary: We have a requirement to include the Department Name and Organizational Hierarchy levels in analyses of Performance Document completions. However if an employee…Joshua Kidd 21 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Combining Oracle HCM Source and data from Microsoft Excel file sourceSummary: Combining Oracle HCM Source and data from Microsoft Excel file source Content (required): We have created a report where we have defined a data model with a joi…Vasanthakumar Ravi 111 views 7 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Absence Accrual report in OTBISummary: Hi All, We have a requirement to develop OTBI Report for Absence Accruals. I couldn't able to get the accrual details. Does any one have catalog file or know ab…Sai Krishna Chelikani 31 views 8 comments 0 points Most recent by Sai Krishna Chelikani Reporting and Analytics for HCM
-
Person Contact Relationship Marital StatusHello Oracle Community, I am trying to develop a demographic of dependent report by using OTBI subject area: Person Real Time. I am having a challenge to find marital st…Mohamed Affan 51 views 8 comments 0 points Most recent by Mohamed Affan Reporting and Analytics for HCM
-
The specified criteria didn't result in any data from Project Subjects AreasSummary: When use Projects – Cross Suject Area Analysis – Real Time subject area, and select only project number column appears data, but when select project number and …Franklin_Cardozo-Oracle 21 views 5 comments 0 points Most recent by Franklin_Cardozo-Oracle Project Management -
Current report structure in OTBISummary: Please could we have a download of current report structure in OTBI for custom folder area? Ideally, we would like a list which contains all the folder/sub fold…Madhuri Brammadevara 41 views 4 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
How to send a scheduled report to a Sharepoint location using an OTBI Agent?Summary: How to send a scheduled report to a Sharepoint location using an OTBI Agent Content (required): How to send a scheduled report to a Sharepoint location using an…
-
can we customize the labels of 9 box in the talent tab of line manager dashboard reportSummary: Wee need to customize the labels of 9 box in graphical view in the talent review tab of line manager dashboard report Content (required): Version (include the v…Arpita Maitra 21 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI formulas to combine 2 criteriasSummary: Help on OTBI formula Content (required): I would like to create a formula that would allow me to get the AVERAGE individual bonus achievement BY workers and BY …Jacqueline GRANDIN 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
I am getting exception error for a scheduled report through bursting for an OTBI querySummary: Scheduled an OTBI report through bursting but getting an exception error. Content (required): Job processor caused exception [INSTANCE_ID=bip.bi_server1] [INSTA…Srini Padmanabhan 204 views 13 comments 0 points Most recent by Supriyaa Damodaraswamy Reporting and Analytics for HCM
-
ZIP output file of an OTBIHi All, We have a requirement to zip the output file of an OTBI analysis before emailing. Is this possible? Regards,Vibha Pandey - Oracle 11 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to use better the indexes on the Oracle HCM cloud tables for efficient SQL writing?Summary: Oracle HCM OBI tables list has list of indexes on each table. Can you please explain what is the significance of those indexes and how to make use of them for m…Amit Patil 131 views 2 comments 0 points Most recent by User_2025-07-18-00-53-38-974 Reporting and Analytics for HCM -
How do I find correct security type to add to a role to run report?I have created a dashboard and a new role which I had inherited to another role. The issue though is when I go to run the report I get the following error which I know i…Aaron Reynolds 21 views 5 comments 0 points Most recent by Aaron Reynolds Reporting and Analytics for HCM -
Export vs. "Open" Report Data OutputSummary: Hello there! I have a question regarding a discrepancy I noticed in the data output of a report that I'm using. The report pulls all active team members as of t…
-
Absence Accrual OTBI ReportSummary: Hi All, We have a requirement to develop OTBI Report for Absence Accruals. I couldn't able to get the accrual details. Does any one have catalog file or know ab…
-
Created initiative for learning but not getting enrollmentsSummary: We would like to assign learning automatically to the new hires. We would like to assign learning automatically to the new hires. We created the initiatives and…
-
Can we restrict OTBI report 'edit' access for user to edit OTBI Analysis created by themselves onlySummary: How can we restrict user to edit only the OTBI Analysis created by themselves, provided 'BI Author Role' access has been assigned to the user and user should ha… -
User person Type is not capturedContent Hi all I have created an ORBI report with Subject Area > Workforce Management - Worker Assignment Event Real Time to capture user Person type detail of the user.…Dhajani Perera 52 views 5 comments 0 points Most recent by Erica Williams Reporting and Analytics for HCM
-
Show the pod or instance name on an OTBI Analysis?Summary: We need to be able to label the header of an OTBI Analysis with which pod or instance it comes from. It can be pulled into a data model using the following quer… -
Delegate Access - InfoletsHi all, I was just wondering if anyone know if it was possible for those who have delegate access to run infolets on front end and see the same results as the manager wh…MikeW 121 views 34 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Active Organization Name for PromptSummary: Hi - I have a BI report that we're using for a dashboard along with some prompts for filtering the report. We have a Business Area (Division) filter but I wante…
-
Holds, Approval and Due payables infotile displaying data for all available BUsSummary Holds, Approval and Due payables infotile displaying data for all available BUsContent Team, User can able to see all available BUs information on the Holds, App…Surya01 35 views 5 comments 0 points Most recent by Arvi Dinavahi-Oracle Payables, Payments & Cash Management -
Duplicate person number in OTBI report.Summary: Hi Team, I am using the subject area " Worforce Management - worker Assignment Event Real Time" with below clolum and without any filter . Legislation CodeLegal…
-
Learning Initiative - New Starter Courses then added to Cyclic Courses - Not WorkingSummary: Content (required): Good Day, We have 8 mandatory course that have to be completed by New Employees within the first 30 days so they become compliant for a Year… -
Is it possible to pull ALL job applications (rejected, accepted, etc.) in an OTBI report?Summary: Is it possible to pull ALL job applications (rejected, accepted, etc.) in an OTBI report? Content (required): Is it possible to pull ALL job applications (rejec…Kim Buch 21 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
How to get outcome, where we can know how many users are set English/German as Language PreferencesSummary: We wanted to know how many users use English/German as a Language Preference set under set Preferences. Content (required): Example, We have 1,000 users, we wan…Deepak9 23 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM