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
-
Invalid Number Error in BI PublisherSummary: Invalid Number Error in BI Publisher Content (please ensure you mask any confidential information): Hi, we are experiencing an issue with a BI Publisher Report.… -
AZA: How to get back dated assignment start date in OTBI reportSummary: Hi Team, We have built an OTBI report to get latest assignment details but how can we get assignment start date of a particular action in the latest assignment … -
Schedule Report to FTP including data timestampSummary Schedule Report to FTP including data timestampContent Hello, I want to daily schedule in OTBI report and BI publisher report and in the file name I want to incl…
-
IN below OTBI Manager DR report but country name not showing it showing DRS country nameSummary: Hi Team, we have list of people with direct reporties but when we add the country name in the it showing reporties country but we need manager country . Any one… -
What is the standard Path in reports and analytics to get Performance management notificationI want to know the standard Path in reports and analytics to get Performance management notification for customization in template. I am attaching the screenshot of noti…
-
Goal approval request notification template non editableSummary: Goal approval request notification template non editable Content (please ensure you mask any confidential information): Hello experts, we have enabled the appro… -
candidate email address in OTBISummary: How do we fetch the candidate email ID in OTBI from recruitment real time subject area as per the email ID present in the candidate personal information page. I…
-
IN BI Report two parameters From Date to TO Date but need to change TO Date as sysdateSummary: Hi Team, I have changed parameter Todate as SysDate but it correct or not I'm not sure, any one could you please check this is correct data or not on below quer…AjayKumar Maddipati 11 views 3 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle
-
Mail Bursting Didnt WorkedHi Everyone, I Just Checked the Bursting SQL, My Data Model but couldnt find the reason. In transaction screen I can see delivered with success . But at my mail I can't … -
Length of service calculationSummary: How to calculate Length of service from latest hire date of employee? Content (required): I am using Workforce Trend Real Time Subject Area, I need to show the … -
time to fill OTBI report in ORCSummary: Does anybody have time to fill OTBI report or dashboard build in ORC? Content (please ensure you mask any confidential information): Version (include the versio… -
Fetching the answer from multiple choice questions in OTBISummary: Hi, I have an OTBI report for Learning Assessments, the field "Answer Text" only appears in the report if the question is an open-ended question. Is it possible…
-
Oracle BIP Report -> RTF Template page bordersSummary page bordersContent Hello, I am having an issue with achieving page borders in RTF templates. Attached a word document explaining my problem. Can anyone please a… -
Add Custom Text to Workflow NotificationSummary: I would like to be able to add custom text to the workflow notifications that would show up conditionally - only when the approve/reject links are shown on the …
-
Analytics > Administration > Manage Sessions > Ability to Trace Sessions for BI Publisher ReportsSummary: Analytics > Administration > Manage Sessions > Ability to Trace Sessions for BI Publisher Reports Content (please ensure you mask any confidential information):…
-
Which table holds the value for 'Province of Employment' for Canada Employees ?Summary: Need the Table and column info for the 'Province of Employment' value to troubleshoot and fix card association issue. Content (please ensure you mask any confid…
-
I need help with creating New Hires report with some Requsition & Assignment & Offer detailsHello, Could you please let me know what Subject Area/Tables I should use to build a report that shows basically the info on the offer screen under: My Client Groups > H…
-
getting duplicate seniority dates in OTBI report FusionSummary: Oracle Fusion OTBI report is there giving duplicate records for one of the employee. It showing two seniority date records out of it we need earliest seniority …
-
How does a matrix manager see the indirect reports for the person set up as matrixed to themSummary: I have set an employee up as having a matrix manager. I would expect the matrix manager to see this employee along with his/her direct/indirect reports in a hie…
-
OTBI Report with manager details and Counts of Direct and Indirect ReporteesSummary: OTBI Report with manager details and Counts of Direct and Indirect Reportees Content (please ensure you mask any confidential information): We are able to get c…
-
OTBI Report - Direct and Indirect ReportsSummary: Does anyone know how to fetch direct and indirect reports of manager using OTBI? Content (required): Hello, Does anyone know how to fetch direct and indirect re…
-
Could someone please inform me about the table where I can find information on deleted user roles?Summary: Could someone please inform me about the table where I can find information on deleted user roles? In the per_user_roles table, records are permanently removed …
-
Number of Direct Reports that are ManagersSummary Need to generate a report that shows, for a manager, which one of their direct reports is also a manager.Content * There is a requirement to get, for a manager, …
-
Line Manager Dashboard Direct/Indirect ReportingSummary: Is there a way to filter the line manager dashboard analysis by direct/indirect reports? Let's say a Manager has 10 direct reports and 30 indirect reports, is t…
-
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…