Category 81
Discussion List
-
Terminated employee still visible as incumbents in position, how to free the vacant positionSummary: Terminated employee still visible as incumbents in position, how to free the vacant position Content (please ensure you mask any confidential information): Vers…Abdelhafid Rhofir 171 views 12 comments 0 points Most recent by User_VCD7M Reporting and Analytics for HCM -
Reverse the BIP Analytics Folder OwnershipHello IS there a way/process to reverse the folder ownership that was set to specific Folders. Say User A created the folder and User A was the Owner of the folder. Now,…
-
Identify persons active both as Employee and Contingent WorkerSummary: I have a requirement to identify employee records that have a User Person Type "Employee" AND a User Person Type "Contingent Worker" where Assignment Status Typ…JHaden3 167 views 5 comments 0 points Most recent by Gopinath.Ulaganathan Reporting and Analytics for HCM
-
Display Formatted Job Description Details on OTBI or BIP ReportSummary: Display Formatted Job Description Details on OTBI or BIP Report Content (required): We are trying to display Formatted Job Description Details onto an OTBI repo… -
Using the results of an OTBI analysis to pass value to a second analysisSummary: I built an offer dashboard for our Talent Acquisition team to determine what we should offer internal candidates. The goal is to help them understand an appropr…Monique 25 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
What table stores reports that have hdl templates and hsdlSummary: I want to list all BIP reports that have HDL templates and list all HSDL templates. Is there a table backend that I can use or subject area that can pull this i… -
Table Names/ SQL Query to fetch the data for Other compensation from Manage OfferHello All, Someone please help on how to know the table for other compensation which can be found from MyClientGroups> Quick Actions> Manage Job Offer Please see below S…Joliver Caangay 46 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Incorrect drill-down results (action link to BI content) when using UNION in OTBI AnalysisI've written an analysis against the Workforce Goals - Goal Status Overview Real Time subject area. I had to use a UNION to accommodate some complex criteria and breakou…Shawn Gertler 11 views 6 comments 0 points Most recent by Shawn Gertler Reporting and Analytics for HCM
-
Re-Activate the Inactivated Banks/Bank Branches with HDLSummary: I used the HDL option to inactivate the banks, but I intended to update the names and bank codes before doing so. Unfortunately, when using HDL with an end date…
-
How do I report on the field 'Order Reference'In Court Order Calculation Card page, I need to report on the Order Reference field - how and where can this be found?Helen Tilling 1 view 2 comments 0 points Most recent by Helen Tilling Reporting and Analytics for HCM
-
BIP Scheduled Trigger Failing - Help NeededSummary: Hi all, I'm trying to add a schedule trigger to my BIP report that's currently scheduled, but when it runs with the code, it fails with the following message: D…
-
Report to pull all Payroll balances to move from one TRU to anotherSummary: Does anyone have a report they have used in the past to pull all balances for an employee, in order to do balances adjustments due to incorrect TRU? Content (pl…
-
Reporting on assessment attempt scores when there's more than one assessment in the offeringSummary: I need to report on the score achieved for each attempt within an assessment however I find that if an offering contains more than one assessment activity, the …
-
Sql query listing transactions with 'Pending' status with transaction tablesI want display_name and person_number information of records in 'Pending' status from transaction tables.Is there a sample query you can share?Cansel Karasoy 688 views 6 comments 0 points Most recent by Nitin Kashiv-Oracle Reporting and Analytics for HCM -
How does the per_person_names_f_ audit table get populated?Summary: I am creating a report to audit name changes in our system. This is so we can see where corrections happened, deletions etc. I have been using the per_person_na…
-
Display a Document of Records Image in a BIP ReportHi all, My customer has a requirement where they need to see a report that includes a Document of Record image (passport photo) in a BIP RTF report. Has anyone managed t…
-
Add custom logo in a Workflow NotificationHi, I customize the RTF of CmpWkstApproval Notification. I add an image in the RTF, the image is visible when i run the report but the image is not visible when the noti…Camilla Crescenzi 82 views 4 comments 0 points Most recent by AP0410 Reporting and Analytics for HCM
-
How attach more than one PDF file into an alert custom (e-mail)Summary: How attach more than one ".PDF" files into an alert custom (e-mail) Content (please ensure you mask any confidential information): Hi to all, our client asked u…
-
BI Publisher - RTF Template - FontSummary: Hi Everyone, I am developing the Offer Letter and Employment Agreement for my client using BI Publisher. Since they are using numbering, and under the original …
-
What is the relationship between hrc_txn_header and gl tablesSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): 23A Code Snippet (add any code snippe…
-
Employees with Manager Change can be viewed in OTBI by the old manager?Summary: OTBI report with the following info: Employees info + performance ratings + worksheet manager name info. This report has been delivered to managers. If an emplo…Oriana L. 2 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to get employee's co-worker-style contactsSummary: How to get employee's co-worker-style contacts Content (please ensure you mask any confidential information): Hi Experts, Is there any query/tables to get emplo…
-
Query for State Tax Withholding details for all statesSummary: Hello! I am looking for the BI query for State Tax Withholding. Thank you in advance! Content (please ensure you mask any confidential information): Version (in…
-
Report on candidate log-ins for experience siteSummary: We have a requirement to identify the last time a candidate logged into their candidate profile through the external career site. Is there a reportable field in…Audrea Miller 1 view 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Supplier Portal InquirySummary: Looking to create an Inquiry Only Supplier Portal role to support supplier portal vendors requiring inquiry to their Invoices, Payments, PO and Supplier profile…dgeryol 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to display Name given Person Number.Summary: We have a DFF tied to Department that has the Person Number of the Executive overseeing the department. The name of the executive (not just Person Number) is of…
-
How to identify Overdue Onboarding TasksSummary: I'm writing an analyses using the subject area Workforce Management - Checklist Real Time. I can see tasks that are incomplete, but I need to report only on tas…
-
Annualized Full-Time Salary the same value as Annualized Salary for those with <1.0 FTESummary: Within the Compensation - Salary Details Real Time there is an option to pull in both the Annualized Salary and Annualized Full-Time Salary. When checking this …
-
How do we get the Pay Period Month , Year , Max Gross Pay MTD in OTBISummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to insert an report dashbaord on a redwood page?How to include or embed an OTBI report/dashboard on a Redwood pageVaishnavi Phulsay 49 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM