Category 81
Discussion List
-
Getting Absence Reason in BIPSummary: I need to get the absence reason for a large number of absence in a BIP report. However, when trying to link the Absence Entry Reason ID to the Reason ID using … -
How can I get only the latest results when reporting on the status of a certain training?Summary: I try to report on the status of a certain required learning to see who has not completed it yet. If the learning was deployed this year, but also the year befo…Cora_Stanciu 31 views 3 comments 0 points Most recent by Cora_Stanciu Reporting and Analytics for HCM
-
Restrict the access for creating data model and create analysisSummary: Hi All, How to find the roles which are giving create and edit access of analysis and BIP report? is anyone have any SQL for to find out these in any custom rol…Amit_Ekbote 41 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
While running whole population in OTBI we are facing issue.Summary: Content (required): we are using Pivot table output in the OTBI report for 1 or 2 employee it's working fine when we are running whole population, we are gettin…challa praveen 22 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Unable to see the Goal Status for Goal plan reportSummary: Unable to see the Goal Status for the Goal Plan OTBI report Content (required): Employee has submitted the goals for approval, but the same is not reflecting in…
-
Report to extract LRU Calculation cards configuration detailsSummary: Report to extract LRU Calculation cards configuration details Content (required): Hi Team, Greetings! Does anyone have the report or the query to extract LRU Ca…Parag Hiremath 53 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
How do I get Box 13 to populate on the W2?Summary: Box 13 on our W2s is not showing as checked. We are a government agency with a pension plan. I looked through Oracle documentation and found guidance regarding …Sara Ro 82 views 1 comment 1 point Most recent by Faithe Chu-Oracle Payroll and Global Payroll Interface (GPI)
-
How to report date/time stamp when a Candidate Label was added.Summary: Content (required): is there a way to report the date/time stamp when a label was added to recruiting>candidate>candidate - labels> label Name ? I see there is … -
Report to get the duplicate element entries in a given pay periodSummary: Report to get the duplicate element entries in a given pay period Content (required): Hi Team, Greetings! Is there an existing report to get the duplicate eleme…Parag Hiremath 11 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Mass Update messagesSummary: Content (required): What table stores the messages from Mass Update transactions? Version (include the version you are using, if applicable): Code Snippet (add …Scott Paulin 41 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Hide "Create Bookmark Link" LinkSummary: Dears we are trying to hide the link highlighted in screenshot attached but we dont understand how. OTBI is available to users within a dashboard, we already ch…
-
Using OTBI to fetch latest ACTIVE assignmentWe would like to use a filter which we can re-use to fetch the latest active assignment for a person. For 99% of our population, it works to do MAX("Worker"."Assignment … -
Invalid Number Error in fetching Basic Salary ComponentSummary: We are writing an oracle sql query to fetch different components in the salary for inactive employees. But it keeps showing below error on runtime. ORA-01722: i…Rohankumar Patel 51 views 2 comments 0 points Most recent by Sudheer Patel Reporting and Analytics for HCM
-
Can we hide a specific sheet in the excel output for some users?Content (required): We have an excel report which contains 2 tabs where 1st sheet contains the data dump and 2nd sheet is the actual report which is based on the 1st she…Sujeeth Chinta 41 views 2 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Total Actual Effort in Learning by DepartmentSummary: I am trying to write an OTBI analysis where we are able to pull in the total headcount of a department, the total actual effort hours of learning for that depar…KatieH 121 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI - How to get all workers who are hired, and transferred to the target department in 30 days?Summary: OTBI - How to get all workers who are hired, and transferred to the target department in 30 days? Content (required): Hi experts, Could you point me in the righ…Volodymyr Faranosov 33 views 4 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Hiding Out of The Box Reports - (Human Capital Management)Is it at all possible to hide the folder that contains the out of the box reports (Human Capital Management)? I can see we can remove the 'BI Consumer Role' from our rep…MikeW 41 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
OTBI reports: 1. Users with 2 assignments 2. Positions with 2 incumbentsSummary: OTBI reports: 1. Users with 2 assignments 2. Positions with 2 incumbents Content (required): Hello, I'm building a data quality dashboard and would like to ask … -
Column Data to print inline using Logical sqlSummary: We want to print area manager value in single column if there are multiple of them, currently its printing in two separate lines. Content (required): OTBI repor…Praveen D 32 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Cannot display data on standard analysisSummary: Generic user cannot see data while admin user can Content (required): Standard Analysis "Recruiter Work Load Details" saved under /shared/Human Capital Manageme…Stefano_Mazzocca 31 views 3 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
Reporting on OTBI and its Subject areas in UseSummary: There is requirement to check if there are any existing OTBIs that uses fields identified as sensitive. Is there a way to achieve this? Content (required): refe…Girish_Kulkarni_123 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Performance Reviews for Inactive employeesHi, I am trying to pull a performance review for a terminated employee.When I go into the performance performance goals screen and search for the employee, he iş appear …Cansel Karasoy 41 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Reporting Comments on Termination/Resignation Quick ActionSummary: Content (required): In classic UI, we were able to pull Employer Comment on OTBI analyses but that field is not available in RUX and is replaced with Comments a…Kathleen Nguyen 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get effective date of analysis so only values with a date greater than a specific date show?We have a report build to view talent ratings and are using the subject area Workforce Profiles - Person Profile Real Time. Our report is currently showing every record …JMora1234 13 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BIP reports emailed securely from HCM (by default)?Summary: BIP reports emailed securely from HCM (by default)? Content (required): We are scheduling a new BIP report to go to internal users and external (outside the com…Rich R 61 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
What permissions do I need to run BI Publisher Web ServicesSummary: Getting this error when trying to run the runReport request for the BI Publisher ReportService: PublicReportService::generateReport failed: user: [XXXXX] does n…SeanWesche 920 views 5 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Need table name for Additional Person InfoSummary: Need table name for Additional Person Info.Please refer the attachment for the screenshot.minati_behera-Oracle 452 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Need to display terminate records as on Yesterdays dateSummary: Need to display terminate records as on Yesterdays date Content (required): We are referring "Workforce Management - Work Relationship Real Time " subject area.…
-
Restrict schedule access to users when scheduling BI jobs and OTBI agents.HI Team, We would like to know how to limit scheduling capabilities to users when scheduling BI jobs and OTBI agents. This access should be limited to certain users. Cou…MadhanMH 85 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Data security on BIP reportHi friends, We have developed a BIP data model/report using the below tables which touches across payables, supplier and hcm. Some of payroll users having the Payroll Ma…Vijay Ramani VJ 332 views 5 comments 0 points Most recent by manish sharma Reporting and Analytics for HCM