Category 81
Discussion List
-
How to get Projected End Date?Summary: How to get Projected End Date? Content (required): Hello, we wrote the follow piece of SQL select pc.* --to_char(PC.CONTRACT_END_DATE,'MM-DD-YYYY') from PER_ALL…Nicola Petri 371 views 10 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Case Statement Length of ServiceSummary: I would like some assistance on a case statement calculating length of service. Content (required): I am creating a case statement that looks at the assignment …
-
Question related to Knowledge base ArticleSummary: We have a subject area "Article Summary Historical Subject Area" in that we are looking at a attribute "Article View" where it related to the number of times us…
-
how can we go with below requirement in OTBI between 2022-23 data of absenceSummary: Hi Team, we have requirement in between 2022-23 data for absence accural balance for annual leave , enchased and lapsed. by using accural real time subject area…AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
New tab on the home page of Oracle HCM (Me | My team | My client Group | My reporting) - languageSummary: New tab on the home page of Oracle HCM (Me | My team | My client Group | My reporting) - text depending on language Content (required): Hello, I am creating a n…Jacqueline GRANDIN 104 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Assignment Changes including Effective SequenceSummary: Hi - I have a logical SQL built that is looking for changes in a DFF field that do not take place on a Sunday. It is supposed to capture the changes between row…
-
Pivot table column blankSummary: Content (required): Hi, I've created an OTBI report using the Workforce Performance - Performance Rating Real Time subject area, with a Pivot for the Manager Ra…Joe Dorrian 25 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Identify all actions/pages that contain Business TitleSummary: I need to identify all actions/pages that contain the Business Title in order to hide them, because client doesn't have them updated. Content (required): Versio…Stela Martins-Oracle 21 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Grade step start date per employeeSummary: Content (required): Hi, would anyone be able to point me in the right direction for creating a report that tells me how long each employee has been at their cur…Leanne W 12 views 4 comments 0 points Most recent by Kathi Chenoweth-Oracle Reporting and Analytics for HCM
-
what metadata I should use to transfer Goals and performance doc while global transferring employeeSummary: I am looking to load transfer Goals and performance doc for person though HDL. Content (required): Metadata to transfer Goals and performance doc while global t…Sushant Srivastava 1 view 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Is it possible to build custom reports retrieving data in more active workforce plans?Summary: Content (required): Hello experts, we need to build custom reports retrieving compensation components values and making analysis based on data loaded in several…Valerio Curzi 12 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Security views for disciplinary and grievances reportSummary: Security views for disciplinary and grievances report Content (required): Hi All, Is there any secured views available for disciplinary and grievances report? I…Venkatesan 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
unable to create new jobSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):H_Rasheed 1 view 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Application Composer tableHow to query custom objects in database - currently hitting HZ_REF_ENTITIES table which seems to store some of the record data, however not finding what table to join to…Michael A. Marthe 245 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Mid Year Check In ReportSummary: Hi All, We have a requirement to fetch both the employee's & manager's responses to the questions for the 2022 Mid-Year Check In. Looking for a report which cov…Peeyush Chandel 41 views 4 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM -
How can I pull all reports and their permissions available /shared folder/custom/ pathSummary: How can I pull all the reports available in "/Shared folder/Custom/" path with their permissions through backend(sql) or any other alternate, with environment h…Nidhi S 411 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Need information of HCM table which store multiple choice answers for any questioners?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Praveen D 58 views 4 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
historical person EITSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Chris Chase 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Assignment EFF Rest APII am trying to query from postman with the relevant platform_id information using Assignment eff rest api,(/hcmRestApi/resources/11.13.18.05/emps/{empsUniqID}/child/assi…Cansel Karasoy 11 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
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 122 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 534 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 98 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 552 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 108 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 21 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM