Global HR
Discussion List
-
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 41 views 1 comment 0 points Most recent by Srikanth Nakka Reporting and Analytics for HCM -
How to disable the download option of Increment Letter posted in DORSummary: We have requirement to post the Increment letter from custom BIP via extract to post in the DOR of employee. However we would like to have the option of downloa…
-
Incorrect "created_by" values in table PER_USER_ROLESWe have identified an issue in the PER_USER_ROLES table where the value in the CREATED_BY column does not reflect the actual user who assigned the role. Most of the time…ReEDCarolineW 21 views 1 comment 0 points Most recent by Jun Ye-Support-Oracle Applications Security
-
Document of Record : Salary Certification - QR code generationSummary: We have a requirement from the customer to generate a salary certificate letter from Oracle Fusion HCM that includes approval. The letter must include an auto-g…Gundllapally Sagar 133 views 2 comments 1 point Most recent by Showstopper09 Human Capital Management
-
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…
-
Custom BI Report is getting time out error while trying with client loginHi, I am facing issue with one of my Global HR Custom BI Report is getting time out error while trying with client logins but it is successfully executing with developer…
-
SQL query to retrieve Division Name and Manager division display nameSummary: Content (please ensure you mask any confidential information): Hello experts, I need to extract the Manager Division full name field and the Division name as we…Valerio Curzi 532 views 5 comments 0 points Most recent by Yahya Khan Reporting and Analytics for HCM -
Query to get ESS job details which are running more than 24 hoursSummary: Query to get ESS job details which are running more than 24 hours Content (required): Query to get ESS job details which are running more than 24 hours, I need …
-
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.4K views 8 comments 0 points Most recent by User_E31A6 Reporting and Analytics for HCM -
How to filter out Contg Worker in Analysis | Workforce Management-Absence Calendar Details Real TimeSummary: Subject Area: Workforce Management - Absence Calendar Details Real Time Question: How can I filter out/ not include Contingent Workers in Analysis ? System Pers… -
Workforce scheduling: can't get details of patterns and shifts to show on analysisSummary: Looking for direction on how to find and capture the patterns and shifts in my analysis. Under Define Availability: Work Shifts, Work Workday Patterns and Work …MissHeidiJ 64 views 3 comments 1 point Most recent by Stephanie McInnes Reporting and Analytics for HCM
-
Redwood Communication info is not loading in Hire an Employee TaskSummary: Hi The Communication info in Hire an Employee action is not loading or showing is there an issue with the VBS configuration? other pages are loading fine. All a…
-
report /audit to track any changes done to auto provisioning rules(HCM role provisioning rules)Summary: We need to get a report /audit for any changes done to auto provisioning rules(HCM role provisioning rules). Please help us on how to achieve this requirement. …Jagadesh S 84 views 5 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to get current timezone as of date in server variable CURRENT_DATE_REP_OTBISummary: How to get current time zone as of date in server variable CURRENT_DATE_REP_OTBI. I am trying to get the correct metrics on the headcount dashboard and what i o…Revanth.Rondla 12 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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 7 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Unable to Retrieve Qualified Entitlements Plan Details Using OTBISummary: Unable to Retrieve Qualified Entitlements Plan Details Using OTBI Content (please ensure you mask any confidential information): Hi Experts, We have a requireme…Vasanthakumar Ravi 11 views 0 comments 0 points Started by Vasanthakumar Ravi Reporting and Analytics for HCM -
How to get users logged on info in HCMSummary: User session info required Content (required): Need to get logon info for users. Seems to be a few posts but not a concrete answer. FND_SESSIONS seems to hold t… -
Guidance Needed: BI Report with After Data Event Trigger in Oracle Fusion HCMSummary: BI Report with After Data Event Trigger in Oracle Fusion HCM Content (please ensure you mask any confidential information): Hello All, We have a requirement to …Vasanthakumar Ravi 26 views 1 comment 0 points Most recent by Nathan CCC 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 42 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 55 views 4 comments 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 7 views 0 comments 0 points Started by Challa Ramya-Oracle 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 14 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 352 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 8 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 3 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.7K 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 2 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 24 views 5 comments 0 points Most recent by Satyam Roy 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…