Category 81
Discussion List
-
Audit of BIP Report ChangesSummary: Audit of BIP Report Changes Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there any available feature to track or audit …Parag Hiremath 38 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
We want to remove Submit Information and Add comments in the goal approval notificationWe have a goal plan approval process where the below is the scenario Employee Creates the Goal > It goes to manager for approval > Manager can either approve or Request … -
Succession Candidate readiness Counts are off in reportSummary: I am trying to get accurate counts of Active Plan candidates (active assignment and active on plan) and while I'm able to pull totals accurately, the candidate … -
Learning Specialist Not able to see employees dataSummary: We have built a custom OTBI report using the subject area - Workforce Learning - Learning Management real time , but when we run the report the Learning special…Veena P 165 views 4 comments 0 points Most recent by Saurabh Pratap Singh Reporting and Analytics for HCM
-
Pivot Table > Sorting Date in Ascending Order Not WorkingSummary: Pivot Table > Sorting Date in Ascending Order Not Working Content (please ensure you mask any confidential information): Hello, We want to display the time card…
-
Education Levels in OTBISummary: I'm not able to locate School name shown in the Education Levels section on Person Profile in OTBI. I don't see the Education Levels section under Person Profil…Gala Meyerovich 4 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Issue with line manager dashboardSummary: Content (please ensure you mask any confidential information): Hello experts, in all delivered dashboards, in my case compensation plan, line manager can look f…Valerio Curzi 12 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Bell notifications are not getting triggered if username and work email IDs are same.Summary: Bell notifications are not getting triggered if username and work email IDs are same for assignment projected end date alert. Content (please ensure you mask an…Siddhesh Nisal 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
SQL to pull Number of Days between two dates (one is a Parameter Date)?I'm currently using BIP Report. This sequel works on me if I'd like to use SYSDATE: TO_NUMBER(TRUNC(SYSDATE) - TO_DATE(TO_CHAR(SEN.SENIORITY_DATE, 'YYYY-MM-DD'),'YYYY-MM… -
We are using Assignment Event Real Time and do not see correct Termination headcount in BI reportsSummary: We are using assignment event real time subject area and reporting annual turnover for previous 5 years. We are not seeing the correct turnover headcount when w…David Boudreau 61 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need query to resignation approved employeesHi, I have a requirement to send emails to employees whose resignation is approved. So I want to use bursting to send emails to employees. Can anyone help me out with th…Dara Nagasai 23 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Blank lines while printing success criterion in OTBIWhen I printing success criterion in OTBI reports, it is giving blank lines before and after text of success criterion. Probably, the reason is that it is defined as HTM…
-
How to report on how long a candidate has been in a particular phase and stateSummary: I would like to report on the length of time that candidates remains in each phase and related state. Content (required): A report that shows how long candidate… -
BI Report Access Issue - User Unable to Open and Access Report.Hello Community, I'm facing an issue with a BI Publisher HCM user information report. A specific user is unable to open and access the report, and I'm hoping someone can…Omran Zeaiter 193 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Is there any way to create bulk users and assign them bulk roles. Also any limitations involved?Summary: Is there any way to create bulk users and assign them bulk roles. Also any limitations involved? Content (required): Is there any way to create bulk users and a…Lucky Sharma 81 views 7 comments 1 point Most recent by CHANDRESHWAR DWIVEDI Reporting and Analytics for HCM -
Combine Two or more subject areasSummary: I tried to add a new subject area to my report - all I need from the below subject area is the Employees Name which is not in the first subject area for Payroll…THawkins_LGI 222 views 19 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Check Digits field in Payroll - Personal Payment Details Real Time subject areaSummary: The Check Digits field cannot seem to be found in the Payroll - Personal Payment Details Real Time subject area. Content (required): The Check Digits field cann…Calvin Tam 53 views 4 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Results to be displayed vertically instead of horizontallySummary: Whenever I create a new OTBI Analysis it displays horizontally Content (please ensure you mask any confidential information): How do I change this to show verti…Anna-MariaP 13 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
XML Publisher/BI Publisher make text bold in XDOFX IF condictionSummary: Content (required): Hi I have this field COMPONENT_NAME from my data model. I've created a table wizard with a repeating group for all the values in COMPONENT_N…Nicolas Vahman 267 views 4 comments 0 points Most recent by Prameesha Reporting and Analytics for HCM
-
OTBI-ORC report issue on filter of candidate job application dateSummary: HI Team, when we apply the filter of candidate job application date report running long time without result but when we remove the filter on date it takes only …AjayKumar Maddipati 33 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
How to make a totals columnSummary: Hi, I am trying to have a column that totals the values for a deduction at a Cost Center level. However, in my report, i continue to have repeating rows per Cos…Darrin N 23 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
where can i locate HR rep emailSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Adam Calvert-Oracle 3 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How do I pull the exact same timecard data that appears on the Oracle Team Time Cards screen?Summary: I need to create a data model that pulls the exact same data that appears on the Team Time Cards screen. We have OTBI reports that use the "Workforce Management…BeachDreamer 88 views 1 comment 0 points Most recent by Mohamed Mahrir Reporting and Analytics for HCM -
How to report on days since assignment status changeSummary: Hello! I am looking to report on days since Leave. We track leaves using the Assignment Status field, so I am looking to report on days since assignment status …
-
Any report that can show all quickpays that do not have a prepayment?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
"SQL or ORA exceptions caused due to invalid sql" Error MessageSummary: "SQL or ORA exceptions caused due to invalid sql" Error Message Content (please ensure you mask any confidential information): Hi, we built a report based on th…
-
Candidate’s application Question code in OTBI or data moduleI am looking to build a report that has the candidate’s application questions and answers and I need the question code on it for analytic purposes. I can build an OTBI b…Chris Pomager-27736 34 views 7 comments 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM
-
Sorting OTBI Report Worker Assignment Event Real Time Subject AreaSummary: I am struggling to sort my OTBI reports by more than one column, I am able to sort by Person Number OR start date but not Person Number then Start Date. It seem…
-
OTBI Report - Workforce Management - Worker Assignment Real TimeHello anyone, can we fetch Inactive - Payroll Eligible employees in OTBI using Workforce Management - Worker Assignment Real Time also their Annualized Salary Real Time?…Hazel De Castro 52 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
A comparison is being carried out between non-compatible types DATE and INTEGER. (HY000)Summary: I have an OTBI report using the Payroll Balances Real Time subject area. The below formula does not return any errors however when running the report I'm gettin…JHaden3 14 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM