Category 81
Discussion List
-
Not showing data in OTBI for other line manager type, how can we fix this?Summary: Right now, individuals with the manager type "Cross-Functional Manager" can't access any data about their direct reports in OTBI. The UI is behaving correctly; …Martijn van den Berg 28 views 2 comments 0 points Most recent by Martijn van den Berg Reporting and Analytics for HCM -
Round to nearest 0.5 decimalSummary: Leave balance in hours, converted to days to 2 decimal points. Content (required): My formula is FLOOR("Front-Loaded Plan"."Accrual Balance"/7.4) however for so…Dawn Cawston - CPS 83 views 4 comments 0 points Most recent by Narendar Rao Naineni Reporting and Analytics for HCM -
showing data based on the selected candidate in analysis added to offer screenSummary: We have analysis added to offer screen and we want to get data based on selected candidate so we need binding variable to take candidate number from the screen …Salma Mohamed Salem 24 views 1 comment 0 points Most recent by Alexandru C. -Oracle Reporting and Analytics for HCM -
Retrieve payroll elements amount increasesSummary: Content (please ensure you mask any confidential information): Hello experts, is there a way to retrieve the payroll element amount increases? For salary basis,…Valerio Curzi 16 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Create an OTBI analysis based on Personal Details Quick actionSummary: We have created a new DFF field in Biographical info tab in the Personal Details Quick action page. Content (please ensure you mask any confidential information…Ayesha Iroshani 39 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Do we have option to have multiple sheet in OTBI extractSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
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 71 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 44 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 18 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 35 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 57 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 42 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 40 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.…
-
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 35 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 19 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 15 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 42 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 6 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 57 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 35 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 92 views 9 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM