Import Setup Data for an Offering or Functional Area

You have completed some setup modifications to a functional area in a development or test environment. And you exported the setup data to move it to another test or production environment. This use case takes you through the steps in using the Setup Offering CSV Imports resource to import that setup data. Before you begin, you must have the exported .zip file and know the codes of the offering and functional area provided during the export process.

In this example, the exported file contains setup data for the offering code XLE_FINANCIALS_JUR and the functional area ORA_ASK_ORGANIZATION_STRUCTURE. Let's look at the steps.

1. Start the import process: Submit a request to start the import process using the setupOfferingCSVImports resource.

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

   Sample Request Payload

   {
     "OfferingCode" : "XLE_FINANCIALS_JUR",
     "FunctionalAreaCode" : "ORA_ASK_ORGANIZATION_STRUCTURE",
     "SetupOfferingCSVImportProcess" : [{  "OfferingCode" : "XLE_FINANCIALS_JUR",
                                           "FileContent": "UEsDBBQACAgIAFqhi00AAAAAAAAAAAAAAAAUAAAATEVfMTIxNDQxNjcxMzY1NS5jc3ZVzkEOwiAQBdC9x2DtKaSNm0YT0QNMYGgmsQOBsQmeXqq06gp48z8ZZVB0cKj26pxGYHqCUOBGF/SYkC0eU3jEE0wLtkMnBEF3KOu91roq9dmhYJqIgeVa4iIDZLlFV8ct8oUhjMR/8vnTlNx7j1ZoXkv6DjmTJ/u74xYyAklacsOe3Zt2L1BLBwgN+fnbhgAAAOkAAABQSwMEFAAICAgAWqGLTQAAAAAAAAAAAAAAABwAAABGVU5fQlVfU0VSVklDRV9QUk9WSURFUlMuY3N27L1Zl9w2si76fn9FLq39cO/aLgrzkC/3cOzWblmqrZLcp/vFKy2l7TotVblLJfd2//oDgEMxB5IAySTIzFott5RgAJn8AggEAjG8iD/fbu8eo29vNl+2L757kX98+/DL5u7235vH2/u7+P6TfnD9cP/77aftQ0VZNhyh/fDb18eH7eZL9u3uo25+9Uk1Jvf/ujvSHN79UY70Nfu8+UU3qae/b4sPserxuP0U/VH+W3VMVIv6+Hrz9fHDb5+qx0+fDwhe3/9ye6dabv74mv7889Z8QUGUv3H8efP16+3Ptx/r75E/qjrcPG4eHnd6VY/Su0/Fg/Jljg5YPjw65MHDctD/58UPt1/VIKub7cPvtx+3X1fv/jNRHY60/sd//P//8R9Jeh2+e/99+uY9PE5l3RcioP8f6v9/o/77m/ov+3Dz6q3+gAAkLwF/CdAK0jUmayQCyihH1JoK5ATiJUQvITTd3vwYqa5v0pubHz+8efVef70UqjtUf9QHwjUpeoldqT2C6I6h+p811UVgiPVbEhcICUHWVBcBIczf0gFCbAUhnh5CJSl/edh+/boKP325vbtVu4oRsrkMPfbEwBHHsJnCqu+RlRxeX//46vvr1z/Gb9/cfHj9PnzzvoJK/XS8AnBN+ZqIAJrVaklPaSAMjGmSwTgWKQIMoYywFBCMOAIZ1RSQU5TTEFUSU9OLmNzdlBLAQIUABQACAgIAFqhi01cQIrlZxcAAPT2AAAhAAAAAAAAAAAAAAAAACeIAQBPUkFfSU5WX09SR19QQVJFTlRfRk9SX0lOVk9SRy5jc3ZQSwECFAAUAAgICABaoYtN27LD73dcAAAGvgYAHgAAAAAAAAAAAAAAAADdnwEASU5WX09SR0FOSVpBVElPTl9QQVJBTUVURVIuY3N2UEsBAhQAFAAICAgAWqGLTeEXQUC4EgAA0owBACUAAAAAAAAAAAAAAAAAoPwBAE9SQV9JTlZfSVRFTV9PUkdfQ0hJTERfRk9SX0lOVk9SRy5jc3ZQSwECFAAUAAgICABaoYtNrbMidnoEAADqIAAAJgAAAAAAAAAAAAAAAACrDwIAT1JBX0lOVl9JVEVNX09SR19QQVJFTlRfRk9SX0lOVk9SRy5jc3ZQSwECFAAUAAgICABaoYtN8I2TmY8MAADJfQAAGgAAAAAAAAAAAAAAAAB5FAIAQVNNX1NFVFVQX0NTVl9NRVRBREFUQS54bWxQSwUGAAAAABUAFQAcBgAAUCECAA=="}]
   }

   The import process starts and a process ID is generated.

   Sample Response Payload

   {
       "OfferingCode": "XLE_FINANCIALS_JUR",
       "FunctionalAreaCode": "ORA_ASK_ORGANIZATION_STRUCTURE",
      
        ...     
       "SetupOfferingCSVImportProcess": [
           {
               "ProcessId": 300100068274939,
               ...
           }
       ],
           ...
   }

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

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

   You get the response value as true or false.

   Sample Response Payload

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

3. Retrieve the import process results: After the import process is complete, send this request to retrieve the process log.

   curl -i -u "<username>:<password>" -X GET https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/setupOfferingCSVImports/XLE_FINANCIALS_JUR/child/SetupOfferingCSVImportProcess/300100068274939/child/SetupOfferingCSVImportProcessResult/300100068274939/enclosure/ProcessLog

   Sample Response Payload

   The process log is the response.

   You can examine the process log to check if the import contained the required setup data.