BI Publisher
Discussion List
-
Report - Notifications a learner received on learningsSummary SQL / Report to Get List of notifications a learner receivedContent Team, We have a requirement to build a report to display Offering Details (Offering Title, St… -
Can we update a column after BI report bursting for person levelSummary Can we update a column after BI report bursting for person levelContent Hi , We have a requirement in compensation module to avoid the letter bursting multiple t…User_MC37Q 47 views 2 comments 0 points Most recent by Tom John Bontoyan Reporting and Analytics for HCM -
CIP Assets cost is not stored in FA_BOOKS_SUMMARY as expectedContent Hi, We are building a custom BI Publisher report that should, among other things, show the cost of a CIP asset within a specific period from and to range. We are… -
Bursting HistorySummary Need to find the table for bursting report hisotryContent Hi Guys, I found a table for BIP Bursting report history but seem that the only usable column is the US…User_2025-02-05-11-53-59-507 80 views 9 comments 2 points Most recent by Tom John Bontoyan Reporting and Analytics for HCM -
when using HTML2FO function to convert HTML enabled text in rtf template output is not coming with tSummary when using HTML2FO function to convert HTML enabled text in rtf template output is not coming with the font and size defined in RTF templateContent Hi All, In a … -
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