Global HR
Discussion List
-
How to pass NULL and All column values prompt values in logical sqlSummary: Hi, I have created a dashboard prompt but when I am passing values as NULL and All Column values in prompt analysis is showing no result. I have created analysi…Shreya Datir 54 views 18 comments 0 points Most recent by Shreya Datir Reporting and Analytics for HCM -
How to add two subject areas event real time and performance real timeSummary: Hi Team, Any one help me on it's urgent requiremnt . How to add two subject areas workforce management—worker assignment event real time and workfroce performan…AjayKumar Maddipati 1 view 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Validate Field Values option no visible in VB stuidoSummary: We have created a rule in change salary and done some field level changes. As part of 24B, we should see Validate Field value options, But we are unable to see …
-
How can i get the results of a fast formula directly from a querySummary I have a complex fast formula and need to read the result of it through a query. Content (please ensure you mask any confidential information): Version (include …Farah Alajou 121 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to End Date Extract Definitions?Hello, Normally after a P2T is performed I would go into the Extract Definitions and end date the FTP delivery to insure no file would be sent to a vendor for example AD… -
How to hide fields in Redwood Position Details page?Summary: We are trying to hide some fields, sections or attrubutes in the new Redwood page specifically for the Position details. Content (please ensure you mask any con… -
Dashboard prompt is not workingSummary: Hi, I have created an analysis using logical sql and passed parameter i.e. presentation variable inside logical sql. But when I am using dashboard and dashboard…Shreya Datir 51 views 5 comments 0 points Most recent by Shreya Datir Reporting and Analytics for HCM
-
Dynamic generation of URL (from OTBI) to Person's Person Management in HCM ApplicationContent Hello, Just wanted to check if anyone tried to generate a dynamic URL from an OTBI analysis that can go to Person's Person Management screen at HCM Application. …SantoshKumarBhairi 239 views 33 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to use 1 common filter for graph and tableSummary: Hi Experts, I created an OTBI analysis and want to add one common filter for graphs and tables. Can someone assist me with how to use all filters for both? Than…
-
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 91 views 0 comments 0 points Started by Surbhi Jat-Oracle Reporting and Analytics for HCM
-
Run time environments are not setup to create new Visual applicationSummary: Hi Team, Run time environments are not setup to create new Visual application. Please advise. Content (please ensure you mask any confidential information): Ver…Vivs111 1 view 1 comment 0 points Most recent by Shay Shmeltzer-Oracle Visual Builder Studio 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 79 views 4 comments 1 point Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Can HCM Extract be used to extract Oracle Learning Cloud details?Hello Please, Can HCM Extract be used to extract Oracle Learning Cloud learning assignments for offering, courses and specialization details? Are there user entities for…
-
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 51 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Service connections are not workingSummary: Hi Team, Service connections are not working, error is displayed. Please advise Content (please ensure you mask any confidential information): Version (include …
-
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 11 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 21 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 31 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 121 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 135 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 21 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 11 views 2 comments 0 points Most recent by Ankush_Jadhav Reporting and Analytics for HCM
-
Enable Personal Details DFF in Redwood UISummary: We have created global segments for PER_PERSONS_DFF. I tried to enable these DFF segments using VBS and made them visible on the Personal Details page. However,…
-
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 533 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
HCM Extracts vs BICCWhat tool is recommended to do bulk extract of Oracle fusion data (HCM, ERP and CX)? Couple of advantages I see with BICC is it supports Blob/Clob data with low or no cu…
-
Extensibility of My Spotlight Redwood pageWe currently have the requirement to add custom links in "My Spotlight" Redwood Page. Similar to using Guided Journeys or Dynamic Containers. It is supposed to be the ce…Arne_Mahnken 61 views 1 comment 0 points Most recent by Julian Challenger-Oracle Visual Builder Studio for HCM