OTBI
Discussion List
-
Error in Copy of Seeded NotificationSummary: BIP Notification issue Content (required): Hi Oracle Experts, I need your help regarding BIP notifications, I have a requirement to add/hide the fields in the n… -
I'm getting a Dashboard screen parameter error, how should I solve it?I get the 'NAME' field from the same subject area in my Analysis Report and parameter report. and in the analysis report I choose 'is promted'. But the parameter does no…Cansel Karasoy 41 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Changing time zone for BI reportsSummary: I need to keep the time zone as GMT-05:00 Eastern Time ( US & Canada) for all BI reports when I'm scheduling jobs. I followed the instructions of this document …Ayesha Iroshani 481 views 2 comments 0 points Most recent by Ayesha Iroshani Reporting and Analytics for HCM
-
Agent Completed with WarningsSummary Recipient not receiving the report using the Agent ConditionContent Hi All, I am creating a report which highlights to the manager that the employee's probation …Jo Black 102 views 3 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
How to obtain a query between the user and the roles associated with itSummary: Roles associated with a user Content (required): Hi team, We need to obtain the list of users and the associated roles. I have reviewed some tables but I cannot…SERGIO BARRETO 128 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
No fact table exists at the requested level of detail - Ethnicity IssueSummary: Hi - We have a roster report for our whole employee population and I was trying to tweak the ethnicity section to account for the many scenarios of if they choo…
-
Create analysis using logical SQL error?Summary: Invalid SQL Identifier: fusion.per_allocated_checklists ac. error Content (required): Hi All, We are looking at building OTBI analyses for identifying allocated…William_Johnson 171 views 3 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Where can I find Product and Segment from the financials side (default expense account) in OTBI?Summary: I want to join HCM data with expense account data Content (required): I need to be able to pull in the Product and Segment from the default expense account (or …Monique Dias 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Calculate Percentage based on Running Sum displayI'm displaying a running sum for minority hires and overall hires from month to month. I want to calculate the % of minorities to hires for each month based on the runni…Susan Anderson 76 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Why do some fields break a report in OTBI?Summary: trying to create a census report with fields from multiple subject areas and many fields work together but certain fields break the report Content (required): I…Monique Dias 51 views 8 comments 0 points Most recent by Monique Dias Reporting and Analytics for HCM
-
Formula for Data Submission Status in Talent ReviewsSummary: Subject Area: Workforce Talent Review - Talent Review Meeting Real Time Content (required): Hi All, We are looking to create an analysis that could be used to m…William_Johnson 51 views 4 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
AOR Templates - RecruitingSummary: I am trying to do an OTBI Report for representatives assigned with Recruiting responsibility type. However, when I add a filter for recruiting responsibility ty…Ridma Karunanathan 52 views 1 comment 0 points Most recent by Mayur Kaushik Reporting and Analytics for HCM
-
OTBI - Need Specific Assignment History along with complete salary historySummary: Hi , Client wants specific assignment history like Job Change, Dept. Change, Status change along with complete salary history. Able to get it but the salary his…
-
Report on PromotionsSummary: I need to be able to capture anyone who is transferred from a job with a job class of 'S' to a job in any other class (E, D, M, in our case). I'm looking for a …Jessica D 44 views 3 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
May I know which subject area suitable for below columns ?Summary: Hi Team, May I know which subject area suitable for below columns ? unable to find ? Thanks, Ajay Content (required): Version (include the version you are using…AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Job code with Null profilesSummary: Hi Everyone! I am trying to create a report which should fetch the job codes with No profiles in Manage job page. I hard coded one job code which is having no p…
-
How to find the max value across multiple columns?Summary: Staff can enter up to 6 qualifications in separate flexfields in the UI. We have a requirement to report on the highest value code entered for each employee. As…
-
How to get highest value from 4 different columns for each personSummary: I am trying to retrieve the highest value from 4 fields for each person For example these four people have various values in the 4 columns (some are null) The r… -
Absence duration between dates when absence start/end spans calendar monthSummary: How to report on absences duration within a given month, even if absence starts or ends outside of that month. Content (required): We have a requirement to repo…Michelle Hughes 34 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to fetch Contract Type Description into OTBI Analysis (Work Assignment Real Time)?Summary: We have different analysis based on subject area Workforce Management -Work Assignment Real Time, and we need to add an analysis per contract type Description. … -
How to report on position changes?Summary: I work for Charlotte-Mecklenburg Schools and we are in the process of modernizing to Oracle HCM Cloud. We have asked our ERP vendor to create a report to captur…Shea Hartsell 253 views 7 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
OTBI Analysis to identify employees with missing payment method - any help appreciatedSummary: We are looking to create an OTBI (not BIP) analysis which returns employees who don't have a payment method Content (required): Our current queries are bringing…Kevin M Storrie 81 views 5 comments 0 points Most recent by Kevin M Storrie Reporting and Analytics for HCM -
OTBI - Person Disability cannot View History using Workforce Management - Person Real Time subject aSummary When using "Workforce Management - Person Real Time" subject area we are only able to return the latest Disability row for an employee. How can we see all Disabi…Derrick Campion 73 views 2 comments 0 points Most recent by Amy Wilson Reporting and Analytics for HCM
-
Formula for most recent grade name on current assignment?Summary: Subject Area: Workforce Management - Person Profiles Real Time Column: "Grade"."Grade Name" Content (required): Does anyone have a formula to pull in an employe…William_Johnson 42 views 6 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Is there a way to report on what jobs are scheduled for extracts?Summary: Content (required): We would like to have a report to list all the jobs that scheduled for extracts. At this moment, after we schedule an extract, we lose visib…Sergio Burgos 11 views 1 comment 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Inability to view the National ID information in the report by the employee,how should we proceed?I have an excel report that I prepared with BI publisher, and this report contains the National ID information I got from the PER_NATIONAL_IDENTIFIERS table. But the use…Cansel Karasoy 305 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Seeded Line Manager DashboardsSummary: Does anyone know where the seeded line manager dashboards are pulling it's data from. When a line manager runs the headcount report then it shows a headcount of… -
Filter Active and Null Values of Assignment Status in Position FTE OTBI ReportSummary: Filter only Active and Null Values of Assignment Status in Position FTE Content (required): We are trying to filter only Active and Null Values of Assignment St…Manoj.Gupta 121 views 6 comments 4 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to add new tab for infolets?Summary: We want to add new tab similar to HR helpdesk and My services in the Analytics area of homepage. We have the links to add new infolet, but how to create a new p…ManishaSahoo 98 views 2 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
Unable to join the UDT subject area to the Assignment subject areaSummary: Unable to join the UDT subject area to the Assignment subject area Content (required): In the OTBI side, we are referring two subject areas. Based on Terminatio…