BI Publisher
Discussion List
-
How to Disable 'Create Shortcut' option on the BI/OTBI reportsSummary: Hi Community, We have a requirement where 'Create Shortcut' option of reports needs to be disabled for a Custom Security role. Any ideas on how to do this pleas…Abhishek Bhaskar-Oracle 33 views 0 comments 1 point Started by Abhishek Bhaskar-Oracle Reporting and Analytics for HCM -
Sample BI workforce compensation notificationSummary: Hello experts, do you have some examples of BI workforce compensation notification to share? In particular, we need Worksheet Overridden by Another Manager BI n… -
How to exract a string from blob column value?Summary: I am trying to extract a string from the blob column value from fa_fusion_soainfra.WFMESSAGEATTRIBUTE table. Content (required): Version (include the version yo…Madhurani Jadhav 41 views 0 comments 0 points Started by Madhurani Jadhav Reporting and Analytics for HCM -
Not able to add filter to question text in OTBI reportSummary Not able to add filter to question text in OTBI report Content (required): I am using "Workforce Management - Checklist Real Time " subject area and when i tried…
-
Need Help on How to Add Multiple Attachments to Same email in BurstingSummary Need Help on How to Add Multiple Attachments to Same email in BurstingContent Hello, Need help on how to add Multiple attachments to a Same Email using Bursting …User_2025-02-05-12-22-46-497 168 views 6 comments 0 points Most recent by RajaPalli Reporting and Analytics for HCM -
Is it possible to control email notifications in the report scheduler based on data model results?Summary: When scheduling a BI Publisher Report, I only want to send an email notification to designated users when the report returns data. Is this possible? Content (re…BeachDreamer 63 views 1 comment 0 points Most recent by BeachDreamer Reporting and Analytics for HCM -
Subject Area for Area of ResponsibilitySummary subject area needed for area of responsibilityContent We have had a business need for some time to pull Area of Responsibility information into an analysis. Does…Shelly Feyerherm 335 views 13 comments 2 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Absolute Path/Reference in RTF templateSummary: Hi all, I am working on a RTF template where the xml structure is mentioned below: DataP1.1 DataP2.1 DataP1.2 DataP2.2 … -
How can I Embed Links within BI Publisher Interactive View?Summary: How can I Embed Links within BI Publisher Interactive View? Content (required): Hi all, I have created a BI publisher data model that includes an html formatted… -
Is there any OTBI reports for absencesDear , Is there any OTBI reports for absences, We have a requirement that we need employees absences including leave balance and leave allowances with months, Please sha… -
Dependent parameters not working as expected in BI Data modelSummary: We have two parameters - one parameter is of Date type and second one is Menu type. Menu type is a sql based parameter and dependent on date. Whenever I'm chang…Meenakshi K 114 views 2 comments 0 points Most recent by Meenakshi K Reporting and Analytics for HCM
-
BIP Report Bursting - Need to split a large file into multiple small filesSummary: Need to split a large file into multiple small files Content (required): We developed few reports to send data to 3rd party systems. For the initial run, these …
-
Can I run a scheduled BI Publisher Report?Summary: I created a schedule for a BI Publisher report to run in the future. I would also like to run it now. I know with OTBI reports there was an option to "Run" in t…Angie Elliott 22 views 2 comments 0 points Most recent by Angie Elliott Reporting and Analytics for HCM -
Since 22B, Some Agents using an Unknown User in "Run as: Specified User"Summary: We have had a few agents stop running since 22B, when researching we found that these agents were using a user not defined in our system (Maureen Armstrong). Co… -
How to rename the person image downloaded using rtf template in BI PublisherSummary: Requirement to download the person image (person photo) from Oracle cloud HCM. I am able to download it but not sure how to rename the default name of the photo…
-
Which Table Assignment Hours Details StoredSummary: Which Table Assignment Hours Details Stored Content (required): Hi Team, Please guide me to get the table name which stored assignment hours details. Please fin…Vasanthakumar Ravi 23 views 4 comments 0 points Most recent by Vasanthakumar Ravi Workforce Management -
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 558 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 52 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 73 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 156 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 812 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 745 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 27 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 32 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