-
Does anyone have Audit/Report on Report Delivery to Customers via BIP bursting?
We need to audit all Emails sent out externally to customers/suppliers which we can view individually on Report History of Individual Reports output.
-
Trial balance report
Where can I find the Query or the tables that bring the data from the Trial Balance Report scheduled process?
-
How send two file-excel multi. template
Good day everyone! Is it possible to send several files in one letter using bursting? I have a report and there are two templates in it, how should I send them to the mail, but so that there are two files in the attachment?
-
Project, Task and Expenditure type details related with Team Time Card details
Dear Team, I trust this message finds you all well. We're currently working on a report to retrieve Team Time Card entries. Our objective is to include specific columns (Project, Task, and Expenditure Types) that are visible in the frontend. In previous attempts to meet this requirement, I utilized the 'PJC_EXP_ITEMS_ALL'…
-
How can i get session log details for BI publisher ? where it gets stored and how we can access it ?
Hello team we are looking for help in getting Run time logs for the report run in BIP .
-
Is there a way to pull the email status for Bursting logic in BI fusion Oracle
Is there a way to Oracle fusion has a table or report to pull all the bursting email status for Bursting from BI report?
-
table name for input value in BIP report oracle
-
Is there a role in Oracle Fusion BIP catalog, that allows users to view data model and not edit it
I would like to know if there is a role in Oracle Fusion BIP catalog, that allows users to only view data model query but not give users the access to edit it.
-
Unable to get value from variable after the tag <?start@last-page-first:body?><?end body?> in RTF
I have developed custom PO RTF template where i am having qty, price & extended_amt (qty * price) under line group so i am using variable inside the group to get the total extended_amt which is working fine before this tag but as i have a requirement to display particular section at the bottom of the last page in the…
-
Reconciliation Report using Supporting Reference segments
We have a reporting requirement to track a transaction (together with natural account) from GL to subledgers. A DFF is created at Journal header level to capture 'Transaction Owner" and the same DFF is defined as supporting reference in different subledgers with same value set. Hence, the ask is to track a complete…
-
Does OBIEE12c to OAS upgrade involve upgradation of all distribution rule lists along with Reports?
We want to upgrade OBIEE 12C(12.2.1.4.x) to same server & OS of OAS. But along with OBIEE Reports, does this upgradation transfers distribution rule lists and application roles as well? Are there any further things to be upgraded manually? What is the tentative to complete this upgradation process?
-
Hide xml tags without data in transformed xml using xsl template in Fusion BIP reports
We are using xsl template in Fusion BIP report to create the output in xml format. Can you let us know if there is a way in xsl template to not display the tags in transformed xml when there is no data. There are multiple xml tags and we don't want to add <xsl:if> for each of the tags in xsl template. Is there any better…
-
Put instructions on Parameter page
Is there a way to put a text box with instructions/comments/directions on the parameter page?
-
Issues in connecting to SFTP servers
Hi, We are migrating OBIEE 12.2.1.4 to OAC. While setting up SFTP server connection via Manage Publisher → FTP Connection, we are getting errors like Connection Timed Out or Invalid Connection Details etc. The same details are working on OBIEE. We have created ingress rules for these servers in OCI and egress is open to…
-
How to retrieve data from xml file which is loaded as data source in data model in oracle fusion
I have a requirement where report will have 2 data set.One data set will have xml file as data source and other data set will have sql query as data source.How to retrieve the data from the xml file data source and use in the other data set?Which function of SQL query used to retrieve xml data? Really appreciate any…
-
Is Oracle Analytics Publisher Desktop free to use for EBS customers?
We are using Oracle E-business Suite version 12.2.17 and would like confirmation that we can download Oracle Analytics Publisher desktop without there being any licensing implications. From MOS documents we believe this to be the case but would like it confirmed. Thank you!
-
Certification of Oracle Analytics Publisher (OAP) on SuSE 15
According to Oracle Analytics 7.0 universal installer, OAP is certified on SuSE 11 and SuSE 12 (check attached screenshots). But support for SLES 12 will end this year: https://www.suse.com/de-de/lifecycle/#suse-linux-enterprise-server-12 General Ends: 31 Oct 2024 Are there any plans to certify OAP 7.0 on SuSE 15?
-
issue while accessing the report from 3rd party application which is integrated with OBI 12.2.1.4
hi, while we access the report from our business application we get the page loaded and prompting for credentials, on entering the weblogic console id pass, once we give credentials reports open. need assistance in this matter if any one can help to fix this issue. regards manoj
-
BI Publisher Report Generation Exception
Hi, I have used the latest bi publisher desktop version software and added as plugin to the MS-Word 2016 version for testing. Later, I have create the template with RTF extension and then used Bi publisher→Translation→Extract Text→ download XLIFF file in local directory. But, This file creates some problem and got below…
-
Extracting excel output in multiple tabs
Hi All - Has anybody worked on below requirement and is it feasible in Oracle ERP fusion? We have a RTF template, and excel output. Is it possible to split the output by number of records (say 30K) as separate sheets in excel output.
-
OTBI analysis bug after 24A update cannot produce csv properly
Hello, We have a custom BIP data model that has used an OTBI Analysis and an xpt report. We schedule this job to run so it will ftp the csv output to an onsite server for further use. This report has been in use for quite a few years. After the 24A upgrade, we followed the suggested doc (Doc ID 3004201.1) Unable To Create…
-
How can we Byepass login screen when rendering analtytics Content in IFarme
Hi, How can I authenticate the loading of analytics report without the need of displaying the login to the end user. Analytics report is rendered in the web application using the iFrame.
-
How to implement Bulk invoice download in BIP
Hi, We have created a BIP report to get IDR links attached to invoices and by clicking on the link given by the report we can download only one invoice at a time. Is it possible download bulk invoices at a time or any other way by which we can extract entity wise bulk invoices etc? Thanks, Nirupama
-
Creating dynamic page indexes based on real-time data in an RTF template within Oracle BI Publisher
Hi Team, We have requirement to print page index/table of content in the word document output in BI publisher report. We are trying to print table of content in the word document output for us its how as page no 0 in the rtf output. Is it possible to get the dynamic page indexes based on real-time data in an RTF template…
-
Schedule via email with bursting option a BI publisher report with ETEXT layout is not funcitonal
Having a BI report with ETEXT layout and the according bursting query defined at its data model, while we are trying to schedule it via email with bursting option enable (Use Bursting Definition to Determine Output & Delivery Destination), the job is finished without success. Alternatively when the report is scheduled…
-
Which tables stores value for Order Orchestration Function and error messages
Can someone help/confirm Which Oracle tables stores value for Order Orchestration Function and error messages (under Financials - Order Management module)
-
How to start page numbering in .rtf template at Page 0 ?
I'm customizing a .rtf template associated to a BI Publisher report. I want to customize the page numbering to start at 0 and exclude the first page from the total number of pages. Purpose: not to have page numbering on the first page ; start page numbering as of page 2 ; exclude the first page of the total number of…
-
invalid relational operator error
Hi - I am trying to write a query to pull report parameter value in report layout, however due to system limitation whenever my default selection for any parameter is All then its appearing as blank in report. To show All as my selected parameter in report output, I created a data base query which is - Select Case when…
-
Security audit logs for the system
I am trying create Bi report that has table and columns that show the detail to who add delete and edit the data such as the user and their email etc.
-
How to Automate Migration BIP Report Objects from one Cloud Fusion POD to other POD
I wanted to understand the Oracle recommended approach for Migration of BIP Report objects from one environment to other environment in a Oracle Cloud HCM application automatically without the Manual process listed below, so please share us with best practice or Solution that is best for this ask Current Process: we use…