BI Publisher
Discussion List
-
Requires to create a role to create reports onlySummary: We have a requirement to create a role that have access to create reports only. Where any Financials or SCM or any other modules are not given access to create …Janitha Perera 181 views 3 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP -
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …Noelle Bartlam-Oracle 71 views 2 comments 4 points Most recent by Tom Strudley Reporting and Analytics for HCM -
Position details with transaction summarySummary: Hello Everyone, I have a requirement to create a position report with a real-time transactional summary. Columns are: I could fetch all the above eleven columns…Saher 61 views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Upgraded from Version 1 to 3. PER_SENIORITY_DATES_F - How is it Populated?Summary: New table PER_SENIORITY_DATES_F created as part of upgrade to version 3. Can any one share the details of the data migration to this table? Content (required): …ChicagoConsultant 11 views 1 comment 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM -
Payslip Reprinting Report flow does not Produce Output and cannot be opened because it has no pagesSummary: Payslip Reprinting Report flow is completed successfully and does not Produce Output and cannot be opened because it has no PDF (Blank) pages ####[2023-07-11T16…Janardhan ACS-Oracle 45 views 3 comments 0 points Most recent by Janardhan ACS-Oracle Reporting and Analytics for HCM -
Timeout while using ESS to manage BI submissionSummary: Our ESS job keeps failing with an odd error but if we manually submit the BI it succeeds Content (required): We have a long-running BI query which has been gran…Scott Paulin 371 views 2 comments 0 points Most recent by Scott Paulin Reporting and Analytics for HCM -
Analysis/SQL Query behind Standard Purchase Order InfotilesVersion (include the version you are using, if applicable): Oracle Fusion Cloud Applications: 22D (11.13.22.10.0) Summary: How to Get the actual OTBI Analysis behind sta…Donald 401 views 2 comments 0 points Most recent by Saurabh Poddar-Oracle Reporting and Analytics for ERP -
"Null" token value in alert composerSummary: Content (required): Hello, We are experiencing a problem within the Alert Composer configuration. In particular, we note that when a field (token) is not valued… -
SQL Query for Territory BIP ReportSummary: Actually I trying to create a Territory Report includes the Territory Name,Parent Territory,Status , Dimension and Converge details . Can somebody helps with th…Tinu 231 views 4 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales -
Hierarchy not availble in BIWe have created an Organzaiotn Hierachy as per 1th of january 2023. The tree version is active, but noy (yet) avaliable in BI. Same for a Department Hierarchy. Is there …Wouter.Schaap 21 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Custom Performance Management Audit BI ReportSummary: Build a custom BI report that contains audit for performance document Content (required): Would like to know if there's an oracle hcm table to capture the previ… -
Can Anyone Please help me on Mapping between two subject areasSummary: Hi Team, I'm building a report on OTBI using below subject areas in Oracle Learning Cloud: Workforce Learning - Learning Management Real Time Workforce Learning… -
Standard OTBI report displaySummary: Content (required): Hello everyone, We are experiencing problems with the visualization of a standard OTBI made available by Oracle that allows the 'department …Gerardo Peluso 41 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Oracle HCM: How to change existing Host Key Fingerprint in BI AdministrationHi Team, We have a requirement to change the Host Key Fingerprint because of change in SFTP hostkey due to recent changes within SFTP application. Are we able to change …Chaitra Lakshmi Krishna 446 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Is there a seeded skills and qualifications report?Summary: Content (required): Is there a standard qualifications report? Version (include the version you are using, if applicable): 23A Code Snippet (add any code snippe…Stella Kaszab 91 views 3 comments 1 point Most recent by Stella Kaszab Reporting and Analytics for HCM -
Form output created in BI PublisherI prepared a absence form using BI Publisher, when I add the relevant fields, it does not change according to the person, the only date is fixed. What could be the cause…Cansel Karasoy 61 views 15 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
California Meal Break ReportCalifornia Meal Break Report Could you please help us getting a meal break report for the California Employees? Thanks Mansur -
Executing seeded data model to display report - TalentProfileDMSummary: How can I run the seeded data model, TalentProfileDM, to review the data that I have input into the talent profile? Content (required): This is a massive data m…User_2025-02-05-22-55-58-511 31 views 1 comment 0 points Most recent by Welsey Reporting and Analytics for HCM -
Table for security console audit?Summary: We have auditing enabled. Specifically, the "Oracle platform security services" option. We need the table names where audit tracking takes place with respect to…Shant Sarkissian_NES 52 views 5 comments 1 point Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM -
Replace special characters with standard onesSummary: Hello, we need to build an integration with a BI report where the recipient cannot accept special characters. In person names we have a lot of special character…Nicola Petri 62 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Is there query to get Audited performance management rows?Summary: Is there already a default query on the system that retrieves audit values for performance management? We have already turned the performance management object … -
Can the Performance Review, Comments section font be made uniform when using custom font?Summary: When creating a custom version of the employee and manager printed performance review document in BI, we are unable to force the font in an open text comment se…Kelly Soos-Fell 21 views 3 comments 0 points Most recent by Kelly Soos-Fell Reporting and Analytics for HCM -
Data Security in BIP ReportTeam, Which is the best way to apply the data security in BIP Report. Example: User belongs to the business unit "BU-A" should be able to see the data of "BU-A" We have … -
Excel BIP report: Comment field split over several rows and columnsSummary: BIP report: How can we make sure that comment field is not split up over several rows and columns when exporting report to Excel? Content (required): Hi, we hav…Franziska Reichel 814 views 6 comments 1 point Most recent by Lucian_Plamada Reporting and Analytics for HCM -
OTBI Emergency Contact by EmployeeSummary: Dear Community, How can i produce an OTBI report to generate an emergency contact? Can anyone share sample Data Model? We need to use this for Incident Response… -
BIP output calling an external webserviceSummary: BIP output calling an external webservice Content (required): We have a report that we'd like to export the data to a third party, but to improve integration, w…Luis Gustavo 31 views 4 comments 0 points Most recent by Luis Gustavo Reporting and Analytics for ERP -
Privileges required to view output on a custom version of a seeded reportSummary: Privileges required to view the output of the Import Project Budget report when a custom copy of the seeded report has been created (relevant to any seeded repo…LawrenceKillick 154 views 3 comments 2 points Most recent by LawrenceKillick Reporting and Analytics for ERP -
Is there any query to get the outstanding invoices for the specified monthSummary: Query to get the outstanding invoices for the specified month Content (required): We need to send a csv report to a customer which contains the outstanding invo…sunny.k.singh 641 views 4 comments 0 points Most recent by sunny.k.singh Reporting and Analytics for ERP -
Bank Payment File FormatSummary: Bank Payment File Format Content (required): Hi All, We got a requirement from the bank to modify the Payment file format . Currently the format is, R|DEBIT_ACC…