Category 81
Discussion List
-
Count of employees by Business Unit, Location and DepartmentWe need count of employees by Business Unit, Location and Department using OTBI. When we use count function, it shows same count for all business units instead of showin…Ashok Kumar Sharma 243 views 4 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM -
Count not coming correctAny idea why below XML is showing Column "Count as 2 " value = 2 for all business units. Column "Count1 using assignment " value = 0 for all business units.Ashok Kumar Sharma 11 views 2 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM
-
How can I get "And" instead of "Or" to work with the same column filter?Summary: I have a sales team member column. Each team member respresents a different function on the team. Example: Primary and Overlay. I want to create a report that s…
-
How to query Location changesIs there an audit trail for Location changes that provides meaningful information? Someone made a change to a location and we're trying to determine who made the change.… -
I want to use hth.xml_data_cache.getClobVal() to get the Promotion details like new Position, etcSummary: I want to use the hth.xml_data_cache.getClobVal() function to display the Promotion details like new Position, new Manager, new Salary in separate columns. How …Consultant Ian 21 views 0 comments 0 points Started by Consultant Ian Reporting and Analytics for HCM -
OTBI Analysis for Benefit Dependents over 21Summary: I need an OTBI analysis get information for dependents who are 21 years of age in every year. Content (required): I created an analysis based on Benefit Enrollm…Ayesha Iroshani 52 views 4 comments 0 points Most recent by User_FG152 Reporting and Analytics for HCM
-
Find and Replace PROD path reference in extractsSummary: Find and Replace PROD path reference in extracts Content (required): Hi Team, Greetings! We have multiple extracts with reference to Production path on SFTP or … -
Talent Notification QueryHi, Is there are a way to query Talent Notification to check when the Enabled column for Talent Review notification was updated? -
It is possible to track compensation change statements line manager have already downloaded?Summary: Content (required): Hello experts, in the compensation change statements system page (please, see the attached screen) our customer want to create a checkbox wh… -
Infolet access - Learning Records Real TimeHello We build a report based upon the subject area Learning Records Real time and created an infolet. When making the infolet available to the employee, it doesn't give…Annelies Van Erom 12 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Filter schedule name based on week start date of timecardSummary: Report has only the schedule applicable to the timecard at time of commencement. Content (required): I have a timecard report that includes every schedule for t…Dawn Cawston - CPS 11 views 8 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
Display Custom Message - Error when adding HTMLSummary: When I try and add HTML to the "Display Custom Message" I keep getting an error message (see below) Content (required): Version (include the version you are usi…Scott_Turner_ 23 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to export all pages on a dashboardHello, Is there any way we can export a full dashboard and it return the full table of results rather than just the rows shown on the dashboard page? Thanks, Stacey
-
Best fit % calculationSummary: Hi Expert, In OTBI do have have a subject area for best fit % calculation? in Talent management module. Thank you! Content (required): Version (include the vers…
-
Which Subject area to use to get report of employee allowancesSummary: Which Subject area to use to get report of employee allowances eg. car Allowance Content (required): Which Subject area to use to get report of employee allowan…PavanBheema-Oracle 23 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Benefit OTBI report with correct option namesI need to create an OTBI report to capture benefit details for a specific benefit program. I need to get the information of employees who are elected and declined that b…Ayesha Iroshani 22 views 6 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
BIP Report LOV becomes read-only when the number of characters increasesSummary: Content (required): I am trying to build a report with prompts for Degree, Certifications, Languages, Major etc. profile items. I have used SQL queries as LOV t…Akash Kiran Jana 56 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to send the BIP report output to dynamic email address based on the report resultsSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Shlomo Elnekave 510 views 4 comments 0 points Most recent by Shlomo Elnekave Reporting and Analytics for HCM -
Could please help me on to find FTE cloumn in OTBI subject areaSummary: Hi Team, We need FTE column in OTBI report, I have taken worker assignment real time but I can't find out FTE column. Any help me on . PFA. Content (required): …AjayKumar Maddipati 34 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to retrieve the OLD payroll frequency and NEW Payroll frequency in the BIPHi ALL, Kindly support me to resolve below issue: I have a requirement to retrieve the OLD payroll frequency and NEW payroll frequency in BI report. Following with other…RamkumarKadhiravan 23 views 2 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM -
SQL to retrieve fields for BI ReportSummary: Hi All Please share SQL query to fetch below details for generate bursting report. Thankyou, Ram Content (required): SQL to retrieve Employee Number, Employee N…RamkumarKadhiravan 71 views 8 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM
-
How to make BI report output file (RTF template with Excel op) as non editable once it's downloadedSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
SQL for Environmental health and safetySummary: Team, Does anyone have the sample environmental health and safety BI report (SQL). Please share Content (required): SQL for Environmental health and safety SQL …
-
The user request exceeded the maximum query governing execution timeSummary: The user request exceeded the maximum query governing execution time Content (required): Hi Team, Greetings! We get error on OTBI report as 'The user request ex…Parag Hiremath 78 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Can we create analysis to fetch terminated workers who HAVE NOT been rehired since their terminationSummary: Can we create analysis to fetch terminated workers who HAVE NOT been rehired since their termination Content (required): Using worker assignment real time busin… -
Absence category and absence types under this category query.I need a SQL query that returns information about the absence category and the absence types connected to this category. I would be grateful for the query you can share …Cansel Karasoy 264 views 11 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Sending Bursting pdf as an e-mail body instead of outputI have a notification work that I have prepared, the report returns table type employee data and absence detail.I can send this tabular report as a pdf output, but I wan…Cansel Karasoy 23 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
person security profileSummary: We need a person security profile that uses Job Type as a criteria. We only want our Sales Comp team to see the people who are in a job type of "producer". Any …
-
Expand Issuing comments in Document Record Notification email templateWe are currently working on expanding the comment box for document record email notifications and BPM work lists, as the current character limit does not align with the …
-
AS-OF-DATE on Prompt - CURRENT_DATE_REP_OTBI-Session DateSummary: I am using CURRENT_DATE_REP_OTBI in the calendar prompt # As of date . The date is is not defaulting correctly. The session date defaults to 01-Nov-2021. While …