OTBI
Discussion List
-
How to identify hires as Internal or ExternalSummary: Using OTBI, I would appreciate recommendations on how to identify hires as either an Internal or an External hire. Thanks! Content (please ensure you mask any c… -
Question on where to fetch seniority dates in OTBI (v1 vs v3)Summary: with the v3 seniority dates in play, we are a bit confused as to where to fetch the seniority date data in otbi. Before we migrated to v3, we leveraged 2 fields…
-
How to identify if a goal has been added from the goal library?Summary: I have created two basic reports showing employee performance and development goals. I want to know how many of those goals have been added from the goal librar…Sarah Cottrell 25 views 3 comments 0 points Most recent by Paul Campanello Reporting and Analytics for HCM -
Future dated benefit groupsSummary: I am trying to create an OTBI report that shows the effective start date and end date of Benefit Groups. The only subject area that I can find that has the bene…
-
SQL Query - Pending Benefit Transactions that would prevent Employee TerminationHello, Hope you are well. Does anyone have a SQL query available, that displays any Active/In-Flight/Pending Benefit Transactions which would cause the Termination of an…David Oldfield 6 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Performance Task Status data is emptySummary: Workforce Performance - Performance Task Status Real Time returns the 'No Results' error. I checked and confirm that my role has the FBI_PERFORMANCE_MANAGEMENT_…George Chernikov 5 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
OTBI Report Is Not Showing Any Employee's Absence DataHello Everyone Summary: We developed an OTBI report to extract employee absence details (leave balance, unapproved leaves, total leaves taken, etc.) using the Workforce …Andriampeno Odilon 36 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Employees With or Without Goals Report - Missing dataSummary: Hello again, I need some help on my report. I need a report of Employees With or Without Goals. I created case statements for Total Employees, Goal Status (With…
-
Guidance to optimize OTBI HCM Cross-SA Reports having static report filters1- Some Cross subject area reports may be costly in terms of response time, if they are not designed correctly. It is always recommended to use (i) at least one common d…Abhishek Dixit-Oracle 137 views 2 comments 4 points Most recent by UdayrajSingh Reporting and Analytics for HCM -
Report Date Parameters needed START: (First_Day of Last month) END: (Last_Day of Last_month)Summary: Hi Forum: I'm looking to use below to accomplish General tab for Scheduling a report START: Last_Day(ADD_MONTHS(SYSDATE,-2))+1 First_day END: Last_Day(ADD_MONTH… -
SQL to list all customized OTBI and BI Publisher reportsSummary How to list all OTBI and BI Publisher reports in Shared Folders?Content Hi Team, Does anyone have the SQL that we can run to list all OTBI and BI Publisher repor… -
No results if no filter is appliedSummary: Hi, We have an HR role with access to a compensation OTBI report. In order for the results to be displayed, HR must filter by at least one BU. However, if I ass…
-
How to pass login user name dynamically in the OTBI Report nameSummary How to pass login user name dynamically in the OTBI Report nameContent Hi Team, We have an OTBI report called Direct Reportees of Manager and it's working as exp…Mahendra 461 views 11 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Time card details based on payroll flow - Load Time Card BatchesHi Expects, Requirement : Need to fetch time card details based on payroll flow - Load Time Card Batches. basically OTL report , based on payroll flow parameter. when we…Rajdeep Chavda 72 views 6 comments 0 points Most recent by Om Shukla-Oracle Reporting and Analytics for HCM
-
Hide Schedule and Job option from reportSummary: Hide Schedule and Job option from report Content (please ensure you mask any confidential information): Hello experts, does anyone know how to hide the followin… -
Looking for the Checklist Task Sequence in the Workforce management Checklist Real TimeSummary: Looking for the Checklist Task Sequence field in the Subject Area Workforce Management - Checklist Real Time Content (required): We are looking to add the Check… -
How to change the date format in OTBI promptSummary: How to change the date format in OTBI prompt. currently we are trying to change the accounting date column to mm-dd-yyyy format but we are getting syntax issue.…User_U4A6A 53 views 3 comments 1 point Most recent by Kuldipsinh Rajput Reporting and Analytics for HCM
-
Building an OTBI report using OTL data. Can't find Project RoleSummary: We are building an OTBI report to show all timecard entered for the week. We are project based company so our timecards include Project and task information, in…Anjula Mittal 25 views 3 comments 0 points Most recent by John Finnegan-Oracle Reporting and Analytics for HCM
-
What is the SA to use for Goals' Published Flag ?Summary: Hello, We need to display in an OTBI report the Performance Goals along with their Shared and Published flags. We are using Workforce Goals - Goal Status Overvi…
-
APISummary: Hi Expert, How to get the ( additionalInformationDetailsUniqID)? I have only URL and Offer ID how shall i get the additionalInformationDetailsUniqID? /hcmRestAp…
-
Print Talent ProfileContent I am creating a custom print of talent profile RTF Template and there are some sections that are only available to line managers but when an employee prints it s…Misbahul Khair 51 views 3 comments 2 points Most recent by Rishitha sravanya Reporting and Analytics for HCM -
HCM OTBI subject areas to database lineage mapping spreadsheetThis spreadsheet documents HCM OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Oracle OTBI Development…Raghavendra Raghunath-Oracle 42.7K views 186 comments 127 points Most recent by Nataliya B. Reporting and Analytics for HCM -
How to change the week start daySummary: Hello Experts, I created an Analysis and i see the Calendar Week Start Date is Sunday, but the customer need set to Monday. And this impact on the number of wee…
-
Unable to restrict OTBI data based on legal entitySummary: While attempting to create any OTBI analysis from HCM subject areas, we are encountering an issue where the data is not being limited to a specific legal entity…
-
Human Capital Management - Transaction Administration Real Time subject area not workingSummary: We have a report reuqirement to fetch all workflow transactions whether completed or failed, and for failed transactions we need to populate th eissue title, is…
-
Query/table information to obtain issue description from transactions that end in errorSummary: need a way to report on Issue description, Resolution and Number from transactions that end in error. Content (required): When a transaction ends in error there…PrashanthGanji 302 views 11 comments 1 point Most recent by Velidi Supraja Reporting and Analytics for HCM -
Action link for learningSummary: Need guidance to create action link for course learning report. I have made a learning report where course related columns are present, e.g. learning item name,…
-
Performance Calibration Module data in OTBI?What Subject Area is this data stored in? I'm specifically trying to extract the Calibrated rating. I've found all other data in our module setup with the exception of t…tim.glasheen_1073872 21 views 4 comments 0 points Most recent by tim.glasheen_1073872 Reporting and Analytics for HCM
-
Dynamic Date Prompts and SQL Setup for OTBI Workforce ReportSummary: Assistance needed with creating a dynamic OTBI report that allows users to enter date ranges for Assignment Details Effective Start Date and Assignment Details …ReiV 21 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Reporting "Additional Address Attribute 1" on OTBISummary Fields don't appear on the relevant subject areaContent Hi. I have aligned my country's geography and i have several address elements that i save on the fields: …