Category 81
Discussion List
-
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 33 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 22 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 14 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 117 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 33 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 42 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 33 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 14 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 14 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…Tisha Negrete 1 view 2 comments 0 points Most recent by Tisha Negrete 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 122 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 4 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 12 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 21 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 5 views 2 comments 0 points Most recent by Natalia_Leemans Reporting and Analytics for HCM
-
Unable to list just one manager for each Matrix Manager TypeSummary: We have a report that provides employee details AND includes each manager type i.e. Line Manager, Comp Planning Manager, and Timeclock Supervisor. When we run t…Darrin N 14 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is there a way to include historical source information?Summary: Candidate Pool Reporting - historical 'Source' data Content (please ensure you mask any confidential information): We are building a report on candidate pools a… -
How to get "Person Type" and Assignment Details from Fusion TablesSummary: Hi All, We are seeing a difference between the "Users license Usage" numbers in the Usage reports for HCM Base cloud Licenses and number of "actual user report …
-
unauthorized access: either you do not have the privilegeSummary: Content (please ensure you mask any confidential information): hi team, I have embedded a bi report, but I'm getting this error- unauthorized access: either you…Alex_Balanovsky 13 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Alert based on Assignment StatusSummary: is there any way we can add this field assignment status in filter criteria under alert composer. Content (please ensure you mask any confidential information):…