BI Publisher
Discussion List
-
SQL or Table names to find the Security Profiles for the Data Role ID..Summary: Looking for a backend Table name or sample sql which can provide the List of Security profiles and mapped date Roles attached the Online page of it. Content (re…Prabhu Krishnamoorthy 571 views 4 comments 0 points Most recent by Prabhu Krishnamoorthy Reporting and Analytics for HCM -
How to create a printable report?Summary: Content (required): Hello everyone, We are trying to understand what are the needed steps to give the opportunity to the users to print the performance report. …Agapi 21 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Difference between SQL Data Sources?Summary: Content (required): Hello everyone, We are trying to create a new Data Model for Performance Management in HCM by using an SQL Query. However, we are not sure w…Agapi 51 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Query - Classroom at activity level in LearningSummary: Hello, does anyone have a query how to get the classroom at activity level in Learning? Thank you so much. Content (required): Version (include the version you …Hazel De Castro 41 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Unable to find Pension Calendar year to date column tableSummary: I am unable to find pension Calendar Year to date column for Annual Pension Initial loaded data in only available in PAY_BAL_BATCH_LINES Table Content (required…Ashutosh12 21 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Query to Fetch withdrawn assignments in LearningSummary: I am trying to fetch the learners who got withdrawn from the courses in Learning. Content (required): We discover that thousands of learning assignment records …Thulasi Ram 71 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to display URL or attachment in OTBISummary: After adding attachment url from subject area facing this error Content (required): Health and Safety module Version (include the version you are using, if appl…Surya -Oracle 162 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Table to pull the Highest Education Level in BIPSummary: Need to determine the table that retrieves the Highest Education Level under Person details Content (required): Version (include the version you are using, if a…RenzelkeithCoquia 844 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Audit log or report for configuration changes to the systemSummary: Is there a report or change log that can be obtained from system on application configuration changes ? Does anyone know of an audit log or report for configura…MilanMohanty 761 views 4 comments 2 points Most recent by Parag Hiremath 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 41 views 0 comments 0 points Started by Peeyush Chandel 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 31 views 2 comments 0 points Most recent by Shiva Prasad M 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…
-
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… -
Any report to get details about the security roles and permissions configured for all reports ?Summary Any report to get details about the security roles and permissions configured for all reports ?Content Hi, Is there any report already available, that can provid…Nitin Gupta HCM 209 views 12 comments 2 points Most recent by Saurabh Pratap Singh Reporting and Analytics for HCM -
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 31 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Could not able to fetch various seniority dates through OTBISummary Could not able to fetch various seniority dates through OTBIContent Hi Team, We are looking to fetch different seniority dates like VLSR Date, Enterprise Hire Da…Harish Kumar Kovi 227 views 25 comments 0 points Most recent by Dannielle Dellucci 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 561 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
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 41 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
-
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 251 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 271 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 31 views 1 comment 0 points Most recent by Sumedh Kumar-Oracle 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 671 views 2 comments 0 points Most recent by Jessica DiCerbo Reporting and Analytics for HCM -
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 41 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
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.5K 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 531 views 4 comments 1 point Most recent by user5969783 Reporting and Analytics for HCM
-
Careers of Interest - ReportHi, Anyone has sample report for "Careers of Interest" which comes under development goals? Or can anyone help me with the tables? Regards, NivyaNivya Mathire 41 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Pull all active and terminated employee or single employee based on person numberSummary: I want to fetch all the records of active and terminated employees or single employees based on the person number parameter and history of all the employee chan…Deepak Bhatt 2.8K views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Report on Temporary Global TransferHello Is it possible to report on the field 'When do you expect the new work relationship to end?' available on Temporary Global Transfer through OTBI?