Global HR
Discussion List
-
Birthday Notification to be sent with Custom text on ImageWe have requirement to send birthday notification to employee by keeping RM , HRRM , Employee direct reportee and RM direct reportee in CC The content of email is :- Dea…Surbhi Jat-Oracle 72 views 0 comments 0 points Started by Surbhi Jat-Oracle Reporting and Analytics for HCM -
Report to get active staff as end of actual month vs their situation in the previous monthSummary: I want to create a BI Publisher report each month that allows me to track the situation of each employee if there is any changes between end of actual month vs … -
BIP report date format is not working in Dashboard promptsContent Hi All, I have created a BIP report with date parameter and it is working fine. When I tried to apply dashboard column prompts on the same report data is not fet…Sachin.Satpute 78 views 4 comments 1 point Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Date Range Parameter value should be defaulted to previous year in OTBI ReportHi Team/Raghavendra Raghunath-Oracle, We have created an OTBI report it's working fine. However in the Prompt parameter we wanted to default the filed values as below; S…Mahendra Y 36 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Migration of Fast Formula, Lookup, UDT in bulk from one instance to another.I am migrating Fast Formula, Lookups, UDTS from one instance to another in bulk, what we need to select under deployment method while creating task, please suggest?
-
Aor QuerySummary: Hi Expert, I have to add an AoR query in my almost five different BI reports. As of now, it shows all data, however, we need to reduce the results based on the …
-
Add New Pay Rate and Old Pay Rate to existing reportSummary: I've been working on making an adjustment to a report (linked below) to add columns for current pay rate and old pay rate. Right now, the sql in the report is r…Henry Imgrund 13 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Multiple School Districts and Multiple Cities per GeocodeSummary: When trying to build an OTBI Data Model for Tax Withholding, we are finding multiple cities in a Geocode (HZ_GEOGRAPHIES, HZ_GEOGRAPHY_IDENTIFIERS), and multipl…ChicagoConsultant 22 views 2 comments 0 points Most recent by ChicagoConsultant Reporting and Analytics for HCM
-
what is the diffrence between reports and extracts where we can we the extractsSummary: Hi Team, what is the diffrence between reports and extracts where we can we the extracts ? How can we learn, i'm new to extracts. Thanks, Ajay Content (please e…AjayKumar Maddipati 26 views 6 comments 0 points Most recent by VijayKumar R Reporting and Analytics for HCM -
Filter OTBI report using dff's effective start date and effective end dateSummary: Need to filter dff data using effective start and end date Content (please ensure you mask any confidential information): I created a analysis report which has …Taushif Anwar 112 views 10 comments 0 points Most recent by Taushif Anwar Reporting and Analytics for HCM
-
Possibility to do Gross Pay in OTBIContent I am working on a report to show gross pay and specific imputed earnings during a specific date range divided by pay dates. I am attempting this report with Orac…User_2025-02-10-19-21-48-801 138 views 8 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Tracking relatives in the same companySummary: I'm interested to know if anyone has tracked relatives or other relationships of employees working in the same company. We want to avoid having relatives workin…Rose_BOH 23 views 6 comments 0 points Most recent by Anna Klapisz-Oracle Reporting and Analytics for HCM -
INFORMATION_TYPE is not unique IN PER_JOB_EXTRA_INFO_F table for same job title.Summary: Integration is failing due to sql not returning data for INFORMATION_TYPE ='EIT'. In BIP report INFORMATION_TYPE is coded 'BMC Grade Details' How the INFORMATIO…Ankush_Jadhav 12 views 2 comments 0 points Most recent by Ankush_Jadhav Reporting and Analytics for HCM
-
OTBI Report to fetch List of Line ManagersSummary: OTBI Report to fetch a List of Line Managers who have at least one direct report and the direct reports(Employees) should be Salaried. Content (required): For t…Thulasi Ram 439 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Query to extract employee grade ladder in the assignment pageSummary: Content (please ensure you mask any confidential information): Hello experts, we built the following query to retrieve the employee current grade ladder. Howeve…Valerio Curzi 393 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Records for Cancel Workrelationship and Reverse Termination scenarios in new subject area in 24AIn 24A , oracle have introduced new subject area - Assignment Action Occurrence Real Time , allows you to report on all HR Actions and reasons associated with the worker…Manisha Singh 247 views 31 comments 0 points Most recent by Melissa Shropshire Reporting and Analytics for HCM
-
Customer wanted to automate the process to send payslip over personal email for terminated employeesSummary: Hi Team, Would you please help us to get the steps how to achieve the requirement "automate the process to send payslip over personal email for terminated emplo…Rama123-Oracle 82 views 3 comments 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
Information about who rejected the rejected absence recordsHi, I need to add information about who rejected the rejected absence records to my report. When I use the 'fa_fusion_soainfra.wftask table', I cannot access it for reje…Cansel Karasoy 13 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM -
Default Expense Account in HCM Subject AreasContent The Default Expense Account is a key field for our client that is used for reporting and security management. They would like to report on it in OTBI so they can…User_2025-01-25-01-23-28-110 284 views 4 comments 0 points Most recent by Nishant007 Reporting and Analytics for HCM
-
Why does Terminated user access not revoked for reportsSummary: Hi, When we assign add User to any reports/report folder under permission, and that User get inactivated, this user access doesn't get revoked automatically. Do…Namrata_20 12 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
query to get the location based country and restrict the country based on the regionSummary: query to get the location based country and restrict the country based on the region Content (please ensure you mask any confidential information): For ex Regio…Sravanthi Kamatham 177 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Advantages and Disadvantages of OTBI seeded dashboardsI'd like to know how the seeded Line Manager Dashboard works when it was copied to the Custom folder. If Oracle made some changes on the seeded Line Manager Dashboard, d…
-
BI Publisher Report Auto Run - Open Report from home page instead opening from BISummary BI Publisher Report Auto Run - Open Report from home page instead opening from BIContent Hi Experts I have created a BI Publisher Report. i have taken the url of…Mansur Khalil 157 views 17 comments 1 point Most recent by Mansur Khalil Reporting and Analytics for HCM -
Any one help me on department change report old and new departmentsSummary: HI Team, could you please help me on we need old and new changed department report. Thanks, Ajay Content (please ensure you mask any confidential information): …AjayKumar Maddipati 93 views 20 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Default prompt values not workingGood morning, I created a dashboard prompt that filters the values based on a query and works fine but I'm struggling to set the default values. In fact, even if I set "…
-
User Login history Audit report for termed employeesSummary User Login history Audit report for termed employeesContent Hi, We are looking for a report in oracle for our auditors that tracks the last login details of term…Shifa Nazumudeen 108 views 5 comments 0 points Most recent by Truptesh Solanki Reporting and Analytics for HCM
-
View the results in the Absence Calendar Real Time Entry ReportI have followed guidance from the 22B document to 'Generate Daily Breakdown of Absence Details Process' and the outcome of this process is to 'View the results in the Ab… -
Looking for Last Contacted field for a candidate in Recruitment Module for reporting purposeSummary: Looking for Last Contacted field for a candidate in Recruitment Module for reporting purpose (Hiring à Candidate Search à Details à Key Highlights Content (requ…
-
OTBI analysis - Bar graph in OTBI analysis for acquiring the headcount trend for the past years on mSummary: We want to create a Bar graph in OTBI analysis for acquiring the headcount trend for the past years on monthly basis. For which we need to get active headcount …Shreya Datir 56 views 15 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Active Bank Accounts with different Display NamesSummary: I have a request to create an OTBI report which shows the active banks accounts with different Display Names against them, these names are likely to be spouses …