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
-
BI report based on questionnaireContent Hello, We need to create a BI report using following tables. HRQ_QSTN_ANSWERS_TL HRQ_QSTNR_PARTICIPANTS per_persons Appreciate if some one can let us know how to… -
Survey ReportSummary survey report subject areaContent I am trying to build a report on the on-boarding survey responses. I have tried building the report in Workforce Management-Che… -
Need sample query to check if employee has location as on hire dateContent Hi All, I'm in need of a sample SQL query to check if employee has location as on hire date.Please share if you have the same. Thanks, Ravichandran Version R13
-
Comparing two datesSummary Comparing two datesContent Hello, I am trying to create a new column whereby I am comparing the effective start date from 'Worker Assignment Event Real Time' sub…
-
OTBI - analysis runs perfectly until I try to add in Manager Name and Person Number from Manager (inSummary OTBI - analysis runs perfectly until I try to add in Manager Name and Person Number from Manager (in Workforce Management - Worker Assignment Real Time)Content B…
-
How to use REGEXP_REPLACE function in OTBI to manage HTML tags in attribueSummary How to use REGEXP_REPLACE function in OTBI to manage HTML tags in attribueContent Hi Team, How to use REGEXP_REPLACE function in OTBI to manage HTML tags in attr… -
How to add a BI Report to a Fusion Page without navigating through Report and Analytics navigator (RSummary The Report should be embedded into fusion application page using create page entry (Link Type: Application Page)Content I want to add a report to Fusion applicat…
-
BIP - data model joining different data sourcesSummary BIP - data model joining different data sourcesContent Is it possible to join data from two different data sources 1) from a SQL query 2) from an Oracle BI analy…
-
Help BIP Report not pulling correct infoSummary We recently went Live with OLC. One of the reports we built is a BIP report with several parameters.Content Here is the WHERE Clause with parameters. For some re…
-
BIP Layout Data Formatting issueSummary When I use the Data Formatting option for BIP layouts the dates are wrongContent When I use the Data Formatting option for BIP layouts the dates never come out c…User_2025-01-23-21-24-21-434 29 views 6 comments 0 points Most recent by User_2025-01-23-21-24-21-434
-
How to add a BI Report to a Fusion PageSummary This document explains how to add a report to an HCM pageContent How to add a BI Report to a Fusion Page This document explains how to add a Salary Range Analyti… -
How to Find an IP Address of a User who has Logged in Fusion Application ?Summary How to Find an IP Address of a User who has Logged in Fusion Application ?Content Hey, I have a requirement to restrict the data based on login IP address in BIP… -
Unable to get the Employee payroll calculation card details from Payroll - Calculation Cards Real TiContent Hi All, We are unable to get Employee payroll calculation card details ( State name, county name and city name details) from Payroll - Calculation Cards Real Tim…
-
Pivot tables and calculations for attritionSummary Issue with calculation column in pivot table - total leavers divided by total headcountContent Hello :) I'm hoping someone can help with an issue I am having. I …
-
Query to Pull List of Candidates and Their Supporting DocumentsSummary Query to Pull List of Candidates and Their Supporting DocumentsContent Hi Experts! Looking for some guidance. We need to build a query that lists all candidates … -
Where can I find Disability Declaration?Content Hello, I am currently building a report in which I need to report on Disability Declaration for all current employees e.g. Yes/No/Not Declared. I have managed to…
-
BI Parameter not picking up exact value from XMLContent We have a BIP report with three parameters Learning Item Name, Completion Date and Person Number. The report is working fine for more Learning Item Name's except…User_2025-01-31-00-25-12-234 17 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234
-
Possibility to notify an employee when dashboard updated with new dataContent Hello All, I will appreciate your support in the following issue: We have configured the following dashboard (PFA) Can you please advise if possible to notify th…
-
Dinamically printing contents in a RTF templateSummary does not work in one caseContent Hi, I am using a RTF template for a Report that should display different contents on the basis of the field named "ANNO", whose… -
Possibility to notify an employee when dashboard updated with new dataContent Hello All, I will appreciate your support in the following issue: We have configured the following dashboard (PFA). Can you please advise if possible to notify t…
-
Could not able to find the "Sequence" field in Checklist Real Time subject areaContent Hi Experts, I am trying to build a OTBI report using Checklist Real Time subject area but i cannot able to see the "Sequence" Field. Has anyone faced this issue?… -
Output file is not getting multiple records using EText template.Summary Output file is not getting multiple records using EText template.Content Hi Experts, Output file is not getting multiple records using EText template. I am attac…
-
how to restrict infolet user wise?Summary how to restrict infolet user wise? -
Set up an Agent to pull last 7 days of hiresSummary Set up an Agent to pull last 7 days of hiresContent Hello, We have an employee roster report that is widely used by our HR team for various uses. It does not hav…User_2025-01-23-21-37-42-476 46 views 3 comments 0 points Most recent by User_2025-01-31-00-25-12-234
-
Performance Analysis Report Issue with Using MINUS clause to extract wanted data.Summary Need help Understanding why no data is returned from Analysis when using MINUS between 2 Subject AreasContent Hello, I have attached a word document with screen …User_2025-02-04-11-20-13-378 21 views 6 comments 0 points Most recent by User_2025-02-04-11-20-13-378
-
Profile Option for OTBI user settingsSummary Profile Option for OTBI user settingsContent Is there a profile option to set the default locale in OTBI? Global User settings get reset each day. It would be di…
-
OTBI Performance GuidelinesContent The attached document pulls together our experience helping customers to improve the performance of OTBI reports into one succinct document. If you are looking t… -
Last Names in OTBI?Summary Location of paternal and maternal last names in OTBIContent Hi everyone! I have been trying to make a report in OTBI and I need the full name of an employee in s…
-
Can I enable guest access to OTBI AnalysisSummary I have an OTBI analysis and I would like to access that analysis using a guest login in OTBIVersion 20C
-
BIP Error MessageContent Hi all - have you seen this error message before? System encountered unexpected error during data processing. Please contact system administrator to enable debug…