How to automate FBDI process in OIC

 

Use Case: Build a schedule orchestration to automate FBDI Process to load GL Daily rate to Oracle ERP Cloud.          

First of all we will create the required FTP and ERP Cloud Connections           

    FTP Connection                             

      Navigator --> Integration --> Connections --> Create

        Search: FTP and click button Select

        Fill the information as

         Name: FBDI FTP Trig Invoke Connect

         Identifier: FBDI_FTP_Connect

         Role: Trigger and Invoke                              

         Click button --> Create

          New page Connection Properties will display and complete it as

          FTP Server Host Address:129.148.208.34

          FTP Server Port:5013

          SFTP Connection OPTIONAL: Yes

          Security

          Username:********

          Password:********

          Press Button --> Test

          Press Button --> Save

          Oracle ERP Cloud Connection:                   

           Navitator --> Integration --> Connections --> Create

           Search: Oracle ERP Cloud and click button Select

           Fill the information as

           Name: FBDI Cloud ERP Trig Invoke Conn

            Identifier: FBDI_Cloud_ERP_Conn

            Role: Trigger and Invoke

            Connection Properties:                

            ERP Cloud Host:https://***.**.**.oraclecloud.com

            Security Policy:***

             Username: fusion.technical

             Password: *****          

        

             Press Button --> Test

             Press Button --> Save                    

             Now we will build our required integration                          

             Navigator --> Integration -->Integration                

             Press Button --> Create                                 

             Choose integration style --> Schedule Orchestration and click button --> Select      

             

             New popup will display and fill the form as                          

             Name: FBDI GL Daily Rates Main Service

             Identifier: FBDI_GL_DAILY_RATES_MAIN_SERVI

             Package: Practice                            

             Click button --> Create                   

After pressing button Create the popup will closed and your integration will be created. Change layout to horizontal and press button --> Save.

Now Download the Template DailyRatesImportTemplate, add required data in the template and create zip file. Once zip file is created move it to FTP server using WinSCP

In our integration, our first step is to read the file from directory and to do so we need add the FBDI FTP Trig Invoke Connect to integration.

New popup will appear and fill the information as

Now we need add the FBDI Cloud ERP Trig Invoke Conn to integration.

New popup will appear and fill the information as

We need to map the file from SFTP and pass input to Bulk import.

Press button validate and close to return back to integration. There is an error on the right side of the integration page. It need to fix.

Action --> Tracking

Press Button --> Save to return to integration page.

Press Button Save again and press button Close to return to integrations listing.

Activate the integration

Run the integration

That is It!