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
-
Sql query for employment term numberSummary Does someone have a query for the employment term number?Content Hi, I'm really need an sql query for that shows the person number, person f.name, person l.name,… -
New Hire NotificationsSummary Daily notifications of new hires created the previous dayContent Hi everyone - We are trying to create notifications of new hires created daily using analysis an…
-
QR Code Integration in BI Publisher ReportsContent Hello Experts: Could anyone please confirm if QR Code integration is done earlier for BI Publisher, or any other type of reports. If Yes, what is the process to … -
Using Concatinate for select valuesSummary Using Concatinate for select valuesContent Hello! I am trying to concatenate a couple of fields, but there are certain "Job"."PER_JOBS_DFF_CNTRBTR_TYP_LFL_" valu…User_2025-01-22-19-51-06-974 38 views 2 comments 0 points Most recent by User_2025-01-22-19-51-06-974 -
OTBI: YTD Values in Payroll Balances Subject AreaSummary OTBI: YTD Values in Payroll Balances Subject AreaContent Hi, Is there a way we can display the YTD Balance values from the "Payroll Balances Real Time" Subject A…
-
R13 Workforce Performance - Performance Rating Real Time subject Area issueContent Hi I am getting below error in R13 while running the OTBI report, but not in R12. ERROR : Runtime error for service -- ADFService11G - JBO-25002: Definition HcmT…
-
Default Presentation Variable Prompt to AllContent Hello Customer Connect community, Is there a way to default a presentation variable to default to all? I am using the following syntax in my logical SQL: AND Cou…User_2025-01-22-19-43-38-766 110 views 5 comments 0 points Most recent by User_2025-01-22-19-43-38-766
-
Duplicate Rows in a ReportContent Hi All, Hoping someone can assist me - I'm getting duplicate rows in a report and it seems to be tied to FLSA status as I have one row with a value and one row w…
-
User_2025-01-30-21-33-03-247 260 views 4 comments 0 points Most recent by User_2025-01-30-20-59-13-989
-
Bar Chart SortingSummary Is there a way to sort the horizontal color axis by the measure?Content Is there a trick to getting a chart to sort when adding color to the horizontal axis? I h…User_2025-01-28-08-47-04-905 26 views 4 comments 1 point Most recent by Raghavendra Raghunath-Oracle
-
How to receive assignmentId from Compensation Page & pull out Legal Employer based on itSummary How to receive assignmentId from Compensation Page & pull out Legal Employer based on itContent Hi guys, we are facing an issue related to compensation page. In …
-
Filtering Based on Phone TypeSummary Need to show only results for work phone but also want to pull in those who do not have a value.Content I am trying to create a report which will pull various da…
-
Scheduler Account LoginContent Hi all - we have a problem we are hoping you can assist :) Right now, we have a few developers that will schedule reports. However they are the only ones that ca… -
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…
-
Scheduled processes reportSummary need to create a report to show all our scheduled processesContent hi, we have a lot of Scheduled processes who run every day. need to create a report showing al…
-
Documentation / Details about "Workforce Management - Absence Calendar Real Time" Subject AreaSummary Documentation / Details about "Workforce Management - Absence Calendar Real Time" Subject AreaContent Hi Experts, Wondering if there is some documentation around… -
TERMINATION - ACTION REASONContent Hi, I am writing a report in BI, to bring the details of the terminated employees. One of the columns is Action reason, such as Dismissal, Layoff, Quit Wondering…
-
BIP Publisher BurstingSummary BIP Publisher BurstingContent Hi, Is it possible to give multiple email addresses in the TO parameter of bursting definition sql query in Oracle Fusion HCM BI pu… -
Handling data field containing a comma while generating CSV files using etext templates in BI PublisSummary Handling data field containing a comma while generating CSV files using etext templates in BI PublisherContent Hi, I have an etext template to create a .csv (com… -
Legal Entity and Payroll Current and Previous ReportSummary Looking for a report with Current and Previous Legal Entity and Payroll CodeContent Hello, We had Oracle build us a custom report that shows Current and Previous…
-
Exceeded Maximum Results Error when adding a promptSummary Any way around this?Content I'm looking to build out a trend report, using the WF Trend Subject area, which will allow the user to select a manager via a prompt …
-
FTP using PPKContent Hi all - need your help on this one! I am not overly familiar with using FTP, but can muddle my way through when using a regular set-up (host, login, password). …
-
How to track Single-Choice Question Answers ?Content I need to get the answers given to the set of single choice questions. I have created an analysis using Workforce Performance - Performance Rating Real Time > Qu…User_2025-01-28-21-18-43-496 18 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle
-
Do we need to give Username & Password in Bursting Query for ftp delivery Channel?Summary Do we need to give Username & Password in Bursting Query for ftp delivery Channel?Content Hello Experts, I have a requirement to deliver bursting file to ftp des… -
Job Profile Succession Plan Report Showing Job Profiles in Multiple LanguagesContent Subject Area: "Workforce Succession Management - Plan Candidates Real Time" When trying to use the subject area above to report on job profile succession plans a… -
Data visibility issue with Compensation Subject Areas (Compensation - Salary Details Real Time)Summary Data visibility issue with Compensation Subject Areas (Compensation - Salary Details Real Time)Content Hi, We're facing the data visibility issue with Compensati…
-
Setting Permissions on OBIEE analysisSummary Customize access permissions on BI analysis (not BIP)Content When we are setting up permissions on BI analysis, it seems as though even though a user was set wit… -
BI Publisher: Is contractor information stored in PER_CONTRACTS_F table.?Summary BI Publisher: Is contractor information stored in PER_CONTRACTS_F table.?Content Hi, I would like to know when is a entry made into table:PER_CONTRACTS_F. I beli…
-
Converting BI Analysis to BIP (Easily)Summary Need to convert existing analysis to BIPContent Is there an easy way, if any, to do this?
-
Need to use 2 stand-alone data groups in an extract without any connect clauseSummary Need to use 2 stand-alone data groups in an extract without any connect clause