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 statement to get the performance document current taskSummary sql statement to get the performance document current taskContent Can anyone help me on how to fetch the current task for the employee performance document , the… -
Query to get Questionnaire answers given by user and right oneContent Hello experts. I need a report for learning assessments. This report is to get the learning item - task assesmment - questionnaire - answer - right answer (based… -
what is difference between CMP_ASG_SALARY_V and cmp_salary ?Summary: Hi Team, what is difference between CMP_ASG_SALARY_V and cmp_salary because of still cmp_salary showing corrctly of cs.COMPA_RATIO and cs.RATE_MID_AMOUNT column… -
Exclude 'Days Suspended' in Recruiting Dashboard Time to Hire data?Summary: Exclude days suspended in Recruiting Dashboard 'time to hire' metrics Content (please ensure you mask any confidential information): Our client wishes to exclud… -
Getting error -ORA-01840: input value not long enough for date formatSummary: I am getting error in BI report due to below line of code. Error - ORA-01840: input value not long enough for date format to_date(:sdt,'yyyy-MM-dd')
-
SQL to get Cost center mapped to countrySummary: Hello Everyone, I just want to ask for SQL on how to get the cost center who are mapped to country. Thanks,
-
Contract duration is displaying no data on FAWHi, I've been trying to create a simple report to show the contract duration of the new hires in a company for a specific month. My reports should look like that where T…
-
Unable to get required currency format in Excel outputSummary: this is the tag we are using to get amount column in US format. we are able to get it in PDF output but not in excel. Content (please ensure you mask any confi…
-
Getting "The file uploaded may contain a virus or otherwise failed to be scanned for viruses."Summary: While trying to load the company logo image on an OTBI Report, i am getting the following error. "The file uploaded may contain a virus or otherwise failed to b…
-
How to suppress aggregated column in order not to repeat its values for every rowsSummary: Suppress aggregated column value Content (please ensure you mask any confidential information): Is it possible to suppress the value of aggregated column in ord…
-
Not able to find Name Field in the subject area OTBIHello Experts, Please help, where can I find the Name Field, I am currently using Human Capital Management - Transaction Administration Real Time, should I need to use a…
-
OTBI report should drill to show the courses that are part of the specialisation.Hi, We need assistance with an OTBI analysis where clicking on a specific specialization should redirect to another analysis that displays the courses included in that s…
-
Join in OTBI is not removing data where joining two subject areas.Summary: When joining two subject area's the data is not removing information in one of the subject areas. Content (please ensure you mask any confidential information):…
-
Sql to find t4 information of employee (like tax year and boxes information etc)Summary: Dear exports, Any one have sql/otbi report to pull the information exist in canada t4 slip? Please suggest Content (please ensure you mask any confidential info…
-
Need to show people who are Missing FeedbackSummary: Hi Oracle Experts! I’m looking for some help on a custom report. As part of a routine audit, our HRBPs check to make sure that managers have left feedback for t…
-
How to Write REGEXP_LIKE FUNCTION in ORACLE BI EE DatabaseSummary: How to Write REGEXP_LIKE FUNCTION in ORACLE BI EE Database. The Below part is having an issue. Please help me how to write regular expression in Oracle BI EE ON… -
find value in one loop and traverse back to another loop in xml etext templateSummary: I have an XML of ACH file where in there is a value in this path PAYMENT_RECORD/PAYMENT_DETAILS/PAYER_METHOD/EFT_USER_REF. When Make EFT Process is ran the outp…
-
How to enable report job historySummary: I need to enable the "Report Job History" option in the Home tab of OTBI, without leveraging BIAuthor or BIAministrator, as we have a requirement to view and no…
-
Extracting Performance Goals that have attachments using OTBISummary: I am trying to report on performance goals that have attachments, in OTBI, and have searched all of the relevant subject areas, with no success. Is anyone able …
-
Benefits Report of Terminated EmployeeSummary: Hi All, Does any one have a Benefits report of terminated employees which Shows their enrollments with Dates parameter? Thanks Content (please ensure you mask a…
-
Is there a way to find out if the users really using the current assigned role that they have?Summary: In the Fussion application, we can pull list of users who has a certain data role. But we wanted to know who among those users in the list that are actually usi…
-
Report to fetch all position Name changes but the job remains sameSummary: I want to fetch a report for the position name updates when we have same job code Content (please ensure you mask any confidential information): we need to find…
-
Line Manager and HR getting different values for years of service formulaSummary: I am working on a report that lists employees that have upcoming birthdays and upcoming anniversaries in the next month. If they have a birthday, that birthday …
-
Using Dashboard Prompts When Using OTBI AgentGood day Experts, Is there a way to use the available dashboard prompts in a dashboard when creating an OTBI Agent? For example I have a dashboard where the default peri…
-
OTBI Export Using Formatted > Excel Row LimitationGood Day, I have a set of data consisting of 90,000+ rows. Exporting via Data > Excel, all rows are retrieving when exported. But exporting using Formatted > Excel, it o…
-
Error when scheduling Logical SQL ReportContent Hi all, I've scheduled quite a few logical SQL reports, but the two newest ones I've created (Change Value Reports) receive the attached error. Any ideas on what… -
Need dashboard prompt based on field with complex formulaSummary: I have a report on a dashboard that has a field that gives me the highest level of education obtained by first ranking the degrees on the employee's records and…
-
Vacation hours disbursedSummary Vacation hours disbursedContent Hello Community, Are you aware of any report in oracle that will tell us vacation hours disbursed? We are specifically looking fo…
-
Sql Query to get payroll deduction detailsSummary: I am looking for a query which provides terminated employees last earnings and deduction details from payroll. Content (please ensure you mask any confidential …
-
Work scheduleSummary: Is the a way to export all work schedules set up and whether they are in use? Thanks Content (please ensure you mask any confidential information): Version (inc…