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
-
People Group Flexfield segments not available in OTBISummary Unable to report on People group flexfield segments in OTBIContent Unable to report on individual People group flexfield segments in OTBI. People group is a key … -
PersonProfileItemPVO Issue post 23D, what's changed to impact this?Summary: We have a nightly extraction that retrieves delta data. Since 23D was applied the extraction is retrieving all data, causing timeouts due to the volume it is tr… -
I am looking for Oracle fusion HCM exit interview questionare tables to develop a BI reportSummary: with the columns mentions below Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code … -
Remove column from Excel BI Publisher reportI have a report containing many columns that I prepared using Excel Publisher and I want to remove a column, but when I upload it back to the system by clicking delete t… -
OTBI report how to display parameter list of values only with the report result in the list ?Hello , In OTBI report, we would like to have a list of values on parameter “location “ based on the values of the report result . Only the values that are extracted fro… -
Displaying different sections in mobile app and web app on dashboardHello, in the dashboard I have prepared, I want some sections to appear only in the web application. I want some of them to appear only in the mobile application. Is thi…
-
BI Report Logo not displaying when exporting report to MS WordSummary: BI Report Logo not displaying when exporting report to MS Word. Content (please ensure you mask any confidential information): I have created a BI report. I use… -
Employment Terms Assignment Number in OTBI Report AnalysisHow do you retrieve Employment Terms Assignment number format? into an OTBI Report Analysis in the format needed for use in spreadsheet loader template?
-
I am having trouble adding Job Code, Job Title, and Department to this Address Change ReportSummary: Hello, I need to add Job Code, Job Title, Department and HR Status to this report and I am having trouble doing so. My current code is attached. Any suggestions…
-
Static URL is not working on page entry under sandbox for navigation to BI custom folderOn Springboard we have created NIB Custom Report tab under we have created icon to navigate to BI catalog to custom folder. When we click on Global HR folder for the fir…
-
OTBI Analyses erroring due to "Termination" columns - View Display ErrorSummary: Since the 24A upgrade was installed, we have (at least) two analyses that are now erroring out. They worked perfectly before the upgrade, but now they throw a V… -
Why do i lose virtually all records in a query dataset when I apply a filter using the analysis toolSummary: i am trying to pull a report listing all those who are on the Basic life insurance Benefits. When I apply a filter based on Participant Enrollment Status to omi…
-
Can you create a personalized prompt to combine multiple selections into 1 prompt selection?Summary: Wondering if it's possible to create a custom prompt in an OTBI report to create a 'group' to select for a variety of different job name codes? Content (please …
-
How to use TOPN in a filter in a column in OTBISummary: I would like to use a TOPN filter in a column formula in OTBI to provide the latest date. There are multiple lines per employee and just want the latest seniori…
-
Can I make a leaver report as a graph showing reasons of termination?Summary: I have made a leaver graph in excel showing leaver reasons by month and have tried to recreate in Oracle, the leaver reasons are appearing, but not the correct … -
Just went live and delivered reports don't return data. Need help troubleshooting Absence Calendar.Summary: I am brand new to Oracle and trying to figure out why we're not seeing data in the delivered reports. The one I'm working on now is the Absence Calendar. I've r…
-
OTBI Dashboard we getting below error ?Summary: Hi Team, we have custom old dashoard but when we run the we getting below error. May I know what is the error and how can I rectify the issue! Thanks, Ajay Cont… -
CMP_SALARY_SECURED_LIST_V emptySummary: Using CMP_SALARY_SECURED_LIST_V to secure a BIP report, but the table is empty for target user. Content (please ensure you mask any confidential information): H… -
Reporting on Leave Duration Without Absence ModuleSummary: Need to report on how long employees have been on a continuous leave using assignment real time subject area. This is for an existing report and my preference i… -
We are not getting GL Cost Center information when we are trying to pull data across learning recordSummary: We have a requirement to pull cost center details in learning history report across learner assignment details. In our project cost center is linked to departme… -
How to print only tags restricting corresponding values in xslt template version 1?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…
-
Bi Publisher. How do you show parameter values used for the reportSummary: We would like to show on the BI Publisher report output the parameter values used to create the report. Can anyone help with this please. Thank you. Content (pl…
-
OTBI_Pivot_IndexSummary: Hi, If anyone knows how to use index on pivot table in OTBI, I would greatly appreciate your help. Thank you. Regards, Melek Content (please ensure you mask any… -
2 Date prompts to pull data OTBISummary: I am trying to pull a report that gives me all Current Terminations and back-dated Terminations. To do so I need the prompt to pull dates from BOTH fields. Term… -
Inactive pending worker data is being pulled in the OTBI Pending worker report.I have created a pending worker report using the logical SQL. In pending worker report Rehires are being pulled onto the pending worker report where the candidate record…
-
Manager not able to see the anything in reportHi Everyone, I have created 2 reports and deployed it for the Line managers to be able to run and self serve but when they run they cant see the results. Details of the … -
How to enable file data source in BI publisherSummary: Add new data source feature has been disabled for FILE connection. How to enable this option. Content (please ensure you mask any confidential information): Add…
-
Report of employees with element entries during the pay period NOT calculated due to ineligibility.Summary: For reconciliation purposes we need to identify the elements that were not included in the calculation process for employees since they were not eligible for th…
-
Security and OTBI AgentsSummary: Hello everyone! I've just started at a new company and have found out that internal policies mean we cannot use OTBI Agents at all (even to send reports without…
-
The custom report spacing is not aligned in PDF and Word formatSummary: A custom report is built for the contract purpose. With the PDF version, the format and the spacing are accepted by the UAT. When the report is generated in a W…