Category 81
Discussion List
-
Offer ID not showing up on Recruiting Real Time Subject AreaSummary: Offers created under a requisition, but Offer IDs not showing up on the backend Recruiting Real Time subject area. Content (required): For a particular requisit…User_2025-07-18-13-29-11-469 62 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
We have OnBoarding_15Days_Report but timeout error coming on below querySummary: Hi Team, we have OnBoarding_15Days_Report its runing ok but few days onwords we getting error is timed out error, we apply one year durationand even schedule al…AjayKumar Maddipati 42 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Fetching column for employee Feedback(in PD) whether it is completed/bypassed in OTBI reportsSummary: I have a requirement to add one column in OTBI report to fetch the status of employee feedback if is completed or bypassed. Can we use SQL query to fetch the de…Kamini Kaushik-Oracle 11 views 2 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Reporting on Eligible for Pretax Age Catch-Up Contributions FieldSummary: Looking to include the column Eligible for Pretax Age Catch-Up Contributions in a payroll report to pull all data assigned to a person's Reporting Information c…Emily Meyer 16 views 2 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
MAX functions for payroll element effective start dateSummary: Content (please ensure you mask any confidential information): Hello experts, I need to extract the most recent effective start date for a payroll element loade…Valerio Curzi 44 views 11 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM -
In Salary report one employee showing two records, difference is one is old salary second new salarySummary: HI Team, In Salary report one employee showing two records, only difference is one is old salary and second one new salary , how can we get latest record (New s…AjayKumar Maddipati 63 views 8 comments 0 points Most recent by Amol Patil HCM-Oracle Reporting and Analytics for HCM
-
Need a sql to get "extra info" on "position details" pageHi All, I'm trying to find SQL tables and joins behind getting "Regulatory Licence Information" under Extra Info Section of Position Details. Navigation : Set up and Mai…
-
Org levels missing from the OTBI report for the inactive treeWe recently did our restructures and created a new version of the tree. The old version end on 2-Jul and the new version starts from the 3-Jul. Now the Org tree has leve…Girish Bhatia 33 views 7 comments 0 points Most recent by Girish Bhatia Reporting and Analytics for HCM -
Oracle BI Tables to retrieve last payroll element entries amount and last dateSummary: Content (please ensure you mask any confidential information): Hello experts, which BI tables collect data related to payroll element entry last amount and last…Valerio Curzi 31 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Goal Details BI Report including Employee Submission Status and Manager Approval Status fields.Hi Team, I have the requirement to create a BI report for the Goals details of the employees including the Employee submission status and Manager approval status fields.…
-
SQL to retrieve employee name,person number,department name and department DFF detailsSummary: SQL to retrieve employee name,person number,department name and department DFF details Content (required): Hi All, Please share SQL to retrieve employee name,pe… -
How to create User defined table (UDT)Summary: How to create User defined table (UDT) with screen shorts. Requirement: i want to store the below data in User defined table & which table can store this inform…Ravindr-Oracle 11 views 3 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
How post a copy of the burst output to the UCM/content server so a web service can get the fileSummary: We have a burst report which goes to workers when they terminate that we would like to archive to our doc management system. In order to do so we need to post a…Mario Lieras 17 views 2 comments 0 points Most recent by Mario Lieras Reporting and Analytics for HCM -
Issue with Logical SQLSummary: Hi, I was working with a Report which will provide various employee emails like home email and business email addresses along with few other assignment details.… -
How to customize BICC to control data that can be accessed by BI teamSummary: Hi All, We plan to use BICC for pulling data out of HCM but our HR team is concerned on the data access front. We feel like the BI team will have access to sens…
-
Enhanced Analysis with parameters changesSummary: Created a Reports and Analytics Analysis which others users can run. Then I made modifications to the Analysis, saved it and now the others can still only run t…David Kubiak 12 views 3 comments 0 points Most recent by David Kubiak Reporting and Analytics for HCM
-
HCM Subject Area QueryHello Experts, Just need a quick suggestion from you - We have a requirement from business where we have to create a custom roles for Auditor - I have created a custom d… -
How to FTP file upload to UCM content server via ODISummary: Hi Folks, Content (please ensure you mask any confidential information): How to upload FTP files to the UCM content server via the ODI tool Version (include the…Prakash Jayavel 36 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to return Geographies using OTBISummary: We want to return Geographies (State, County and City) using OTBI. But the data should not return the geocodes but should return the actual name. Ex: State: LA …RenzelkeithCoquia 2 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
How to display the recruiting candidate's department name in OTBISummary: Content (required): I have a candidate who's department in the job offer is different from the one in the requisition. Using OTBI, is it possible to display the…User_2025-02-12-02-38-00-520 58 views 8 comments 1 point Most recent by Mansur Khalil Reporting and Analytics for HCM -
Offers Report not pulling dataSummary: Content (required): Anyone experiencing data not pulling through on OTBI analysis reports created using subject area: Recruiting - Recruiting Real Time? Anyone …
-
How do I remove unwanted commas in OTBI report outputSummary: Custom address field column contains extra columns when source column is null Content (please ensure you mask any confidential information): I have created an O…DennisOliver 27 views 5 comments 0 points Most recent by DennisOliver Reporting and Analytics for HCM -
HCM native datamodels/bipSummary: are there another schema.table wich sample reports delivered in HCM Cloud are stored to extract a list of them ?? Content (please ensure you mask any confidenti…
-
csv output giving multiple date format while using etext templateSummary: I have built a report to display a date column in dd-mm-yyyy format using etext template. the report output is displayed in text or csv. In both the cases when …Nisha_Hegde 74 views 9 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
SQL instruction to join data from 2 or more BI tablesSummary: Content (please ensure you mask any confidential information): Hello experts, which instruction when building queries in data models allows me to join two or mo…Valerio Curzi 15 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Connections BIP report - how to remove HTML tags?Summary: Hello, I've created a BIP report for Connections. Could you please advise how to remove HTML tags? Please find SQL query attached. Kind regards, Marta Content (… -
How to remove the duplicates in rtf templateSummary: Currently using the three Data sets in the report First DS will contain the employee details,legal employer name ,Dept id and element amount Second DS contains …
-
How to filter the column values by another column?Summary: I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time I want to filter employees which have these Response A…
-
Facing issue with top manager type in OTBIWe have created otbi report using top manager type. Multiple managers are visible in OTBI, but in system only 1 manager is tagged. Is there any way we can pick the activ…Pranay_Soma 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM