Global HR
Discussion List
-
OTBI-Dashboard promt values not showing in Dashboard after added the new oneSummary: HI Team, We have new enhancement requirement in old dashboard that is needed to change the check task name from HR Questionnaire First 2-weeks check into Onboar…AjayKumar Maddipati 32 views 9 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Extract text data from "SuccessCriteriaText" in "XML_DATA_CACHE" column "HRC_TXN_HEADER" tableSummary: Does anyone know how to extract text data from "SuccessCriteriaText" column in "HRC_TXN_HEADER" table? Although I could extract some text data such as GoalName,…S.Watanabe0110-Oracle 163 views 1 comment 0 points Most recent by GajavalliKoteswararao Reporting and Analytics for HCM -
Courses Link table name for LMS reportFrom which table we can get the course link in bi reports. Can anyone help me with the table name. Thanks, Dara NagasaiDara Nagasai 1 view 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Bell notifications are not getting triggered if username and work email IDs are same.Summary: Bell notifications are not getting triggered if username and work email IDs are same for assignment projected end date alert. Content (please ensure you mask an…Siddhesh Nisal 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
SQL to pull Number of Days between two dates (one is a Parameter Date)?I'm currently using BIP Report. This sequel works on me if I'd like to use SYSDATE: TO_NUMBER(TRUNC(SYSDATE) - TO_DATE(TO_CHAR(SEN.SENIORITY_DATE, 'YYYY-MM-DD'),'YYYY-MM… -
Locations Child Data Group returning records at unexpected eventsWe've a changes only extract to retrieve person, assignment data. In assignment DFF, we've utilized 1 for Site-location(Attribute1) which LOV is retrieved as internal_lo…
-
We are using Assignment Event Real Time and do not see correct Termination headcount in BI reportsSummary: We are using assignment event real time subject area and reporting annual turnover for previous 5 years. We are not seeing the correct turnover headcount when w…David Boudreau 61 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need query to resignation approved employeesHi, I have a requirement to send emails to employees whose resignation is approved. So I want to use bursting to send emails to employees. Can anyone help me out with th…Dara Nagasai 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BI Report Access Issue - User Unable to Open and Access Report.Hello Community, I'm facing an issue with a BI Publisher HCM user information report. A specific user is unable to open and access the report, and I'm hoping someone can…Omran Zeaiter 281 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Extract Error The payroll relationship action ID isn't valid.Summary: A system error ORA-20001: The payroll relationship action ID isn't valid. Contact your help desk. ORA-06512: at "FUSION.PAY_REPORT_BALANCE_GROUP", line 2462 ORA… -
How to report on days since assignment status changeSummary: Hello! I am looking to report on days since Leave. We track leaves using the Assignment Status field, so I am looking to report on days since assignment status …
-
Manager Hierarchy starting with CEOSummary: We are looking to get the manager hierarchy with CEO as level 1 of the organization. The Flattened Hierarchy table (PER_MANAGER_HRCHY_DN) has data with manager …User_2025-03-07-06-12-02-972 181 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Can we have Mail Triggers, once Extract has run successfully,Full Profile, Extract has been created to do HDL Upload Query : Mail trigger to happen once Extract has run to know how many cases have been failed.
-
In what particular subject area can Date of Fill, Time to fill and Time to Hire be found?I'd like to pull the following columns within the Recruiting Subject Areas: Date of Fill - Returns the date/time when the requisition was most recently filled. Time to F…Welsey 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Check Working Day QuerySummary: Dear All, I have a requirement to check if a specific date is a working day for the employee or an off day. So basically I need a query with a parameter called … -
Need to Add board members in system and Pay Quarterly onceSummary: My requirement is to add Board members in System who are not actually employees and i want to pay them only Quarterly once. what is the Best way to achieve this…Laxman Doppalapudi 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Data Not fetching when joining cross subject areas with a DFF attributeSummary: We have encountered an issue while join two cross subject areas. Workforce Management - Worker Assignment Real Time and Workforce Performance - Performance Rati…Atul#620 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
We updated our integration URLs with workers api but not workingSummary: We have rebuild our integration URLs with Worker API but when we are testing getting error like: "Request parameter expand with value workRelationships.assignme…mohityagyik 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How is Audit Table of HCM different from events captured in hrc_evt_source_objectsSummary: How is Audit Table of HCM different from events captured in hrc_evt_source_objects and which one should be used when Content (please ensure you mask any confide…Amod Kulkarni 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How do I find out the end date used for a scheduled process that has already endedSummary: We are trying to find out the end date used when a process was scheduled that is already in "finished" status. One of our ESS jobs has stopped running and we wa…Jefferson Yuliat 81 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Hierarchy Report - Top to bottomHi, Is there any way of reporting on the hierarchy from the top to the bottom? In OTBI there is this 'Parent Manager' field that is ordered bottom up. Is there any way o…
-
How to get Job offer details using HCM ExtractSummary: I have requirement to extract Job Offer Details like Offer Name, Designation, Person Name, Recruiter etc. using HCM Extract. Would like to Know How can we get H…
-
Need sample HDL for Contact Relationship (To Upload Dependent Information)Summary Need sample HDL for Contact Relationship (To Upload Dependent Information)Content Hello Everyone, Can you please provide sample HDL file for adding employee depe…
-
PPM Selected Bank AccountSummary How to Find selected bank account under personal payment methodContent Hello All, When employee update their bank details by clicking into their existing payment… -
How to send UCM file as an email attachment using BI publisher reportSummary: How to send UCM file as an email attachment using BI publisher report Content (required): Hi Experts, We need to extract a PDF file from UCM and send as a email…Venkatesan 705 views 15 comments 0 points Most recent by Dara Nagasai Reporting and Analytics for HCM
-
Any report to get the employees with missing calculation card detailsSummary: Any report to get the employees with missing calculation card details Content (please ensure you mask any confidential information): Hi Team, Greetings! There a…Parag Hiremath 31 views 2 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
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 : "…AjayKumar Maddipati 404 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
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…AjayKumar Maddipati 41 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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…Avinash.Potti 24 views 2 comments 0 points Most recent by Avinash.Potti Reporting and Analytics for HCM