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
-
SQL Query service to extract the Payment Methods for all employeesSummary: I am trying to retrieve all current (i.e. 100%) bank accounts for all employees Content (please ensure you mask any confidential information): Would someone be … -
Trying to get BIP report to burst and consolidate on emailSummary: I am having trouble getting my BIP report to burst and consolidate delivery by email, even though the Enable Consolidate Output box is checked. I have been doin… -
How to build query like audit report?Summary: Content (please ensure you mask any confidential information): I can run this Audit Report: Is it possible to query the database to obtain the same info? Versio… -
OTBI Report Library ReportSummary: First question: Is there a subject area besides OTBI Usage that displays the entire catalog of reports, allowing you to filter by a commonly used field? For exa…
-
filter out html imputs in columnSummary: Im making a reporting for talent and need to filter out de html inputs in the Description field of the table HRT_CAREER_STATEMENT_ITEMS_V. is there a better way… -
BI Tables storing legal employer addressSummary: Content (please ensure you mask any confidential information): Hello experts, do you know in which Oracle HCM table the legal employer address is stored? Thanks… -
Unable to update headcount as 1 for few employees using HDLHi, We are using HDL for updating the headcount of 48K+ records and have successfully updated for most of them however for 5 records we are getting error as "More than 1…
-
Compensation - Indvidual compensation real time not showing any detailsDespite of having the necessary roles I still don't have access to show data from this subject area I added everything from this document, Document 3052888.1 but still, …
-
Getting Duplicate data on performance and goalsGetting Duplicate data on performance and goals when employees checking from Me >> Performance >> Employee is able to view the list of goals of other employees from his …
-
In which table has the information of Manage Legal AuthoritiesSummary: SQL query or Table has the information of Manage Legal Authorities Content (please ensure you mask any confidential information): Version (include the version y…
-
Cannot get specific element entry values from XML data cache column for pending transactionSummary: We are not able to get the accurate element entry value from XML data cache element entry rows data , we are only fetching values if they have in element entrie…
-
Need query for Calculation card values to run result values in hcm fusionSummary: Need query for Calculation card values to run result values in hcm fusion Content (please ensure you mask any confidential information): Need query for Calculat…
-
Duplicate and Missing Payroll Payment Records for EmployeesContent (please ensure you mask any confidential information): I'm encountering an issue where the query returns two rows for a person one with the correct payment statu…
-
Goals Created or Not Created by Country CodeSummary: When I use the union report suggested by Oracle/the community forum the no of workers without goals is not returning enough workers Content (please ensure you m… -
Report to show "Previous Incumbent" name in an existing "Position Incumbent Report"Content Hello Team, We have an existing "Position Incumbent Report" in which we show the "current incumbent" name. But now we have a requirement to add a new data column… -
Past Incumbents in position tableSummary: HI, I have checked there is no column for past incumbents in HR_ALL_POSITIONS_F and also in subject area "Workforce Management - Position Real Time", But we can… -
Employee Name ChangesSummary: Employee Name Changes Content (required): I'm trying to determine via OTBI the history of someone's name and their changes, but I don't see any values where I t…
-
OTBI missing journey tasksWhen creating an analysis to report on deferred journey tasks, I am not seeing ALL results. I am getting some, but there are definitely others that are seen in the UI, b…
-
I am looking for a filter to add to a date to show values in the current financial yearSummary: I have an OTBI analysis for terminated workers and I am wanting only those terminated in the current financial year to return in a filter. how to I write and ap…
-
Image in Email Body of BI bursting query along with static AttachmentSummary Image in Email Body of BI bursting query along with static AttachmentContent Hello All, I have a report that needs to be bursted I have a static attachment in it…
-
Need table names/SQL for Check-ins meeting and Questionnaire attached to the Check-in TemplateSummary Need table names/SQL for Check-ins meeting and Questionnaire attached to the Check-in TemplateContent Hi, I need to build i query to capture the response of ques…
-
Max Effective Date Record on a Combined Subject Area Report Or Null ValueSummary: We are trying to bring back one row for Performance Task Completion Date, either the Null row or the latest completion date. Using "- Performance Task Status De…
-
learning compliance reportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Since redwood update in hcm the URL for reports are now not able to be shared as these get 404 errorSummary: Redwood has been updated into our production enviroment. The URL for the BIP reports, now no longer is able to be copied, shared as a link, and opened. Content …
-
Build a BI Publisher Report that tracks incremental changes in Core HRSummary Build a BI Publisher Report that tracks incremental changes in Core HRContent Hi Experts, I have a requirement for a BI Report wherein I need to pull a lot of ch… -
How to do grouping for data visualization in OACwe had a requirement to develop a workbook on Business unit wise Average age of employees. For that i have made a connection with Oracle Analytics and then i have create…
-
User Account Details (Email Address) in Security ConsoleSummary Need table names to be able to pull email address kept in Security ConsoleContent Hi All, I am struggling to find and link tables to pull User Account Email Addr…
-
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…
-
In which table has the information Manage Reporting EstablishmentsSummary: Hi Team, Need a table or sql query to get the information Manage Reporting Establishments as in below marked screenshot Content (please ensure you mask any conf…
-
insert line break inside a conditional statement in rtf letter templateSummary: insert line break inside a conditional statement in rtf letter template bi publisher Content (required): creating an RTF letter template and need to insert a li…