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
-
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 … -
Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiSummary Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiple tabsContent Hi Experts, I have a problem. There is a BI R… -
Learning Subject Area and Organisation Structure Reporting PerformanceSummary: Hi, we have an issue where trying to filter on Org Structure for Learning reporting results in the reports either timing out or taking 10+ minutes to run for a …
-
Report on Parent Position's Current Incumbent when Position is vacantContent We need a way to report on the parent position's current incumbent when the position itself is vacant. The report that we created shows the incumbent name for bo…
-
Retrieving learner-submitted attachments through the BI reportSummary: I need to fetch learner-uploaded attachment details via the BI report from the specified path below. UI Path - Edit Assignment > Related Materials > Learning As…
-
Oracle BI Report bursting throwing errorHi Team, I created 5 reports and all 5 are scheduled in Prod. Only 1 report is getting failed while bursting. Getting below error. Detail Message: ::JOB_WAIT_TIME_SECOND…