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