Export Setup Data for an Offering or Functional Area

You have completed some setup modifications to a functional area and want to export the setup data to move it to a test or production environment. This use case takes you through the steps in using the Setup Offering CSV Exports resource to export the setup data. Before you begin, you must identify the code of the offering and functional area that you want to migrate. For instructions, see topic Automate Export and Import of CSV File Packages.

In this example, the offering code is XLE_FINANCIALS_JUR and the functional area is ORA_ASK_ORGANIZATION_STRUCTURE. Let's look at the steps.

1. Start the export process: Submit a request to start the export process using the setupOfferingCSVExports resource.

   curl -i -u "<username>:<password>" -X POST https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/setupOfferingCSVExports
   Content-Type: application/vnd.oracle.adf.resourceitem+json

   Sample Request Payload

   {
     "OfferingCode" : "XLE_FINANCIALS_JUR",
     "FunctionalAreaCode" : "ORA_ASK_ORGANIZATION_STRUCTURE",
     "SetupOfferingCSVExportProcess" : [{  "OfferingCode" : "XLE_FINANCIALS_JUR"}]
   }

   The export process starts and a process ID is generated.

   Sample Response Payload

   {
       "OfferingCode": "XLE_FINANCIALS_JUR",
       "FunctionalAreaCode": "ORA_ASK_ORGANIZATION_STRUCTURE",
      
        ...     
       "SetupOfferingCSVExportProcess": [
           {
               "ProcessId": 300100068271744,
               ...
           }
       ],
           ...
   }

2. Check the process status: Send a request using the process ID to check if the export process is completed.

   curl -i -u "<username>:<password>" -X GET https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/setupOfferingCSVExports/XLE_FINANCIALS_JUR/child/SetupOfferingCSVExportProcess/300100068271744

   You get the response value as true or false.

   Sample Response Payload

   {
     "ProcessId": 300100068271744,
     "ProcessCompletedFlag": true,
     ...
     
   }

3. Retrieve the export process results: After the export process is complete, send this request to download the .zip file containing the exported setup data.

   curl -i -u "<username>:<password>" -X GET https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/setupOfferingCSVExports/XLE_FINANCIALS_JUR/child/SetupOfferingCSVExportProcess/300100068271744/child/SetupOfferingCSVExportProcessResult/300100068271744/enclosure/FileContent

   Sample Response Payload

   The response is a base64 encoded string that you can download in the form of a .zip file.

   You can download the .zip file and examine the offering setup data.