Category 81
Discussion List
-
Required Table or SQL query to get Criteria under Manage Statement Groups in Workforce compensationSummary: Hi, We are stuck to get the details for Criteria details under Manage Statement Groups in Workforce compensation plan in Compensation Module. Please help us to …Opkey PA 6 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Looking for a Custom Audit report showing old and new valuesClient is looking for a custom audit report build through BI which shows the old and new values.Meenakshi K 10 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI result to show in one lineDear Team How to show the OTBI result in one line, instead of showing them in multiple lines?Surendar 3 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Can we set the absence accrual repeating period to daily?Summary: Can we set the absence accrual repeating period to daily? I tried searching for the delivered Daily Calculation repeating period in the absence accrual plan, bu…Shannon Teves 9 views 1 comment 0 points Most recent by Kanimozhi N-Oracle Reporting and Analytics for HCM
-
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 60 views 3 comments 1 point Most recent by Stephanie McInnes Reporting and Analytics for HCM
-
Accruals on Payroll Activity ReportSummary: Payroll Activity Report is pulling PTO Accruals as of Inception to Date for Rehires which is incorrect. Content (please ensure you mask any confidential informa…
-
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…
-
Performance Document Acknowledgement Task Status and Completion DateSummary: We're using the Oracle Cloud HCM Talent Management > Performance Management performance document to manage and document performance improvement plans (PIPs) and…Angie Elliott 24 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM -
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…
-
Help with Extracting L1/L2/L3 Managers in ReportsHi, We’re working on extracting L1/L2/L3 manager hierarchy using the standard logic (e.g., PER_MANAGER_HRCHY_DN). In most cases, the extraction works fine — but in speci…
-
When I add filter to query the report goes in timeoutSummary: Slow learning (WARF) query Content (please ensure you mask any confidential information): I have the attached query. Everything works just fine without the fina…Stefano_Mazzocca 7 views 0 comments 0 points Started by Stefano_Mazzocca Reporting and Analytics for HCM -
I am looking for a way to report scheduled hours for each employee for each pay periodSummary: I need to compare reported hours vs. scheduled hours Content (please ensure you mask any confidential information): Version (include the version you are using, …Jennifer Johnson 6 views 0 comments 0 points Started by Jennifer Johnson Reporting and Analytics for HCM
-
Transaction being created while BIP report is runningSummary: We have created a custom BIP, the report takes 15 minutes to completed, while the report is running the users create additional transactions which were not ther…
-
Expected Effort values not populatingHi team, We are experiencing an issue where we receive really inconsistent results for the 'Workforce Learning - Learning Records Real Time' Expected Effort value. Some …
-
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
-
Query to fetch Run Result Element Entries & Balances for particular time periodSummary: We have a requirement to pull element entries & balances from Run Results for the particular time period. I have written the below query but which is giving mul…Manoharan 8.5K views 9 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Latest data changes are not reflecting in the OTBI report immediatelySummary: Hello All, We have an AOR drill-down OTBI report, but the latest changes to data are not reflecting immediately. For example, when we assign an AOR to an employ…Nusrat Shaheen 68 views 8 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Fast Formula for getting balance avail date in Oracle Absence Management?Summary: fast formula for getting balance avail date in Oracle Absence Management Content (please ensure you mask any confidential information): I need a fast formula fo…Ruvina Khan 13 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
Blank Specialization Sections and Activities from Workforce Learning - Learning Records Real Time.Summary: When using the Workforce Learning - Learning Records Real Time Subject Area we are getting Blank values for the Specialization Sections and Activities. We are u…David Bean - BW 96 views 7 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Workforce Learning - Learning records Real time returns no dataSummary: Workforce Learning - Learning records Real time returns no data Content (please ensure you mask any confidential information): Hello I am trying to build a repo…
-
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 11 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BI Publisher Workflow Notification – Show/Hide Fields Based on Logged-In User for NotificationsSummary: Hi, I’d like to know if it’s possible to configure a BI Publisher Workflow Notification to dynamically display or hide certain fields based on conditions relate…Matheus Roberto 15 views 0 comments 0 points Started by Matheus Roberto 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 3 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
SQL query or Table for Dynamic Columns data under Configure Assignment Segments in CompensationSummary: Hi, We could not find the tables name or query for Dynamic Columns data under Configure Assignment Segments in Worforce Compensation plan What is the table name…Opkey PA 9 views 1 comment 0 points Most recent by Gail Langendorf-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 14 views 0 comments 0 points Started by Vasanthakumar Ravi Reporting and Analytics for HCM -
How to perform conditional formatting on Excel template when old value is not equal to newSummary: I have built a Changes only extract to get the employee Demographic information and getting data in Excel format in separate sheets. First sheet contains new hi…Sreenivasulu Kaveti 14 views 0 comments 0 points Started by Sreenivasulu Kaveti Reporting and Analytics for HCM
-
Can't add column prompt in OTBISummary: Hi, I have an analysis with 3 subject areas. For some reason I'm not being able to add a column prompt to my analysis, the only option is to add a Currency prom…
-
SQL to fetch the Target Proficiency field in the Performance DocumentHello Experts, I am currently creating a report for Core Competencies, and I am having a hard time searching for this specific field in the performance document page Doe…Joliver Caangay 15 views 0 comments 0 points Started by Joliver Caangay Reporting and Analytics for HCM
-
OTBI report for role , Security Context & Security context Value access assigned to userSummary: Creation of OTBI report for role , Security Context & Security context Value access assigned to user Content (required): HI Team, We have one requirement to cre…Rohit Kumar Singh 454 views 7 comments 1 point Most recent by SirilG Reporting and Analytics for HCM
-
Is anyone else getting a geospatially error in their Payroll Validation Report?Summary: In the Payroll Validation report, we are getting this error for all employees in the first pay cycle since going live on 25C: "The address couldn't be validated…