Global HR
Discussion List
-
Custom Criteria Person Security ProfileSummary: Hi all I've created a custom role and created a Person Security Profile which is secured by Area Of Responsibility, and the scope of responsibility is Organizat…Nicolas-Vahman 4 views 0 comments 0 points Started by Nicolas-Vahman Reporting and Analytics for HCM -
Help Needed: Retrieving Current Address for a Legal EntityHi Everyone, I'm trying to retrieve the current address for a Legal Entity, but I'm facing challenges in identifying the correct tables and joins. Context: I understand …Saurabh_Mharolkar 48 views 8 comments 0 points Most recent by Saurabh_Mharolkar Reporting and Analytics for HCM
-
Database Table name for Approval DelegationsSummary: We have a requirement to build a report for approval delegations, thus need the database table name for Approval Delegations. Navigation: Person Management > Se…JainSamyak 52 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Emergency contact detail access via BIP reportSummary: Emergency contact detail access via BIP report Content (please ensure you mask any confidential information): Hi, We've built a BIP report to give emegency cont…Bhavna-Civeo 6 views 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Feedback center manager email and BPM notification content mismatchHad an issue in Notifications content display - We have enabled and customized the template - /Shared Folders/Human Capital Management/Workflow Notifications/NoteSentToM…Challa Ramya-Oracle 5 views 0 comments 0 points Started by Challa Ramya-Oracle Reporting and Analytics for HCM
-
In which table can I find the Proposed Worker Type field in Workrelationship?Hi, I want to add the Proposed Worker Type field on the person screen to my report as in the screenshot below, but this information returns an id in the per_all_assignme…Cansel Karasoy 1.2K views 7 comments 0 points Most recent by User_E31A6 Reporting and Analytics for HCM -
Unable to enable the ORA_OARS_VB_NAVIGATION_ENABLED profile option.Summary: We had previously raised an SR with Oracle regarding a REST action error on the My Team Activity Center (Redwood) page. The solution provided was to set the ORA…Hamsa Lekha E B-Oracle 10 views 2 comments 0 points Most recent by Hamsa Lekha E B-Oracle Reporting and Analytics for HCM
-
Adding additional column to get headcount for each month in OTBISummary: How to add additional column or calculated item to get the head count for every month? Content (required): I am using 'Workforce Trend Real time Subject Area' a…Raghavendra M 320 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is there any way to get back the archived transactions related workflow transactionsSummary: I want to get the information on archived transactions details. Content (please ensure you mask any confidential information): Recently we have click on archive…VishnuVardhan Raju 3 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
From which tables can I get the Workflow details of transactions archived in transaction console.Summary: Tables to get the Workflow task details of transactions archived in the transaction console. Content (please ensure you mask any confidential information): Vers…JSAHOO1988 4 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Table for proposed Projected end dateSummary: Hi All, We have a requirement to create a report in which we want to capture Current Projected End Date and Proposed Projected End Date. We are unable to find i…VishalDhane_HCM 8 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need query to get scheduled process details such as process name, scheduled time, parameters.Summary: Need query to get scheduled process details such as process name, scheduled time, parameters. Content (required): I need query where I can get count of active s…Swati U 3.4K views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
BIP Report - Certification File Attachment - Assemble URL for downloading attachment from reportGreetings, During Auditing, our desire is to be able to quickly download any Certification attachments direct from the BI Report results. I'm trying to create SQL for a …Michael_Burgett 3 views 0 comments 0 points Started by Michael_Burgett Reporting and Analytics for HCM -
How to identify edited DOR in BI reportsHow to identify edited DOR in BI reports?Nivya Mathire 21 views 5 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
Fusion table for Employee Vacation and Delegation rulesWe want to develop a custom BI Report for Employee Vacation and Delegation rules. However, we are currently facing some challenges in identifying the correct tables that…Srikanth Nakka 11 views 0 comments 0 points Started by Srikanth Nakka Reporting and Analytics for HCM
-
How to make comparison between dates in FFSummary: Content (please ensure you mask any confidential information): Hello experts, we built the below FF. However it seems not working the highlighted condition in b… -
OTBI Data Security Not Aligning with HCM UI Security ProfileDear Team, We have a business user who has been assigned a security profile that restricts access to view only employees within a specific AOR or Legal Entity. This secu… -
OTBI to fetch adjusted service dates from Work relationshipSummary: Hi everyone, We are trying to fetch the adjusted service date field from the employee work relationships page service dates section through OTBI. Can anyone sug…Prabha_112 141 views 2 comments 0 points Most recent by Rana Ritesh Kumar Reporting and Analytics for HCM
-
How do you filter on the results of another OTBI analysis in combination with a date prompt?Summary: I want to be able to split workers who are paid and unpaid and break them down by age, BU etc etc. Those who are paid may have additional assignments as non-wor…Diane G123 33 views 9 comments 0 points Most recent by Kayla Malecki Reporting and Analytics for HCM
-
How to get the details like employee user name, person number and employee statusHi Team, We have requirement to see employee user name, person number and employee status in a report. Can anyone help me on this. Regards, RaviRavi-Palacharla-Oracle 130 views 4 comments 0 points Most recent by AMIT KUMAR YADAV Reporting and Analytics for HCM -
Query to make audit on Document of RecordsSummary: Content (please ensure you mask any confidential information): Hello experts, is there a way to track who loaded document of record type and attachments, when t…
-
Query to extract all the updates made on employees assignmentsSummary: Content (required): Hello experts, when accessing the employee assignment page, it is possible to see users making last updates. Is there a query to extract all…Valerio Curzi 793 views 6 comments 0 points Most recent by VivekKumarAgarwal_CZTR1 Reporting and Analytics for HCM
-
Matrix Manager HDL Load shows new manager in UI but not in OTBISummary: We completed an HDSL load of new Matrix Manager assignments for employees. The UI shows the new manager but the OTBI report does not. Reflect the update. Is the…
-
Restore saved OTBI analyses after user name changeHi guys, One of the HR Users of the customer married last weekend. So her name changed, as well as her username changed. On the old user name she stored some analyses in…Katharina_Seidenfuß 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Populate if an employee is a Manager in HCM OTBISummary: I'm trying to create a report in OTBI with the subject area Worker Assignment Real. And in the Worker Assignment folder there is Manager Flag. However all our p…Nicolas-Vahman 41 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
User unable to view Employee's address details in OTBI ReportsHi Experts, We have created a report using the subject area 'Workforce Management - Worker Assignment Real Time'. We got the other cloumn values except city, county, sta…
-
Include min function in value setSummary: Content (please ensure you mask any confidential information): Hello experts, I should manage the attached query in a value set. However in the VALUE COLUMN NAM…Valerio Curzi 31 views 11 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Worker HDL Error A primary assignment already exists.Summary: We are trying to load worker data with historical Data in Dev1. We are getting this error(A primary assignment already exists.)for lot of inactive employees. We…Krishna Manmohan 77 views 3 comments 0 points Most recent by SarthakRohilla Reporting and Analytics for HCM -
Combine multiple Ethnicities in OTBI "Two or more races"Summary: Per the below - we have some Team Members that classify with more than one Ethnicity and the "Two or more race" option is no longer available in Oracle. This is…THawkins_LGI 201 views 16 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
How to embed Dashboard to My Team Page tab?Summary: Content (required): Could you please advise where I can find the instruction on how to embed an OTBI dashboard into My Team as a new tab? Thank you! Version (in…Evgeniya Repnina 193 views 12 comments 0 points Most recent by Vittoria Reporting and Analytics for HCM