Category 81
Discussion List
-
calculate the past experience in HCM BI ReportSummary: calculate the past experience in HCM BI Report Content (required): My client requirement is to calculate the past experience and current organization experience… -
Measurement to sum Actua Effort for yeach years starting from Current_DateDears, i've been trying to create performance tiles based on following measurements so to have sum of actual effort for the last 3 years splitted by years: Sum of Actual…
-
Total Salary by Division for the first of each month - OTBISummary: I feel like maybe this is very obvious and I'm overlooking it. But here it goes: We want a report that total salary for a given division on the first of each mo…Monique 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Cannot Modify Chart Properties on BI Publisher for WordSummary: I am trying to edit an rtf document using BI Publisher for Word to increase the size of the chart and the font. When double clicking on the graph/chart to displ…Johnna Balane 121 views 3 comments 0 points Most recent by User_Sathishkumar Sundaresan Reporting and Analytics for HCM
-
In which subject area can I find 'Business Title'Summary: I need to create a report/analysis, showing all assignments, where job is not equal to Business Title. Content (required): I have started on an analysis with su…Morten Graae 528 views 4 comments 0 points Most recent by Stela Martins-Oracle Reporting and Analytics for HCM
-
Custom Error message on OTBI Reports / Dashboard Reports DisplaySummary: We need to display the custom error message on OTBI reports. Please provide the workaround for this. Content (required): OTBI Reports / Dashboard Reports - Disp…
-
"Selected Performance Goals Report" does not display the correct goal plan end dateSummary: I believe there may be a bug with this report, where the SQL is selecting the wrong Goal Plan End Date. While the OTBI subject areas (i.e. Workforce Goals - Goa… -
Absence - Shift start and end time can be 24 hours format ?Summary: In the Create Work Shift page(Set up -> All tasks -> 'Work Shifts' -> Create Time Shift -> Start Time), the current system allow us enter the time in the HH:MM …Faqir 81 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
ORA-01830: date format picture ends before converting entire input stringSummary: Getting above error while running query with date parameter instead of parameter if i give sysdate it is working fine Content (required): Version (include the v…Narendar Rao Naineni 533 views 2 comments 0 points Most recent by Narendar Rao Naineni Reporting and Analytics for HCM
-
How to create a report with manager management levelSummary: report with manager management level Content (required): Hi, I need to create a report with every employee of my company and relavite manager. I need also to re…Alberto Americi 109 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Deep link for a reportI have created a new page entry under "My Team" and i want a report to be triggered when someone clicks on that. Screenshot attached. How can i obtain the link to a repo…Girish Bhatia 22 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Report on Prior Visa InformationSummary: I needed help with BIP SQL code that can help me extract prior visa information for employees. Content (required): Currently if an employee has multiple visa in…Rohan Fernandes 21 views 8 comments 0 points Most recent by Rohan Fernandes Reporting and Analytics for HCM
-
Payroll-Personal Payment Details Real Time Target Bank Account is Null but not "IsNull" in the fieldSummary: Content (required): We are trying to find all the employees that have missing Bank Account Numbers or Bank Sort Codes We are currently using Payroll - Personal … -
Sample Payload for Update customer account via SOAP UI.Summary: Want to change the status of customer account from Active to Inactive. Content (required): Version (include the version you are using, if applicable): Code Snip…
-
Poor performance with CASE statement and sub-querySummary: Custom analysis with CASE statement extremely slow Content (required): Good afternoon, I have created an OTBI analysis that yields the names of line managers wh…ammiano 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
tables for state tax and local tax setup in hcm cloudSummary: looking the tax class,tax_type,max_gross based on the tax class Content (required): Version (include the version you are using, if applicable): Code Snippet (ad…
-
Change Assignment without Salary update included in the compensation salary audit reportSummary: Change Assignment without Salary update included in the compensation audit report. Why would this be included in the compensation salary audit report if salary …
-
BI tables to extract Contract attributesSummary: Content (required): Hello experts, which table allows me to extract PER_CONTRACT_LEG_DDF attributes; Italy Context? We need to retrieve the highlighted fields f…Valerio Curzi 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Are any specific role or privilege or job is required to access service infolets.Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Arpita Maitra 6 views 2 comments 0 points Most recent by Arpita Maitra Reporting and Analytics for HCM
-
Audit ReportHi Experts, Can we have an audit report in the system on employee details change which included any change relevant to employee assignment, DOR and personal info etc.
-
Job Code Usage ReportIs there a report shows the last time an associate was in a given job code. We have a number of job codes with no one in the title. It would be helpful to know if the jo…Rebekah Gilday 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Emergency Contact and Employment Info ReportSummary: Hi all. I've reviewed the documentation shared in other posts, but I'm still not getting there, for some reason (likely user error!). I need to create a report …Jessica D 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Matrix Manager - Why does OTBI return multiple matrix managers for each employeeSummary: We use Line Manager and Compensation Manager when creating or updating an employee assignment. Our reports should return no more than two managers for the curre…Michael Grant 131 views 6 comments 0 points Most recent by Michael Grant Reporting and Analytics for HCM
-
OTBI analytic: Populate a value in a column based on another columnHi ! In my OTBI analysis I want to have column formula where I check if an employee have any value in column A. If a value in present in column A for an emoloyee, I want…Ida-OC 669 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Position Vacancy ReportHello, does anyone know how I could report on vacant positions in HCM? I need to be able to report on both positions that are currently vacant, and positions that were v…User_2025-02-07-03-52-39-913 660 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report to show all items in the report and analytics catalogSummary: Is there a way to pull a report to show all items in the catalog (Shared Folders & Dashboards)? Content (required): Hi, This might be a long shot but does anyon…Amar Bilkhu 812 views 11 comments 2 points Most recent by ahmed alsharief Reporting and Analytics for HCM
-
Does anyone know which database table is used to report on Performance > Process Flow NameSummary: Creating a Data Model to report on Process Flows in relation to Performance Management. Does anyone know which database table is used to store/report on the Pro…Nigel Wiltshire-Oracle 53 views 10 comments 0 points Most recent by Ravi Tilekar Reporting and Analytics for HCM
-
Role requirements for editing templates within XML server?Summary: We have been eliminating the Application Implementation Consultant role from power users and have noticed gaps in our access to different system functions. Can …
-
If you think you do OTBI really well and have a large portfolio - Can we connect?Summary: We are fairly new to OTBI (just implemented HCM) and struggling a bit with how to best govern scheduling, enhance performance of OTBI reports which at this time…Luke.esh 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need 'Work Order Number' details of Background check page Under Screening section In BIp ReportSummary: Need 'Work Order Number' details of Background check page Under Screening section In BIp Report Content (required): Hello Experts, I Need the Work Order Number …