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
-
Could not find the table link between Rating Model and Profile section nameSummary: We could not find the table link between Rating Model and Profile section name HRT_PROFILE_TYP_SECTIONS_VL - section names are available in this table HRT_RATIN… -
We could see some extract sections from bakend for the task Profile Content Section AccessSummary: Hi Team, We are encountering an issue that there are some more sections in UI which we are unable to find functionally and technically where these extra section…
-
Subject Area to determine the Legal Entity details in Workforce Succession Management Subject AreaSummary Subject Area to determine the Legal Entity details in Workforce Succession Management Subject AreaContent Hi , While building some reports for the talent Module,…
-
Payroll register dynamic BI reportI have a requirement to get the below records in payroll register report(dynamically). Person Number|| 1|earning element run result values| deduction…
-
Help with setting up Map View in OTBI - Map showing marker on incorrect StatesSummary: I'm looking to create a headcount by State/City/County report and use the map feature to display the results. State appears to be working correctly and the head…
-
How to retrieve Work Day Definition (Weekly Working Hours section) using OTBIContent Hello We need to extract the information: Work Day Definition (Weekly Working Hours section) using OTBI. USA are using this information to track Shift informatio… -
Difference between two dates with decimal outputSummary: In an OTBI report, the requirement is to calculate years of service for terminated employees (difference between hire and term dates). The output needs to be 2 …
-
SQL Query to get calendar attached to employee .Summary: Dear Team: We need to get the calendar details for an employee. Navigation is Login as an employee→Time and absences→Calendar Content (please ensure you mask an…
-
Element entries related to the current assignmentContent Hi Team, We are generating an offer letter for the candidate once they become a pending worker. For that we are getting the data from the element entries table. … -
HCM Table to connect payroll run result values to an employee assignmentSummary Need help with finding a table or column which can tell payroll run result values ran for an assignment_idContent Hello Everyone, I am in middle of editing an SQ…
-
Does exist a BIP table/view with both Person Number and Employee Name?Summary: Building a valueset Content (please ensure you mask any confidential information): I need to create a value extracting person name, person number and person id.… -
Issue and Resolutions from the Transaction ConsoleSummary: Hello, I was able to find the issue description and resolution information from the table "HRC_CONSOLE_FAULT_DETAILS_VL". However, I'm unable to connect the act…
-
Absence Type and Absence Reason not visible on employee's timecardSummary: Hi, has anyone here encountered an issue where, when an employee logs an absence with a reason, the timecard shows nothing? I have set up the absence reason and…
-
How do I extract a portion of a text field before a special character in OTBI?Summary: One of our Display Name fields shows Preferred Name Last Name (pronouns). What is the expression to extract the portion of the text before the "("? Content (ple…
-
Restrict the compensation information in reports and analytics.Hi Team, We have a requirement that some set of employees can able to access/view the compensation data in BI and OTBI Analysis reports. E.g: If a user queries the compe… -
Subject area for report to fetch content section of person profile typeSummary: Content (please ensure you mask any confidential information): Hello, We want to fetch all the details inside 'Content Sections' under Profile > Profile type > …
-
Prompts are not showing while scheduling the OTBI AnalysisThere are 4 prompts in the Analysis. But when we try to schedule the report, these parameters/prompts dont show up in the General tab. Please suggest.
-
how to get the retention rate calculationSummary: HI team! Do you know how to calculate the retention rate in an Analysis Report? This is the formula: (Number of employees at the end of the period / Number of e… -
the end date of assignment is 4712for the previous assignmentHi, Currently just Working on one requirement where i encountered a scenario is(Using Per_all_assignments_m) The person has four Assignments Active employee where the en…
-
Analysis report to find all the talent notifications enabled in systemSummary: Content (please ensure you mask any confidential information): Hello, We want to create an analysis report where we get the list of all the enabled and in use n…
-
Table links between Questionnaire and candidate tables in orcSummary: I need to get candidate Interview feedback Content (please ensure you mask any confidential information): able to get interview feedback from fusion.hrq_qstnr_p…
-
How to enable library in goal development on redwood page?Summary: Development Goal I want to enable the library in development goal, but I'm having trouble. Does anyone know how to make it available? Version (include the versi…
-
Query for Assignment Action and Action reasonSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Roles required for PER_AVAILABILITY_DETAILS.GET_AVAILABILITY_DETAILSSummary: Hi, We have created a report to get employee calendar, and we are using PER_AVAILABILITY_DETAILS.GET_AVAILABILITY_DETAILS in our query. This is working for us a…
-
Seniority Date in Workforce Management - Worker Assignment RT is not returning any data in OTBISeniority Date.Seniority Date in Workforce Management - Worker Assignment RT is blank whereas Person Seniority Details.Seniority in Workforce Management - Person Seniori…
-
Performance Issue - per_availability_details.Get_availability_detailsWe've developed a BI Publisher Report, but it's experiencing performance issues. When run ad-hoc, the report times out (Timeout Error), and when scheduled, it takes over…
-
When a filter is applied after ranking total months of service the analytic function no longer worksI have a report to pull the most recent seniority service data to get a list of employees eligible for a service award. My report works up until I set my final filter. H…
-
How to add Active FTE column to OTBI PivotIs there a way to add a column to the Pivot in this OTBI report that shows CURRENT total FTE by Dept By Job? Here is a print screen of output example. New column hi-ligh…
-
Equivalent FUNCTION (per_bipntf_utility) for XPATH QuerySummary In Fusion Cloud Applications Update 21C, Oracle will deprecate a column in a table in the BIP Data Models (HRC_TXN_DATA.DATA_CACHE) and advised to replace XPATH … -
How to fetch report in hiring tab in redwoodSummary: Content (please ensure you mask any confidential information): Hello, When using the Responsive UI, we were able to add a report (Candidate tracking ) in such a…