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
-
How do I retain drill-down reporting with a null value in a data setSummary: Hello. I have a dashboard which has several pies on it that draw data from talent review categories. I need to enable drill-down person reports from the pies fo…User_2025-02-05-22-55-58-511 31 views 2 comments 0 points Most recent by User_2025-02-05-22-55-58-511 -
(QUERY) Fix null value isn't show in csv outputSummary: When export as xls or view online it show header with all of null value, but header is disappear in csv output Content (required): Hi, I wanted to fix the data … -
Turnover Report Filtering 0-2 year TenureSummary: We have a requirement for a report that would have a rolling 3 year calendar that shows the headcount/termination counts for employees that are 0-2 years during… -
OTBI report for ChecklistSummary: OTBI report for Checklist Content (required): Tring to create OTBI report for Checklist for a questionnaire, however, the questions are not reflected nor the re…
-
Missing columnsSummary: Not appearing columns heading when records are exported. Content (required): We have created query to export data which has been generated in xml. However, when…
-
Checklist not assignedSummary Checklist not assignedContent We have multiple onboarding checklist by country etc and want to report where one of these checklist has not been assigned to a new…
-
Analysis from Compensation - Salary details real time returns double the annual salarySummary: While creating analysis from Compensation - Salary details real time, the report returns double the amount of the annual salary for few employees. Have anyone e…
-
Need inputs to get the DFF fields in Worker folder in OTBI analysisSummary: Need inputs to get the DFF fields in Worker folder in OTBI analysis Content (required): We have few DFF fields in Employement and Person UI/Screen. As of now we…
-
Need to print sum of Position FTEs by Business Units in OTBISummary:We have a requirement in OTBI to fetch business unit name and Position FTEs. But we have to print the sum of FTEs grouping it by each business unit. We are using…
-
Attendance Summary ReportSummary: Does anyone have a report where you can see a summary of absences by plan type for an employee? Would like to audit and keep track of usage against balances. Al… -
Custom Balance ReportHi We have a requirement to display custom balance details in the report along with some other employee/payroll details , so I would like know whether to go with BIP or …
-
Database mapping documentsSummary: We've recently moved to 21D but the latest database mapping document we have is REL13_21_C_HCM_OTBI_Database_Mapping_with_ViewObjects can anyone point me in the…
-
How to search for text string across all BI componentsSummary: Content (required): I need to find all BI data models and report templates referring to specific attributes. Has anyone tried to do this, or have an idea how we…
-
Sum Parts of a ColumnSummary: We have a table with the %age of absence per absence name however on the pie chart, I need to sum the ones that are at the lower end of the spectrum. Content (r… -
Custom Recruiting Dashboard To Provide Global and Restricted View of InformationSummary: My customer have requested a Recruiting dashboard with a summary page with target stats on the recruiting process (time taken to move from one phase to another,…
-
Create a report to show both accrual values for an employee and absence value for an employeeSummary: I want to create a report, that shows how much holiday an employee has left on their balance, and in the same report show how many days of absence an employee h…
-
Assignment Expense InformationSummary Sourcing/Auditing the assignment Expense informationContent Hello, We're trying to audit the Expenses Information stored on the on the Manage Employment screen w… -
What is the Subject Area for the new MCR fields?Summary: Trying to locate the Role_identifer and the Teacher Reference Number. They are both showing in the employment screen but cannot find them in the assignment subj… -
HCM Cloud question - Consolidation of BIP Report Stage from different flow submissionsSummary: HCM Cloud question - Consolidation of BIP Report Stage from different flow submissions Content (required): Hi Team, Greetings! We have a question in terms of so… -
How do I translate a PDF layout template?Summary: I have a very large PDF which is to be eSigned using journeys. I need to keep the PDF format because the RTF version of it ends up being over 100MB and unsuppor…
-
Ability for an employee to run a report from talent profile page with Badge outputSummary: Ability for an employee to run a report from talent profile page with Badge output Content (required): We are in the process of implementing learning module and… -
How to identify the tables updated by transaction in Fusion HCM?Summary: Hi Team, Is there a way we can identify the backend tables affected by a transaction done in application. For example Hiring an employee, in this case how to id…
-
Can we report on screening questions responses?Summary: Is there a possibility to report on screening questions in OR? I am not able to find them in the subject area. i.e. the yes or no responses Content (required): …
-
Creating dependent prompt in OTBI analysisSummary Creating dependent prompt in OTBI analysisContent Team, I have created a variabl 1st prompt for "Review Period" with "@{variables.ReviewPeriod}". Now i am trying…
-
how to Limit the prompt values based on the result of the analysis?Content I'm creating a validation report in OTBI which contains Employment data of contractors. The requirement is to be able to prompt on Business Unit. I want the list… -
OTBI Prompts-How to restrict the values of other fields based on the values selected in other fieldsSummary: Hello, is it feasible with OTBI prompts to restrict the values of other fields based on the values selected in other fields? Example: AMNS India BU = Department…
-
HCM User Interface to OTBI Subject Area MappingSummary: Hi all, I am always grateful to the invaluable assistance, insight and support of the customer connect community. I have no idea if this will be of use and this…
-
How can I locate the new MCR fields for the Responsive UI?Summary: I am looking for the new fields Role_Identifier and Teacher Reference to add to the Responsive UI, but am not sure how to find them Content (required): Are the …
-
Use of MAX function to get current Tax CodeSummary: I need to tweak a repot which shows all the tax codes under one employee with dates against them, however I just need the current tax code that is applied. Cont…
-
Termination Date less than and greater than 3 months of current dateSummary: I'm trying to work out how to write a formula for a Leavers report that will bring back everyone who has left the department in the last 3 months and projected …