Category 81
Discussion List
-
Help with "Guide me" ReportSummary: Hello, I am building a report that fetches information about Grade Ladder, Grade Name, Step Name, and Value. The query itself is not an issue. However, I need t…Matheus Roberto 12 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Need to fetch Resignation/Termination withdrawn after last working dateSummary: Hi, There is a requirement to pull all the employees who has withdrawn the resignation/terminations after the last working day need to include pending for appro…Aruna Aounti -Oracle 3 views 0 comments 0 points Started by Aruna Aounti -Oracle Reporting and Analytics for HCM -
Dashboard prompt for effective date reporting possible?Summary: Hi all, I have added SET VARIABLE PARAM_EFFECTIVE_DATE = '@{P_DATE}{@{system.currentTime}[YYYY-MM-DD]}'; into the advanced tab under prefix for a OTBI analysis …Ian.Gooderham 136 views 8 comments 0 points Most recent by Ian.Gooderham Reporting and Analytics for HCM
-
Recruiting Real Time: Application Questionnaire reports take several minutes to generateSummary: When trying to run a basic query from RRT Application Questionnaire, it takes several minutes to run the query. Does anyone have ideas on how to improve reporti… -
How to use GET REST API call to get the candidate data based on candidate emailHi Team, We are trying to pull the candidate data using GET REST API call, is there any way to to get the candidate data based on candidate email. GET: /hcmRestApi/resou…
-
No Participants - Hyperlink to be changed to “Additional Feedback”Summary: The requirement is to have 0 to 1 participants responded/No Participants - Hyperlink to be changed to “Additional Feedback” Content (please ensure you mask any …
-
How to add custom paramter based on other custom parameter in Dashboard PromptHi Team, I need to create custom parameter with formula based on the value from the other custom parameter with formula. Category and Sub cateogry - both are from same f…Harish S 13 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How i can improve the running time for one report?Summary: Misdated Payroll Relationship timming out I used this formula: CASE WHEN "Payroll Assignment"."First Standard Earning Date" = MIN("Worker Payroll"."Payroll Star…ClaudiaManea 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to Include the Weekends and Public Holidays in the OTBI dashboardSummary: How to Include the Weekends and Public Holidays in the OTBI dashboard to the below code snippet. Content (please ensure you mask any confidential information): …Harish S 19 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Issue with Dependent Filters and Multiple Selections in BIP Report for CoursesSummary: Hi Team & @AshishERPCloud, I have created the BIP report for the Courses. Where I have given the filters of Course, Offering, Business Unit, Start and End Dates…Dasari Dileep 45 views 2 comments 0 points Most recent by SAI KOMATIREDDY Reporting and Analytics for HCM
-
Issue with employee's line manager compensation plan approval status SQL querySummary: Content (please ensure you mask any confidential information): Hello experts, we built the following query by filtering for an employee for testing purposes: se…Valerio Curzi 2 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
SQL query to retrieve compensation plan status at the employee levelSummary: Content (please ensure you mask any confidential information): Hello experts, I need to track for all employees the status of their line managers compensation p…Valerio Curzi 296 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to display the filters in a BI Report, in multiple rowsSummary: How to display the filters in a BI Report, in multiple rows Content (please ensure you mask any confidential information): Hi, we built a BI Report, entering se…Barile Alberto 12 views 1 comment 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
How to add Business Title from Worker Assignment Realtime in User System Usage subject area?I have created an analysis under User System Usage subject area. However, upon adding Business Title column from Worker Assignment Realtime subject area, data became emp…Welsey 13 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to trigger notifications to the Mobile Numbers instead of Email IdSummary: Hi Team, We know that the notifications will be triggered to Email IDs through bursting and the customer asks to trigger the notifications to the employee's mob…Dasari Dileep 1 view 2 comments 0 points Most recent by Dasari Dileep Reporting and Analytics for HCM
-
expiry date for tasks under journeys are not populating in the backend table for few recordsSummary: Hi Community, we have a requirement to populate expiry date of the allocated task for journeys of an employee,where in the UI it shows the epiry date and not po…
-
bip query is very slowSummary: I have written a BIP query which runs fast in SQL Connect using one bind variable. When placing the query into a BIP report there are no issues but the query so…JDCal 62 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Issue on value set retrieving custom field in person profileSummary: Content (please ensure you mask any confidential information): Hello experts, we created a custom value set retrieving a custom attribute in person profile. At …Valerio Curzi 1 view 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Cannot retrieve Manager IDSummary: Content (please ensure you mask any confidential information): Hello experts, I've created the attached value sets retrieving the employee Manager ID. If I laun…Valerio Curzi 12 views 3 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM
-
Importing Oracle JET Visualizations in OTBIWe have an ask from the Customer if we can import Oracle JET Visualizations in OTBI We checked the above link to explore Oracle JET Visualizations but not really sure on…Chinmay Gharpure-37456 12 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Help on manager hierarchy fast formulaSummary: Content (please ensure you mask any confidential information): Hello experts, I need to replicate the line manager hierarchy in compensation plan. However, we s…
-
Query retrieving manager job nameSummary: Content (please ensure you mask any confidential information): Hello experts, how can I retrieve the line manager job name? I've used the following query but th…Valerio Curzi 100 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Query to retrieve employee Job nameSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample SQL query retrieving the employee Job name visible in the ass…Valerio Curzi 340 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Error when copying a report shortcut to another folderSummary: We are trying to setup a folder containing shortcuts to reports that are located in various folders across the OTBI tool, in order to simplify access to commonl… -
Succession Plan Report IssueHello there, We are trying to create an OTBI Report on Succession Plan Details .We have attempted to use all related subject areas for succession plan , but we keep enco…prags 21 views 3 comments 0 points Most recent by Melanie Mahon-Oracle Reporting and Analytics for HCM
-
Customize- Payroll Register Report for the Latest ProcessSummary: Can we add additional attributes by customizing the seeded extract "Payroll Register Report for the Latest Process". Content (required): Can we add additional a…Mohan Murali 134 views 6 comments 1 point Most recent by Nithya_Bussety-Oracle Reporting and Analytics for HCM
-
Termination Approval Process ReportHi… does someone have a report, either an OTBI or BIP, that captures the full termination process with comments, who it is/was assigned to, and status. We are having iss… -
Payroll-Personal Payment Details Real Time - no data being returnedSummary: Trying to build a report showing employee bank account details from SA 'Payroll-Personal Payment Details Real Time' - I have the required roles (Payroll Mgr etc…
-
If a EFF does not have a value is there a way to pull it into reporting?Summary: We have some positions that have Extensible flex fields entered for Background checks and Licenses - but some of the positions do not have this yet (so essentia…THawkins_LGI 61 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM