Category 81
Discussion List
-
Getting error when person extra info flexfield is pulled in OTBI reportSummary: Getting error when person extra info flexfield is pulled in OTBI report Content (required): I am getting following error when I dragged and dropped one of the p…Swati U 25 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Unable to find the USER_GUID for few employees in ASE_PWD_RESET_REQ tableSummary: Hi All, We have a report which we send to the new hired employee. In the email, we are sending the password reset link as well. For some of the employees the da…Peeyush Chandel 39 views 0 comments 0 points Started by Peeyush Chandel Reporting and Analytics for HCM -
Time to complete self-paced learningSummary: Is there a way to report on the time taken from launching a piece of self paces learning to the point it is finished? We have a lot of compliance offerings whic…Elizabeth Docherty 27 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How can I display talent information with job, salary informationSummary: I need to pull current job code and title, salary, salary grade for associates and combine it with their most recent talent meeting results (i.e., date of meeti…User_2025-02-05-22-55-58-511 55 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Is Manager Display Name available in OTBI? What SA can be used?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 25 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to create custom deeplink in oracle cloud hcm ?Summary: Content (required): Hello Dears , We are looking for custom deeplinks and we need to know if that applicable to create or not ? Thank You. Version (include the …Nariman Moussa 86 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI challenges rendering null valuesSummary: OTBI challenges rendering null values. Content (required): Hi experts, We experiencing challenges to come up with a solution to correctly show the data in the O…Volodymyr Faranosov 119 views 4 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
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 40 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 3K 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 18 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 8 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 32 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 38 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 24 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 559 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 46 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.9K 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 257 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 280 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 36 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 56 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 672 views 2 comments 0 points Most recent by Jessica DiCerbo Reporting and Analytics for HCM