Category 81
Discussion List
-
Address change report to capture old and new valuesSummary: I have not been able to build or find a report that captures address change data. We have been looking for something and was wondering if the community would be…Tammy Hemmingson 302 views 5 comments 0 points Most recent by Natalie A. Reporting and Analytics for HCM -
Worker Seniority Date appears double in the BO Type drop-down of the Audit ReportsWhy does the Worker Seniority Date appear 2 times in the Business object Type drop-down list of the Audit Reports? This makes no sense at all. See screenshot attached : …Lynn Sack 15 views 1 comment 0 points Most recent by Mihnea Savu-Oracle Reporting and Analytics for HCM -
Query to fetch manager hierarchy based on Functional Reports-toSummary: Need help in fetching manager hierarchy based on most recently assigned Functional Reports-to manager. Content (please ensure you mask any confidential informat…Dinky Dudeja 446 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
OTBI Performance Management Summary dashboardSummary: Need path for this seeded report dashboard Content (please ensure you mask any confidential information): Our customer has this screenshot showed and mentioned …Rajkumar Subbareddi 73 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Scheduled OTBI reports- What happens when person who scheduled reports gets terminatedMy team has been scheduling reports for end users using their IDs (instead of a generic/master account). I was wondering what happens to the scheduler agents when the pe… -
Line manager dashboard through My Team > My DashboardSummary: We found the line manager Dashboard that was available through My Team > My Dashboard is no longer accessible for line managers. The function (tile) is no linge…
-
Excel template missing row header infoSummary: I have converted an Excel template to display in rows rather than columns. I have updated the Name Manager and the results display as expected however the param…Viviane Beaudoin 6 views 1 comment 0 points Most recent by Viviane Beaudoin Reporting and Analytics for HCM -
Can we add Settlement Date to OTBI reportSummary: Can we add settlement date to OTBI reports? Content (please ensure you mask any confidential information): Version (include the version you are using, if applic…Shameer Shaik 34 views 4 comments 0 points Most recent by Shameer Shaik Reporting and Analytics for HCM
-
Getting different employee counts using the same filtersSummary: I was getting inconsistent employee counts on a dashboard I was working on so I created 2 different analyses from different subject areas and applied the same f…
-
Generate candidate list for incomplete submissionsSummary: how do i generate a list of candidates that did not complete their application? Content (required): Hi we are in process of migrating from Taleo to ORC 22A and …MarkHodges 46 views 3 comments 0 points Most recent by Harika.Viswanatham Reporting and Analytics for HCM -
Recruiting Audit Report neededSummary: Recruiting Audit report needed Content (please ensure you mask any confidential information): We are looking for a Recruiting Audit report. Showing Requisition-… -
Run report that will show users that have run BIP or OTBI reports over timeframeSummary: Good afternoon. Any suggestions around how to produce an audit report (we don't have auditing enabled) to produce a list of users that have run Human Capital Mg…Rich R 18 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
In OTBI, how to set the filters to fetch data between the last 3 years to the current year?Hello, I'd like to create an analysis to fetch Performance Rating from the last 3 years up to this year based on "- Competencies"."Review End Date". How to set a dynamic…Lise_Rekik_Acc 32 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Whenever bursting job ran where can we find the details whom all the trigger is sentHi , We have letters like tenure/grade change we need the detail to whom the trigger is sent. Where will the details stored. Can i get the tables. Please help Regards, S…
-
Approval Date of the Approved Absence in Workforce Management - Absence Real TimeI'm currently creating a dashboard for Absence Management. Why there are Approved Absence, but the Approval Date is Null?Welsey 16 views 2 comments 0 points Most recent by SatheeshSamy-Oracle Reporting and Analytics for HCM -
Timecard Time Attributes Not Appearing in OTBI Timecard Subject AreasWe have Time Attributes set up that can be viewed in the application by navigating to Setup & Maintenance -> Workforce Deployment -> Time and Labor -> Time Entry Layout …
-
Termination ReportSummary: We are new to Oracle and looking to build a simple termination report that returns all terminated workers. Current problem we have is that it's returning termin…Darrin N 270 views 14 comments 0 points Most recent by Manmohan Mohapatra-Oracle Reporting and Analytics for HCM
-
How to enter a Column Group in a OTBI reportSummary: How to enter a Column Group in a OTBI report Content (please ensure you mask any confidential information): Hi, we would like to create a new OTBI report, which…Barile Alberto 182 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
CMP_ASG_SALARY_V we need these fields zone_name,ZONE_TYPE_NAME,ZONE_TYPE_ID,ZONE_ID related querySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Surya Prakash Chetla 18 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
SCROM ReportSummary: Has anyone had any success with creating a SCORM report in OTBI or BI? Would really appreciate help with this. We are trying to create a report to take out the …Teja Arepalle 34 views 2 comments 0 points Most recent by Teja Arepalle Reporting and Analytics for HCM
-
Changed information not shown in the Audit ReportsSummary: Hi, Regarding Address or Legislative information changes within the Audit Reports ; The log does not display all the fields that have been created, updated, mod…
-
Custom folder structureSummary: My client wants to change the Custom folder structure. My client does not want path to be Shared Folders > Custom > Human Capital Management. My client wants to…Consultant Ian 19 views 2 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
Terminated Employee QuerySummary: Can anybody Please share a query where the Terminated Employee should be Pulled in the query on the Day of Termination as Active Record. Content (please ensure …MilanMohanty 1.2K views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
How to report on days in state/phase through BIPSummary: We would need to create a datamodel showing when a submission entered a certain phase/state to calculate the times in phase/state. You can see similar informati…
-
New fields not showing any data in rtf template for document of recordsHello, I have one Document of record which is working fine but requirement is to add 3 new columns in that , For example Notice period/Hours and contract so i added all … -
Exclude Data Models in BI Search ResultsWe don't want end users to see data models in BI. We have followed the typical approach of saving data models in a Data Models folder where the permissions on the folder… -
Is there a report that lets you know when there is an empty position with direct reportsSummary: Hello - We are trying to find out if there is an alert, notification, or OTBI report that is delivered when there is an empty position with direct reports. We w…G. Class-Peters 31 views 6 comments 0 points Most recent by G. Class-Peters Reporting and Analytics for HCM -
What is the alternative of EXTRACTVALUE function and how to use it?Summary: Hi All, As EXTRACTVALUE function is no longer supported in Oracle SQL, the Data Models designed using EXTRACTVALUE is throwing error. The alternative is suggest…Robinson Ng 106 views 3 comments 0 points Most recent by Jordan Ritchie Reporting and Analytics for HCM
-
sql statement to get the performance document current taskSummary: sql statement to get the performance document current task Content (please ensure you mask any confidential information): Hi Team, I need these below two column…Malak 905 views 3 comments 0 points Most recent by Himavarsha Sathpadi Reporting and Analytics for HCM
-
Unable to find Title field (on Record External Learning Experience page) in OTBI ReportHi Team, We are unable to find below field in my OTBI report. Could you please help us to find the same. Field Name: "Title" (on Record External Learning Experience page…User_2025-02-12-02-03-48-970 44 views 9 comments 0 points Most recent by User_ZKDAR Reporting and Analytics for HCM