Before You Install the Recipe

You must perform the following configuration tasks on your FTP Server and Oracle ATP instance in order to connect to these external systems using Oracle Integration and successfully handle throttling with the implementation of parking lot pattern.

Access Your FTP Server

Obtain a sFTP server and ensure that you're able to access it.

  1. Log in to the FTP server using your user name and password through an FTP client; for example, FileZilla.
  2. Create the following directories:
    • An input directory to place the CSV file received from the upstream system. For example: HCM_To_Payroll_Input. This file should be in a particular format for the recipe to run successfully. Download the following sample input file to successfully test the recipe: Sample file.
    • A directory to place the files from the upstream system that were successfully processed. For example: HCM_Archive
    • A directory to receive files from the downstream system that could not be processed successfully. For example: Payroll_To HCM_Input
    • A directory to archive files received from the downstream stream that were retried and processed successfully. For example: Payroll_Archive
    • A local input directory. For example: Input
    • A local output directory. For example: Output
    • A local error directory. For example: Error
    • A local processing directory. For example: Processing

You can also use File Server, an embedded sFTP server within Oracle Integration to store and work with the files. To use File Server, you must enable it for your Oracle Integration instance. See Enable File Server in Using File Server in Oracle Integration 3.

Configure Oracle ATP

To configure Oracle ATP, perform the following configuration tasks:
  1. Complete the prerequisites for creating a connection from Oracle Integration to Oracle ATP. See Prerequisites for Creating a Connection in Using the Oracle Autonomous Transaction Processing Adapter with Oracle Integration 3.
  2. Download and run the following SQL script to create the required parking lot table: SQL Script.