BI Publisher
Discussion List
-
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 11 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 31 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Cross subject area analysis - ErrorSummary: Content (required): Hello everyone, We are trying to create a cross analysis in OTBI using the following subject areas: Workforce Management - Person Real Time …
-
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 11 views 1 comment 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM -
Eligibility tables for data modelSummary Eligibility tables for data modelContent I am having some difficulty creating a data model that i need for the report bursting. I want to create a report that wi…Shelly Feyerherm-2023 77 views 5 comments 0 points Most recent by User_LYY7E 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…
-
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 …Ramzzz 1 view 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
table to pull the error details from transaction console.Summary: Hi All, I'm trying to build a report and looking to pull the error details from transaction console. I tried searching tables but I'm not getting the info, can …vamshi krishna-283622 12 views 6 comments 0 points Most recent by vamshi krishna-283622 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 12 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 17 views 2 comments 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM
-
How to find the difference between two date attributes in eText templateSummary: We need to find out the difference between two dates and add 1 to the result in eText template. Content (required): We need to find out the difference between t…
-
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 31 views 4 comments 0 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 21 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 11 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 142 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 11 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Cannot Modify Chart Properties on BI Publisher for WordSummary: I am trying to edit an rtf document using BI Publisher for Word to increase the size of the chart and the font. When double clicking on the graph/chart to displ…Johnna Balane 13 views 2 comments 0 points Most recent by Johnna Balane 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 147 views 25 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM
-
Table names/SQL query for Individual Compensation details in HCMSummary: Hi All, Can you please share me the Table names/SQL query for Individual Compensation details in HCM. Thanks, Janardhana Content (required): Version (include th…Janardhana K 198 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Need query to get scheduled process details such as process name, scheduled time, parameters.Summary: Need query to get scheduled process details such as process name, scheduled time, parameters. Content (required): I need query where I can get count of active s…
-
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…ChuckM_23230 21 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 11 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 59 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 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can we use case when condition in Parameter 1(To email address) while using burstingSummary: Can we use case when condition in Parameter 1 (To -email address) while bursting. Content (required): I need to deliver report to different email address as per…
-
Query to fetch Run Result Element Entries & Balances for particular time periodSummary: We have a requirement to pull element entries & balances from Run Results for the particular time period. I have written the below query but which is giving mul…
-
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 30 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 14 views 1 comment 0 points Most recent by Sumedh Kumar-Oracle Reporting and Analytics for HCM