BI Publisher
Discussion List
-
Need help on OTBISummary Sum of Balances in OTBI reportContent Hi Team, We are creating one report. Our requirement is to print the balance value in such a way that balance value of A an… -
Date fields using excel templatesContent Is there a way to print date fields on excel based BI publisher reports where excel can recognize it as an actual date field? Is this the only solution https://d…User_2025-02-10-08-27-16-805 26 views 1 comment 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Using .xlsx template instead of .xlsContent Is there a way to load .xlsx file as a template instead of .xls file? I am trying to create a BI publisher report with slicers and I run into compatability issue…User_2025-02-10-08-27-16-805 44 views 1 comment 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
SQL query to get offering start date and end date in learn module in fusion HCMContent Hi All, I am working in a requirement where I need the following details: Offering Name, Offering start date, Course Name, Person number enrolled in the offering…Mani Venkataraman 1.1K views 1 comment 0 points Most recent by Maxime Pignot-Oracle Reporting and Analytics for HCM -
Dependents not enrolled in Benefits SQL HelpSummary Dependents not enrolled in Benefits SQL HelpContent Hi All, I have a query that I use in a BIP report that is supposed to be determining if a dependent is going …User_2025-02-04-08-51-08-912 117 views 1 comment 0 points Most recent by Nagaraj Hunur-Oracle Reporting and Analytics for HCM -
Custom Performance Document TemplateSummary Changing the fonts in Performance Document templateContent Hi, Has anyone successfully customized the RTF in template in: Path: /Human Capital Management/Career/…Janine Dorongon 33 views 2 comments 0 points Most recent by Janine Dorongon Reporting and Analytics for HCM -
Printing legal entity number, legal entity name, department code and department name on the standardContent Hi there, I suggest printing the legal entity number, legal entity name, department code and department name on the standard expense report printout, it would he… -
Missing account coding data for Invoices in Workflow tables in PRODContent Hello, We have a custom BI report that tracks the Account coding details for AP Invoices. We are using the workflow tables to get these details. Per my understan…Shruthi Ramesh 60 views 3 comments 1 point Most recent by Nishanth B Jain Reporting and Analytics for ERP -
which table holds the withdrawal reason for oracle learn ?Summary which table holds the withdrawal reason for oracle learn ?Content which table holds the withdrawal reason for oracle learn ? We want to use this to report on no … -
Change Font of Delivered Performance Management ReportSummary Change Font of delivered - Performance Document Worker And Manager Ratings ReportContent Hello Experts, I am planning to change font (to Arial) for the delivered…Anil Pillaresetty 43 views 9 comments 0 points Most recent by Janine Dorongon Reporting and Analytics for HCM -
Oracle SQL - Display rows as columns - Many to Many RelationshipSummary Oracle SQL - Display rows as columns - Many to Many RelationshipContent Good day! I need some guidance if I want to do is actually possible in Oracle SQL. I have…Raymund Jerome 36 views 2 comments 0 points Most recent by Raymund Jerome Reporting and Analytics for HCM -
Include payment instructions on customer invoiceContent I want to include payment instructions on our invoices to external customer in the send payment to section of the invoice, i.e "pay to bank account number 11234-…Stefan pettersson 33 views 1 comment 1 point Most recent by Nishanth B Jain Receivables & Collections -
How to restrict access to submit the installments on installment selection on AP payments in fusionSummary How to restrict access to submit the installments on installment selection on AP payments in fusion cloudContent Hi All, How to restrict access to submit the ins…Devendra Thota-220620 38 views 3 comments 1 point Most recent by Jayanth Muralidhar K-Oracle Payables, Payments & Cash Management -
"Insufficient Privileges" in Fusion CloudContent Hi All, We have a requirement to find the approver name of a particular transaction. I did some research and found that may be we can get relevant data in hcm_fu… -
Cost Accounting Distribution TablesContent Hi Team, Can anyone help me with table name for all the transaction types and the cost distribution details present on attached screen. Regards Nidhi...Nidhi Chhajed 32 views 3 comments 0 points Most recent by Sushan Peiris Reporting and Analytics for SCM -
Role Change Reflect to AnalyticsSummary When you change roles in Fusion, does it also get changed at the same time in Analytics?Content We encounter scenarios where we cannot see a report and then we a…Pernel Dela Pena 27 views 6 comments 0 points Most recent by Matt Nease Reporting and Analytics for HCM -
How to report on "lineouts" and "ergonomic injuries" within OTBI / OSHASummary How to report on "lineouts" and "ergonomic injuries" within OTBI / OSHAContent How to report on "lineouts" and "ergonomic injuries" within OTBI I think this data…Andrew_Schmitz 29 views 2 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Need SQL Query/ table names to get Source System ID for person's areas of responsibilitySummary Need SQL Query/ table names to get Source System ID for person's areas of responsibilityContent Hi All, What I need is to get Source System ID for person's areas…Dhanuka Chamal 3.1K views 6 comments 2 points Most recent by Dhanuka Chamal Reporting and Analytics for HCM -
Bursting A Report With SubTemplatesSummary How to burst a report using a sub template.Content Hi Experts, We have a custom report which uses a sub-template. The report also uses bursting to email. But the… -
How can we pass a table prompt selected in the main report to the table prompt in the drilldown repContent We have a dashboard with a drill down to a detailed report. The main dashboard has a report that shows the rollup counts of documents by task status. When you cl…Tom_Giarratano12 30 views 3 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
Looking for the Table for assignee Details from Service RequestSummary Table for the Assignee Details to whom the SR is assign to in the Helpdesk.Content Table for the Assignee Details to whom the SR is assign to in the Helpdesk. Ve…Preethi nair 25 views 3 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Cannot Find Category Name in Service RequestsSummary Looking for Category Name in the CRM Service ModuleContent Hey everyone, We recently installed HCM and we use the service model to act as our HR Help desk. I hav… -
Organization Chart Custom ReportContent Hi All, I customized the DirectoryPrintReport report in /xmlpserver. I have kept only Custom as Default and Active. But the system is still printing the delivere…Mohit Sinha-Oracle 41 views 2 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
ExternalReportWSSService sample payload to pass template nameSummary ExternalReportWSSService sample payload to pass template nameContent Hi, Can we pass report template name to ExternalReportWSSService SOAP service which triggers…Vinod Kumar Mohanraj 414 views 3 comments 1 point Most recent by Arun Raj Reporting and Analytics for ERP -
Custom report for goals displays HTML tags and splits the Success Criteria Text CLOB data into multiContent Sample text in Success Criteria Field. - -This is a sample for success criteria textoralife 59 views 1 comment 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Dashboard prompt returned error (Failed to load (Odbc driver returned an error SQLExecDirectW).)Content Hello All, Currently I am using SQL Results option to populate value of a dashboard prompt called "Module Name".I am using below SQL code for this : actual colum…Janardhana Kondaveeti 26 views 6 comments 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM -
deep link to reportSummary deep link to reportContent Hi, We are trying to deep link to report in OBI report. below is the link we copied from the browser address bar:…Nizar Kassam 201 views 5 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
Table to get BI Report Template and Data Model DetailsSummary Table to get BI Report Template and Data Model DetailsContent Hello, In EBS, we had XDO tables which stored BI Report and Data Definition details. Do we have any…Vinay Gharge 1.2K views 3 comments 2 points Most recent by SimonTomey Reporting and Analytics for ERP