Category 81
Discussion List
-
OTBI Comparison between two tables with the same fields in one tableHello! I would need some help with this idea of an analysis. The idea would be to make a comparison in a single table of two different tables with the same fields. Somet… -
Query For External Record Learning Experience(Non Catalog Learning)Summary: I am unable to find below two fields to fetch a data from 'Record External Learning Experience' screen. Field1: URL Field2: Start Date (Under Completion Detail)…
-
Absence calendar inc work patternSummary: Is it possible to report on work patterns/worker availability in OTBI Content (please ensure you mask any confidential information): Hello With the ability for …Helen Thomas 22 views 2 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM
-
Omar El-sherif 21 views 2 comments 0 points Most recent by Venkat Balasubramanian-Oracle Payroll and Global Payroll Interface (GPI)
-
Does an Agent(OTBI) continue to run even though the user who set it up is inactive?Summary: Is there any way to find out the agents created by a user(Inactive now) in "MY Folder"? Also does an Agent continue to run even though the user who set it up is…Sushant95-Oracle 1 view 2 comments 0 points Most recent by Sushant95-Oracle Reporting and Analytics for HCM
-
Headcount and Termination # for Turnover and ESG reportHi there, We are looking for the columns in subject area to display precise headcount and termination number for Turnover and ESG reports. Below are other numbers which …Yiming Xiong 15 views 2 comments 0 points Most recent by Yiming Xiong Reporting and Analytics for HCM
-
how to edit the resignation workflow notification approve pop upwe have a requirement to edit the pop up message box asked to enter comments when an approver clicks on Approve or Reject in Resignation workflow notifications In the be…Dara Nagasai 49 views 1 comment 0 points Most recent by Mihaela Cojocariu-Oracle Human Capital Management -
BI Publisher : I need to create a report to track the changes on employement for my employeesSummary: I need to create a report to track the changes on employement for my employees with situation before the action and action reason and the situation after the ac…Ayoub AFRASS 22 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Maryellen_Gancena 14 views 3 comments 0 points Most recent by Maryellen_Gancena Reporting and Analytics for HCM
-
BIP - Completed Learnings ReportSummary: Hello, Has anyone tried creating a BIP report that contains all of a learner's completed learnings at a course level? (Completed, Bypass Completed) Below are th…Hazel De Castro 61 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
-
Need to know tables used for storing geographies for use in BI publisher reportSummary: Can someone help me with names of tables that internally store all geography hierarchy information in HCM. I need to use this in my BI publisher report to extra…
-
How can I set the default of a date parameter to the same date in the prior year in Bi Publisher?Summary: Due to leap year, {$SYSDATE()-365$} is no longer working correctly to set the default for a date parameter to the same date in the previous year. Content (pleas…BeachDreamer 199 views 4 comments 1 point Most recent by BeachDreamer Reporting and Analytics for HCM -
Candidate is incorrectly transferred to HR moved to previous phaseWe have an HR report under tools>reports and analytics report name: New Hire and Pending Starts Report - ExternalsNew Hire This report calculates candidates that have be…CharleyT 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Table containing Attestation details for Activities - Oracle BI PublisherSummary: Need to know which tables store the Attestation details for the Learning module, which is available in the Activities section page. Content (please ensure you m…Tom John Bontoyan 11 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM
-
Query for Role – AOR Mapping ReportHi All, We need a query for "Role – AOR Mapping Report". Can someone help to provide the query of this if anyone has already gone through this type of requirement? The f…
-
Primary Beneficiary DetailsSummary: I need to create an OTBI analysis for to get details about one benefit plan including primary beneficiary details. I used the Benefit- Enrollment Real time subj…Ayesha Iroshani 33 views 4 comments 0 points Most recent by Mahesh Sharma Reporting and Analytics for HCM
-
Original Referral SourceSummary: How can we show the original referral source from the candidate's general profile? Content (required): If an employee refers a candidate for the first time the …
-
is there an easy way to extract all the data from a specific table?Summary: Sorry in advance if this has been asked but I have not been able to find a resource to help me. I am looking for an easy way to extract all the data from a spec… -
Termination report pulling last compensation of hourly associates but not salaried associatesSummary: Term report pulling last salary of hourly associates but not salaried associates Content (please ensure you mask any confidential information): Hi! I am in need…Ameya_J 21 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Payroll Results with Details NeededDoes anyone have a query or XLM for a payroll results report that provides the hours and amount by pay element along with the specific pay rate for each element? We are …
-
Historical Benefits Enrollment DataHi I am looking to see if anyone has a report showing historical benefits data by employee (both active and inactive) . Something that will show me all plan election det…
-
In OTBI-Whr to find the Approval Pending with /submitted by/submitted date info in job RequisitionSummary: I am trying to create a pending Job requisition OTBI report, in the subject area Recruiting - Recruiting real time with the requirement in adding information re…Sankaran Lakshminarayanan 1 view 1 comment 1 point Most recent by Sankaran Lakshminarayanan Reporting and Analytics for HCM
-
How to remove these many duplicates of Child Role columnDear Experts, The Below query producing duplicates. Could you please help out me. Query: ============================================================================== S…
-
Null row is occurring in OTBI because of Case statementI am facing some strange issue where null row is getting when i had use case statement one of the attribute as we have multiple phone types and for one of the employee h…
-
BIP report with Excel template output file showing wrong time when compared the value in Data modelHi Al, I am working on a conversion BIP report where I am printing Start Time, End Time in the output file. when I loaded the XML and inserted the fields into the Excel …JP Chandran 21 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How/where can I get a glossary/dictionary of language pack translations for all UI text?Hi We are in process of implementing HCM & Learning cloud for 5 countries in Europe. As part of the implementation, we have a couple of custom reports (BIP) to be genera…Jayant Ankur Kujur 61 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
From which table can I obtain the Manager Overall Rating field?Hi, I want to add the Manager Overall Rating field to a report. Can I do this with SQL? In which table do I find this field? In OTBI, I can achieve this by using the Wor…Cansel Karasoy 236 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Can’t design the RTF file in Arabic layout when the report exceed 64 fieldwhen the report extracted from system the layout starts from the middle of the excel sheet and technical advised that he can’t design the RTF file to start from the (Cel…Omar El-sherif 1 view 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
HCM Table To Fetch BCC Details From Report Job HistorySummary: Need HCM table to fetch BCC details from report job history Content (please ensure you mask any confidential information): Version (include the version you are …puja suryanarayana 31 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM