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
-
Extract Development Goal Learning and join with employee goal report (SQL Query)Summary: 21D new learning section - Extract Development Goal Learning and join with employee dev goal report Content (required): Dear All, Would like to know, how to ext… -
Query for getting learning details of Development Plan GoalSummary: Please help with getting the query of learning details in the Development Plan Goal under Career Development Area.
-
Talent Profile report not printing few valuesHi, I am looking to extract license and certifications, career preferences values in print profile Navigation: My career->My profile->skills and qualifications -> action…
-
OTBI Report to get Activity Status value "Required"Summary: can anyone have OTBI Report to status of Activity in course - Learning Module Navigation for Requirement My Team>Learning>>Worker name>Course title>>Enrolment T…
-
How to get distinct record for Dimension field in OTBI just like SQL?Summary: Any DISTINCT function that can be used in OTBI to get distinct Dimension record just like SQL ? Content (please ensure you mask any confidential information): A…
-
How to get Salary Transaction entered by Name from Salary Transaction entered by for a Person NumberHello Everyone, I am using "Compensation - Salary Details Real Time" subject are to build a report. This subject area already holding a field "Salary Transaction entered…
-
previos salary after correctionSummary: Content (please ensure you mask any confidential information): Hi all, I need to fetch current salary and the previous one, when i do it on the regular way - it…
-
Query to extract ElementEntry SourceSystemID and ElementEntryValue SourceSystemIDSummary: Content (required): Hello experts, do you have a query to extract ElementEntry SourceSystemID and ElementEntryValue SourceSystemID? We need to recover both keys… -
How to link Dependent Care Physician to DependentSummary How to link a Dependent with their Dependent Care PhysicianContent I am trying to pull a report of employee and dependent care physician after Open Enrollment. I… -
Direct join between Benefit and Element tables issueSummary: Hi, I am building a report where I need to show the CONTRIBUTION_PERCENTAGE (BEN_PRTT_RT_VAL.ANN_RT_VAL) from Benefit and CONTRIBUTION_AMOUNT (pay_element_entry…
-
Report to show Deleted Payroll ElementsSummary I need to generate an Audit report showing when an element was deleted and by whoContent I tried running the Deleted Data Report but I didn't get any information…
-
When adding field to my report, the Matrix Manager values are being eliminatedSummary: I have a report that includes both Worker Assignment Real time and Compensation Salary Detail subject areas. I have been able to add all desired fields successf…
-
Not getting the proper charts on the user defined logical sqlSummary: I have written a sql statement by performing a left join between two subject areas. Have got the desired output. However am note getting the expected outcome wi… -
Absence Date End problem with clock change in OTBISummary: During British Summer Time (BST) (GMT+1) the Date End of an absence has a time stamp of 1am the next day. So 01/05/2021 00:59 not 30/04/2021 23:59. Content (req…
-
Watermark not coming in HTML ( Email body) outputContent We got a requirement to send an email (not an attachment in email) to user on his/her anniversary. We are trying to use BIP bursting concept to send an email. In… -
Is there a table or view that contains goal names before approval?Summary: Is there a table or view that contains goal names before approval? It seems that HRG_GOALS contains the information such as GOAL_NAME, SUCCESS_CRITERIA_TEXT, LO…
-
Sickness - Avg day lost and % time lostContent Hi I have created a report to work out average days lost and % time lost , but in order to do this I need the total number of working hours available (which I al…
-
Quick question: Is there a way to confirm when a report was last opened ?Summary: Hi friends. I am doing a reports and analytics audit, of sorts, and am looking to delete reports that are no longer utilized. How can I confirm when a report/an… -
Problem with the sender for a bursting reportHi folks! I'm developing a simple notification with BI Publisher report using the bursting, but if I use for sender any address with domain @customer.com the system indi…
-
Check list real time SA for onboarding questionnaire but output vertical view issue in reportSummary: Hi Team, How can I convert Vertical into horizontal of question text and response answer . we need candidate onboarding questionnaire feedback suervy but in que… -
OTBI Dashboard Usage Via TileHi all, We've built an OTBI dashboard and we'd like to share this via a tile on the front end of PeopleCloud. We've followed these instructions we found on here (pdf att…
-
How to get bursting delivery detailsSummary: How to get bursting delivery details Content (please ensure you mask any confidential information): Hi All, We need to develop a BI report to show the bursting …
-
US compliance reportingWe plan to retire our US & CA Operational Data Store (ODS). Currently, it feeds HR & payroll data to multiple downstream applications. Equally as important, it helps us …
-
In Talent if you have a probation goal that crosses two review periods / goal plans how do you managSummary In Talent if you have a probation goal that crosses two review periods/ goal plans how do you manage this ?Content In Talent if you have a probation goal that cr…
-
How to join/merge/combine two sql queries.Dear Experts, Thanks For Looking into this post. Could you please help out me. I have two queries as shown below, we need to join one together. Query1: UDT_LKP query. Qu…
-
Formula to prevent deletion of annual absences with Approved status in the system.I prepared a validation formula so that absences with "Approved "status cannot be updated or deleted in the system. The formula for updating is running and an error mess… -
Value set retrieving lookup meaningSummary: Content (please ensure you mask any confidential information): Hello experts, I should retrieve by value set the CMP_CWB_CUST_COL_46_LIST lookup meaning entered…
-
"Absence Calendar Direct Reports Current Month" - How does it work 'normally' (but with custom SQL)?Summary: I was editing the logical SQL of a seeded analysis and noticed that while it appears to have custom logical SQL, it still works just like a normal subject area … -
What is mean by Translation information in the data tables?Summary: What is mean by Translation information in the data tables? Content (please ensure you mask any confidential information): Hi Team, I have a query. What is mean…
-
How to extract Questionnaires and Employee Response?Summary: How to extract Questionnaires and Employee Response?