Oracle Financials Cloud V1 midstream transformation in mappings
Before you configure a midstream transformation, you must create a business service. Select an Oracle Financials Cloud V1 connection and choose an Oracle Financials Cloud operation when you create a business service.
Midstream transformation properties
When you configure the midstream transformation, select the business service and the operation on the Web Service tab.
When you select a midstream transformation, the Properties panel displays the following areas and information:
General
Use to configure the name and a description for the transformation.
Incoming Fields
Includes the field rules that define the data that you read from the source. Allows a preview of the source fields.
Web Service
Specifies the business service and the operation that you want to perform in an Oracle Financials Cloud application.
Request Mapping
Maps the incoming fields from source file to elements in request structure.
Response Mapping
Maps the selected elements from the response structure with the output fields. You can view the response structure on the Response Mapping tab. When you map the elements from the response structure to the output fields, the Secure Agent creates the output groups, along with the primary and foreign keys for the field names.
Output Fields
Displays the fields included in the mapping.
Advanced
The properties required to configure a midstream transformation.
Oracle Financials Cloud V1 advanced midstream properties in mappings
The following table describes the advanced properties that you can configure for a midstream transformation:
Property
Description
Inbound_Parameter_List
Enter the values of the argument in order and use a comma to separate the argument values for the selected object.
For example, enter the value in the following manner: 300000046975980,Balance Transfer,300000046975971,ALL,N,N,N
Note: Use this property when you run a mapping to write data to a target.
Outbound_Output_Directory
Enter the directory path where you want to download the .csv files on the machine that runs the Secure Agent .
By default, the .csv files are downloaded as a zip file in the IO Directory\Reader\Output directory.
If you provide a directory path in this property, the Secure Agent downloads the .csv files in the directory path that you specify here and ignores the default directory path.
Note: Use this property when you run a mapping to read data from a source.
Timeout_Value
Specify the time in seconds for the connector to wait and initiate download of output logs and data. Default is 300 seconds.
Cache Size for Web Service Request (KB)
Memory available for the web service request. If the request is more than 100 KB, you can increase the cache size.
Default is 100 KB.
Cache Size for Web Service Response (KB)
Memory available for the web service response. If the web service response contains many rows or columns, you might want to increase the cache size.
Default is 100 KB.
Allow Input Flush
Not applicable.
Transaction Commit Control
Not applicable.
Midstream transformation mapping example
To read data from an Oracle Financials Cloud V1 source and to write the data to a flat file, perform the following tasks:
1 Create an Oracle Financials Cloud V1 connection to read data from an Oracle Financials Cloud V1 source.
2In Data Integration, click New > Components > Business Sevice.
The Business Sevice Details dialog box appears.
The following image shows the configured business service that associates an Oracle Financials Cloud V1 connection and an operation:
3On the Web Services transformation, specify a name and description in the general properties.
The following image shows the source, web service, and target in the Oracle Financials Cloud V1 mapping:
4On the Web Service tab, select the business service and the operation that you configured.
The following image shows the configured web service:
5On the Request Mapping tab, map the incoming fields from the source to the elements of Request Structure to form a web service request.
The following image shows the fields that you map:
6On the Response Mapping tab, select the source details fields that you want to write to the target file on the Response Structure.
The following image shows the source details fields that you want to write to the target file:
7On the Advanced tab, provide the value for the required advanced property. You can specify the cache size details.
The fields that you select from the Response Structure of the Web Service transformation appear as incoming fields for the target object.
8If required, map the incoming fields to the flat file fields.
The following image shows the mapped fields between the source field and the target field:
9Click Task Wizards > Mapping Task, and select the mapping for the task.
10When you save and run the mapping, the Secure Agent reads the data that you map on the Request Mapping tab from the Oracle Financials Cloud application and writes the data to the corresponding flat files.
Rules and guidelines for midstream transformation in mappings
Use the following rules and guidelines when you run a midstream transformation in a mapping:
•When you use a midstream transformation to read data, you must map all the arguments in the request message from a source.
•You must use expressions to convert the values of the date/time argument to date.
•You must provide the value for the date type argument in the YYYY-MM-DD format.
•You must not provide a null value for the date type argument in the request message. You must provide a real or a dummy value for the date type argument in the request message. However, there might be an impact in the output.
