-
How to avoid ask reference when I validate a request
Hello, I have a problem with editing reports. I duplicated a data model and want to add fields in the query but parts of the query are dynamic and when validating the changes, it asks me to value these parts. How can I validate without doing this valuation? Thank you
-
BI Publisher XPT='template' ERROR
We have installed a publisher 12c version, but after registering on a publisher, we receive an error when we make changes or share it with other users. Anyone experiencing this problem? How should we solve it? Best Regards, Özcan GÜNGÖR
-
BI Bursting with PDF attachment and HTML in the body
Summary BI Bursting with PDF attachment and HTML in the body Content Hi All Kindly, I have business requirement as following: * to send email to our customers email with attached PDF file and html body, this is how I did this: * I developed new report in BI with Bursting option as a PDF, * RTF template * I am passing the…
-
How to restrict access to audit tables in fusion HCM
Hi All, We have a certain requirement to restrict access to audit tables like "CMP_SALARY_". People with only specified roles/permissions should be able to query this table. Is there anyway or workaround to restrict access like this? Thanks, Thimmaiah
-
Help with Transaction History Report in DM
I need to find the table that have this information: Transaction Source Could someone kindly help me?
-
Is there a log that contains error details for Oracle Analytics Publisher REST API
I am trying to use the RunReport request but am getting "Request Failed" returned. For testing purposes at this point, the report only returns current time and does not take parameters. Using the same report path, I am able to retrieve the report definition using the Get Report Definition request, so the API is…
-
Excel Template Scalable Mode to true from Runtime Properties?
Waiting Time: 0.6 seconds Data Fetch Time: 1.9 minutes Total Execution Time: 2.3 minutes Job Priority: Normal Output fejlede. [INSTANCE_ID=bip.bi_server1] [OUTPUT_ID=1608279] oracle.xdo.XDORuntimeException: Your data is more than 65531 rows in a sheet, that exceeds Microsoft Excel (.xls) limitation. Stop processing.…
-
how to get the underline details of job history in bursiting
Using bursting if we are sending any letter i need to know the details of the against each employee the delivery status Sucess/Failed/Error and the email to which it is delivered.
-
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 -…
