About This Recipe
This recipe exports a purchase order from Oracle ERP Cloud, maps its values to a comma separated file (CSV) file in Oracle Integration, and uploads the CSV file with the purchase order values to an FTP server.
To use the recipe, you must install the recipe and configure the connections and other resources within it. Subsequently, you can activate and run the integration flow of the recipe manually or specify an execution schedule for it. When a new purchase order is created in Oracle ERP Cloud, the integration flow of the recipe is triggered and it fetches the details of the newly created purchase order from Oracle ERP Cloud. Subsequently, the recipe matches the values in the purchase order to fields in a CSV file, and uploads the CSV file to a specified location in an FTP server. For the first run, the recipe creates the CSV file and adds the purchase order values to it. For subsequent runs, it appends a line with the newly created purchase order values to the same file.
- Creation Date
- Order Number
- Supplier
- Buyer Name
- Currency
- Total Amount
Only the Order Number field is mandatory. The rest of the fields are optional.
Note that you can upload the CSV file on File Server, an embedded sFTP server within Oracle Integration. To use File Server, you must enable it for your instance. See Enable File Server in Using File Server in Oracle Integration 3.