BI Publisher
Discussion List
-
How to viiew Package - gl_flexfields_pkg.get_description_sqlHi, I was able to fetch the description based on the package /* select gl_flexfields_pkg.get_description_sql(23,23,7) from dual*/. However; I would like to see the entir…
-
how to exclude our custom application data from being picked by Account Analysis Report?Summary: Recently We has implemented a custom application. Data for this custom application flows through accounting hub. The data volume is huge (millions of data each …
-
Invoice Print Template Translation to Arabic Language converts Amount and Date also in ArabicSummary: Invoice Print Template Translation to Arabic Language converts Amount and Date also in Arabic Content (please ensure you mask any confidential information): We …
-
Is it possible to develop BI report to fetch data from VBCS pageSummary: Is it possible to develop BI report to fetch data from VBCS page Content (please ensure you mask any confidential information): Hi All, Is it possible to develo…
-
Created a BIP report from subject area Payables-Payments Disbursement Real to concatenate columnsSummary: Created a BI publisher report using Subject area from Payables. There is no option to concatenate two or more columns. I need to concatenate the payee address f…PSehgal2388 12 views 1 comment 0 points Most recent by James McBride Reporting and Analytics for ERP
-
Report to get employee's default expense accountSummary: Hi, Can you please suggest if OTBI report is possible to develop to get employee's default expense account? If Not can you please share any SQL query which can …Ninja 190 views 3 comments 0 points Most recent by Aravindkumar Shah Reporting and Analytics for ERP
-
Need help on getting correct YTD_DEPRN (YTD Depreciation) and DEPRN_RESERVE (Depreciation Reserve)Summary: Can someone pls provide inputs on where can we find correct base table and column for YTD Depreciation and Depreciation Reserve for a specific Asset and Book wi…
-
permissions to access reports and analytics catalogSummary: Cloud ERP R13 Content (please ensure you mask any confidential information): I have a user with BI Administrator but when trying to access Tools > Reports and A…Service Desk Claremont 47 views 4 comments 0 points Most recent by Service Desk Claremont Reporting and Analytics for ERP
-
How to reorder columns in xpt templateSummary: How to reorder columns in xpt template Content (please ensure you mask any confidential information): Hi Team, We have created xpt template and we need to re-or…Nidhi Chhajed 20 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Auto Refresh a BIP ReportSummary: How to refresh a BIP report after a certain period of time? Content (please ensure you mask any confidential information): HI, We want to show a report on a Dis…Zahid Rahim 24 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
How to call an OIC integration from BIP reportSummary: I have created an app driven integration with two request parameter. How can I submit the integration from BIP report? Content (required): I got a blog https://…Ananya Sadhukhan 3.1K views 19 comments 0 points Most recent by Adi Salomons Oracle-Oracle Reporting and Analytics for ERP
-
ExternalReportWSSService runreport data is inconsistentSummary: When we call a HCM report which has employee info, the contact details info-the phone number value is coming inconsistently. Sometime it gives a empty/null valu…KarthikeyanPK 11 views 2 comments 1 point Most recent by KarthikeyanPK Reporting and Analytics for ERP
-
Is there a tool or a way of extracting all a list of all reports OTBI, BIP and OACHi All, Is there a tool or a way of extracting all a list of all reports OTBI, BIP and OAC. Thanks & Regards, Keerthana SekarKeerthana Sekar 78 views 8 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting and Analytics for ERP
-
Budget Override Request NotificationSummary: How to customize Budget Override Request Notification Data Model to enhance the Notification? Content (please ensure you mask any confidential information): Cur…
-
Fusion to SFTP - File got corruptedSummary: By bursting query we are transferring a fusion report to SOA SFTP. But in SOA SFTP the files seems to have missing lines. i.ie., Fusion report has 18k lines in …
-
BLOB in sql query datamodel, how to display readable values?Summary: In BI in a datamodel, how to display in readable format a BLOB value? select adhocschedule from fusion.request_history This value only displays: ��¿¿ ¿dgodard22 104 views 4 comments 0 points Most recent by Rajesh Kumar Gunda Reporting and Analytics for ERP
-
Sql query to get PO Change Order line Details.Summary: Required sql query to get following PO Change Order line Details. Columns: Attribute Change From and Change To Content (please ensure you mask any confidential …Praneeth Nalluri 45 views 1 comment 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP
-
Unresolved Account Permission getting added to BI catalogue in oracle ERP after deployment.Summary: we are migrating the BI Data model and Report along with folder structure to higher environment in ERP cloud, we are facing issue where an "unresolved account" …Praveen Kumar P 24 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Query to fetch project and Time card entries(OTL)Summary: Hi Team, We need a table where the project number and time card entires details or SQL query Content (please ensure you mask any confidential information): We n…
-
performance issue in transaction listing reportSummary: I am trying to optimize the performance of GL transaction listing report. It is taking longer time to load the report & after 30 mins it is getting failed while…Abhijeet Tamoli 64 views 5 comments 0 points Most recent by User_965ST Reporting and Analytics for ERP
-
How to get green check mark and Time along with Digital Signature in Oracle BIPI have a requirement to print the Digital Signature with Green Check mark and Time using RTF Template in BI Publisher(Sample Attached). Let me know how can we achieve th…
-
Need PVO details for PER_USER and PER_USER_HISTORY?Summary: I am looking BICC Tag for PER_USER, PER_USER_HISTORY I've found "HcmTopModelAnalyticsGlobalAM.UserAM.UserPVO" this PVO has history id so I assume this is for PE…RameshBabuJambula 12 views 3 comments 1 point Most recent by RameshBabuJambula Reporting and Analytics for ERP
-
ExternalReportWSSService in SOAP UI does not give correct BIP Report responseHello All, I am facing issue in OIC New Hire Integration between Oracle HCM Cloud and Ceridian Dayforce. In OIC Service, SOAP API call(ExternalReportWSSService) to BIP R…Taruna Sharma 16 views 1 comment 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
AP_HOLDS_ALL record deleted from the tableSummary: Hi All, we are trying to build a dashboard for AP invoices and related holds. During some tests, we notices that some record in the table ap_holds_all disappear…
-
How to handle data access security in Custom BI ReportsSummary: We have the requirement to restrict data in custom BIP reports based on business unit access for the user in Fusion. For example, if report is built for 'XYZ' b…
-
What is the Retention policy for BIP Jobs run in Fusion ERP Cloud?Summary: What is the Retention policy for BIP Jobs run in Fusion ERP Cloud? Do we have more information on maximum value/minimum value for retention? Also Is there a cos…Abhilash K - Deloitte USI 13 views 0 comments 1 point Started by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
ESS job and job sets migration from one instance to anotherSummary: We have around 200+ ESS jobs and each time after refresh, it is a tedious and time consuming task to migrate each of them individually. We have to document each…Pawan Lakhotia 1.3K views 9 comments 3 points Most recent by Ram M. Pillai Reporting and Analytics for ERP
-
Error when performing a multiplication on a calculated measure in OTBISummary: Hello, When trying to perform multiplication on a calculated measurement of the items in the image, An error occurs that I have not been able to resolve. Conten…Kauan_Bohn 41 views 15 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
BIP 12.2.1.4 desktop flagged with Malicious with high threat scoreSummary: Software packaging team has restricted BIP 12.2.1.4 desktop installation due to high threat score. Need a workaround so that we can continue to use BIP desktop …
-
Is there a way to limit what tables a user can query in OTBI?We have a support team that's requesting access to write Data Model queries in OTBI. Our concern is restricting them to only the financial tables. Does anyone know if th…Mike Burnett 23 views 3 comments 0 points Most recent by user10597052 Reporting and Analytics for ERP