Get Started with Redwood for Oracle Cloud HCM Begin Now
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
-
TABLE/SQL FOR TIMECARD CUSTOM ATTRIBUTESSummary: There are 2 custom attributes created in Time and Labor under Time Layout Sets and it shows in the UI. Time Layout Sets. When entering timecard What specific Or… -
Incomplete Time Card ReportSummary: The Business is running into issues with employees submitting time off through the Absence module that automatically transfers to the Time Card, but the employe… -
line manager DashboardSummary: In Line manager dashboard, we are getting head count from "Workforce Management - Worker Assignment Real Time" subject area. I am able to see all records in thi…
-
Workforce Management Subject Areas (Historical Role & Manager Data)Morning Everyone, I'm investigating a quirk with an OTBI report that we've recently developed for viewing various articles of information for new starts within our organ…
-
How do I join WLF_SKILL_CENTER_ITEM_DN to WLF_ASSIGNMENT_RECORDS_F?Summary: In HCM work life, I need to join a skill name to an assignment. WLF_SKILL_CENTER_ITEM_DN has SKILL_CENTER_ITEM_DN_ID and PROFILE_ID as possible keys to join to …
-
Query to get the scheduled work hours of employee from shifts the employee has assignedContent I have a requirement to report the weekly work hours the employee is scheduled for. Employee will be assigned work schedule and work schedule will be liked with … -
SQL Behind the Package FUSION.PAY_BALANCE_PKG.GET_VALUE_DBIWe are trying to debug one the issue in BIP SQL where they have used the FUSION.PAY_BALANCE_PKG.GET_VALUE_DBI to bring the data from this column. But wea re not able to …
-
Get the "Related Materials" attachment in Learning reportSummary: Content (required): hi there, I have a learning report but want to capture also a link to the related materials on the Offering level. see image. is that even p… -
Is there a way to export HCM organizational charts?Summary: What are the options to take HCM organizational charts and export them in some type of format that could be used in a PowerPoint? Content (please ensure you mas…
-
Hide catalog and home options to usersSummary: Hide catalog and home options to users Content (please ensure you mask any confidential information): Hi Team, I have a requirment, in my organization under me …
-
Can we use Line Manager Dashboard to build HR Dashboard by removing securityWe want to build HR Dashboard, however most of the metrics are already available in Line Manager Dashboard. So can we re-use Line Manager Dashboard by removing security …
-
Multiple External Identifiers in OTBI would like in separate columns and to include null valuesContent Our organization has multiple External Person Identifier Types that we need to report off of (Taleo ID and Oracle Transportation Management Number). As opposed t…
-
Report to get the Listing the existing reports with the subfoldersSummary: Report to get the list of all existing seeded and custom BIP reports Content (please ensure you mask any confidential information): Hi All, Greetings! Is there … -
How to remove null values in OTBI? If I change choice list to SQL, the Limit Values disappears.Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
document recordSummary: If I upload documents to document records, I want a report to show me the details of the document as entered into Oracle, the ability to filter by document type…
-
Person security profile to restrict hourly employees in BIP reportsSummary: We have created a data role and person security profile created to display only Hourly employees In person security profile provided -- secure by AOR -- Respons…
-
Language translation in oracle standard notificationsHi, I want to edit the rtf template according to the language of the standard notifications that I want to edit in Oracle. For example, where can I edit the Turkish RTF … -
Pension Automatic Enrolment calculation card report in OTBISummary: Content (required): Hi, hoping someone can steer me in the right direction here. I'm looking to report on the data contained in employees' PAE calculation card …
-
Fetching employee using BIP query if employee have Job changes and TerminationSummary: Fetch the details of employee who have job changes and termination details of employee Content (required): Hi, I am working on BIP query to fetch the details of…
-
Remove NULL option in a PromptSummary: Content (required): hi there, I have a prompt that filters the employees in a learning dashboard report. I get also at the top the NULL option. How can I exclud…
-
OTBI external identifier not appearing when Department is selectedHello I am trying to get a specific external id type through OTBI. I've managed to do this using MAX (there are multiple types), but when I add the Department, position … -
how to loop through a value set from a fast formula to get multiple valuesHi All, I have requirement to get multiple rows from a value set from a loop and then add up all the returned values from the value set in the fast formula. how can this…
-
How to get Questionnaire Answers on a Single Row in OTBISummary: Create an analysis with Checklist questionnaire answers/responses on a single row in the analysis Content (required): I have created an analysis using the Workf… -
How to fetch the Initials of the employee using OTBI?How to fetch the Initials of the employee using OTBI?
-
SUM in Table ValuesetTeam, We need to use SUM in table valuset. If you have any idea then, please share. It would be helpful. SELECT SUM(peevf.screen_entry_value) FROM pay_element_entries_f …
-
OTBI Training Tutorials on YouTubeSummary OTBI Training Tutorials posted on YouTubeContent 26 OTBI, BIP & SmartView tutorials are now available on YouTube, Oracle Learning Library and Oracle HCM Cloud R1… -
Which Table Holds "Access level" From The Compensation Worksheet ?Summary: SQL query to fetch Access Level in report. Content (please ensure you mask any confidential information): I need to fetch "Access level" From The Compensation W…
-
How to compare output of two files in oracle fusionSummary: We've created a custom BIP report to get the salaries of each employee. This output from the publisher, we wanted to match with the document with same format wh…
-
Pulling Goal Success Criteria without the HTML TagsSummary Is there a way to pull goal information without the html tags?Content Hello, I am looking to report on the Goal Information from HCM Fusion Release 11. When we p… -
For Goal notes report as well the description is in HTML format in the report.Hi Team, We are trying to pull a goal report along with long description and it is pulling the text in HTML format. Is there a possibility to get normal text for descrip…