Global HR
Discussion List
-
Query to retrieve manager assignment numberSummary: Content (please ensure you mask any confidential information): Hello experts, we need for each employee to retrieve the line manager assignment number. Do you h…Valerio Curzi 119 views 5 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
Can you use "prompted based on results of another analysis" when using presentation variables?Summary: Essentially we need to find the delta/ difference between two analyses that are date tracked to different points in time in the Prefix of the OTBI Analysis usin… -
Query to find BIP report schedule detailsSummary: Query to find BIP report schedule details Content (required): Hi Team, We have requirement to fetch the schedule details of a BIP report like schedule start dat…Vasanthakumar Ravi 2.6K views 8 comments 1 point Most recent by Dev V Reporting and Analytics for HCM -
Columns Missing from the Subject Areas in OTBIwe have 3 OTBI reports showing error in the output, when i checked, some of the column headings are in the report like 1.Deduction Developer DF_QUALIFYING_PEN_SCHEME 2.D…Global Support Desk 21 views 3 comments 0 points Most recent by Global Support Desk Reporting and Analytics for HCM
-
"Report of the day" - Report about all data added/changed todayHello, I am looking for a report, which shows ALL data that have been added/changed by any user in the system per day. We have some troubles with one of our interfaces b…Michael Schweizer 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Transactions Tables are not storing Data for few TransactionsSummary: Hi Team, I am trying to fetch the transaction details for Time Change Request Approval. But I have encountered that there two tables that were not storing any d…Dasari Dileep 283 views 5 comments 0 points Most recent by kanchana venkatasubramanian Reporting and Analytics for HCM
-
I need to update position of employees using HDL w.e.f 1st Feb 2025Summary: Hi There, Can someone help me with the HDL template to update the employees' position with effect from 1st Feb 2025. Appreciate your help! Thanks, Lakshmi. Cont…Lakshmi Devi Bathala 11 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
25A New Feature : View Journeys Analytics - How to hide response Summary buttonSummary: We need to hide the Response Summary button, where Oracle soak testing confirmed this can not be handled by privileges, they told to raise SR and SR redirected … -
Primary keysSummary: Is there any document listing the Primary keys to be joined in the fscm oracle pvo ? Content (please ensure you mask any confidential information): Version (inc…Lauriane Massin Whitaker 21 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for SCM
-
Task Performer name in Workforce Management - Checklist Real Time is blank in OTBISummary: Task Performer name in Workforce Management - Checklist Real Time is blank in OTBI Content (please ensure you mask any confidential information): If the Task pe…AvinashP 21 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Requirement for Custom QuerySummary: Hi Experts! We had a requirement from the customer to have a role which would grant access only to CONTRACTOR records and should satisfy the following condition…
-
Dies anyone know the table and field for "Enrollment Type Description" in OBTI Learning?Summary: Does anyone know is what the table and field that correspond to "Enrollment Type Description" and/or "Enrollment Type" in OBTI. Specifically under "Workforce Le…
-
Can we send alerts to AOR via alert composersSummary: Hi Team, I have a quick query can we share alerts to AOR / role via alert composers Content (required): Version (include the version you are using, if applicabl…priyankatriv 31 views 8 comments 0 points Most recent by ShivaBildikarMGS Reporting and Analytics for HCM
-
Position History ReportingSummary Is it possible to report on changes to positions themselves over a period of timeContent I have a requirement to report on historical changes to positions in OTB…Jo Kelly 222 views 4 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Query to get Position History along with Changed Attributes.Summary : I have a requirement to find out Position History details along with the changed attributes as shown in screenshot below. If anyone have query for this kindly …
-
Calculate FTE and headcount automatically filed nameSummary: Calculate FTE and headcount automatically filed name Content (please ensure you mask any confidential information): In the "Change Assignment" UI, we have "Calc…Visu 23 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
we looking lapsed(Forfeiture) data in all plan types as on dec 2024Summary: Hi Team, we looking lapsed(Forfeiture) data in all plan types as on dec 2024. please find xml of report. Thanks, Ajay Content (please ensure you mask any confid…AjayKumar Maddipati 1 view 0 comments 0 points Started by AjayKumar Maddipati Reporting and Analytics for HCM -
if a journey- checklist is deleted in ORC, what are the ways we can check who has deletedSummary: if a journey- checklist is deleted in ORC, what are the ways we can check who has deleted the checklist. We wish to capture the data of deleted ones Content (pl…
-
Attachments - Deeplink in OTBIHi, Is it possible to have a deep link for attachments in OTBI so that the person accessing the report can view the respective attachments, such as PDFs, highlighted in …
-
how to find the employee tenure of the current position in the report.How to find the employee tenure of the current position in the report.Mohamed Eliyas 11 views 3 comments 0 points Most recent by Mohamed Eliyas Reporting and Analytics for HCM
-
SQL Behind the Package FUSION.PAY_BALANCE_PKG.GET_VALUE_DBIWe are trying to debug one the issue in BIP SQL where they have used the FUSION.PAY_BALANCE_PKG.GET_VALUE_DBI to bring the data from this column. But wea re not able to …
-
Can we use Line Manager Dashboard to build HR Dashboard by removing securityWe want to build HR Dashboard, however most of the metrics are already available in Line Manager Dashboard. So can we re-use Line Manager Dashboard by removing security …RahulMore 32 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Multiple External Identifiers in OTBI would like in separate columns and to include null valuesContent Our organization has multiple External Person Identifier Types that we need to report off of (Taleo ID and Oracle Transportation Management Number). As opposed t…
-
When does the STATE column in table HRC_TXN_DATA changes to 'INITIAL'Summary: An approval transaction is always showing as DRAFT status in the table HRC_TXN_DATA with STATE column having value 'INITIAL'. This transaction is not visible th…Anoop K N 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
document recordSummary: If I upload documents to document records, I want a report to show me the details of the document as entered into Oracle, the ability to filter by document type…Asha Barnes 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to fetch the Initials of the employee using OTBI?How to fetch the Initials of the employee using OTBI?Hazel De Castro 33 views 2 comments 0 points Most recent by Sharon Harper Reporting and Analytics for HCM
-
Report/Tables to extract User Role change History for every role assigned/revoked on a userSummary: Hi Experts, We have a requirement from the customer to track the history of changes on a user roles. Ex, If a user has been assigned a role on 01-Jan then that …Abhinay Singh-Oracle 182 views 1 comment 0 points Most recent by Sharon Harper Reporting and Analytics for HCM
-
BIP Report: Position title change data irrespective of their current employment status.Summary: Hi experts, I am looking for a report which can return previous and current employment fields if position gets changed. Mainly looking out for these fields: Pre…
-
Document record request, details are not reflecting on Supervisor's notification page.I'm raising a Document Record request from an employee user but in supervisor's notification page the document details are not reflecting in the document details column …
-
Generate query related ODA reportsSummary: I want to generate analytics report for responses for specific queries like feedback query to understand bot responses and communication with user to improve pe…