Oracle Financials Cloud V1 target transformation in mappings
When you configure a Target transformation, select an Oracle Financials Cloud V1 connection and choose an Oracle Financials Cloud operation to represent an Oracle Financials Cloud V1 target.
Target transformation properties
You can use one or more Target transformations in a mapping.
When you select a target transformation, the Properties panel displays the following sections:
General
Use to configure the name and a description for the target.
Incoming Fields
Includes the field rules that define the data written to the target. Allows a preview of the target fields.
Target
Use to select the connection and the operation, and to configure the advanced target properties.
Target Fields
Not applicable for an Oracle Financials Cloud V1 targets.
Field Mapping
Use to define the field mappings from the upstream transformation to the target.
Oracle Financials Cloud V1 advanced target properties in mappings
In a mapping, you can configure or create a Target transformation and configure the advanced properties in the Target page of the Mapping Task wizard.
The following table describes the advanced properties that you can configure in a Target 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)
Not Applicable.
Note: Do not change the value of this property unless Informatica Global Customer Support instructs you to do so.
Input settings properties
You can enable Sorted Input under Input Settings. Sorted Input indicates that input data is presorted. Default is disabled.
Enable sorted input for better performance.
Note: When Sorted Input is enabled and the input is not sorted, the Secure Agent does not process input and the mapping fails.
Target transformation mapping example
You can map a source to an Oracle Financials Cloud V1 target and use the mapping to perform a mapping task.
To read data from a source and write to an Oracle Financials Cloud V1 target, perform the following tasks:
1In Data Integration, click New > Mapping > Create.
The New Mapping dialog box appears.
2 Enter a name and description for the mapping.
3 On the Source transformation, specify a name and description in the general properties.
4On the Target transformation and perform the following tasks on the Target tab:
aIn the Connection field, select the Oracle Financials Cloud V1 connection to connect to Oracle Financials Cloud application.
bIn the Operation field, select the required object in the Package Explorer section and select the required operation.
cIn the Advanced Properties section, provide a value for the Inbound_Parameter_List property. You can set the cache size and the transaction commit interval.
5On the Field Mapping tab, select the input elements to map to the target fields.
The following image shows all the mapped fields between the input file and the Oracle Financials Cloud V1 target:
6Map the source and target.
7Click Save and Run the mapping.
8In Data Integration, click New > Task.
9Click Mapping Task > Create and select the mapping for the task.
