Global HR
Discussion List
-
How to restrict to get one level of indirect employee data of manager?We want to get the data only for Indirect employee of the Senior Manager? but we are getting Indirect employees reportees data also. In query we have used PER_ASSIGNMENT…YAMINI DANTOORI 12 views 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
How to get legal employer legislation code with SQLSummary: How to get the legal employer legislation code with SQL Content (please ensure you mask any confidential information): Hi experts, I need to get the legal emplo…Volodymyr Faranosov 57 views 2 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
How to disable the deeplink from the bot responseSummary: How can I remove the deeplink "Schedule time off" from the response coming from custom component. Content (please ensure you mask any confidential information):… -
HR_DOCUMENTS_OF_RECORD_AUDIT Missing DFF Value for Assignment Number (Purged I-9 Report Issue)We are encountering a critical issue with generating a purged I-9 report due to a missing Descriptive Flex Field (DFF) value in the HR_DOCUMENTS_OF_RECORD_AUDIT table. T…Sunil Kumar A 22 views 1 comment 0 points Most recent by Shweta Ganguly-Oracle Human Capital Management
-
How can I export list of delivered reports for fusion HCM?Summary: Where can I find list of core delivered reports for fusion HCM modules. Content (please ensure you mask any confidential information): Version (include the vers…
-
Fast Formula doesn't return expected valueSummary: Content (please ensure you mask any confidential information): Hello, we built the following FF where we should retrieve value from two different value sets. If…Valerio Curzi 22 views 3 comments 0 points Most recent by A_R-Oracle Reporting and Analytics for HCM -
Overall Summary and Rating in Document of RecordsSummary: Does anybody tried to bring the Overall Summary and Rating details from Performance to a Document of Record? Is it feasible to add those in a DFF? Content (plea…GeorgianaB. 1 view 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
HCM Transformation Fast Formula : Getting all Metadata for AssignmentWe are trying to develop Worker.dat which will include Workterm and Assignment Metadata why We are able to get all the required fields metadata for worker but somehow as…Ajitabh Kumar-Oracle 33 views 2 comments 0 points Most recent by User_VB3A0 Reporting and Analytics for HCM
-
SYSTEM_PERSON_TYPE not updated to CANCELED_HIRE after Cancellation of work relationshipSummary: We used to get the employees whose work relationship is cancelled after Hire (from Pending Worker to Employee conversion) by querying the 'per_person_type_usage…Sujay Bhowmick 61 views 6 comments 0 points Most recent by Awadhendra Tripathi Reporting and Analytics for HCM
-
Guidance on OTBI Report for Transaction Summary by RegionSummary: OTBI Report for Transaction Summary by Region Content (please ensure you mask any confidential information): Hello Experts, We have a requirement to extract tra…Vasanthakumar Ravi 3 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Enterable Calculation Values on Calculation Cards - Query/ReportSummary: Enterable Calculation Values on Calculation Cards - Query/Report Content (required): Hi Team, Greetings! Does anyone have the report or query to extract the dat…Parag Hiremath 140 views 6 comments 1 point Most recent by Ankammarao Reporting and Analytics for HCM -
Based on the parameter year i should get the data based on that year i should get the data.lets say the paramter is audit_year = '31-12-2021' the requirement is something that we should get the data based on the parameter i.e i should get the person record bas…
-
Payroll Flow - BI Report - Bursting - Not generating output file.Hi folks, I'm generating a payroll report and pushing it on SFTP using bursting. Template, filename and path is derived via bursting .This report is attached to a Payrol…
-
Report dashboard prompt showing error - ACIOA5LNSummary: Report dashboard prompt showing error - ACIOA5LN Content (required): One of the working BI report which uses dashboard prompt, suddenly stopped working and show…Swati U 3K views 17 comments 1 point Most recent by Aaron Epstein-261578 Reporting and Analytics for HCM
-
Chetana Pawar 766 views 2 comments 0 points Most recent by Maheswar Reddy Reporting and Analytics for HCM
-
notification received is Redwood Users Delegation RolesSummary: Content (please ensure you mask any confidential information): The notification received is Redwood Users Delegation Roles. I need to know the OTBI path for thi… -
Object Validation Rule for Salary Adjustment Percentage not supporting as expected.Summary: Object validation rule for Salary business object is triggering for conditions where Salary.Adjustment Percentage should generate error message. Condition is se…Gaurav Bhagwandas Bhojwani 12 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Learning items with learning outcomes assigned are not displayedLearning items with learning outcomes assigned are not displayed. In the front we can see data according to this but not in OTBI. Using the "Workforce Learning - Learnin…User_DA2EL 12 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM
-
BIP publisher email unable to send to icloud candidate emailSummary: Hi, we are using BIP jobs to trigger emails to new hires based on task completion in journeys and recently BIP email is getting failed to deliver to icloud doma…
-
Default View Reports and AnalyticsHello all - We're currently looking for a way to default the displayed folders application and user wide when navigating to Reports and Analytics from the home page. Doe…Samantha_Kellstrom 13 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Manager information regarding the last active assignment of inactive employeesHello, In Oracle HCM system, the manager information of the employees who left the job is emptied, therefore the managers of the inactive employees are empty in my repor…Cansel Karasoy 17 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report that identifies when an employee becomes a manager of peopleSummary: Is there a way to build an report that will identify when an employee (non-manager) becomes a manager (people leader). We utilize the "Working as a Manager" fie…S. Johnson 28 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Employee Length of service (LOS) sql query based on Hire Date/Rehire Date in fusion hcmHello Team, I need a sample Employee Length of Service (LOS) SQL query based on hire date/rehire date in Fusion HCM to use outbound integration for one of my customers. …Janardhana K 237 views 1 comment 0 points Most recent by Janardhana K Reporting and Analytics for HCM -
What privilege or configuration is needed to ensure the user could view Demographic Info it in OTBI?Summary: Content (please ensure you mask any confidential information): One user can see PER_PERSON_LEGISLATIVE_DFF on the screen but not in OTBI, while another user can…
-
What table stores the extended lookup code name for Visas and Permits?Summary: I am trying to build a DM for Visa and Permit notifications. What table stores the extended lookup code name for visas and permits? I would assume there is a ta…Luke.Findex 27 views 5 comments 0 points Most recent by Ketan-Oracle Reporting and Analytics for HCM -
Document of Record : Salary Certification - QR code generationSummary: We have a requirement from the customer to generate a salary certificate letter from Oracle Fusion HCM that includes approval. The letter must include an auto-g…
-
Query to get Vacation Rules informationSummary: Query to get Vacation Rules information Hi, We need to create a report for vacation rules for all employees in the system and I know that there is a seeded repo…Kiran345 522 views 14 comments 0 points Most recent by Deepak Kumar Dev-Oracle Fusion Applications Administration
-
How to fetch Cost Center Details which are mapped at Department LevelContent Hi Team, In our organisation we mapped Cost Center at Department level. How to fetch those cost center details. If anyone have SQL query please help me. I tried …User_2025-02-05-04-17-04-394 7.4K views 13 comments 0 points Most recent by Boying Reporting and Analytics for HCM -
Arabic Text in PDF Output Not Bold and Font Does Not ChangeSummary: Hello everyone, I am facing an issue with generating PDF output where the Arabic text does not appear in bold, and the font does not change as expected. • The b…
-
Absence Plan does not update when worker's employment details updated.Summary: Has anyone encountered an issue where, when a worker's employment was updated, the new eligible plan was not enrolled, even though the Update Accrual Plan Enrol…Shannon Teves 27 views 1 comment 0 points Most recent by Priya Palanivel-Oracle Workforce Management