1. Import Customer Records from an FTP Server to Oracle ERP Cloud
  2. Activate and Run the Recipe

4 Activate and Run the Recipe

After you've configured the connections, you can activate and run the recipe.

  1. In the project workspace, click Activate. In the Activate project panel, with the default project deployment selected, choose an appropriate tracing option, then click Activate.

    A message confirms that the integration has been activated. Refresh the page to view the updated status of the integration.

  2. Update property values for the integration flow. You can update the integration properties only after activating this flow.
    Integration Property Description
    ESSJobDefinitionName_Param Specify the name of the ESS job definition.
    ESSJobPackageName_Param Specify the name of the package that contains the ESS job definition.
    ESSjOB_Wait_Count_Param Specify the number of minutes the integration must wait for the ESS job to be completed.
    ftpOutputDir Specify the path of the FTP directory where you can download the job run log files.
    ftpInputDir Specify the path of the FTP directory where the integration must import the CSV zip file with customer records. See Access Your FTP Server.

    For the procedure to update the integration properties, see Steps 7 and 8 in Override Design-Time Properties in an Integration.

  3. Log in to your FTP server and upload the CSV zip file with the customer data in the corresponding directory. See Configure ERP Cloud.
  4. Run the recipe.
    1. In the Integrations section of the project workspace, click Actions Actions icon on the integration flow, then select Run.
    2. On the Configure and run page, click Run.
      You've now successfully submitted the integration for execution.

      Note:

      You can also schedule this integration to run at a date, time, and frequency of your choosing. See Define the Integration Schedule.
  5. Monitor the running of the integration flow in Oracle Integration.
    1. In the project workspace, click Observe. You'll see the integration flow being triggered and running successfully.
    2. To manage errors in your project, see Manage Errors in a Project.
  6. Log in to Oracle ERP Cloud and check for new customer records.
    1. Navigate to Receivables, select Billing, and then select Manage Data Import.
    2. Click the corresponding Batch ID to view details such as total number of records, records processed, and error records.
      You can also view individual customer records. To do so, navigate to Billing Work Area, select Manage Customers, and search for the specific customer record.

Related Documentation