Category 81
Discussion List
-
How to extract PDF bytes from BI publisher using BI web serviceSummary: Client have requirement to extract the pdf output generated from BI publisher to be feed to third party to get that pdf output affixed with digital signature in…Shiva Prasad M 31 views 2 comments 0 points Most recent by Shiva Prasad M Reporting and Analytics for HCM -
Need subject area to get the manager name of inactive employeesSummary: Need subject area to get the manager name of inactive employees Content (required): Hi, I need subject area to get the manager name of inactive employees. For e…
-
Query to find All grade Rate values with Grade codeSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Sowmiya Velusamy 2.7K views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI Subject Area not displaying Payroll Periods After a certain PeriodSummary: I am facing an issue where in the Subject Area ( Payroll Ruy Result Real Time ) is not fetching the Payroll Period Data of an Employee after a certain Period (s…Rajit Paliwal 11 views 5 comments 0 points Most recent by Sharon Harper Reporting and Analytics for HCM
-
Steps to create OTBI Report / BI Publisher Report for Planned Schedule → Time ManagementSummary: we need steps to configure Planned Schedule report which can be useful for HR Representatives and HR Admin which provides information of employees whose Worksch…
-
Where to check if employee received a pager unit and their on-call premium?Summary: I'm trying to look where in HCM this information can be visible: Employee received a pager unit and their on-call premium. Thanks!notautomni9 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Create Temporary Table or View for complex agreement templateSummary: Seeking advice regarding BI publisher capabilities to create temporary data tables. Content (required): Hi team, I am seeking advice as to whether it is possibl… -
Does anyone how to saved search in BIP parameter?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Hazel De Castro 22 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Ability to report on modified approved future-dated absence entriesSummary: Content (required): Hi - is there a way to report on absences that have been modified by employees ? Example: On 11-Aug-2022, an employee applies for a 2 day ab…
-
How to put the information into one row and limit the duplications?Hi All, I've been working on building a report to show the employee's personal information (address, contact number etc) and include their emergency contact information …
-
Union for 2 reportsSummary: How can I combine the output of 2 reports into one output Content (required): I have two reports, both using the same 2 Subject Areas (Workforce Management - Wo…Joe Dorrian 32 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Usage of BI System RoleSummary: Usage of BI System Role Content (required): Hi Team, We would like to know the usage of BI System Role. Please share your knowledge on the same. Version (includ…Vasanthakumar Ravi 25 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
How to query the organizations in the Organization List of an Organization Security Profile?Summary: How to query the organizations in the Organization List of an Organization Security Profile? Content (required): The Organization List section of the Organizati…User_2025-01-25-06-00-22-809 533 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
OTBI Reports on agents and delivery recipientsSummary: Hi, any reports that can give you the report agents, including the schedule and the list of the recipients (by username or email address)? Thank you! Jenia Cont… -
No option to output format in excel 2007+ .xlsxSummary: Hello! From my online research online (I'm not an MS history expert) - "XLS and XLSX extensions represent popular Excel file formats that were introduced by Mic…Kevin M Storrie 42 views 5 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
Looking for a sql query to get the absence plan and corresponding element name associatedSummary: Hi, We have a requirement to get the data of the Absence Plan and corresponding element data using the sql. If anyone has come across such requirement then plea…Peeyush Chandel 3.6K views 1 comment 0 points Most recent by Nagaraju Godasi Reporting and Analytics for HCM -
Issue: Unable to find Donation related Entry reason in Absence tableSummary: Unable to find Donation related Entry reason in Absence table Content (required): We can see the Additional Information stored in Adjustement_Reason but when it…
-
Provide access to OTBI report by Area of Responsibility by BUSummary: Content (required): We have a requirement that the user will have only Employee and/or Line Manager Role and they should be able to fetch the employee records i…Vinay Gharge 255 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Sql Query to Fetch the Last Modification Date and Last Modified By Details of SSOSummary: Can any one please help with a sql query to get the last modification date, last modified by, Created by details for SSO configuration. Content (required): Vers…MilanMohanty 276 views 2 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Email Address for Implementation Users in FusionSummary: Team, I would like to know the table in which the email address of the implementation users are stored. As they are not tagged to employee record, we will not b…Sumedh Kumar-Oracle 32 views 1 comment 0 points Most recent by Sumedh Kumar-Oracle Reporting and Analytics for HCM
-
Seeded HCM Extract for payrollHello, Is there a seeded HCM Extract to get total payroll balances per location/department? Thanks in advance!
-
Embed bursting report content in body of email?Summary: Embed bursting report content in body of email? Content (required): Hi all, Hoping someone can advise if it is possible to embed report content within the body …Luke.Findex 53 views 3 comments 0 points Most recent by Aaron Hager Associated Bank Reporting and Analytics for HCM
-
How to query if a pending worker to EMP was converted with manual or auto conversion?Summary: Is there a query to determine how a pending worker was converted to EMP (ex: "include in auto conversion" or "quick convert")? Content (required): Is there a qu…Jessica DiCerbo 592 views 2 comments 0 points Most recent by Jessica DiCerbo Reporting and Analytics for HCM -
Is it expected that the previous salary in Salary History will be deleted after Mass Salary Update?Summary: After mass updating the salary, the previous salary in salary history was deleted. Is it the expected behavior or it should have retain the previous salary and …
-
Turnover- Last 3 monthsSummary: Content (required): trying to add a filter for the last three months but nothing is pulling - I tried several sql expressions and repository variables xml attac…Riti Malhotra 42 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Career Profile Dashboard: Filtering for Performance Tiles and Analysis Not WorkingSummary: We're creating a Career Profile dashboard and would like tiles/drill down analysis to display for employees whose career profile is In progress (1-8 out of 9 se…
-
Drill downs on DashboardSummary: Why does drill down report different numbers to dashboard when its the same report? Content (required): I've created a dashboard report for absence reasons, but… -
How to get SQL query details of BI Report data modelSummary: Hi , We need to identify list of Data models which is using a specific column in BI Report SQL query. We have two option , first is to verify manually all data …Niraj 2.3K views 2 comments 3 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Missing time card OTBI/BIP report or analysisSummary: Content (required): Is it possible to create an OTBI or BIP report to show employees who have not handed in their time cards? Either standard or customized repo…Nicolas Vahman 459 views 4 comments 1 point Most recent by user5969783 Reporting and Analytics for HCM
-
How to make the shown value of one column depend on the value of another column?Summary: How to make the shown value of one column depend on the value of another column? Content (required): I've made an analysis from the assignment real time subject…Matti Bugge 105 views 4 comments 0 points Most recent by Matti Bugge Reporting and Analytics for HCM