-
BI Publisher - Word Preview error/failed
I am getting an error when trying to preview a document. ConfFile: C:\Program Files\Oracle\Oracle Analytics Publisher\Oracle Analytics Publisher Desktop\Template Builder for Word\config\xdoconfig.xml Font Dir: C:\Program Files\Oracle\Oracle Analytics Publisher\Oracle Analytics Publisher Desktop\Template Builder for…
-
How do I change de date formats for a non-ISO field in a RTF template?
Hi, I'm kind of new in Oracle-land, and the many fora and places to ask questions are still sometimes confusing, so first of all I hope I'm in the right place at the moment. The issue at hand is: I live in 'nl-NL' and I'm building a template for a confirmationletter for Opera Cloud. In this letter I have several date…
-
Programming of a Bi PUblisher
Hi, I have problems when programming BI Publisher. I can't get it to add 1 day to the parameter. What I want is that it takes each day, the day of execution as input parameter but it always executes the same day. The day I programmed it. It always executes it with the 30/10/2024. Regards, Iker
-
SWIFTMT103 Payment Template Issue.
Problem Description --------------------------------------------------- SWIFTMT103 standard payment template whose 32A tag is not generating decimal value upto 2 places for Payment Amount value and it is showing the after decimal value as zero. Kindly help me to resolve this issue. Regards, Mujtaba
-
What is the difference between Uploading a BIP report vs. Archiving a BIP Report
Summary: There are two options to take a copy or get a copy of Data Model and Reports. * XMLPServer and click on Upload/Download * Catalog folder and Archive/Unarchive Content (please ensure you mask any confidential information): What is the difference between these two options? When should we choose one over the other?…
-
Calling another template in RTF left-justifies the alignment instead of justify
Summary: Content (please ensure you mask any confidential information): Hi all, I am calling another template within my rtf template and it's working great, but the issue I am getting is that when I run the sub template on it's own, the page is just the way I want it (justify alignment), but when I run the report within…
-
Format table cells in RTF Template like Excel's "accounting" number-format?
If you're like me, you've got a RTF template that contains a table of numeric values, and you've been asked to format them "like the 'accounting' number-format from Excel" — with one difference. I'd appreciate some advise on how to make this happen? From what I can tell, this means: a dollar sign aligned to the left margin…
-
Possible to display the current and future value of a specific payroll element for an employee?
Hi there, Our business requirement is to produce a BI report that shows the current and future values of a known and finite set of payroll elements for an employee. For example, suppose Employee A currently has a Base Salary and Involuntary Deduction. Following a promotion - effective 30 days from now - the Employee's Base…
-
There is a way to limit access to specify tables trought customize DM in OTBI?
Hi everyone! We have a requeriment, and we need to know if there is a way to restrict the access an specifics tables in oracle fusion trought customize DMs in OTBI? I mean, create a custom role with access to OTBI and just can query the following tables and not others. FND_FLEX_VALUES FND_FLEX_VALUES_TL…
-
Is it possible to create a data set using REST API as a data source in oracle fusion cloud?
Please suggest solutions to set up an REST API as a data source for a data model in Oracle Fusion. instead of sql query as a data set we need to pull data from rest api data.
-
BI publisher Header record displays in Uppercase.
I am generating CSV file with PIPE(|) delimiter and output looks good. However, my header record always display in Uppercase even though I defined as mixed case in the data model query. my requirement is whatever format I gave and should come same format in my CSV file. select FIRST_NAME 'FirstName', LAST_NAME 'LastName'…
-
Can we write a report to query the "Directory" and "File Name" from report history?
We are checking to see if it's possible to write a query in BIP to query BIP report history and capture the Directory and File Names. Use case is that we need to provide these details to another team so they can validate they picked up and processed each of the files we FTP'd to them.
-
CUPS Server Printer Setup in ERP BIP
Summary: Hi Team, we have below requirement and need to understand. Can some one please help on this. * The print server has been installed in Azure with the CUPS service activated. * We need to setup point1 CUPS server printer server in BIP. Content (please ensure you mask any confidential information): NA Version…
-
Inquiry Regarding Dynamic User Inclusion in Report Emails via Bursting
Summary: Hi Oracle Experts, We have received a request from our users to include the username of the individual executing a report in the email body after the "Thanks" section within the bursting logic. This inclusion should occur dynamically whenever a report is executed, whether through a scheduling job or an ESS job.…
-
Oracle BIP Report Not Summing
I need your help in my RTF template that has a sum for every each segments. * I added the field in the cell, set the Calculation to Sum and checked the Grouping. * Generated the report and it's giving "0.00" in value instead of 5,149.999.96 (DEBITS Column) Here's the report layout: I would appreciate any help. I'm not sure…
-
Can we get ZPL output for Zebra Printer from Oracle BI Publisher
Summary: We need to get ZPL output for Zebra Printer from Oracle BI Publisher. Is it possible to get that. Please advise. Content (please ensure you mask any confidential information): We need to get ZPL output for Zebra Printer from BI Publisher. Is it possible to get that. Please advise. Version (include the version you…
-
Customization of item structure report
Hello Everyone, Actually ,We are trying to do customize the standard report of item structure report, where we have followed the oracle document to Configure the Template for the Item Structure Report with Additional…
-
how to call a procedure call(Row Tag name)in BI publisher 11.1.1.7.141014
Summary how to call a procedure call(Row Tag name)in BI publisher 11.1.1.7.141014 Content Hi All, how to call a procedure call(Row Tag name)in BI publisher 11.1.1.7.141014. I am creating a Data Model by using a procedure call and creating the template as a RTF by using the same datamodel. Regards, Chandra
-
Empty columns missing from BI Publisher output in oracle fusion report and analytics
I have developed BIP report with around 60 columns in my query and generated pipe (|) delimited output. However, my output shows only columns which has data and missing all other columns which does not have any data. My requirement is to include each and every column in the output whether the data exists or not. Really…
-
How to add a parameter when calling a function from the trigger section
I have a parameter that I pass directly to the data model - RDATE, and this parameter is automatically added to the triggers section. I get an error when calling the function in the usual way - PKG_REPORT.CHECK_RESULT_FROM_CALC_REAL_CASH_EXPIRE(SYSDATE) "ORA-06550: line 2, column 18: PLS-00302: component 'RDATE' must be…
-
NVL In RTF Template
Summary NVL In RTF Template Content Hi Team, How to use NVL In rtf templete If <ABC> is null the it should write <DEF> Thanks AT
-
Create a conditional area in a pivot table in publisher rtf
Hello Team, I created a pivot table in an rtf. I would like to show the cell of the total by row only if the attribute row is similar (includes or not) to some text. I thought about using the like condition in an if statement, but it doesn't seem to work. This is the if statement that works: <?if@cell:.//H = '01 -…
-
BI Publisher Sync vs Asynch
We have recently upgraded from BIP V11 to V12 and all our reports appears to be running in Async mode instead of the previous Synchronous mode when we post the URL to run the report into a browser, Is it possible to run in Synchronous mode? Is this a setting somewhere that has been perhaps lost in the upgrade?
-
Issue with Bursting Query in Oracle Report: "There is no data to process" Error
I have created a report in Oracle that outputs data correctly when run on its own. However, when I attach a bursting query and run it through an ESS job, I receive the error: "There is no data to process", even though there is data available. Here is the bursting query I am using: SELECT '1' AS KEY, 'Department Delete…
-
How to layout tables in custom order by RTF
Hi, All I am looking to layout 8 tables per page in RTF, 2x4. The tables should be generated based on the values contained in a single row of the data model, I would like the output in the following order one table on the upper left one table to the right of 1. 3. one table to the left of the next line one table to the…
-
How to recover / find who has deleted the data model.
Unfortunately, the data model got deleted. So we need to know who has deleted the data model. Could you please share the steps to check the history of data model.
-
GettingError "ORA-00904:"CPI"CLEARING_CCID":invalid identifier" while running US 1099 Paymentsreport
GettingError "ORA-00904:"CPI"CLEARING_CCID":invalid identifier" while running US 1099 Payments seeded report Need some guidance on troubleshooting this error, Would like to understand the root cause for this
-
Query for Workflow Details of NIR
Hi Everyone, I am looking for the query to get workflow task details of an NIR. Please refer to highlighted part screenshot for details. I am creating a custom BIP Report for this requirement.
-
Accidentally deleted a report and data model - can it be recovered?
Summary Accidentally deleted a report and data model - can it be recovered? Content A user accidentally deleted a report and its data model, can this be restored? Once a catalog object is deleted, does it go to a deleted folder before it is purged? I am checking in other environments to see if there is a copy there.
-
Barcode / QR code generating capability on a BI publisher report originated from Oracle FAW / ERP
Hello All - Need community insight on a client requirement I am working currently. There is a requirement to generate Barcode / QR code from the data exists in Oracle ERP / Financials on a BI publisher report originated from the Oracle FAW. Once generated, the next ask is to send them for printing on a peel and stick type…
