OTBI
Discussion List
-
Start Date change on ORC side - Need to know table where Old start date value is storedSummary: When a candidate is in Post Offer stage and the Start date is changed to a new value, in which table does the old value reside? Context - We are trying to build…Patrick Turcotte 94 views 9 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Select a particular value from concatenated fieldSummary: To obtain a specific value from concatenated field. The business requirement is to obtain information regarding people reporting to C suite (Senior Leadership) …Pranav Waichal 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Job requisition report not pulling all job requisitionsSummary: I created a job requisition report to show all open requisitions in a month. I need it to show any that are currently open plus those that were open and filled …Emily Wilde 206 views 11 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
OTBI Report with future hires and terminationsHello, We are attempting to build a report to help our partners keep track of I-9 completions. We are using the subject areas Worker Assignment Event Real Time and Work …joshvanlaan 266 views 9 comments 0 points Most recent by Subbu Santra Reporting and Analytics for HCM
-
Reported Time Card Real Time Performance Very SlowSummary: Reported Time Card Real Time Performance Very Slow Content (please ensure you mask any confidential information): Good Day, Is there a way to improve the perfor…JMLMIII 25 views 10 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM
-
Illinois "Equal Pay Registration Certificate" reporting requirementSummary: Any suggestions or experience on how companies can best extract this data to meet this state requirement? Content (required): Good afternoon! Has anyone had to … -
Unable to create OTBI AnalysisHi to all, as an administrator user, when I try to create a OTBI Analysis I'm only able to view my own informations. I can't see the information about other users. The s…
-
SQL query for Planned Schedules on Time ManagementHello! I need help in developing an SQL query for generating the Planned Schedules for employees on the Time Management navigation: My Client Groups>Time Management> Pla…Hassan Mohsin LC 54 views 8 comments 0 points Most recent by ganesh_b-Oracle Reporting and Analytics for HCM
-
OTBI delimit data from 1 column into multiple columnsSummary: We have a report requirement where we want to delimit output from 1 column into multiple columns based on '/' delimiter Content (please ensure you mask any conf… -
Sample Report: Workforce Compensation Market CompositesSummary: Sample report showing how you can report on market composites within Compensation - Workforce Compensation Real Time Content (please ensure you mask any confide…Gail Langendorf-Oracle 6 views 0 comments 0 points Started by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Request for SQL/OTBI to Extract Scheduled Process Parameters (ESS)Details: We are looking for a way to extract Scheduled Process details (ESS), specifically the following information that is visible in the UI for processes such as Calc… -
is there way to hide Page Options - Edit dashboard - we have access it through work areaSummary: Dear exports, We have created work area and provided below static url of the dashboard link to access the report. The manger's are able to see the ritNow, the c…Rama123-Oracle 1 view 2 comments 0 points Most recent by Rama123-Oracle Reporting and Analytics for HCM
-
Can I speed up the search for people who successfully completed a course?Summary: I need to generate a list of who's completed a specific course. I don't care how often they've completed it - I just need to know if they've got at least one su…
-
OTBI Filter Criteriaanalysis result in error when no prompts are selected Errore Errore di visualizzazione della vista Errore durante l'elaborazione della query (SQLExecDirectW). Dettagli e…Rosita Santosuosso 13 views 0 comments 0 points Started by Rosita Santosuosso Reporting and Analytics for HCM
-
Learning related subject areaI need to create report based on these inputs but I am unable to find relevant columns from the learning related subject areas. I am not aware of the proper columns.
-
Absence Plan Use report via OTBII need to create an Analysis report in OTBI (I am new to this so I have not yet able to create reports etc) that will show employees sickness absence and the days used a…Julie Searles 241 views 7 comments 0 points Most recent by Gillian Kilbride Reporting and Analytics for HCM -
Offer Accepted Date and Offered Date returns an errorSummary: When we try to add the fields to our OTBI report Offer Accepted Date and Offered Date we received an error. We have tried to apply what the following post says …
-
How to show custom dashboards under Dashboard Header Menu in Oracle Fusion Report & AnalyticsI have created custom dashboard and I want show that dashboard under Dashboard Header Menu as attached Help me how to achieve it. How to add custom dashboard to Existing…
-
V3 Seniority date pulling old assignment detailsSummary: We are currently building a report using the "Payroll - Payroll Run Results Real Time" subject area. When we add attributes from the "Workforce Management - Per…Sreeraj Kavallore Sujith 11 views 2 comments 0 points Most recent by Sreeraj Kavallore Sujith Reporting and Analytics for HCM
-
OTBI Data Security Not Aligning with HCM UI Security ProfileDear Team, We have a business user who has been assigned a security profile that restricts access to view only employees within a specific AOR or Legal Entity. This secu… -
OTBI to fetch adjusted service dates from Work relationshipSummary: Hi everyone, We are trying to fetch the adjusted service date field from the employee work relationships page service dates section through OTBI. Can anyone sug…Prabha_112 141 views 2 comments 0 points Most recent by Rana Ritesh Kumar Reporting and Analytics for HCM
-
Sample Report: Workforce Compensation Budget Subject AreaSummary Workforce Compensation Budget Subject Area by levelContent Workforce Compensation Budget Subject AreaThis is part of a series of sample reports to use in your cl…Gail Langendorf-Oracle 340 views 15 comments 2 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How do you filter on the results of another OTBI analysis in combination with a date prompt?Summary: I want to be able to split workers who are paid and unpaid and break them down by age, BU etc etc. Those who are paid may have additional assignments as non-wor…Diane G123 35 views 9 comments 0 points Most recent by Kayla Malecki Reporting and Analytics for HCM
-
Salary details are not getting fetched for Subject area Recruiting-recruiting real timeSummary: I have seeded compensation manager role with required duty role Compensation Transaction Analysis Duty and Compensation Transaction Analysis but still i am not …Rajib_Samanta 297 views 20 comments 0 points Most recent by Jacqueline Mellonas Reporting and Analytics for HCM -
SUBSTRING function to separate multiple Valid GradesSummary We are trying to separate each valid grade into a separate columnContent When pulling job codes and valid grades, all valid grades are in one cell. We would like… -
Labelling issue for Percentage Bar graphSummary: My client has created Graphs for OTBI report data as part of requirement and what we see in one of our Percentage bar graphs is we are not getting the expected …Mamatha P-Oracle 19 views 8 comments 0 points Most recent by Mamatha P-Oracle Reporting and Analytics for HCM
-
Matrix Manager HDL Load shows new manager in UI but not in OTBISummary: We completed an HDSL load of new Matrix Manager assignments for employees. The UI shows the new manager but the OTBI report does not. Reflect the update. Is the…
-
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 299 views 10 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to hide embedded dashboard setting and help link and create custom dashboard styleContent Hi All, I have embedded a dashboard adding dashboard link to webpage content on the Oracle cloud hcm homepage. 1) I have added "PortalPages" to the link, however…Punam Roy Karmokar 67 views 8 comments 0 points Most recent by Punam Roy Karmokar Reporting and Analytics for HCM -
OTBI Agent Returns 25,001 RecordsSummary OTBI Agent Returns 25,001 RecordsContent I created an OTBI analysis. Then, I created an agent that runs the analysis. I schedule the agent and request the format…Daniel McMillian 97 views 7 comments 4 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM