FBDI Introduction

FBDI stands for File Based Data Import. It is a pattern provided by Oracle to have the data loaded into Oracle ERP Cloud. Its usually used for

Data volume to be imported is high.
Usually used to be loaded from FTP/SFTP locations to CloudERP.
OIC is the preferred choice for importing the files.

Below documents have complete information on FBDI and types of FBDI. These are the very useful Oracle links.

https://docs.oracle.com/en/cloud/saas/financials/r13-update17d/oefbf/Financials-File-Based-Data-Imports-Overview.html

https://docs.oracle.com/en/cloud/saas/financials/r13-update17d/oefbf/FBDIOverview.html



In the FBDI series, I will give detailed process of importing FBDI file to CloudERP.

OIC Integration using FTP Adapter created locally in WINDOWS 10, Local Machine

In this POST, I will provide detailed steps on how to use a FTP adapter in OIC using local FTP created in WINDOWS 10 machine  

Steps to create a scheduled integration in OIC using FTP adapter using local WINDOWS FTP. You can go through these links. 

Create FTP server using WINDOWS 10 locally: here  
Why is an ICS Agent needed: here 

•             Login to OIC àIntegrationàDesigneràAgentsàCreate Agent Group (Give below New Agent Group -Information)

Agent Group Name	DhireshWinLocalAgentGroup
Agent Type	Connectivity Agent
Description	POC purpose

• Download Connectivity Agent. Save it to C:\OIC\oicAgent\
  

C:\Windows\system32>cd C:\OIC\oicAgent\oic_connectivity_agent C:\OIC\oicAgent\oic_connectivity_agent>java -jar C:\OIC\oicAgent\oic_connectivity_agent\connectivityagent.jar Enter your OIC username : OICUserName Enter password for username : OICPassword No Proxy Configuration Detected Checking for trusted certificates ... Making call to check OIC Version ... Making call to check Agent group availability ... Updating Agent with configuration details ... Making call to register new agent instance ... Making call for getting agent app id & keys... Done with Agent installation & configuration... Starting Agent for message processing. Agent started successfully...Now available for new messages...

•            Ensure that the agent is running - OIC àIntegrationàMonitoringàAgentsàMonitor Agents

•          Create a FTP Connection : OIC HomeàIntegrationàDesigneràConnectionàCreate New ConnectionàSelect Adapter FTP and select create -

Name	DHIRESH_LOCAL_FTP
Role	Trigger and Invoke
Description	POC purpose

Once Connection is created. Provide the below details –

FTP Server Host Address	Local IPv4 address identified from Ipconfig
FTP Server Port	21
SFTP Connection	No
Security Policy	FTP Server Access Policy
User Name	Windows Login Id (usually Hotmail id)
Password	Windows password
Agent Group	DhireshWinLocalAgentGroup (as created in step1)

            Save and test the connection.

•         Create a new Scheduled Integration—OIC HomeàIntegrationàDesigneràIntegrationàCreate àScheduled Orchestration. I gave the integration name as DHIRESH_LOCAL_FTP

                 Edit the schedule parameters and add below parameter name and ensure these two directories are present in local ftp

fileName	test.txt
inputDirectory	/ftpLocalOIC/readDirectory
outputDirectory	/ftpLocalOIC/moveDirectory

            Drag the FTP adapter created above over + sign
            Details for Configuring the FTP Adapter

What do you want to call the endpoint	Move File
Select Operation	Move a File
Directory Path	/ftpLocalOIC/readDirectory
File Name	test.txt
Target Directory Path	/ftpLocalOIC/moveDirectory
Target File Name	newtest.txt

       

            Save and then ad the 3 variables. Save the integration. Add filename for tracking. Finally Activate the integration

             Activate the integration. Before Submitting the integration -

      

           Submit the integration. 

       

       

        

           You can  see after submitting the scheduled integration the file has moved from one Windows directory to another locally om your machine. 

 

Creating FTP locally using WINDOWS 10

In this post, I will explain how to create a local FTP server which we can use for creating future OIC FTP adapters - 

Step1: Type cPanel in Search tab. Then Browse Control Panel\All Control Panel Items\Programs and Features. Click Turn Windows Features on or off as below:

Select FTP and IIS Management Console and click Close.

Step2: Type cPanel in Search tab. Then Browse Control Panel\All Control Panel Items\Administrative Tools. Right Click on Internet Information Services (IIS) Manager and Run as Administrator. You will see a similar console – 

Step3 : Under Sites à Create New FTP option

Step4: No SSL. Select basic Authentication. Allow access to Specified Users with Read , Write permissions. Use PORT 21

Step5: Browse Control Panel\All Control Panel Items\Windows Defender Firewall\Allowed apps. Select FTP. Click OK

Step6: Run cmd as Administrator, Type ipconfig and Enter. Copy the IPv4 address and Default Gateway IP

Step7: Login to your router by typing Default gateway in the browser. Usually the user id password should be admin and password

Step8: Go to Port forwarding option. Select this computer and provide IPv4 address

 

Download WinSCP or any other FTP software. Create new session with below details - 

Protocol : FTP
 Encryption : No Encryption
 Hostname : IPv4 address
 Port Number : 21
Username : Windows User Id (usually the Hotmail Id)
Password : Windows Password

Note - This is my personal recommendation. Since we have allowed the firewall to use this FTP server, the best would be to use this only for POC, development purpose locally and once objective is achieved, you should use WINDOWS to disable the FTP feature. 

 

Oracle Service Bus 12C REST Example from Scratch – PART 2

In the previous part we understood how to set up OSB environment. In this Demo I will explain how to create a REST OSB Proxy Service and Business Service.

Now as the JDEVELOPER Studio Edition Version 12.2.1.4.0 and OSB Version 12.2.1.4.0 has been setup, I will first create a Business Service. For this DEMO I am not using any WADL, instead I will try to consume a REST API already available – http://dummy.restapiexample.com/create

 Step1: Click FileàNew ApplicationàService Bus TieràService Bus Application with Service Bus Project (I have provide the name of Application as Practice and Project as RestDemo)

Step2: Open the composite. Drag the REST Adapter to the External Services. Give name as DummyRESTBS. Follow the screenshots below

Step3: Generate a pipeline to connect to BusinessService. From the image above you can find a WADL was already generated by OSB while creating the Business Service. Follow the steps below and ensure that the pipeline is exposed as a Proxy Service

Step4: Connect Pipeline with the BusinessService

Step5: Right Click on the ProxyService and click RUN. This will open the Test Console for the proxy in the OSB integrated server. From the API the following use the below payload for testing

{"name":"test","salary":"123","age":"23"}

Jdeveloper Studio Edition Version 12.2.1.4.0 - REST ADAPTER ERROR FIX

If you get rror while using REST adapter– SOA 12.2.1.4 JDeveloper Error: NoClassDefFoundError com/fasterxml/jackson/core/JsonFactory

The following steps needs to be performed –

Download Bundle Patch Patch 30482761: SOA 12.2.1.4 JDeveloper Error: NoClassDefFoundError com/fasterxml/jackson/core/JsonFactory from Oracle Support and Unzip to your local

1.                   Open cmd in admin mode and follow the instructions as below

a.                   cd C:\Oracle\Middleware\Oracle_Home\OPatch

b.                   C:\Oracle\Middleware\Oracle_Home\OPatch>

SET ORACLE_HOME=C:\Oracle\Middleware\Oracle_Home

c.                   C:\Oracle\Middleware\Oracle_Home\OPatch>

SET PATH=%PATH%;C:\Oracle\Middleware\Oracle_Home\OPatch

d.                   C:\Oracle\Middleware\Oracle_Home\OPatch>cd C:\Users\dhiresh.kavi\Downloads\30482761

e.                   C:\Users\dhiresh.kavi\Downloads\30482761>opatch apply

[Oracle Interim Patch Installer version 13.9.4.2.1

Copyright (c) 2020, Oracle Corporation.  All rights reserved.

Oracle Home       : C:\Oracle\Middleware\Oracle_Home

Central Inventory : C:\Program Files\Oracle\Inventory

   from           :

OPatch version    : 13.9.4.2.1

OUI version       : 13.9.4.0.0

Log file location : C:\Oracle\Middleware\Oracle_Home\cfgtoollogs\opatch\opatch2020-03-29_00-50-26AM_1.log

OPatch detects the Middleware Home as "C:\Oracle\Middleware\Oracle_Home"

Verifying environment and performing prerequisite checks...

OPatch continues with these patches:   30482761

Do you want to proceed? [y|n]

y

User Responded with: Y

All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = 'C:\Oracle\Middleware\Oracle_Home')

Is the local system ready for patching? [y|n]

y

User Responded with: Y

Backing up files...

Applying interim patch '30482761' to OH 'C:\Oracle\Middleware\Oracle_Home'

Patching component oracle.soacommon.plugins, 12.2.1.4.0...

Patch 30482761 successfully applied.

Log file location: C:\Oracle\Middleware\Oracle_Home\cfgtoollogs\opatch\opatch2020-03-29_00-50-26AM_1.log

OPatch succeeded.]

     3.  cd C:\Oracle\Middleware\Oracle_Home\jdeveloper\jdev\bin --> run -jdev clean 

Oracle Service Bus 12C REST Example from Scratch – PART 1

SETTING UP LOCAL OSB 12C ENVIRONMENT VIA JDEVELOPER INSTALLATION

Step 1: Download SOA Suite from here
Step 2: Download Java SE Development Kit 8u241 from here
Step 3: Install Java
Step 4: Run cmd as Administrator à cd to Jdk bin location à C:\Program Files\Java\jdk1.8.0_241\bin>java -jar C:\swdownloads\fmw_12.2.1.4.0_soa_quickstart.jar
Follow instructions and keep clicking Next. Jdeveloper will be installed with SOA SUITE 12C and OSB 12C

Step 5: Follow the sub steps below to Start Integrated Server

1. Open JDeveloper Console click RUNàClick Start Server Instance
2. Provide username and password. Keep weblogic and welcome1. Don’t change any port and Click Next
3. You will start seeing the below messages -  
   #################################################[Waiting for the domain to finish building...]
   [12:35:36 PM] Creating IntegratedWebLogicServer Domain...
   [12:38:11 PM] Extending IntegratedWebLogicServer Domain...
   [12:39:51 PM] Extending IntegratedWebLogicServer Domain...
   [12:41:06 PM] Extending IntegratedWebLogicServer Domain...
   [12:42:55 PM] IntegratedWebLogicServer Domain processing completed successfully.
   *** Using HTTP port 7101 ***
   *** SSL port conflict detected.  The SSL port will be reassigned to port 7104. ***
   C:\Users\dhiresh.kavi\AppData\Roaming\JDeveloper\system12.2.1.4.42.190911.2248\DefaultDomain\bin\startWebLogic.cmd
   [Starting IntegratedWebLogicServer.]
   [waiting for the server to complete its initialization...] Depending on the system specifications, you will something like this
   [IntegratedWebLogicServer startup time: 420989 ms.
   [IntegratedWebLogicServer started.]
   **** Due to port conflicts, the server is configured at Listen port 7101, SSL port 7104.]#############
4. You can open the EM Console using this URL: http://127.0.0.1:7101/em/
   Weblogic Console using this URL: http://127.0.0.1:7101/console/
   Service Bus Console using this URL: http://127.0.0.1:7101/servicebus/

SOA CS ADAPTERS - JMS

JMS ADAPTERS - Creating Weblogic Resources

JMS (Java Messaging Service) Adapter is based on JCA architecture (J2ee Connector Architecture) also known as Binding components. It can be used either as Inbound (receive message) or external (publish message).

Adapters basic helps converts native data to web services format to be used by composite. Conversion is done using JCA API, packaged as .rar file deployed in WebLogic server which is available during the runtime of a composite.

It falls under category of Technology Adapters. This can be used by both Oracle SOA Suite and Oracle Service Bus.

JMS is Java Messaging Server Application which runs of Application Servers as WebLogic provides JMS messaging infrastructure two mechanisms for message exchange –

• Point to Point (Queue)
• Publisher Subscribers (Topic)

This acts as a bi-directional adapter which allows messages to be published both (inbound and outbound)


JMS Adapter Configuration

1. Login to SOA CS instanceàClick Managed Service IconàClick WebLogic Administrative Console.
2. Login to WebLogic Admin ConsoleàExpand Domain Structure Panelà ServicesàMessagingàJMS Modules
3. Click Lock and Edit Button. We can either create a new JMS module or create a new infrastructure under an existing module like SOAJMSModule. Click this module
4. Click Newà Select Queue àClick NextàProvide Name and JNDI Name as TestQueue1 and jms/TestQueue1. Click Finish. The Queue is now created
5. Click QueueàClick Subdeploymentà(Target to SOA JMS Server)
6. Click NewàSelect Connection FactoryàClick NextàProvide Name and JNDI Name as TestCF1 and jms/TestCF1. Click Finish. The Connection Factory is now created
7. Click ConnectionFactoryàClick Subdeploymentà(Target to SOA JMS Server)
8. Expand Domain Structure Panelà Deploymentsà JmsAdapteràClick ConfigurationàClick Outbound Connection PoolàSelect Existing Connection FactoryàClick newàGive JNDI Name of ConnectionPool as eis/TestQueue1. Save the deployment plan as JMSAdapterPlan.xml
9. Go Back to the ConnectionFactory created in Step8. Click the above JNDIàProvide ConnectionFactory created in Step 6 in the ConnectionFactoryLocation field, Click Save. Finally activate changes.
10. Click Lock and Edit. Expand Domain Structure Panelà Deploymentsà Navigate to JMS AdapteràClick JMS AdapteràClick Update Button, Click the option having the deployment plan created in Step8