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
-
Legal Employer Hire Date and Enterprise Hire Date on Work Relationship DetailsContent Hi All, Can someone help to find underline tables and fields for "Legal Employer Hire Date and Enterprise Hire Date on Work Relationship Details Tab" If you have… -
To hide "Home", "Catalog" option while opening an OTBI Dashboard via Widget on Home Page.Content We have a requirement where we need to call an OTBI dashboard via Widget on the Home Page. The road block is to hide the Home, Catalog, Advance, etc. tab that ar… -
OTBI report to show records ONLY if there was a change in a particular fieldSummary OTBI report to show records ONLY if there was a change in a particular fieldContent Hello, I need to pull a report on a weekly basis if any employee got their Ma…User_2025-02-04-15-06-22-759 317 views 8 comments 1 point Most recent by Raghavendra Raghunath-Oracle
-
Balance Report for CanadaSummary This BIP report renders all dimensions associated to the reported balance and their values (RUN, MTD,QTD, YTD, etc.). Content Data model is based on the query pr… -
OTBI Agent Email Analysis Run As Of Date Derived by SQLSummary Trying to setup existing 'Point in Time' analysis with AsOfDate Parameter as automated agent that uses SQL to derive the last day of the prior month at runtimeCo…
-
Find courses not completed in a specializationContent Hello, I have created an OTBI report for our specializations in learn, but I cannot get the report to show which courses are still outstanding. In the screen sho…User_2025-02-06-11-18-47-896 49 views 2 comments 2 points Most recent by User_2025-02-06-11-18-47-896
-
How can I filter on column and not a measures in OTBISummary Filter in a sample column and not a measures how can i do it??????Content Hello, I want to transform a simple column in otbi into a measures to create a filter :… -
Error with Month as a Presentation Variable PromptSummary ORA-01722: invalid number at OCI call error when calling the report through prompt but works fine when hard-codedContent OTBI Report runs fine in Edit mode and s…
-
Selection Steps/Filters per table in one reportContent Hi all, I'm wondering if it's possible to put different filters or selection steps per table, but within one report. I'm making some headcount reports and want t…User_2025-01-31-00-25-12-234 23 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234
-
Global Transfer ReportingSummary Global Transfer ReportingContent Hi All, We have a requirement to fetch all global transfers within a date range or in specific year with their old and new assig…
-
Cross-Subject Area Report with 'Security - Roles and Privileges Real Time'Content We are in search of a report that would require a cross-subject area analysis using Worker Assignment Real Time and Security Roles and Privileges Real Time. I am…
-
schedule a OTBI Report when data is thereContent Hi, I want scheduler to run only when report has data. I have developed OTBI Report. Can you please tell me how I can do it in BI and OTBI. Thanks, Vijay
-
ETEXT Sort not working on two columnsSummary Sorting on two columns is not working for EtextContent I have a need to sort my ETEXT output using two columns. Per Oracle documentation, I should be able to use…
-
HDL- Can we load the Assignment DFF Values in ArabicSummary HDL- Can we load the Assignment DFF Values in ArabicContent Dear Team, For Saudi Arabia Legislation, we need to capture Contract - profession details. For that I… -
Audit reportContent Hello Team, We have embedded the BIP report as a link for employee in Fusion HCM page,each employee can access the report in one country so, is it possible to cr…User_2025-01-30-19-06-42-738 81 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle
-
Workforce Management - Workforce Trend Real Time pulling current employee typeContent Hello, I'm working on making a headcount report using the Workforce Trend Subject Area, but I've noticed the subject area is pulling the current employee type ra…User_2025-01-31-00-25-12-234 23 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle
-
Business Unit Headcount vs recognitionContent I am trying to create a pivot table to show headcount of business unit against our recognition values which employees have been awarded. So I can clearerly see a…
-
Report to identify loops in the line manager hierarchyContent Hello, Does anyone have a report that they could share that identifies a loop in the line manager hierarchy i.e. an employee lower down in the hierarchy also man… -
Employees with salary changeContent Hi, I have dashboard report with number of new hires, terminated employees, promotions, position changes as attached in screenshot. Similarly I would like to hav… -
Report with null data between tablesContent Hello experts I've managed to make an interaction between 2 tables in OTBI DataModel. Then I need to create a report. The problem is the report does not show the… -
Can we hide a Performance Tile based on a value of a column in the OTBI Analysis Criteria?Summary Can we hide a Performance Tile based on a value of a column in the OTBI Analysis Criteria?Content Hi, We have a requirement were we need to hide a Performance Ti… -
Query Absence Pending TransactionsContent Hello experts. I'm trying without success to create a report that gives me the history of transactions. Category - Status - to whom - initiated at - Approver (As…
-
Reporting on reversed terminationsContent Hi all, I have searched on this topic but have not found a working example of this report or confirmation that it can be done. Can anyone advise whether it is po…
-
When I Run EEO-1 Component 2 Electronic Report, the Text results come back blankSummary When I Run EEO-1 Component 2 Electronic Report, the Text results come back blankContent Hi, When I run the When I Run EEO-1 Component 2 Electronic Report, there …
-
How to modify existing OTBI analysis built using Logical SQL?Summary I am new to Logical SQL OTBI reports and want to know how to make modifications to an analysis once I created it using logiical? I have to add a new column and p…
-
Change the language of the text in RTF template.Content Hi Experts, I am looking for a function for RTF template using which I can change the Language of the text. for eg: Orignal Data- English: One Thousand Two Hundr…
-
Who hasnt submitted a TimecardContent Hi all We have been live with HCM for a year and i have been tasked with providing a report that shows who has not submitted a time card. The seeded reports dont… -
Fusion HCM OTBI/BI report usage analytics?Summary How to get OTBI/BI report usage analytics?Content Is it possible to get OTBI or BI report usage analytics? VIZ., input - Report Name Output - list of users who r…
-
Unable to access reports and analytics after userid changes in OTBISummary User no longer is able to access reports and analytics. Receives error 'Unable to reconnect (after 3 tries) to BI Presentation Server using the connection Id =BI…
-
Unable to Combine 2 Subject Areas throws error.Summary I am trying to combine Compensation salary history and payroll element history Subject area it throws me error. If someone can help out or would appreciate if th…