Category 81
Discussion List
-
HDL Report using payroll flowHi we have loopback inbound interface, we created HCM Extract and added task Initiated HCM Data loader to the flow. Now we need to create BIP for HDL summary by passing … -
Requirement to have a report that provides details of changes made to UDTSummary: We have a requirement to have a report that provides details of changes made to User defined tables. can anyone please help us on this requirement? Content (ple…Jagadesh S 21 views 2 comments 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM
-
Actual Goal Names are not reflecting in the Analysis ReportSummary: We are trying to build OTBI Analysis Report with the following attributes from Two Subject areas: Person Number, Name, Position Name, Unit, Department Name, Man…sayeed_ahmed 41 views 10 comments 0 points Most recent by sayeed_ahmed Reporting and Analytics for HCM -
Bringing the latest record of the person instead of all records in the OTBI reportHi, I have an Analysis report that contains employee background information, and an employee may log in and leave work more than once, and all records of this person com…Cansel Karasoy 41 views 10 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Why Oracle did not create Per_All_Assignments_D View In HCM CloudSummary: Dear All, Since we can't create any objects in the Cloud Database like Views, why oracle did not bring one of the most useful HR Assignment view used on the EBS…Alaa Abu Hijleh 22 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to get all Active and Inactive Records Regardless of Assignment Type Except for Inactive PendingSummary: Hi All, I have a report that get all Active and Inactive Records but I want to Exclude Inactive Pending Worker only. Any one have already tried this? Trying to …
-
SQL to get current and proposed assignment DFF values for notifiationSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Krishna Manoj-Oracle 41 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Calculations with Sum Distinct for Pivot TableSummary: Hi! I am hoping for some guidance regarding a report I am making to predict retirement in my company. I built a formula to estimate the likelihood of retirement…
-
"Periodicity Prime" data not found in subjects areaHello, I'm creating a report about contractual compensation, in this report i have many columns about Primes (bonus) (type of prime, amount, etc). I need a column that w…Hiba Ghoualmia 21 views 2 comments 0 points Most recent by Hiba Ghoualmia Reporting and Analytics for HCM -
Worksheet Proration ReportSummary: Worksheet Proration Report Content (please ensure you mask any confidential information): Hi All, Greetings! This is about the reporting requirement including c…Parag Hiremath 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
I Need a report showing pension contribution by employees and employersSummary: Does anyone know which subject areas I should use to get the pension contribution from employees and employers? Content (please ensure you mask any confidential…Isabela Radivoi 161 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
How to use a dashboard prompt in Case When query for a fieldSummary: Content (please ensure you mask any confidential information): We have a custom field in OTBI report that uses Person Number as a prompt on a dashboard. Below i…Giuseppe Cannova 41 views 1 comment 0 points Most recent by Giuseppe Cannova Reporting and Analytics for HCM -
issues with customized OTBI report in HR Help DeskSummary: we are customizing an OTBI report for the hr help desk module but we are unable to extract the following info: - Which employees (which person ID) did a search …Gianfranco Fariello 41 views 2 comments 1 point Most recent by KMChris-Oracle Reporting and Analytics for HCM
-
Valid grades list is not displaying on few JobsSummary: Hi Team We noticed that for few Jobs on Job details page Valid grades list are not getting displayed but for few Jobs we see grades list is populating . I have …Liyaquath 31 views 4 comments 0 points Most recent by Julian Challenger-Oracle Human Capital Management -
Can we report on deleted OTBI agents?Hi all, We seem to be unable to find a very important OTBI agent - at this point having gone through each folder we can only conclude somebody deleted it. Is there any w…Cora_Stanciu 11 views 2 comments 0 points Most recent by Cora_Stanciu Reporting and Analytics for HCM
-
PL/SQL - Absences in UoM: Weeks to be Displayed in Days?Hi all, Hope you are well. We have certain absence types such as Maternity, which have the UoM: Weeks. We have a requirement for reporting purposes to display this as Da…David Oldfield 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to authorize manager-based reports?We added the SQL reports we prepared to the spring board screen and we want to make an authorization here. But is it possible to make it manager-based rather than person…Cansel Karasoy 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Office 2019 Oracle BI Publisher ErrorFor example when I try to load a xml data ı got this message Hello I just downloaded Oracle BI Publisher but at my publisher area there is an error . I tried to install …Kaan Can Calkan 31 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Is there a report I can run with earnings history?Summary: Is there a report I can run with earnings history? Content (please ensure you mask any confidential information): Version (include the version you are using, if…User_2025-11-21-00-15-21-711 1 view 2 comments 0 points Most recent by User_2025-11-21-00-15-21-711 Reporting and Analytics for HCM
-
Provide access to Transaction console without actionsHi, I want to provide view only access to Transaction Console ,I have followed instructions as in , however i dont see the transaction security while adding the Data sec…
-
Document of Records OTBI Subject Area not displaying dataSummary: Document of Records OTBI Subject Area not displaying data. Do we need to run any processes? Content (please ensure you mask any confidential information): Tryin…
-
How do we track bypass Approval Rules - Bypass TrackingSummary: Need Audit record of Approval Rules - Bypass Tracking Content (required): Hi Team, We got a requirement from customer that we need to get the Audit details when…ankit.j.kumar-Oracle 142 views 2 comments 1 point Most recent by Sowdha Murugan Reporting and Analytics for HCM
-
is there a REST API which will give list of all nationalitySummary: Hi Team is there a REST API which will give list of all nationalities ? Please help Content (please ensure you mask any confidential information): Version (incl…mudassirsOrc-Oracle 21 views 5 comments 0 points Most recent by mudassirsOrc-Oracle Reporting and Analytics for HCM
-
How to limit Department prompt values to active onlySummary: I have an OTBI report using Workforce Management - Worker Assignment Real time subject area with an optional Department prompt. How can this prompt be limited t…
-
-
Manager only saves ratings (no submit) and then the OTBI report is run, are saved ratings fetched?Summary: Hi Peers, Our client has a requirement relating to an already live Performance Evaluation. They want to calibrate the rating (as an afterthought) Instead of add…S Shree 11 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM
-
Rating Subject Area showing future cost center instead current cost center informationSummary: Workforce Performance - Performance Rating Real Time Subject Area showing future cost center instead current cost center information Content (please ensure you …VarunG 11 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM
-
Data is not fetching When I add Column: PER_ASG_DF_DESC_UNIT - Worker Assignment DetailsSummary: No records are fetching when I add Column: PER_ASG_DF_DESC_UNIT - Worker Assignment Details from Workforce Management - Worker Assignment Real Time with another…sayeed_ahmed 22 views 9 comments 0 points Most recent by sayeed_ahmed Reporting and Analytics for HCM
-
Does BI Publisher allows dates in dd/mm/yyyy format?Summary: Does BI Publisher allows dates in dd/mm/yyyy format? Content (please ensure you mask any confidential information): I see only these formats: I need dd/mm/yyyy …Stefano_Mazzocca 41 views 5 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
ORC - Answers to open questions not visible in analysis with Subject Area 'Recruiting Real Time'Hi, We can't seem to pull the answers from open text questions (prescreening) into a report using an analysis based on the Subject Area 'Recruiting Real Time'. We use th…Natalia_Leemans 11 views 2 comments 0 points Most recent by Natalia_Leemans Reporting and Analytics for HCM