Oracle Fusion

Adding Banner in Fusion Instance

Adding Banner in Fusion Instance

with few simple steps, we can add Banner in Fusion Instance.

Banner is nothing but "A message displayed at the top of the Instance"

Example : You are using Prod Instance

Adding Banner

Search for Manage Administrator Profile Values Task

Open it and search for FND_BANNER_MESSAGE in Profile Option Code

Select first one in search results i.e., FND_BANNER_MESSAGE under Profile Options

Click on Create icon (+) under Profile Values

Enter "Site" for Profile Level and "Any text you want to display" for Profile Value

Save and Close

Previewing Data in FRS without Saving the Report

Generally in any report we see the output after saving the report. Issue is like if any changes has to be reverted it will be difficult, so FRS provides us options to preview data without saving the report.

We can see the output in either HTML format or PDF Format.

HTML Format:

Open any existing report

goto File > HTML Preview.

This opens report output in a new window.

This how output appears, since I didnot select any values for any segments we cannot see any data

PDF Preview:

Open any existing report

goto File > PDF Preview.

This opens report output in a new window.

Output in PDF Mode

Opening FRS Web Studio

Hi Everyone,

In this post let us see opening FRS Web Studio.

This is online tool that can be opened from Fusion Instance itself.

Step1: Login to Fusion and open Navigator

goto Others > Financial Reporting Center

Step 2: goto Task list > Open Workspace for Financial Reports

Step 3: goto Tools > Launch Financial Reporting Webstudio

This is how page looks after this

To create a New report: goto File > New > Report

Every report contains 3 parts Header, Body and Footer

Downloading FBDI Template

FBDI stands for File Based Data Import

FBDI can be used to load data in large volumes.

It is an offline application.

To get an FBDI template, follow these steps

Search for Oracle Fusion Financials FBDI templates > open the following link

Scroll down to required one, consider for AP_Invoices

For AP_Invoices, select Payables Standard Invoice Import. Highlighted .xlsm file is required fbdi template, download it.

If you scroll bottom to the page,

we can see scheduled process and Interface Tables used in this load.

Differences between File Adapter and FTP Adapter in OIC Integrations

Following are the differences between File and FTP Adapter

FTP Adapter:

We can create encrypted by using PGP

We can use decryption using PGP

For Trigger connection requires connectivity agent or else use a scheduled orchestration which can use ftp as invoke connection.

Supports Invoke connection

Supports Read, Write, Read in Segments, List, Download, Move, Delete operations

Can be used for FTP or SFTP server except if they are private requires Connectivity agent.

File Adapter:

We cannot create an encrypted file

We cannot create a decrypted file

Supports trigger connection

Supports Invoke connection as well.

Supports only Read and Write operations

Requires OIC Connectivity agent

Printing parameter values in Excel Template when All is selected

Hi Everyone,

In this post let us see how we can show values in Excel Output when parameter value is empty.

We dont get any value in parameter when we select All values in the Report and in the report All is linked with Null Values.

Let us see sample XML

<?xml version='1.0' encoding='utf-8'?>

<DATA_DS><BU/>

<G_1>

<INVOICE_NUMBER>1</INVOICE_NUMBER><BUSINESS_UNIT>test1</BUSINESS_UNIT>

</G_1>

</DATA_DS>

If we see above xml data BU tag dont have any value.

Let us see how we can we handle this in Excel Template.

<xsl:choose>

<xsl:when test="DATA_DS/BU!="">

<xsl:value-of select="DATA_DS/BU"/>

</xsl:when>

<xsl:otherwise>Print required value

</xsl:otherwise>

</xsl:choose>

Above code checks if BU value not equal to Null.

<xsl:when test="DATA_DS/BU!="">

If it is not equal to Null, then prints Bu value

<xsl:value-of select="DATA_DS/BU"/>

If it is Null, then print whatever value we need

<xsl:otherwise>Print required value

oracle.xdo.servlet.data.dataexception: your data is more than 65531 rows in a sheet, that exceeds Microsoft Excel (.xls) limitation

Hi Everyone,

oracle.xdo.servlet.data.dataexception:oracle.xdo.servlet.data.dataexception:oracle.xdo.XDORuntimeException: your data is more than 65531 rows in a sheet, that exceeds Microsoft Excel (.xls) limitation. Stop Processing. Suggest to turn on Excel Template Scalable Mode to true from Runtime Properties

If you see this issue while generating Excel output in BIP Report, it is due to the reason that you have large amount of data in your report. In an Excel sheet, it can accommodate only upto 65531 records, if more that count of data comes this issue arises.

Solution to this problem:

Go to the concerned Report and open properties

Formatting

Excel Templates > Enable Scalable Mode. Set this to True

Now go and check if report is working for large data. If you check the report output, we can see data comes in multiple sheets.