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 get a data secured Job Requisition report in ORC?Summary: We need an Oracle Recruiting Job Requisition report with Job Offer status/progressing information if the Requisition started the offer process, which will publi… -
R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet in 26CSummary: Hi, Can anyone please share R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet in 26C release Thanks, Content (please ensure you …
-
Need Table name to pull Time Entry Layout Component in Time and LaborSummary: Need Table name to pull Time Entry Layout Component in Time and Labor Content (please ensure you mask any confidential information): Hi, Need Table name to pull… -
FDI : action & on click on calculated "Without Check-Ins" always redirects to "With Check-Ins" datahave a bar chart visual with: X-axis: Business Unit (from "HCM - Workforce Core" subject area) Y-axis values: Worker with Check-Ins (from "HCM - Check-Ins" subject area)…
-
Table Name for Availability CalendarTeam, Need table name which holds the availability calendar details. Person Management -> Work Schedule Assignments-> View Calendar. Please Guide.
-
How to Generate a Unique Reference Number for Each Report in Oracle Fusion HCMHello Oracle Community, We have a requirement to generate a unique reference number for each report generated in Oracle Fusion HCM, specifically for documents like lette… -
Subject Area for Terminated Employee Last SalarySummary Subject Area for Terminated Employee Last SalaryContent While using "Compensation - Salary Details Real Time" subject area we are not getting terminated employee… -
Is there any way to get all BI folder level permission details via report?Hi Team, I have a requirement to fetch details of folder level permissions set on each folder in BI catalog. I see different roles/users have different level of access o… -
How to get the details of action items which are denied?Summary: Need details of the action items which are denied along with their denied date Content (please ensure you mask any confidential information): We have a requirem…
-
Payroll Reports Performance Impact After 26C Introduction of "Quick Pay" TaskSummary: Hi everyone We are experiencing a significant performance degradation in a custom BI Publisher payroll reports after our environment was updated to release 26C.…
-
OTBI - Need filter on from date to To date as sysdateSummary: Hi Team, we have requiremnt in OTBI to apply the filter(Completion Date) as From date is 1-04-2023 to TO Date is sysdate. thi is the the is colums of fomula : "… -
Creating BI Publisher Audit Reports Equivalent to Native Oracle Fusion Audit ReportsSummary: Hi everyone, We're running into the row limit in the native Oracle Fusion HCM Audit Reports UI and are exploring the possibility of building custom BI Publisher…
-
How do I calculate the number of days a position has been vacant?I am trying to write a report in OTBI to calculate how many days a position has been vacant for to enable management of aging positions. My initial analysis was in Worke… -
BIP query to get OTL project and task detailsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
BIP query for LCP tracker informationSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Comparison between two fields in rtf templateSummary: Comparison between two fields in rtf template Content (please ensure you mask any confidential information): In the RTF template, we need to conditionally displ…
-
Unable to get the Calculation card Federal Start Date valueSummary: Unable to get the Calculation card Federal Start Date value in OTBI/BIP query Content (required): I am unable to get the Federal Start Date value in OTBI/BIP qu…
-
Special Characters in BIP ReportSummary: have requirement of replacing special characters coming in the description column of the BIP report with following: Double quotes replace with '"' need to … -
How to report on worker Area of Responsibility records assigned?Currently created an analysis report in OTBI to pull Area of Responsibility records against current active employee records. Tried testing with a variety of ways with di…
-
Session Variables for Use in Activity Center VisualizationsHello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reportin… -
when we run the RTF template report we getting below errorSummary: HI Team, we have RTF developed template but now we have enchement on statement of text so we changed the matter but we getting below error. please assitance on …
-
Cannot Create Visualization in Redwood AnalyticsHello, In following this documentation, I attempted to create a new visualization for Redwood Analytics and mapping an OTBI report to it. My goal is to add this to the R…
-
difference between legal employer hire date and enterprise hire dateSummary difference between legal employer hire date and enterprise hire dateContent Hi, Please find attached screenshot of Manage Work Relationships for a person: 63060.… -
How can we print different Logo based on LE name in EXCEL BIP TemplateSummary: For the Excel template, we have a requirement to print the logo based on the Legal Employer selected in the parameter while running the report. This requirement… -
How to report on job subfamily?Hi, Is there a way to run a report with the job code, job name, associated job family and associated job subfamily in BI publisher?
-
Headcount value 0 for some employeesSummary: I was comparing the headcount (the built-in fact) against the employee detail row wise data and the counts did not match. I noticed that some employees had the …
-
Reliable way to identify negative gross / net pay employees without error message text?Hi all, We maintain a custom BI Publisher report that flags employees with negative gross or negative net payments during payroll processing. The report is provided to o…
-
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b… -
Payroll : Fiscal year to date balance showing results for the Calendar year and not Fiscal yearSummary: Payroll : Fiscal year to date balance showing results for the Calendar year and not Fiscal year Content (required): Hi, We have enabled "Relationship NoCB Fisca…
-
Is Marketing Communications Opt In available in Recruiting OTBI?Summary: We need to report the Redwood Recruiting candidate-profile value “Marketing Communications Opt In”. The value is stored in IRC_CANDIDATES.OPT_IN_MKT_EMAILS_FLAG…