BI Publisher
Discussion List
-
How to check/download the BI report output submitted by usersSummary: Content (required): This is from Support User perspective. If a user opens a report from BI Catalog, runs it, and downloads the output, then how can we check/do…Vinay Gharge 32 views 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP -
HCM Transaction Status DashboardSummary HCM Transaction Status DashboardContent Hi Team, Do we any dashboard to monitor all HCM transactions? Thanks. Version 20B -
CUSTOM BIP NOTIFICATIONS NOT TRIGGERINGContent Hi, After adding BIP_CLIENT_REFRESH_TIME in Manage Administrator Profile Value, we are observing that many transactions aren't triggering custom BIP notification…Mohit Sinha-Oracle 107 views 9 comments 2 points Most recent by A.JOSH Reporting and Analytics for HCM
-
Schedule Event Trigger in Data Model Errors immediately when ScheduledSummary: I have created an event trigger in a data model, which I have done before without issue, but for this one as soon as I schedule the report that uses this data m… -
Query to get account numberSummary: Query to get account number present in below screenshot Content (required):Navigation - Payroll>Statement of earnings>Costing Results>Account number. Can anyone…Jaeyshree Kumaran 41 views 1 comment 1 point Most recent by Dharmendra Shukla Reporting and Analytics for HCM
-
workforce structure change reporttrying to build a report that captures changes on the department table. We maintain history on our departments, but would like to be able to report on it. If we do the r…Mike Borghoff 81 views 4 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
Mismatch in ZX_LINES and Manage Tax Details in Invoice PageSummary: Hi All, We are trying to create a report to fetch invoices with tax point basis as "ACCOUNTING". When we try to open the invoice result in front end it shows th…Siva Kumar-Oracle 41 views 0 comments 0 points Started by Siva Kumar-Oracle Reporting and Analytics for ERP -
View Formatted CLOB Text in BI Report Excel TemplateSummary: We are trying to fetch a formatted CLOB Data in an Excel template. However, the report is fetching HTML tags in the Excel cell . We tried the solution given in …Tanu Shri Patel 302 views 3 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BI Publisher RTF Template AR Invoice : Grouping rowsContent I am required to create an AR Invoice report, where services are needed to be grouped based on what kind of service they are within a report. To be more clear, f…
-
How to use one or the other parameter in a SQL querySummary: I have a query that I built that is supposed to either pull in the list of terminated employees based on the date range entered OR a list of terminated employee…User_2025-02-04-08-51-08-912 51 views 3 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
Can we Hide Exporting options from user while running BI Publisher Reports ?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Kaustubh Deshmukh 31 views 7 comments 1 point Most recent by Kaustubh Deshmukh Reporting and Analytics for HCM
-
Combining two analysisHi Team, Can we combine two or more analysis (columns are same for all analysis) results in a single report? Thanks.
-
Report With the FileURL (Download Link) of an Employee DocumentSummary: We need a BIP report with a download link to an employee's document (DocumentRecords) Content (required): Hi, Is it possible to generate a BIP report with the d…Yaniv 31 views 5 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
Default Revenue account for Credit Memo lines not defaulting correctlyContent Hi Would like to kindly seek help as when we are creating a credit memo, the default revenue account combination is not exactly defaulting as some of its segment…User_2025-02-11-12-30-38-982 41 views 2 comments 0 points Most recent by User_2025-02-05-00-10-05-674 Receivables & Collections
-
PARAM_EFFECTIVE_DATE based on payroll balance effective dateHi Team, We are creating report using logical SQL. We are fetching balance details for the whole year. So, Assignment details should be based on the balance effective da…
-
Job Start date in OTBI reportSummary if employee having multiple assignments but can we fetch job start date in OTBIContent Employee : works for property #1 (legal entity) with job of cashier starti…User_VR8E0 57 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Report showing new managers with direct reportsContent Hello, We need a report that will show managers with direct reports and the effective date of when they had their first direct report assigned to them. This repo…Shanna Oppenheim 105 views 7 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
SQL to query current BI Agents scheduled to e-mail / dashboard page etcSummary: I have written an sql query to extract all BIP reports currently scheduled, but want to do the equivalent with OTBI BI Agents - is it possible using sql and acc…User_2025-02-10-15-12-48-631 141 views 5 comments 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP
-
Report Error: ORA-01438: value larger than specified precision allowed for this columnSummary: Hey, I am running a custom report in BI Enterprise and keep getting the error below. The report is failing for only a few circumstances and am able to run it fo…User_2025-02-10-17-54-21-557 91 views 3 comments 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP
-
Print performance document from MobileSummary: When i try to print a performance document from mobile, it's blank. I created a custom button to print it Content (required): Talent Management Version (include…
-
Dynamic Pivot column in BI PublisherSummary Need the column of a pivot table to be dynamic in BI PublisherContent We have a requirement to display GL balances by BU hierachy and period. As the users can ru…saravana maneeian subhramaniun 65 views 1 comment 2 points Most recent by User_7836 Reporting and Analytics for ERP
-
What tool(s) are recommended for populating a data warehouse?Summary: Content (required): We are currently using BIP because the EDW has requested full tables. We're looking into the alternatives due to our volume (35,000+ workers…Scott Paulin 11 views 1 comment 0 points Most recent by Dilpreet Kaur Reporting and Analytics for HCM
-
Dynamic file name and dynamic sheet name for excel templateSummary: Content (required): I need to run the report for every month and output generated via Excel template. I need the output file name with the month and year for wh…Jaeyshree Kumaran 281 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Dynamic Pivot in excel templateSummary: Content (required): I have 2 sheets on my excel template output. the second has all the output columns and their data. Based on second sheet I need to create a …Jaeyshree Kumaran 31 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Bursting feature in BI PublisherSummary Burst contents to email body than attachmentContent Hi - I have a requirement to send Dunning letters in BIP but the contents should be in the email body rather …
-
In a scheduled report send outcome only if the result of a specific query is 20Summary: In a scheduled report send outcome only if the result of a specific query is 20 Content (required): We need to count the number of extract run. If the result is…Nicola Petri 21 views 4 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
HCM - Employee termination manager approval comments - how to reportSummary: Content (required): It has been noted that the comments made by managers in the approval of a termination are only part of workflow and can not be reported on. …Annette M 71 views 3 comments 0 points Most recent by Sowdha Murugan Reporting and Analytics for HCM -
Not able to view entire data in assignment and performance related subject areaSummary: I am using performance document status Real time/worker assignment real time subject areas but in the respective subject area I am able to see only my record. I…Kamini Kaushik-Oracle 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM