Global HR
Discussion List
-
Joining Grade/Grate Rate with Job and PositionSummary Joining Grade/Grate Rate with Job and PositionContent I am looking to report Midpoints for Jobs and Positions. Is there a way to join "Grade Rate Real Time" Subj…Andrew_Schmitz 93 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Report - Hourly/Salaried vs Rate Value for the GradeSummary Looking to crate a report to get Hourly/Salaried vs Rate Value for the GradeContent From Person Management - Get If person is Hourly or Salaried. Then navigate t…SD Acush 71 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Issue with Grade Rate Real Time Subject AreaSummary Grade Rate value is not returnedContent We had a requirement to display all workers who has a current salary not equal to the current grade step rate value i.e, …Akash Kiran Jana 26 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Pending Approver when a transaction is claimedSummary: The transaction detail analysis as well as the SQLs do not provide the information of the current approver when a transaction is claimed in case of parallel app…Sowdha Murugan 11 views 1 comment 0 points Most recent by Sowdha Murugan Reporting and Analytics for HCM -
Leader Dashboard for Oracle Cloud HCM 22CHello, Any guidance on where I can find the Out of the Box documentation for the Leader Dashboard for Oracle Cloud HCM, 22C? Thank you, Tanya -
Is there a way to pull service accounts into user admin reports?Summary: Currently our existing user lists only pulls users who are employees in the system. We need to be able to pull a list of all accounts as we have service/generic… -
Parameter definition in reportI will use the last_update_date parameter in the report I prepare. But I want to use the last_update_date column in more than one table in a single parameter. For Ex: pe…Cansel Karasoy 21 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
manager hierarchy analysisSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Bhagyashri_Bhoge 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to add the EEO 4 field from Job to a OTBI report?Summary: Adding EEO 4 field to a OTBI report Content (required): Hello - how can you add the EEO 4 field to a OTBI report? I am able to locate the EEO-1 field but not EE…Jbow 51 views 1 comment 0 points Most recent by Shashank Priyadarshi - Oracle-Oracle Reporting and Analytics for HCM -
Payroll - Calculation Cards Real TimeContent Good Morning, We are trying to find granular details with regards to Pension details. On the front end we can see in a sub-folder called 'Calculation Component D…User_2025-01-28-07-12-45-467 185 views 7 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Report to get employee default expense accountSummary Report to get employee default expense accountContent Hi is there any report which can get what is the default expense account attached the employee please? this…User_2025-01-29-02-09-34-137 104 views 13 comments 1 point Most recent by Isabela Radivoi Reporting and Analytics for HCM -
Effective Date attribute is not getting value from parameterSummary: Effective Date attribute is not getting value from parameter Content (please ensure you mask any confidential information): Hi Team, Greetings! We have the cust… -
Dependable Parameters in HCM ExtractSummary: We have an requirement where we have to add Two parameter in our HCM Extract. The First One would be the 'Business Unit' and next one would be the 'Position Nam… -
Identifying global transfer records, hire/rehire records from per_periods_of_serviceSummary: Identifying global transfer records, hire/rehire records from per_periods_of_service Content (please ensure you mask any confidential information): Hi All, Empl…Gayathri K M-Oracle 882 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Is there a way to get date tracked data for Per_periods_of_service tableI'm trying to figure out the date when the "Actual Termination Date" is changed, but Per_periods_of_service table has top of the stack record only. Is there a table that… -
We can able to load the data in User-Defined Table Business objects but not able to see in frontSummary: We can able to load the HDL data but we can't able to see the data but in backend we can able to see the data. Note: If we entered manually in UDT then we can s…Ravindr-Oracle 113 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Bring back Headcount Data from 12 months agoSummary I want headcount data from 12 months agoContent I have a simple report that sums headcount up and gives me numbers for today however I want to return the numbers…User_2025-01-29-21-02-12-466 115 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Passing values from the UI to parameters in a BI Publisher reportSummary Looking for a method of passing values shown in the UI to parameters in a BI Publisher reportContent I have a requirement to filter a BI Publisher report based o…Ron Nelson 200 views 14 comments 0 points Most recent by Jaison Joseph-Oracle Reporting and Analytics for HCM -
How to make hyper link in one of the column values in BIP reportSummary: I have to establish link between MEANING Column values to the respective bip report . Thanks For Your Help!! RavindraRavindr-Oracle 71 views 3 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM -
Not showing data in OTBI for other line manager type, how can we fix this?Summary: Right now, individuals with the manager type "Cross-Functional Manager" can't access any data about their direct reports in OTBI. The UI is behaving correctly; …Martijn van den Berg 21 views 2 comments 0 points Most recent by Martijn van den Berg Reporting and Analytics for HCM -
Create an OTBI analysis based on Personal Details Quick actionSummary: We have created a new DFF field in Biographical info tab in the Personal Details Quick action page. Content (please ensure you mask any confidential information…Ayesha Iroshani 31 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Need a sql to get "extra info" on "position details" pageHi All, I'm trying to find SQL tables and joins behind getting "Regulatory Licence Information" under Extra Info Section of Position Details. Navigation : Set up and Mai… -
Org levels missing from the OTBI report for the inactive treeWe recently did our restructures and created a new version of the tree. The old version end on 2-Jul and the new version starts from the 3-Jul. Now the Org tree has leve…Girish Bhatia 41 views 7 comments 0 points Most recent by Girish Bhatia Reporting and Analytics for HCM -
How to create User defined table (UDT)Summary: How to create User defined table (UDT) with screen shorts. Requirement: i want to store the below data in User defined table & which table can store this inform…Ravindr-Oracle 31 views 3 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM -
How to FTP file upload to UCM content server via ODISummary: Hi Folks, Content (please ensure you mask any confidential information): How to upload FTP files to the UCM content server via the ODI tool Version (include the…Prakash Jayavel 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to Enable WebCenter Content (WCC) Download Applet ?hi, I got the below document reference. How to Enable WebCenter Content (WCC) Download Applet (Doc ID 1374700.1) Administrator 1. Log into WCC UI as administrator 2. Cli… -
Unable to fetch the Effective Date Parameter in the Extract RuleSummary: Unable to fetch the Effective Date Parameter in the Extract Rule Content (required): We have a requirement to use the Effective Date parameter value in the Valu… -
How to return Geographies using OTBISummary: We want to return Geographies (State, County and City) using OTBI. But the data should not return the geocodes but should return the actual name. Ex: State: LA …RenzelkeithCoquia 1 view 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
HCM native datamodels/bipSummary: are there another schema.table wich sample reports delivered in HCM Cloud are stored to extract a list of them ?? Content (please ensure you mask any confidenti…