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 to schedule BI report only when it has dataContent Hi All, Can some please help me if its possible to schedule BI Report when there is data. I know we do it in OTBI in condition tab. Thanks, Vijay -
OTBI ReportsSummary CURRENT DATE formulaContent We are in the process of converting to Oracle so I am new to writing OTBI reports. I have tried the following formulas and get errors… -
Simple Math on a Pivot TableSummary I need some help with some math that I might be overcomplicating.Content I have created a pivot table that groups employees into temporary, seasonal and regular … -
Reporting Error with Worker.AssignmentNumber fieldSummary OTBI error being generated when user attempts to access report - specifically states user does not have access to Worker.AssignmentNumber fieldContent Hi all, We…
-
Formula to add 30 days to a date fieldContent Is there a formula that can take a date field and add 30 days to it? Version 21A -
How to stop dashboard auto runSummary How to stop dashboard auto runContent Hi Team, Greetings of the day!!. Dashboard is getting auto run even the parameter was not passed in oracle fusion. Is there… -
Role security not being enforced on dashboard promptContent I am using "Workforce Profiles - Person Profile Real Time" to create a list of employee certifications by manger (direct and indirect). The "Matrix Manager"."Top…User_2025-01-23-21-24-21-434 23 views 4 comments 0 points Most recent by User_2025-01-23-21-24-21-434
-
How to identify position of Nth occurance of a character or string similar to INSTR functionalitySummary Objective is to display one of the segment values from People Group Flexfied Structure in OTBI ReportContent I have requirement to show a segment value from Peop…
-
Unwanted grouping of data in OTBI AnalysisSummary OTBI analysis giving multiple data against employee instead of one rowContent I have created an analysis with a custom column to interpret employee's adoption of…User_2025-02-11-13-38-56-242 39 views 5 comments 0 points Most recent by User_2025-02-11-13-38-56-242
-
questionnaire joins to the candidate in BIPSummary how to join the questionnaire and answers to a specific candidate in BIPContent Hi, I am developing a report in BIP which displays the questions from the questio…
-
Finding the actual performance document managerSummary Would like to find the document manager of the performance evaluationContent Dear All, We have created the OTBI analysis through Performance Document Status Real…Janaki Ramana Reddy Vayyala 57 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle -
Detail vs Summary flagContent I have a report that prompts the user for a beginning and ending check date. Is there a way to add a flag to an OTBI parameter that when selected, the report wil… -
Drill down report not showing up for a specific userSummary Drill down report not showing up for a specific userContent For viewing the Drill down report does the user need any special security? The user can able to see t… -
Is it possible to have conditional Display of report parameters on the basis of value in other paramSummary Is it possible to have conditional Display of report parameters on the basis of value in other parameter ?Content Hi Experts, Is it possible to have conditional … -
BI Pub folder/object security reportContent Hello, Are the catalog folder/object level permissions stored in a DB table? Can we report on what users/roles have been applied to folders/items to secure them?…
-
OTBI Dashboard prompt defaultContent I have an OTBI dashboard prompt that I want to default to the current logged in user. However, the session (server) DISPLAYNAME value is in a different format an…User_2025-01-23-21-24-21-434 71 views 5 comments 2 points Most recent by Raghavendra Raghunath-Oracle
-
Excel based Template Report- Does not provide PDF export optionSummary Excel based Template Report- Does not provide PDF export optionContent One of our BI Report, The Report was created using an Excel based template (Means: Created…
-
What is Talent Rating Subject areaContent Hi Team, We have the talent rating where we have, Performance rating, Risk of loss etc. Is there any possibility to get the from OTBI? I know, We can get through…
-
Report for delegation using BPM worklist vacation rule screenContent A report is required to show BPM Workflow information where a task has been assigned due to a vacation rule taking effect. We are trying to get the following inf…
-
Query to return employees related to a particular Representative type for a given AoR and scope of rSummary Query to return employees related to a particular Representative type for a given AoR and scope of responsibilityContent Hi All, Please share Query to return emp… -
HCM Cloud - OSHA ReportsSummary Looking for documentation (HCM Cloud) on 300, 300a and 301Content I cannot find any configuration documentation related to these reports. Can someone please dire…
-
BI publisher SQL for finding users who are active in the security console but terminated in the applContent Hi experts, We have found an issue where sometimes when an employee is terminated in HCM they are still showing as an active user in the security console. To res… -
Column Formatting for hashtag resultsContent Hi all, I'm hoping the request I'm asking is relatively simple to do. We have an OTBI report that when run within OTBI, displays date values as '00/00/0' but whe…
-
RTF TemplateContent Scenario: I have created two data sets in my data model: G1 and G2 G2(Parent) G1(Child) Parent will always have one row and its corresponding child can have a ro…
-
Using EL Expressions to Filter an OTBI Report which is embedded in the applicationContent Hi, Is it possible to filter an embedded report based on contextual variables? For example the following EL expression #{bindings.DisplayName.inputValue} returns…
-
OTBI Elements Report is not Pulling in All ElementsContent I've built a simple OTBI report for Retirement Deductions and Matching Contributions. My company has 401K, 403B, and 457 Retirement Plans. So, I've filtered for …
-
Pay Code / Element Mapping to General LedgerContent Is there a Subject Matter Area which permits you to build an OTBI report of the Pay Codes and the GL Coding or Concatenate Segment associated with the specific P…
-
OTBI Agent to send one email for each recordSummary OTBI Agent is sending the entire report to the recipientsContent Hello Everyone, I need some help. We are trying to implement a mail merge that will be triggered… -
Create Custom Subject AreaContent Hello experts We need to do a dashboard with an easier layout to deal with. and better UX then Publisher native Is it possible to use a query and create the subj… -
Issue with Views in HCM cloud Learning Management (WLF_LRNR_COMPLETION_DETAILS_V) in SpecializationSummary Joins are missing in the Specialization item type part in the Views WLF_LRNR_COMPLETION_DETAILS_V and WLF_LRNR_COMPLETION_SUMMARY_VContent In the code of the vie…