OTBI
Discussion List
-
View the Milestone Due Date's Time in OTBISummary: How do I get the time stamp of a milestone's due date? Content (required): I need to present in a report the difference between the current time and the milesto…Richard_Page 31 views 6 comments 0 points Most recent by Bhaskar Konar Reporting & Analytics for Fusion Service -
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 182 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 81 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 51 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…
-
Course Comments - ReportSummary: Hi Team, Do we have option to create a report to fetch Comments added by Learners at course level/ Learner name etc currently. This was not possible earlier in …
-
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 41 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…Joshua Kidd 101 views 3 comments 0 points Most recent by Joshua Kidd Reporting and Analytics for HCM
-
PDH Item PublicationSummary: PDH 'Item Publication' process Content (required): Hi, I am testing the 'Item Publication' process in product hub. I have done the spoke system setup using - ht…Sravanthi Kollapudu-Oracle 41 views 3 comments 0 points Most recent by Manoj Bagul-Oracle Product Master Data Management
-
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… -
Do you know how to add a deeplink in the HTML ouput of an emailSummary: The request from business is to avoid opening a attached report to use deeplink from the report. But the email should contain directly the lines expected with a…
-
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 51 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Subject Area for PO Variance and PO Accrual?Summary: We are generating a PO report, and are looking to include the PO Charge, Variance, and Accrual accounts that are on each line. Subject areas seem to only show t…
-
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 264 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 81 views 2 comments 0 points Most recent by Amy Wilson Reporting and Analytics for HCM