Get Started with Redwood for Oracle Cloud HCM Begin Now
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 query the Effective Start and End dates of job on job profileSummary: How to query the Effective Start Date and Effective End Date of Job Name/Code added to a Job Profile in OTBI. Content (please ensure you mask any confidential i… -
Ability to report on auto provisioning rules?Summary: Is there a way to report on all the auto provision rules we have set up within the Manage HCM Role Provisioning Rules task? Or some way to report on all securit… -
Report Path for Audit Reports PageSummary: Could someone please share the report path for the page below? I intend to generate a BIP report to monitor user role deletions and additions. Content (please e… -
Time to Fill Measure using Requisition Open Date in Recruiting - Recruiting Real Time Subject AreaContent I'm trying to create a Time to Fill measure using data in the Recruiting - Recruiting Real Time Subject Area. My calculation works but the Requisition Open Date … -
Query to extract the list of available Locations based on the Legal EntitySummary: Content (required): Hello experts, is it possible to build a SQL query to retrieve the list of applicable locations based on the legal entity? Thanks in advance… -
How to Organize the BI Publisher reports and create Library and definitions inside HCM?We implemented Oracle HCM back in 2019, and since then we created a lot of BI Publisher reports across the modules. Those reports are very useful, however, the report na…
-
prescreening report orcSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Automating HDL Worker loading via BIP ReportWhat is the process to Automating HDL Worker loading via BIP Report -
need a payroll element costing reportSummary: Need to write a payroll element costing report that includes highlighted information from picture below Content (required): need a report that shows all the inf…
-
AbcdAbcd -
How to convert bip report out format into JSON format by using e-Text templateDear Experts, I need to convert Bip report out format into JSON format by using e-Text template. Please send me the e-Text template and how to use that template with XML…
-
Etext Report output is not coming correctly.Summary: Hi Everyone. I am trying to create a etext report in the HDL format, EDI(delimited type). When i view the report, instead of getting the output value, i am gett…
-
In which table I can find this column "Department" ?I'm creating a report with BI Publisher and I need the department column but I've searched several tables and can't find it. I've found the business units and legal empl… -
Condtional formating not working for standard fieldsSummary: Adding a conditional formating criteria does not work on standard fields but works fine for flex fields Content (please ensure you mask any confidential informa… -
Where can you find the meaning for the ASSIGNMENT_STATUS_TYPE_ID number?Hi, When running the below query, the table contains ASSIGNMENT_STATUS_TYPE_ID. This is a NUMBER value. Does anyone know where I could find the meaning of the value retu…
-
Pass Parameter to Order By condition in Data Model (BI Publisher)Summary I'm trying to configure a Data Model to use a Parameter. I want a user to be able to choose a column to Order By.Content Hi, I'm trying to configure a Data Model…
-
Unable to get the Payroll Balance Value through Payroll - Payroll Balances Real Time subject areaSummary: Unable to get the Payroll Balance Value through Payroll - Payroll Balances Real Time subject area Content (required): We have payroll balance data for an employ…
-
AOR Areas of Responsibilities in OTBIContent Hi All, Can someone help, which Subject area I can find Assigned Areas of Responsibility details in OTBI? Thanks, Vijay
-
Oracle BI tables to retrieve Talent RatingsSummary: Content (please ensure you mask any confidential information): Hello experts, which tables allows to extract Talent Ratings as that one attached? Thanks in adva…
-
Permission - BI ReportSummary: We need an audit report with information about which user made the changes to the report's permissions in analytics.
-
Is there any documentation available on using AND, OR, and groups in OTBI report filters?Summary: I am trying to set up filters in an OTBI report to pull a subset of employees for an assignment in Oracle Learn. I need to select a group of employees and then … -
Report to find employees without any presentative (AoR HRBP)Summary: Hi, I'd like to create a report to find if any employees haven't been assigned to any HR Business Partner with an AoR. Do you know if this is feasible and how t…
-
Need query to get who submitted resignation in last 24hourswe have a requirement to get the report of employees who submitted resignation. Can anyone share me the query to get employees data or atleast how can we get data of emp… -
Colorado state employee retirement benefits year end reportingWorking with a school district in Colorado whose employees are participants of PERA. PERA has a very specific requirement for reporting year end data in the exact EFW2 S… -
How to fetch PREVIOUS Grade and Grade Step using BIP?I need to pull the latest previous Grade/Grade Step in a single row because we don't need to back track all the changes on their Grade/Grade Step. How to construct the B…
-
Mutiple conditions applied at the same time in conditional formatSummary: I am trying to use color code for one column, where two conditions need to apply for the conditional format, meaning that both conditions have to be met at the … -
HCM Infolet Tab unavailableSummary The HCM Infolet tab is missing from the pageContent Hi, I am having trouble in adding an infolet to the HCM infolet tab. The Service Infolet tab is present but I… -
OTBI Goal Plan ReportSummary Cannot get individuals to show 0 goalsContent Hello all, I am at an interesting place. Using OTBI I am attempting to create a report that shows me how many goals… -
Employment Contract Real Time Subject Area Not Returning any recordsSummary: Employment contract Real time subject area not returing any value when a column from "Employment Contract Details" is added. Content (please ensure you mask any…
-
How to report on Owner Person Email in Workforce Management - Checklist Real Time subject areaSummary: Content (please ensure you mask any confidential information): We are building an OTBI report to display Journey tasks metrics using the Workforce Management - …