Category 81
Discussion List
-
Help in query to retrieve Relationship Criteria on Eligibility Profile for BenefitsSummary: Hello! I am currently biulding an query to get all the Eligibility profiles and their criterias. Currently, I am in need to find the table to give me the relati…Matheus Roberto 22 views 1 comment 0 points Most recent by Thiru-Oracle Benefits-Oracle Reporting and Analytics for HCM -
Questionnaire report with Question that has multiple answers - duplicating rowsSummary: Has anyone successfully been able to get a report on questionnaires that has a 'check multiple choices' question on one row for an employee who selects multiple…Rachael Puthoff 22 views 2 comments 0 points Most recent by Rachael Puthoff Reporting and Analytics for HCM -
Getting multiple values with HZ_LOCATIONS queryHello, I am creating a BI report to fetch location values from HZ_LOCATIONS table for longitude and latitude along with person details from employee table. The query is …Vaishnavi Katiyar 63 views 0 comments 0 points Started by Vaishnavi Katiyar Reporting and Analytics for HCM
-
How to pull data from Additional Compensation in BIP ReportsHello Experts, Does anyone know how to or who has available SQL to fetch these data from Additional Compensation ThanksJoliver Caangay 3 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Function "per_bipntf_flex.getEFFAttributesFromCompare" is not retriving the data properly.Summary: We are using TABLE(per_bipntf_flex.getEFFAttributesFromCompare(htd.TRANSACTION_ID, 'Responsive', 'j_CategoryPerAsgEitResponsiveEmplFlowsVORow','FALSE')) functio…
-
23D:AUDIT MASS DOWNLOAD OF DOCUMENT RECORDS-hr_dor_mass_requestsHello All I am trying to query the hr_dor_mass_requests and its populating the values. It populates the numeric values for status and object version number as 3,4,7. wha…
-
Audit Report for Talent for changes in skills and qualification pageSummary: Audit Report for Talent for changes in skills and qualification page Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there…Parag Hiremath 2 views 0 comments 3 points Started by Parag Hiremath Reporting and Analytics for HCM -
Which table contains the information from Manage Legal Reporting Unit HCM Information ?Summary: Content (please ensure you mask any confidential information): Which table contains the information from Manage Legal Reporting Unit HCM Information? Version (i…OliveiraRR 23 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How do I do a simple SQL to bring the Name, Legal Entity and registration number of the Legal ReportSummary: Content (please ensure you mask any confidential information): How do I do a simple SQL to bring the Name, Legal Entity and registration number of the Legal Rep…OliveiraRR 128 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Historic Grade Steps in OTBISummary: I can see a previous grade step and current grade step using the screens, I wish to see the same information using OTBI. Content (required): When I create an An…ScottHillier 85 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Custom report is changed using page integration. But the link is showing the previous reportThe report is added to the home page as a page entry using page integration. Later the report path is changed and report is modified using page integration. However, the…Reshma Eldho 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Non-typeable flags - Audit ReportI cannot put the flag on "Show User-Related Details", "Show Attribute Details" and "Show additional object identifier columns", when exporting audit reports. What role/p…Greta S 3 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need to fetch the grade, grade step and grade rate at the employment level using BI reportSummary: Hi all I need to fetch the grade, grade step, and grade rate whichever assign to the person, but in my query, I am getting multiple grade steps assigned to the …Deepak Bhatt 2.7K views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
ORA-01719: outer join operator (+) not allowed in operand of OR or IN with payroll reportHi, The environment was recently upgraded to version 24D. Following this upgrade, the payroll report started encountering the attached error during execution (ORA-01719:…Saurav R-Oracle 111 views 1 comment 0 points Most recent by Matthew Hancock Reporting and Analytics for HCM
-
How to return values within a subquery by referencing tables from outer query?Summary: Content (please ensure you mask any confidential information): How can I return the name of the task owner from Oracle HCM Journeys using the Task Owner Person …Giuseppe Cannova 22 views 2 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM -
Query to find schedule details of a BIP reportSummary: Content (required): Hi Team, Is there a way to identify the schedule details of a BIP report like schedule start date, schedule end date, frequency etc? Version…MandeepGupta 1.1K views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to add background image in fusion home pageSummary: How to add background image in fusion home page Content (please ensure you mask any confidential information): Hi All, How to add background image in fusion hom…
-
how to customize employee promotion letter notificationSummary: how to customize employee promotion letter notification Content (please ensure you mask any confidential information): Hi Team, We got a requirement to add new …
-
loader for licenses and certificationsSummary: I'm trying to figure out how to do a bulk load of employee licenses/certifications with the field below. I looked in HSDL and I'm not sure what I need to pick t…
-
ICP start date in fast formulaSummary: How to restrict start date in ICP page. We want to restrict employee entering the back dated changes for their pension contributions. Have any one done these ty…SivaKumarRajan 27 views 4 comments 0 points Most recent by SivaKumarRajan Reporting and Analytics for HCM
-
Change assignment transaction cannot be approved with a comment.Summary: In change assignment, transaction cannot be approved with a comment but without comment it can be approved Content (please ensure you mask any confidential info…Abhishek Kuamr 12 views 1 comment 0 points Most recent by Rambabu Laveti-Oracle Human Capital Management
-
How is the Assignment manager List Unsecured populated in OTBI?Summary: I am executing the standard OTBI analysis "Headcount KPI - Female Managers" and I am getting a wrong number of female managers. How is it working? We have 13 fe…B Casla 78 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
I am not able to fetch the pay value for Social Security DeductionsI am not able to fetch the Pay Value of Social Security Deductions For Oman Salary Payment Report in Oracle Fusion Cloud HCM . Can someone help me out with the query or …Tuhinaa Nanda 3 views 1 comment 0 points Most recent by Tuhinaa Nanda Reporting and Analytics for HCM
-
Need SQL Query to fetch degree of the employeeSummary: Hi experts, I need an SQL query to retrieve the degree of an employee. If possible, please provide sample data along with the table and column names to help me …Arti_Priya 55 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Projected start date field in OTBI showing incorrect valueThe Projected Start Date in the OTBI Recruiting Real Time subject area doesn't appear to be pulling accurate data. We tried changing time zones but at the end of the day…Vaishnavi Katiyar 48 views 5 comments 0 points Most recent by Chantel Berger Reporting and Analytics for HCM
-
How to create a Bell Curve in OTBI reportSummary: Client team is expecting to show the Performance Rating Distribution results in a Bell curve model as shown in the attached screenshot. Could you please share a…Santhosh Gangishetty 311 views 14 comments 0 points Most recent by Gimhani Perera Reporting and Analytics for HCM
-
Getting merged and blank rows while trying to fetch Performance rating and Salary together in OTBISummary: Hi Peers, I am trying to build an OTBI analysis to fetch both the Performance rating and the Salary. I'm using Compensation - Salary Details Real Time and Workf…
-
Presentation Variable Dashboard Prompt Not Working For KPIsSummary: We created a custom Talent Acquisition Activity Report Dashboard via OTBI and recently added a Presentation Variable prompt for 'Workplace Segment'. The dashboa…Maryellen_Gancena 12 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
HSDL Updates to Requisition are not captured in IRC_LC_HISTORY TableSummary: When a requisition is updated using HSDL and if EXT_PUBLISH_JOB_STATUS , EXT_PUBLISH_JOB_END_DATE columns are being updated without any change to phase or state…vinay karumanchi 13 views 1 comment 0 points Most recent by Madalina Danis-Support-Oracle HCM Spreadsheet Data Loader (HSDL)
-
HCM Embedded BIP ReportsSummary: How to show BIP report with parameter in Comp landing page Content (please ensure you mask any confidential information): I'd like to show Embedded BIP Reports …CHANZAWA-Oracle 23 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM