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
-
Analysis Total is Rounding to ThousandContent Hi Champions, I have created Headcount Analysis in my Custom Dashbaord ( Like Count(worker.person_number) to get exact number of employees working in a particula… -
Compound sort in OTBIContent Hi All, Is it possible to do Sort on 2 columns in OTBI? Ex. First Sort on BU and second sort on LE in same report. Thanks, VijayUser_2025-02-07-19-03-14-525 40 views 2 comments 1 point Most recent by User_2025-02-07-19-03-14-525
-
Getting Error When Click "Drill to Transaction Detail"Content Hi Experts, When I'm clicking on link "Drill to Transaction Detail" from HeadCount Analysis ( I copied it in my custom Dashbaord) I'm getting following error. Er…User_2025-02-07-19-03-14-525 34 views 3 comments 0 points Most recent by User_2025-02-07-19-03-14-525
-
Learning -> How to achieve Fusion Security into Custom BIP Reports through SQL?Summary Apply fusion security into custom-sql reportsContent Hi, Can anyone please help? I am in the process of developing a few custom reports using sql/bip option and … -
Is it possible to write a validation query against excel/csv data source in data model?Content I have created 2 data sets using excel and csv as data source. I want to write basic query to validate data from these files. Is it possible to validate excel da… -
Removing Nulls from Limited Dashboard PromptsSummary Limiting dashboard prompt by other values while removing the null optionContent Hello, I've created a dashboard prompt where we're trying to limit the values of … -
Duplicate Manager Data Integrity ReportSummary Duplicate Manager Data Integrity Report not workingContent Hi All, We have a data integrity report that we would like some help troubleshooting. This report is i…User_2025-02-07-16-42-37-187 32 views 4 comments 0 points Most recent by User_2025-02-07-16-42-37-187
-
How to setup private key authentication with sFTPContent Hi all, I'm trying to setup a sFTP connection to a vendor using private key authentication. I'm being told that Oracle needs to have a password setup, but the ve…
-
Printing the Entire Dashboard PageSummary Print the entire dashboard page on the My Team DashboardContent We have pushed out some dashboard reports for our end users. We have placed these reports on the … -
BI Publisher for WORD creates last row of a table as merged cellsSummary BI Publisher for WORD creates last row of a table as merged cellsContent With BI publisher for WORD I created a template with a table to be able to run the repor… -
Dashboard runs a report that opens a new window when it shouldn'tSummary As the title says, we have a Dashboard that runs a BIP Report and the run process pops the information into a new window. We aren't looking for this functionalit… -
Report AuditSummary Report showing when a report was last ran and by whoContent Hi All, I thought I saw this on a webinar, but I don't really recall. Is there a report in OTBI that …
-
Combining Fields into one Column / Field in OTBIContent Hi, I'm looking to see if its possible to combine multiple fields / columns into one field / column? I currently have a report that brings back 5 fields / column…
-
Multiple IF ELSE Conditions in BIP Excel TemplateSummary Multiple IF ELSE Conditions in BIP Excel TemplateContent Hi Experts, How to use multiple IF else condition BIP Excel Template. Example: IF Legislation_Code IN ('…
-
Backend table name for error transactionsSummary Backend table name for error transactions generated from transaction ConsoleContent Hello Everyone, I'm trying to create a report to show data from the Transacti…
-
How to convert a datetime columns from a timezone to another oneContent Hi, we are trying to extract the start and end date of a learning activity in the correct timezone. as you can see in the screenshot we have created an activity … -
Locate First Names that begin with Blank characterSummary Locate First Names that begin with Blank characterContent Can anyone please advise on the proper Function or CASE statement to use in an OTBI Analysis to locate … -
Vacant Position report with Last incumbentSummary Need a vacant position report with last incumbent detailsContent Hi Team I need a vacant position report with last incumbent details in OTBI, can you please let …
-
Having problem with Manager Field in OTBISummary Having improper value of Managers in OTBIContent In our system we have two different manager type i.e. functional manager and one is matrix manager. Functional M… -
Transaction Administration Real Time Subject Area - ReportContent Hi all, I am using this subject area to create report to pull the data about the pending transactions, however, we don't see that it has a dimension to show who … -
Annual Employee Salary DetailsSummary Annual Employees Salary details ReportContent Is there any OTBI & Standard seeded report available for employee annual salary details. -
Is there a diagnostic report or other tool that will show Reports & Analyses that haven't been run iSummary Is there a diagnostic report or other tool that will show Reports & Analyses that haven't been run in 6 monthsContent Good afternoon. We are auditing our HCM BIP…
-
How to add employee picture on DashboardContent I can't seem to add the employee picture/image on Dashboard. Can someone assist.
-
Adjust Auto numbering in RTF Template OutputContent We have multiple paragraphs in a report built using RTF template which are numbered and some of them have conditions so if the condition is met the paragraph is …
-
Employees with Grade ChangesSummary A report that shows grade changes in last 12 monthsContent Hi How can I set up a report to identify a person who has changed its Grade on the last 12 months? Doe…User_2025-02-05-22-44-35-842 69 views 2 comments 0 points Most recent by User_2025-03-07-20-55-01-859
-
Identify retro changes on absence entriesSummary Identify retro changes on absence entriesContent How do we identify retro changes on absence entries? For example. employee A applies for leave from 10/1/2020 to… -
Tax Year to Date / Statement of EarningsSummary How can I report on Tax YtD values from SoEContent We have a requirement to build a report in PeopleCloud which is currently an SQR in PeopleSoft. The existing r…
-
Date Prompts with Italian InterfaceSummary Invalid Date format when using a date prompt in ItalianContent Hello! I've recently encountered a new problem and I'm hopeful that someone out there has figured …
-
Pivot Table helpSummary Trying to split two values in pivot tableContent Hi, I am trying to get my pivot table to show the sum of all National & International contracts by Business Unit…
-
Editing Delivered DashboardSummary Trying to edit the delivered Line Manger Dashboard but received error on saveContent Hi, I am trying to edit the delivered Line Manager Dashboard, I want to upda…