Category 81
Discussion List
-
Percent of total Responses from Workforce Management - Checklist Real TimeSummary: I am trying to get an OTBI Analysis to return the Count of Responses to the Response Answers to specific Checklist Questions. In the example shown below I would… -
accessing benefits of terminated employeesSummary: in benefits service center - i cannot access benefits of terminated employees Content (please ensure you mask any confidential information): is there some confi… -
Converting PW to EMP future installments switched to paid on start date instead of staged future datSummary: When converting PWK to EMP, if there are multiple future Sign On Bonus installments, all element entries from the PWK record are removed. Additionally, all inst…Madhuja Bhaumik 11 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Payroll and Global Payroll Interface (GPI) -
In which page is Military Rank Lookup present?Summary: Hi, We are aware there's a Military Rank lookup as per following documentation We are able to find the lookup, and add values to it, but we do not find this fie… -
Scheduling OTBI reports to roles /user groups- How does access work ?Summary: If we have a simple headcount report built using Assignment real time subject area, and it is scheduled to a role (meaning multiple users with the same role but…Swapna Govind 2 views 2 comments 0 points Most recent by Swapna Govind Reporting and Analytics for HCM -
OTBI – Calculate Percentage of Responses per Question in Learning Evaluation SurveysHi everyone, I'm building an analysis in OTBI using the Workforce Learning – Learning Records Real Time subject area, and I’m looking to better understand how learners r… -
Using Dynamic Hyperlink in Layout Editor (.xpt template)Summary: I have a report using .xpt template / Web layout editor, there is a text Goal Center that I need to convert to a hyperlink so users can go directly to My Team >…Carlo Reyes-59977 67 views 0 comments 0 points Started by Carlo Reyes-59977 Reporting and Analytics for HCM -
Is there a way to know who changed Password and when?Summary: We would like to know if there are any tables that store information about users' passwords Content (please ensure you mask any confidential information): Hello…Giuseppe Casalino 63 views 7 comments 0 points Most recent by Giuseppe Casalino Reporting and Analytics for HCM -
Report that shows job requisition salary vs job offer salary.Hello I am trying to pull together a report that compares the requisition salary and the job offer salary filtering only on requisitions that are filled. I am unable to …HCM_Dot 130 views 12 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Can employee view performance evaluation without manager clicking "Share and release?Summary: HI can we make the performance document automatically shared once the manager submits the evaluation task? if I remove share performance document from the proce…Mohammed Alharbi 13 views 1 comment 0 points Most recent by SAI KOMATIREDDY Reporting and Analytics for HCM -
Can we disable or hide the “Delete” action from Progress NoteSummary: Hi Is it possible to remove “Delete” action from Progress Notes ? Content (please ensure you mask any confidential information): Version (include the version yo…Mohammed Alharbi 11 views 2 comments 0 points Most recent by SAI KOMATIREDDY Reporting and Analytics for HCM -
RTF Template: Achieve Distinct Values in RTF TemplateSummary: RTF Template: Achieve Distinct Values in RTF Template Content (please ensure you mask any confidential information): Hi Team, I have an extract where location a…UrvashiJ 511 views 1 comment 0 points Most recent by Basavaraj Navalagi Reporting and Analytics for HCM -
Required table for "Direct Apply" section under the task "Recruiting Category Enablement"Summary: Hi Team, We are unable to find the table for the field "Direct Apply" under the setup task Recruiting Category Enablement. The main table are IRC_TP_PARTNERS, I… -
How to fetch Audit reports under tools or how to schedule the audit report and get data on a dailySummary: Hi Team, I need to fetch audit data, I am able to export the data from the audit report under the tools, how to schedule this report on a daily basis or help me…nanda.patil 201 views 3 comments 1 point Most recent by Ashwin Sinha Reporting and Analytics for HCM -
OTBI column formula help - change days to working daysIn my report I need the following column formula to calculate 5 working days (not 5 days as it does now) and leave out Saturdays and Sundays. Any help would be great. CA…Tracy Goodchild 2 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Percentage of Employee With and Without Goals not showing properly in columnsSummary: Hello again, I need help to check my case statements. The % of employees with and without goals are not reflecting properly. CASE WHEN "Workforce Goals - Goal S…Marilyn O 22 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How can we display different Infolet tiles based on each page?Summary: Is it possible to display difference Infolet tiles based on page (e.g., Me, My Team, My Client Info)? Can EL expressions solve this problem? If so, please provi…Nipon 13 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Grade Validation During Offer CreationSummary: Recruiters should only be able to select the same or a lower grade than the Job Requisition grade. An error should be triggered if a higher grade is selected. W… -
Is it possible to add a field to an OTBI analysis that uses sql to query the underlying oracle tableSummary: We have an existing OBTI Analysis that reports on candidate from ORC. We need to add that a field from the Extra Info section of the candidates profile, the Des… -
Reporting on Payroll Balances with a Time Definition DimensionSummary: Hi, we have a number of payroll balances defined which utilise element allocation functionality and have a 'time definition' dimension i.e. _REL_BD_TDPTD. The t…Jon Taylor 13 views 2 comments 0 points Most recent by RJH.CC.gov.uk Reporting and Analytics for HCM -
Mass Download of Document Records errorsSummary: Can you get details on the skipped downloads or those with errors? Content (please ensure you mask any confidential information): This is in the log file: Total…Stephen Jones 12 views 1 comment 0 points Most recent by Stephen Jones Reporting and Analytics for HCM -
Week Number calculation for OTL Overtime report if week starts from saturday and end on fridaySummary: Hi Team, We need to calculate the weeknumber for a overtime card report. Week will start from saturday and end on friday We need to pass "from week" and "to wee… -
which table has the information of Legislative Categories for Manage legala AuthoritiesSummary: Hi Team, We need a table where the information of Legislative Categories stored for Manage legala Authorities. We have the table HZ_PARTIES to get Legal authori…Opkey PA 11 views 1 comment 0 points Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI) -
How to report Job Details > Action reason in OTBISummary: We use the 'Action Reason' field in Workforce Structures - Job Details to record why we created or updated a job. We would like to be able to report on this fie…Lachlan Tanner-283818 61 views 9 comments 0 points Most recent by Kayla Malecki Reporting and Analytics for HCM -
User unable to run OTBI report but could in the pastSummary: All of a sudden this user is not able to run reports specific to ORC. I cleared the server cache but it's still not working. Any ideas prior to logging an SR? C…THawkins_LGI 42 views 15 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
Area of Responsibility in Redwood Compensation pages (Salary History, Change Salary)Summary: Hi Experts, We recently enabled Redwood in our test instance and it appears that the AOR is no longer being applied to some of the Compensation pages like Salar… -
Job Requisition Audit report neededHi Team, We have a requirement to create a report to bring Requisition Audit report, The client is trying to fetch each transaction that occurs with a requisition , any …Sushant95-Oracle 6 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
📄 OTBI Report to Generate HDL File for Deleting Feedback RequestsSummary: This provides a custom OTBI report built on the Workforce Performance – Requested Feedback subject area. It helps companies generate HDL-formatted data to delet… -
Does exist an official/unofficial presentation for OTBI reporting training?Summary: Looking for OTBI reporting training presentations. Content (please ensure you mask any confidential information): I need to teach the customer how to use OTBI r…Stefano_Mazzocca 21 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BIP HCM Payroll - Is there any alternative to pull the Payroll process statusBIP HCM Payroll - Is there any alternative to pull the Payroll process status apart from below Query /* ( SELECT meaning FROM hcm_lookups WHERE lookup_type = 'ORA_HWM_PA…BhaskarDondapati 299 views 10 comments 0 points Most recent by Sunil Makam Reporting and Analytics for HCM