Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
Is metric tracking available for AI agents similar to AI Digital Assistant?Is there any available metric tracking for the AI agents we are putting on our pages that are replacing the AI Digital Assistant? Currently we are utilizing the analytic… -
Formatting BI Publisher chart axis labels to display integers onlySummary: I am working on a complex report in BI Publisher that is based on uploading an RTF file, and in this chart I need to display only integer numbers on the X-axis.…
-
-
HCM extract flow results in a tableHi, We are currently doing manual monitoring on schedule HCM extract runs and we are looking into creating an OTBI or BIP report in order to somehow automate this monito…
-
SQL to fetch learning catalog profileSummary: In which database table(s) can I find the learning catalog profile ID and learning catalog profile number Content : Background information: In version 25D Oracl… -
Workflow Transactions Detail BI ReportContent Hi All, We have a requirement to create a report to fetch all the details of all workflow transactions going through approval. Is there a way to create a single …
-
Example Feedback Report query for BI Publisher based on Feedback requests and Questionnaire tablesSummary: Our requirement is to generate a report based on feedback requests and questionnaire (eg. Annual Performance Feedback) tables. Manager will submit Feedback Requ…
-
Unable to pull E-Signature details from RequisitionSummary: I am looking to extract E-signature information, specifically the flow name, signature date and time, and the signer’s identity. My current approach joins IRC_A…
-
HDL for to upload the goal in librarySummary: Dear team, We are looking a HDL to upload the goal into goal library. Thank you! Content (please ensure you mask any confidential information): Version (include…
-
Workforce Performance - Performance Task Status Real Time showing incorrect assignment informationSummary: The Workforce Performance - Performance Task Status Real Time subject area seems to be displaying incorrect assignment information for employees that have had t…
-
Empty per_person_secured_list_v and per_assignment_secured_list_vSummary: I have admin profile but secured views are empty. Content (please ensure you mask any confidential information): I have admin profile but the following queries … -
“Connection is either null or invalid” Error Only for HR Specialist (Custom Role)Summary: We have a BI Publisher report in the Custom folder. When I run the report using my implementation user, it works correctly and generates output. But when we log… -
Is it feasible to get the number of candidates applied through easy apply in report ?Is it feasible to get the number of candidates applied through easy apply in report? i would like to know if it will be captured in the backend or not? In ORC report
-
Is it possible to save my preferred filter within the dashboard?Users cannot save or retain their own personal filters in the reports or dashboards. I understand that we can only configure default report filters/parameters - this fea… -
How to increase the specific BIP report's runtime or timeout limit?The Query Time Out that has been configured within the Data Model>Properties was set to 36000. However, during running the report, I'm still getting this kind of error: … -
Query to fetch departments with cost centre and cost centre managersSummary: Hi, i need a query with departments assigned to cost centre and cost centre managers. Please help Content (please ensure you mask any confidential information):…
-
Table per_national_identifiers is blank however there are data in the screenSummary per_national_identifiers table no dataContent Hi, I have a problem with person national identifier table is shown no data but the application screen shows data c…
-
How to Hide/Show Analysis in Dashboard Based on a Parameter ValueHello everyone, I’m working on an OTBI dashboard and need some guidance. The dashboard contains multiple analyses, and I would like one specific analysis to display only… -
Activity Report IssueHi, im working with a issue in my Activity report, that need course and offering info, the problem rise because of a excel course that they use the same activity for all… -
Custom Extract is taking more time to run than expectedSummary: I was checking and noticed that the payroll flow for 308 is now taking 3.5+hours where it was taking less than 2 hours before. It is critical we find out why th…
-
BIP Tables for Calendar/Calendar Events linkage with EmployeeSummary: BIP Tables for Calendar/Calendar Events linkage with Employee Content (please ensure you mask any confidential information): Hello, from My Client Groups > Orga…
-
Display Department Title on all levels of Department Hierarchy OTBISummary: Need to pull a report of all levels of our Functional Department Hierarchy with Department level 1,2,3,4 Name, and Associated Department Title. Content (please …
-
Requesting details on FDIHi Team, We are planning to implement FDI module ( Reporting ); and I am unable to get much details on FDI on CCC as well as on HelpCenter. Can you kindly assist on the … -
Need sql query to get Performance Library goal task and target outcomesNeed sql query to get Performance Library goal task and target outcomes I am using below to get performance library goals SELECT *FROM hrt_content_items_vl hciv WHERE hc…
-
SQL query to fetch public holiday according to the work schedule of an employee.Summary: need a SQL query that fetches public holiday according to the work schedule of an employee. Content (please ensure you mask any confidential information): I nee…
-
default List of values based on login user in BI ReportSummary: I am trying to Default Division in List of values based on user login, is it possible?? If I login as someone from Operations, I want only Operations Division t… -
Degraded performance when using secured views in BIP reportsSummary: Using a secured view (e.g., PER_PERSON_SECURED_LIST_V) in a BIP report results in a severe increase in the execution time of the query when ran by a user with a… -
Restrict BI Author Role to only create OTBI Reports, they should not have ability to edit BI ReportsHow to restrict the user having BI Author Role to only create & access OTBI ORC Subject areas reports only. Not having access & edit BI Reports for other work area like …
-
BI Report in payroll flowSummary: I’m trying to add a BI report in a payroll flow. I’ve done everything, and when I run the flow, the payroll gets calculated successfully. But when it reaches th…
-
Create OTBI report with manager types other than Line ManagerSummary: We created a manager type for Time Keepers that we need to be able to report on for our time keeping system. We have only been able to find Manager Type = Line …