BI Publisher
Discussion List
-
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 811 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 32 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 163 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 647 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…
-
How to disable user login whenever the user is deactivatedSummary: Content (required): Hi All, The requirement that when users leave the company and when email get deactivate in the company, then fusion application login also s…
-
Time Entry report to get updates and deletion of time entrySummary: Need a report for time entry to pull all new creation, updated and deleted records. Content (required): We have a requirement for integration where we need to g…Raghavendra M 71 views 9 comments 0 points Most recent by John Finnegan-Oracle Reporting and Analytics for HCM -
Need query for notes created on transaction level and customer level at collections dashboardSummary: Need query for notes created on transaction level and customer level at collections dashboard Content (required): following query only return notes at transacti…
-
Legal report for Portugal to communicate the inventories once every year - Portugal localizationsSummary: Portuguese companies are required to communicate to the Tax Authority the inventory relating to the last day of the tax period, through a file with defined char…Siddharth JSS 82 views 6 comments 0 points Most recent by Bogdan Pana-Oracle Reporting and Analytics for ERP
-
Need query for notes created on transaction level and customer level at collections dashboardSummary: Need query for notes created on transaction level and customer level at collections dashboard Content (required): following query only return notes at transacti…Nikatfusion 43 views 1 comment 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management
-
Unable to Deploy to BIP using Oracle SOAP ServicesSummary: Unable to use /analystics-ws SOAP Service to deploy a BIP Report (catalog file). Content (required): We use pasteItem2 operation of https:///analytics-ws/saw.dl…Shrujal Patel 64 views 2 comments 0 points Most recent by Shrujal Patel Reporting and Analytics for ERP
-
Can someone help me with the query for customizing the trial balance report.Summary: Currently i am trying to customize the oracle standard trial balance report for fetching the YTD,PTD and QTD balances. Need someone who can help with the logic …Rudraksha Vishnu 171 views 1 comment 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany -
Access to restricted data in BI reportSummary: We have a BIP report in /Custom/Human Capital Management/Reports, which is used by certain users. On May 31st one user reported that he/she is able to view data…
-
Getting Absence Reason in BIPSummary: I need to get the absence reason for a large number of absence in a BIP report. However, when trying to link the Absence Entry Reason ID to the Reason ID using …
-
Need help in DataModelInSession SOAP ServiceSummary: Can someone share working payload of DataModel In Session SOAP Service to call Data model dynamically in Fusion? Content (required): Version (include the versio…sailesh_cloudare 41 views 0 comments 0 points Started by sailesh_cloudare Reporting and Analytics for ERP -
BI Publisher report with cashing multi-million records query and staggered upload to FTPSummary BIP Maximum Rows for CSV output limit is 2 million. need elegant solution to query database only once for bigger record count and then have staggered upload of r…Roman Havrylyak 507 views 4 comments 1 point Most recent by Roman Havrylyak Reporting and Analytics for ERP -
How to create actual vs budget and variance report?Summary: Hi, We have loaded our budget on budgetary control. We are now trying to build a report with budget vs actual amounts and variance between the two. However, ora…ShailenS 1.1K views 4 comments 0 points Most recent by Linda Wong-Oracle Reporting and Analytics for ERP
-
Payment format file is producing output in Text format instead of PDFSummary: Payment format file is producing output in Text format instead of PDF Content (required): Version (include the version you are using, if applicable): Code Snipp…User_2025-03-10-22-49-33-989 144 views 2 comments 0 points Most recent by Sandeep Nayak-Oracle Payables, Payments & Cash Management
-
Restrict the access for creating data model and create analysisSummary: Hi All, How to find the roles which are giving create and edit access of analysis and BIP report? is anyone have any SQL for to find out these in any custom rol…Amit_Ekbote 41 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
While running whole population in OTBI we are facing issue.Summary: Content (required): we are using Pivot table output in the OTBI report for 1 or 2 employee it's working fine when we are running whole population, we are gettin…challa praveen 23 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
User wants to use BI PublisherSummary: Hi, There are 2 users in Oracle Application Cloud- kalam and rtokar. kalam can access and see data in OBIEE my folder where as rtokar can't do the same. The use…
-
Report to extract LRU Calculation cards configuration detailsSummary: Report to extract LRU Calculation cards configuration details Content (required): Hi Team, Greetings! Does anyone have the report or the query to extract LRU Ca…Parag Hiremath 64 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
Is there a way to report which report is used how frequently for BI/OTBI/BICC/FRS?Summary: Hi Team, We are looking for providing a metrics on usage of reports and wanted a way to report which report is used how frequently for BI/OTBI/BICC/FRS? Content…Abhilash K - Deloitte USI 73 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Payment Amount Text in eText template for check printingSummary: We have a requirement to print check amount in below format ONE THOUSAND FIVE HUNDRED USD AND 00/100 DOLLARS Currently xml generated from PPR is having format l…
-
What are the prerequisites/setups for tax reporting in Fusion?Summary: Hi, Could someone please point me towards the prerequisites/setups need to make the "Finally Reported" column work? Thanks in anticipation, Shailen Content (req…