Category 81
Discussion List
-
Future new hire reportI am using Workforce Management - Worker Assignment Event Real time subject area. I am trying to pull all new hires and rehires. In order to included the future hires I …Trupti Khodke 74 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
How to Specify Multiple People in Cc While Bursting in Custom BI AlertsSummary: Content (required): There is a requirement of having multiple people in Cc while bursting. How to configure PARAMETER 2 for multiple recipients? Version (includ…Shashank Singh 978 views 3 comments 0 points Most recent by jahanavi metta Reporting and Analytics for HCM
-
Way to fetch Value By Criteria Definitions in custom payroll fast formulaSummary: Way to fetch Value By Criteria Definitions in custom payroll fast formula select * from PAY_VBC_VALUE_IDENTS? I'm not seeing my records in HCM BI query Thank yo…jtwhit_hcm 26 views 0 comments 0 points Started by jtwhit_hcm Payroll and Global Payroll Interface (GPI)
-
Skills and Certifcation Report but issue is will get one Extra Empty rowSummary: Hi Team, We have Skills and Certifcation Report but issue is will get one Extra Empty row how can we overcome the thta row. Thanks, Ajay Content (please ensure …AjayKumar Maddipati 23 views 6 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Combination of position data and worker name only shows filled worker name rowsSummary: For an analysis in OTBI I used the subject area "Workforce Management - Position Real Time" for position data (position code, position name, department etc.) an…
-
PVO hcm extracts what types should be used and how ?Hello , We would like to use PVO extracts of Oracle of HCM type. Purpose -to get the worker (employee) details including their current manager, location, assignments, et…Revital Mefano 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
How to pull employees and contingents on a OTBI report along with seniority datesSummary: Hello, I am trying to pull both employees and contingents on a OTBI report along with seniority dates. I am noticing that since contingent workforce donot have …Nikhila 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need help on combining these two analysisSummary: Hi, I have to create an OTBI report(attached screenshot) where I have to show voluntary termination/active HC and total termination (vol+invol)/active HC in one…Shreya Datir 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Perfermance Status Chart (SPI AND CPI)Summary: In which type of Analysis the said graph could be made. Thank you for your prompt attention to this matter.Looking Forward for your reply. Version (include the …
-
Sql to get period end active head countSummary: Hi Does anyone have sql to get active head count at the end of each month/quarter? Thanks in advance. Content (please ensure you mask any confidential informati…
-
Trying to invoke candidate attachment REST API through PL SQL procedure giving errorSummary: Trying to invoke candidate attachment REST API through PL SQL procedure giving error " PLS-00306: wrong number or types of arguments in call to '||' " v_buffer1…
-
Vinay Prasad 34 views 3 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM -
How can I pull Job Families and Jobs, including Job Families not linked to Jobs?Summary: How to display "blank values"? Content (please ensure you mask any confidential information): From the Worker Assignment Real Time subject area, I can pull the …Arnaud Bory 34 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Custom Font on OTBI Dashboard?Is it possible to use a custom font with OTBI Dashboards/Analyses? We would like to develop a "theme" for our Dashboards and use our company's font. The only information…
-
Payroll Flow Pattern ReportSummary: Payroll Flow Pattern Report Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there a way to find out the programs which are…Parag Hiremath 43 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Requisition: Is it possible to create a report to see who deleted a candidate from a requisition?Hello, Is it possible to create a report/analysis to see who deleted a candidate from a requisition? If so, could you please tell me how? I am not so familiar yet with O…Michael Schweizer 1 view 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
Calculated Eligibility fieldSummary: Hello, We're trying to extract the Calculated Eligibilty column in SQL, as we need to know the value if it's Forced Eligible or Eligible. However, we cannot fin…
-
Payroll - Personal Payment Details Real Time gives an errorSummary: Hi Everyone, Currently, I'm working on the "Payroll - Personal Payment Details Real Time" Subject Area. when I'm trying to add employee bank details, it gives m…
-
Learning Items for Pending WorkersSummary: Unable to pull Pending Worker information from Learning Records Real Time DM and Assingment Real Time DM Content (please ensure you mask any confidential inform…
-
Trying to create a BI report to fetch out the payroll element entry data for employee.Here the data is flowing from ORC to Individual Compensation.When the employee is hired he will be awarded with some "BONUS" with some additional fields these data's wil…Jebarsan Thangam John Durai Raj 95 views 10 comments 1 point Most recent by Shanna Oppenheim Reporting and Analytics for HCM
-
Not enrolled in Waive but showing on OTBI report, along with standard enrollmentIn OTBI using Benefits - Enrollments Real Time, we are getting 2 records on some employees - 1 enrollment in Waive and 1 enrollment in Medical. They are only enrolled in…
-
Need SQL to extract the amount and periodicity of worker element entriesSummary: Hi Experts, Could you please provide SQL code that extracts the amount and periodicity of worker element entries? I need help with this requirement. Written thi…Hiba Ghoualmia 75 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Locked Goals IssueSummary: Employee submitted their goals, manager missed the notification and now the goals are locked. Please help to resolve this. Content (please ensure you mask any c… -
How can I activate audit trial on PER_CONTACT_RELSHIPS_F tableSummary: How can I activate audit trial on PER_CONTACT_RELSHIPS_F table Content (please ensure you mask any confidential information): Version (include the version you a…Farah Alajou 43 views 12 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Specialization Completion PercentageSummary: I am looking to build an OTBI report that lists by associate an enrolled learning specialization and a summary count of the number of the courses in the special…Kristen Arner 51 views 5 comments 0 points Most recent by PEEMA O-CHA Reporting and Analytics for HCM -
Creating a report from BI Workflow Correction Notification in HCMSummary: A client is looking to create a report of all of the correction notifications they receive in order to better analyze the data. Is this possible? Ex. Correction…
-
Call a bi publisher report from redwood pageSummary: Hello, Recently we have transformed absence standard page in fusion to redwood, can I call a custom BI Publisher report from this page and pass specific paramet…
-
How do I Round Down my TIMESTAMPDIFF formulaSummary: I have a TIMESTAMPDIFF formula to calculate the number of years but it rounds it up in OTBI, and I need it to round down to show completed years. Content (pleas…
-
What is the Subject Area for News and Announcements (which are displayed on the user home page)?Summary: We have a requirement to show employee announcements in an OTBI dashboard, so we want to know the subject area for the same. Content (required): Subject Area fo…Bhukya Vamsi Naik 42 views 4 comments 0 points Most recent by gguittini Reporting and Analytics for HCM
-
HR is unable to view own record on 1 Report in OTBISummary: Hi Team, Our HR Team has raised a concerned wherein they are unable to access/ view their own data (means the one who's extracting the report) in 1 of our repor…