BI Publisher
Discussion List
-
User Prompt Results Causing ORA-01795 Error (IN statement 1000 expression max limit)Summary Need solution to get past ORA-01795 error caused by expressions returned from user prompts into an IN statement when selecting AllContent Hello, Appreciate any h… -
Remove DuplicatesSummary Remove DuplicatesContent How to remove duplicates from Excel template? Regards, ReddykrishnaReddykrishna 55 views 3 comments 0 points Most recent by Karen Costakes Reporting and Analytics for HCM -
Send a system notification for all employeesSummary Send a system notification(Not an email) to all employees of their previous day attendance reportContent My requirement is , need to send a system notification t…Murugesu.V 40 views 3 comments 0 points Most recent by Harish Vummidi Reporting and Analytics for HCM -
What date format do I need to use in order to calculate the days between one date and another?Summary What date format do I need to use in order to calculate the days between one date and another?Content Hello I am busy creating a data model for a BI report. In t… -
Need a SQL query to fetch Previous salary and previous assignment working hours of an employee.Summary Need a SQL query to fetch Previous salary and previous assignment working hours of an employee.Content Hello, I have a requirement to fetch Previous salary and p…User_2025-02-10-16-28-01-402 1K views 2 comments 0 points Most recent by User_2025-02-06-20-13-56-572 Reporting and Analytics for HCM -
SQL Code to Extract Setup Grade Rates with Grade NameSummary SQL Code to Extract Setup Grade Rates with Grade NameContent Team, I have a similar requirement. I am trying to fetch the setup data of Grade Rates with Grade na…User_2025-02-01-03-43-13-079 116 views 3 comments 0 points Most recent by Rajeev Nayan Reporting and Analytics for HCM
-
Which table to get the Plan Period Start DateSummary Plan Period Start DateContent Dear Expert, Which table to can we get the 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen. Please find the attached …Vasanthakumar Ravi 120 views 6 comments 0 points Most recent by Debkanya! Reporting and Analytics for HCM -
Changes Report - What are your practices?Content Currently we are modifying the changes report that we had using BIP and we stumble this difficulty How's your company show changes in the changes report? We have…Rick Jason 40 views 7 comments 2 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Save file directly to oracle import and export folderSummary Save file directly to oracle import and export folderContent There is the possibility to save the file generated by Otbi in the Oracle import and export file pat…Leandro Vasconcelos 24 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
BIP Bursting to email: how to embed a link to the application in the emailContent Hi, we created a bi publisher report with an RTF template. in the report we created a form field and in the bi publisher property we set: View the column NEW_L…Alberto Boccato 264 views 9 comments 0 points Most recent by Alberto Boccato Reporting and Analytics for HCM -
How to exctract the AddressId in OTBI (PersonAddress)?Content Hello experts, is there a way to extract the Person Address Id in OTBI? In case, do you have the SQL Query to extract the AddressId? Thanks in advance for your t…Valerio Curzi 36 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Restrict access to Reports and Subject areaContent Good day, everyone! Could you please tell me if there is an option to restrict access to reports based on roles? I also wondering if is possible to restrict acce…Kristina Serikova 41 views 2 comments 2 points Most recent by Kristina Serikova Reporting and Analytics for HCM -
Learning -> How to achieve Fusion Security into Custom BIP Reports through SQL?Summary Apply fusion security into custom-sql reportsContent Hi, Can anyone please help? I am in the process of developing a few custom reports using sql/bip option and …SantoshKumarBhairi 102 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
How to setup private key authentication with sFTPContent Hi all, I'm trying to setup a sFTP connection to a vendor using private key authentication. I'm being told that Oracle needs to have a password setup, but the ve…User_2025-02-05-20-24-10-848 44 views 1 comment 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM
-
Printing the Entire Dashboard PageSummary Print the entire dashboard page on the My Team DashboardContent We have pushed out some dashboard reports for our end users. We have placed these reports on the …Shelly Feyerherm 61 views 4 comments 1 point Most recent by Shelly Feyerherm Reporting and Analytics for HCM -
BI Publisher for WORD creates last row of a table as merged cellsSummary BI Publisher for WORD creates last row of a table as merged cellsContent With BI publisher for WORD I created a template with a table to be able to run the repor…Dena Swanson 38 views 4 comments 0 points Most recent by RaviThejaDarbha Reporting and Analytics for HCM -
Dashboard runs a report that opens a new window when it shouldn'tSummary As the title says, we have a Dashboard that runs a BIP Report and the run process pops the information into a new window. We aren't looking for this functionalit… -
Report AuditSummary Report showing when a report was last ran and by whoContent Hi All, I thought I saw this on a webinar, but I don't really recall. Is there a report in OTBI that …
-
Multiple IF ELSE Conditions in BIP Excel TemplateSummary Multiple IF ELSE Conditions in BIP Excel TemplateContent Hi Experts, How to use multiple IF else condition BIP Excel Template. Example: IF Legislation_Code IN ('…Bala Kasineedi 70 views 1 comment 1 point Most recent by Raghavendra M Reporting and Analytics for HCM
-
Backend table name for error transactionsSummary Backend table name for error transactions generated from transaction ConsoleContent Hello Everyone, I'm trying to create a report to show data from the Transacti…
-
How to convert a datetime columns from a timezone to another oneContent Hi, we are trying to extract the start and end date of a learning activity in the correct timezone. as you can see in the screenshot we have created an activity …Alberto Boccato 23 views 2 comments 0 points Most recent by Alberto Boccato Reporting and Analytics for HCM
-
Transaction Administration Real Time Subject Area - ReportContent Hi all, I am using this subject area to create report to pull the data about the pending transactions, however, we don't see that it has a dimension to show who …SunnyJaiswal 49 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is there a diagnostic report or other tool that will show Reports & Analyses that haven't been run iSummary Is there a diagnostic report or other tool that will show Reports & Analyses that haven't been run in 6 monthsContent Good afternoon. We are auditing our HCM BIP… -
Adjust Auto numbering in RTF Template OutputContent We have multiple paragraphs in a report built using RTF template which are numbered and some of them have conditions so if the condition is met the paragraph is …User_2025-02-05-15-04-32-460 77 views 1 comment 0 points Most recent by Venkata Sumanam Reporting and Analytics for HCM
-
Report to fetch Tax calculation cards at set up levelSummary Report to fetch Tax calculation cards at set up levelContent Hello Team, Is there any OTBI/BIP report to fetch tax calculation cards at the set up level? I want …Harish Kumar Kovi 76 views 4 comments 0 points Most recent by Thomas Cottrell-Duncan Reporting and Analytics for HCM
-
BIP Report running for everSummary Existing BIP report is running for ever with recent upgradeContent Hello Everyone, We have report which was running fine without any issues for 5 hours now with …
-
Embedding Dashboard on context UIContent Dear All, I have embedded dashboard on Hiring page by creating another tab as shown in attached screenshot. I don't want to show all the catalog options with das…User_2025-02-06-14-37-05-233 68 views 8 comments 0 points Most recent by User_2025-01-30-00-32-10-452 Reporting and Analytics for HCM
-
20C-Format does not match with date when scheduling BIPSummary 20C-Format does not match with date when scheduling BIPContent We're getting the attached when users go to schedule any BIP that has a date prompt. They can clic…User_2025-02-04-16-58-40-850 45 views 6 comments 3 points Most recent by Prudence K Reporting and Analytics for HCM
-
Best practice to pass parameters to BIP reports in the URLContent Hi, we need to embed a button in the performance document page in order to print a custom version of the performance document. We did the following: we created a…Alberto Boccato 55 views 5 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
How to add parameter value when scheduling AnalysisSummary How to add parameter value when scheduling AnalysisContent Hi, When I try to schedule Analysis using Agent, I can't find parameters which are available when it i…