Oracle Financials Cloud V1 Connector > Mappings and mapping tasks with Oracle Financials Cloud V1 Connector > Oracle Financials Cloud V1 source transformation in mappings
  

Oracle Financials Cloud V1 source transformation in mappings

When you configure a Source transformation, select an Oracle Financials Cloud V1 connection and choose an Oracle Financials Cloud operation to represent an Oracle Financials Cloud V1 source.
When you read data from the Oracle Financials Cloud application and write data to a target, the target contains only the status of the read operation. The .csv files are downloaded as a zip in the following directory on the Secure Agent machine: IO Directory\Reader\Output
To access the .csv files, you must have the access to the directory on the Secure Agent machine.

Source Transformation properties

You can use one or more Source transformations in a mapping.
General
Use to configure the name and a description for the source.
Source
Use to select the connection and operation. You can configure the request options and advanced source properties.
Field Mapping
Use to map elements of the response structure with the output fields.
Fields
Use to edit the source field metadata that you want to use in the mapping.

Oracle Financials Cloud V1 advanced source properties in mappings

In a mapping, you can configure or create a Source transformation and configure the advanced properties in the Source page of the Mapping Task wizard.
The following table describes the advanced properties that you can configure in a Source 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
For more information about obtaining the value of the Inbound_Parameter_List property, see https://kb.informatica.com/howto/6/Pages/20/519421.aspx?myk=519421
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.
Tracing Level
Amount of detail that appears in the log for the Source transformation. Use the following tracing levels:
  • - Terse
  • - Normal
  • - Verbose Initialization
  • - Verbose
Default is normal.
Cache Size for Web Service Response (KB)
Not Applicable.
Note: Do not change the value of this property unless Informatica Global Customer Support instructs you to do so.

Source Transformation mapping example

You can map an Oracle Financials Cloud V1 source to a target and use the mapping to perform a mapping task.
To read and download the data from the Oracle Financials Cloud application, 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.
    3On the Source tab, perform the following steps:
    1. aIn the general properties, specify a name and description.
      2. The following image shows a sample of the Oracle Financials Cloud V1 mapping:
    2. bIn the Connection field, select the configured Oracle Financials Cloud V1 connection to connect to the Oracle Financials Cloud application.
      1. aIn the Operation field, select the required object in the Package Explorer section and select the required operation.
        2. The following image shows the list of the read operations:
        Note: If you select the Custom Extract operation, you can provide your own custom arguments.
    3. cIn the Request Options section, click Configure to configure the request message.
      4. Specify the request message and attributes in the XML format. Request messages are different for each of the objects. When you read data from the Oracle Financials Cloud application, you can extract the data using the following extract modes:
      - FULL_EXTRACT
      - INCREMENTAL_EXTRACT
      - INCR_DATE_UPDATE
      - REGISTER_CUSTOM_EXTRACT
      - RERUN_MODE
      If you do not provide any argument value in the request message, the Secure Agent sets the P_EXTRACT_MODE extract mode to FULL_EXTRACT extract mode and sets the P_EXTRACT_NAME extract mode to the object name that you have selected.
      The following example shows a sample request message for the Receivable Adjustment Extract object:
      <!--1 or more repetitions:-->
      <proc:REQUEST_MESSAGE_INPUT xmlns:proc="http://xml.schemas/infa/procedure/">
      <!--1 or more repetitions:-->
      <P_ORG_ID>
      300000046987012
      </P_ORG_ID>
      <!--1 or more repetitions:-->
      <P_ORDER_BY>
      ADJUSTMENT_NUMBER
      </P_ORDER_BY>
      <!--1 or more repetitions:-->
      <P_ADJ_NUMBER_LOW>
      <!--STRING-->
      </P_ADJ_NUMBER_LOW>
      <!--1 or more repetitions:-->
      <P_ADJ_NUMBER_HIGH>
      <!--STRING-->
      </P_ADJ_NUMBER_HIGH>
      <!--1 or more repetitions:-->
      <P_TRX_NUMBER_LOW>
      <!--STRING-->
      </P_TRX_NUMBER_LOW>
      <!--1 or more repetitions:-->
      <P_TRX_NUMBER_HIGH>
      <!--STRING-->
      </P_TRX_NUMBER_HIGH>
      <!--1 or more repetitions:-->
      <P_TAX_REGISTRATION_NUMBER>
      <!--STRING-->
      </P_TAX_REGISTRATION_NUMBER>
      <!--1 or more repetitions:-->
      <P_EXTRACT_MODE>
      FULL_EXTRACT
      </P_EXTRACT_MODE>
      <!--1 or more repetitions:-->
      <P_INCR_EXPORT_DATE>
      <!--DATE-->
      </P_INCR_EXPORT_DATE>
      <P_EXTRACT_DATE_FROM>
      <!--DATE-->
      </P_EXTRACT_DATE_FROM>
      <!--1 or more repetitions:-->
      <P_EXTRACT_DATE_TO>
      <!--DATE-->
      </P_EXTRACT_DATE_TO>
      <!--1 or more repetitions:-->
      <P_EXTRACT_NAME>
      ReceivablesAdjustmentsExtract
      </P_EXTRACT_NAME>
      <!--1 or more repetitions:-->
      <P_PARENT_EXTRACT_NAME>
      <!--STRING-->
      </P_PARENT_EXTRACT_NAME>
      </proc:REQUEST_MESSAGE_INPUT>
      For the arguments that you did not provide values in the request message, the Secure Agent considers the values of the argument as null. By default, the Secure Agent considers the value of the second last argument as the operation name. However, if you provide the value of the second last argument in the request message then the Secure Agent considers the value that you provide.
      Note: If you encounter an error message when you validate the request message, you can ignore the error message and proceed. There is no impact in the output. However, if you want to remove the error message for the date type argument in the request message, you must provide the following XML code inside the date tag in the request message:
      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:nil="true"
      The following example shows a sample request message for the Custom Extract object:
      <proc:REQUEST_MESSAGE_INPUT xmlns:proc="http://xml.schemas/infa/procedure/">
      <!--1 or more repetitions:-->
      <jobDefinitionName>
      <!-STRING->
      </jobDefinitionName>
      <!--1 or more repetitions:-->
      <jobPackageName>
      <!-STRING->
      </jobPackageName>
      <!--1 or more repetitions:-->
      <paramList>
      <!-STRING->
      </paramList>
      </proc:REQUEST_MESSAGE_INPUT>
      Note: When you configure the Custom Extract object, you must include the jobDefinitionName, jobPackageName, and paramList parameter. When you define the paramList parameter, include comma separated values and if there are no parameters defined, include #NULL. To access the Custom Extract object, create custom user defined ESS job in the Oracle Financials Cloud Application.
      The following image shows the parameters defined in the Job Definition page:
    4On the Field Mapping tab, select the elements in the response structure that you want to map to the output fields.
    Select the check box and expand the option. Select Map All Decendants > Output Group to choose the source from where you want to read.
    The following image shows the response structure on the left pane in a hierarchical format and the output groups on the right pane in a relational format:
    5On the Target transformations, specify the target connection, target type, object, and operation for the target transformations.
    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.
    The following image shows the Mapping Task wizard with the applied mapping:

Read the encrypted data

You can read the encrypted data from an Oracle Financials Cloud application.
To read the encrypted data from a source, configure the UseReaderEncryption property in the Secure Agent.
The encrypted data is saved in the .gpg format.
To configure the UseReaderEncryption property, perform the following steps:
  1. 1In Administrator, select the Secure Agent listed on the Runtime Environments tab.
  2. 2Click Edit.
  3. 3In the Custom Configuration section, add the following property and save:
    4. Attribute
    Value
    Service
    Data Integration Server
    Type
    DTM
    Name
    UseReaderEncryption
    Value
    true
    Sensitive
    Not selected
  4. 4Restart the DIS for changes to take effect.