Category 81
Discussion List
-
Report in OTBI to show data as of end of previous monthSummary: Need to show number of openings (from recruiting requisitions) from a specific date (6/1/22) through the last day of the previous month. I created a filter to s… -
What if i cannot find the Subject Area in the dashboard prompt. Does that mean i cannot create?Summary: Trying to create LSQL coming from Workforce Profile - Person Profile Real Time and Workforce Profile - Model Profile Real Time and will add it to a Dashboard wi…
-
Email Body not bursting correctly (22C)Summary: Content (required): Hi Since we went live with the 22C patch, notifications burst from OTBI are not including anything in the body of the email sent to recipien… -
How to embed Analytics, as an icon, in My Team page in UISummary: Our client wants to embed Analytics, as an icon, in My Team page in UI, which will redirect to a custom Analysis, as similar to the attached screenshot. The ico…Dona Das-Oracle 2 views 0 comments 1 point Started by Dona Das-Oracle Reporting and Analytics for HCM
-
OTBI Analysis report for auditing changesSummary: Hello - we are looking for a report/audit tool that will help us monitor when changes have been made to OTBI analysis based reports. We are utilizing the functi…Shanna Oppenheim 922 views 16 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
How to read primary national identifier?Summary: How to read primary national identifier? Content (required): How to read primary national identifier? I use per_national_identifiers table but no reference to t…Nicola Petri 56 views 2 comments 1 point Most recent by Seema Kalantri Reporting and Analytics for HCM
-
Do Business Unit names in BI report criteria gets changed to BU ID value during archive/ unarchive?Summary: Hi All BI/ reporting experts - The question is regarding migrating BI reports from one pod to the other. Oracle recommends using archive/ unarchive feature. We … -
Terms (Leavers) with Most Recent Performance Score and Box AssignmentSummary: We need a report and bar chart that shows terms (resignation and term-invol), NO legal employer changes, with their most recent performance score- the Calculate…Rebekah Gilday 31 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Errors found FBDI - Import Project Resource AssignmentsSummary: I am receiving these errors while performing the imports by project. Some of these I believe are caused by bad configuration data but not all. I am new to HCM a…Jon Calhoun 21 views 1 comment 0 points Most recent by Shivashish Dwivedi-Oracle HCM Spreadsheet Data Loader (HSDL)
-
Conditional display of dashboard analysisHi All We have a requirement to hide some area's (protected characteristics in particular, Age, Gender, Ethnicity) of the line manager dashboard based on the team size, …Murthy Kodavati 53 views 2 comments 0 points Most recent by Murthy Kodavati Reporting and Analytics for HCM -
HCM OTBI Workshop Session 2Summary: This following link allows you to download the recording of session 2 of HCM OTBI Workshop for beginners organized by JAPAC CS Org along with DEV and COE. Conte…Raghavendra Raghunath-Oracle 954 views 6 comments 14 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How can I get double quotes around fields in the output generated by an etext template?Summary: After adding a new field to a current etext RFT template and uploading it, the output no longer contains double quotes around the fields that contain spaces or …BeachDreamer 1.1K views 3 comments 0 points Most recent by BeachDreamer Reporting and Analytics for HCM -
Filter does not remain for Inactive Applications tabSummary: Content (required): Hello all, I'm facing a problem regarding Requisition Recruiter filter in OTBI dashboard. Starting from the first tab of the dashboard, name…Maria Xydopoulou 52 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
How to find the list of scheduled jobs and their individual runs?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):kishore madhavan-Oracle 52 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
What are the available web services for Fusion BIP?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):kishore madhavan-Oracle 21 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
How to SUM 1st, 2nd, 3rd and 4th occurrence of values in trailer summary record for ETEXT template?Summary: I have a requirement to build a trailer record that includes 4 separate SUM totals based on the occurrence of these totals in the employees record. I can't chan…
-
Colleague Goals Folder in Workforce Goals - Goal Alignments Real Time Subject AreaHello, Does anyone have experience using the Colleague Goals area of OTBI? I am creating Goal Alignment analyses, and I have already created analyses for Manager Goals a…Nick Dorfner 62 views 7 comments 0 points Most recent by Alvaro Couto Reporting and Analytics for HCM -
How to get performance rating of Manager and Employee in a single row based on Review Period?Summary: How to get performance rating of Manager and Employee in a single row based on Review Period? The employee rating and manager rating should be in single row bas…
-
CONTENT SERVER REQUEST FAILED error messageSummary: Error message when trying to generate dynamic URL embedded in custom Talent BIP report. Content (required): In the process of generating a dynamic URL to be emb…
-
Terms (Leavers) with Most Recent Box AssignmentSummary: We need a report and bar chart that shows terms (resignation and term-invol), NO legal employer changes, with their most recent box assignment from the Talent A…Rebekah Gilday 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Development Goals view of Top 5 for different categories - not overallSummary: HI there, I am reporting on our Development Goals using "Workforce Goals - Goal Status Overview Real Time" As there are so many goals in our system, I want to g…Stephanie McInnes 41 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to give mirror text formatting in rtf templateSummary: For one of the client requirement , in rtf template i need to show the text in mirror look. Please do the needful. If anyone tried this , please help us. Conten…SAKTHI SUNDAR 32 views 1 comment 0 points Most recent by Ankur Miglani Reporting and Analytics for HCM
-
How do we get Date performed ,Percentage of Performance Tasks by Status in performanceSummary: Hi All, I am using the Workforce Performance - Performance Task Status Real Time subject area for an OTBI Analysis. Can you please let me know from where Date p…Asha Jennifer 21 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM
-
Agent for a BI report?Summary: Content (required): Hi there Is there a way to prepare an Agent for a BI report? Thanks B Version (include the version you are using, if applicable): 22D Code S…Bobby Jourdan 61 views 9 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM -
Period Rolling Turnover by Employment CategorySummary: I am trying to get a rolling turnover by employment category. This analysis doesn't change any value even if I provide the assignment category filter. The resul…Anita 33 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to customize Goal workflow notificationSummary: How to customize Goal workflow notification Content (required): Hi All, We have a requirement to customize the Goal workflow notification. we need to replace th…
-
Identify the list of reports that a custom role can accessWe have 100s of custom reports within our /Shared Folders/Custom BI catalog folder structure. We have quite a few custom HCM security roles and each custom folder & repo…Pradeep TU 73 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to calculate percentage of Employees with more than 5 hours of learning?Summary: I need to get the percentage of Employees with more than 5 hours of learning for a specific time period in OTBI. So far, I have: a counter for employee names to…A Geyne 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Custom report permission with Custom RoleSummary: Hi We have requirement where we wants to give a custom report access to all of the employee of the company. Our organization in using all custom role (Custom Em…Manisha Gupta 23 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Legal Employer LOV not populating while running EEO ReportsSummary: Hi All, While running the EEO-1 report, I am not able to find any Legal Employer coming in the dropdown. We have 3 LEs in the system and in other actions, I am …Gaurav Rath- PGC 51 views 1 comment 0 points Most recent by Abhishek Tiwari, CPP -Oracle Payroll and Global Payroll Interface (GPI)