Customer transaction AR Invoice Creation Inbound OIC Integration
AIM
customer transaction Creation Inbound Using OIC
deployment Instructions
Integration Required Files Link
Author: MD Abdul Rehman
Creation Date: JUNE 05, 2025
Last Updated:
Version: 1.0
Title, Subject, Last Updated Date, Reference Number, and Version are marked by a Word Bookmark so that they can be easily reproduced in the header and footer of documents. When you change any of these values, be careful not to accidentally delete the bookmark. You can make bookmarks visible by selecting Tools->Options…View and checking the Bookmarks option in the Show region.
Approvals:
To add additional approval lines, press [Tab] from the last cell in the table above.
Copy Number _____
You can delete any elements of this cover page that you do not need for your document. For example, Copy Number is only required if this is a controlled document and you need to track each copy that you distribute.
Document Control
Change Record
3
Reviewers
Distribution
The copy numbers referenced above should be written into the Copy Number space on the cover of each distributed copy. If the document is not controlled, you can delete this table, the Note To Holders, and the Copy Number label from the cover page.
Note To Holders:
If you receive an electronic copy of this document and print it out, please write your name on the equivalent of the cover page, for document control purposes.
If you receive a hard copy of this document, please write your name on the front cover, for document control purposes.
Contents
Create Connections for ACTIVITY CUSTOMER TRANSACTION 1
Open and Closed Issues for this Deliverable 32
To update the table of contents, put the cursor anywhere in the table and press [F9]. To change the number of levels displayed, select the menu option Insert->Index and Tables, make sure the Table of Contents tab is active, and change the Number of Levels to a new value.
Create Connections for ACTIVITY Customer Creation
Creation of Connections:
For Activity Apply Customer Creation we are using two Adapters 🡪 Restapi and Winscp (server)
To create connections, navigate to connections tab and select create option then select desired adapter as shown below.
Adapter :- it helps to store the required credentials to make a connection.
Creation Of FTP :
Connection Role :- a trigger means the connection where the integration receives the message. An invoke means the connection where the integration sends the message.
Based on our requirement we choose trigger and invoke role connection.
After clicking on create we need to pass the required Data along with the login credentials.
Click ‘Yes’ in SFTP Connection in Optional Properties.
Then click on test,popup will appear as shown above then select diagnose & test.
After successful testing save your connection.
Creation Of REST Api Connection For Creating Customer:-
role 🡪 trigger and invoke
Navigate to connections tab then select the adapter based on the connection(Rest)
Rest Connection : - https://fa-epxp-test-saasfaprod1.fa.ocs.oraclecloud.com.
Enter the Rest URL and select security as basic authentication and enter fusion credentails as username and password.
Then click on test, after testing successfully save the connection.
Creation Of Integration:
Click on Design and select the integration and Click on Create .
Try to create with a unique name for identification.
Select the application to create integration
Fill the name, Identifier and if includes then Package.
Select the sample rest connection and create the rest connection.
Select the method as GET as give the response as shown below.
And check the add and review parameters for this endpoint
In (What is the endpoint's relative resource URI?) : CT/CREATE
Click continue , add two parameters : headerFilename and linesFilename datatype string
Configure this endpoint to receive the response.
Next create and assign following variables.
Add the sftp connection
Select the list of files in the server to know if the data files exist.
In the mapper header file name picked up from the paramters in the trigger
Select the approiapriate directory in server and select file name pattern as (header file name)
Make sure you have put files in this directory structure
Name the ftp connection appropriate to your integration for better understanding. As we are listing the number of files in source dir, so we used the List_Files operation.
Use the switch connection after it if filecount=1 then proceed or else end to trigger mapper and it results that file doesn’t exists.
Now using FTP connection do a read file operation for the headers file
Drop your header data file here
In the read file mapper map header file name and directory from varibles
Now using FTP adapter List file operation check for Lines file exist
Map the list lines mapper to the assigned variables
Use the switch connection after it if filecount=1 then proceed or else end to trigger mapper and it results that file doesn’t exists.
Read Lines File using FTP adapter
Drag and drop lines file
In the mapper map with lines file name and directory variables
Open for each loop giving it repeating element as Header record so that the loop is now for each record.
In the loop open a scope
Using the REST conncetion we made create this REST node use POST method
Endpoint URL : /fscmRestApi/resources/11.13.18.05/receivablesInvoices
In request payload upload this file below
In response upload this file
In the REST mapper map header details from the forloop variable and lines details from the readLinesFileResponce use Choose XSLT function to link lines and header data
Using a Stage File Write operation store records that were successful and use headerdata file as file reference in this to store data.
In the mapper map all values from REST reponce and header_id from forloop variable
Make a Global Variable and store stage file refrence and add Success_file_flag = ‘Y’
Now open default fault handler in scope
In the fault handler add a stage file write operation to make a error records file
Use this file as schema file
In the mapper map as following
Create a data stich to assign this two variables
Outside the forloop open a Switch using following condition
In the switch create a read file operation
Give the following file reference
Create a Write file operation for FTP connection in switch with following configuration
Map all fields from read file to write file as follows
Create a Move File operation for FTP
Map as following in the mapper
Open a other switch with following condition
In the switch open a Stage read file operation with following configuration
Upload this file in the file reference
Create a FTP write file operation with following conguration
Upload this file for file refrence
Map all fileds from the pervios read file operation
Now create a FTP move file operation with following configuration
Map the following in the mapper
Outside the switch create read FTP file operation with following configuration
Map the following in the mapper
In the final trigger mapper map it as follows
Running The Integration:
Before running an integration we need to activate it initially it will be in draft state after successful creation it will be in configured state after activating it will be in active state.
You can activate and run as per your requirement it will run or you can just activate directly.
By clicking on submit now option it will run the integration.
You need to fill data file names in FTP server and click run then will get an InstanceId when you run the integration by clicking on that instance id you will be redirect to tracking page where you can check the status of that integration.
Tracking The Integration:
To track the integration manually Monitoring🡪Integrations🡪Tracking.
Here you can observe the InstanceId and status of the integration (if you clicked on InstanceId while running the integration you will be redirected here)
By clicking on instance id in activity stream you can check the flow of the integration.
Comments
Post a Comment