ErpIntegrationService can be leveraged to import FBDI file data in csv format to UCM server, load data into GL_INTERFACE table based on the jobName specified and trigger import job in a single webservice call.
Below is the example:
Service WSDL URL: https://servername/fscmService/ErpIntegrationService?WSDL
Operation: importBulkDataAsync
Uploads a file to the Oracle UCM server based on the jobName specified and submits the ESS jobs to import and process the uploaded file.
Input Payload:
<soapenv:Envelope xmlns:erp="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/"> <soapenv:Header> </soapenv:Header> <soapenv:Body> <typ:importBulkDataAsync> <!--Optional:--> <typ:document> <!--csv file content in Base64 Format:--> <erp:Content>TkVXLCwyMDE5LzA5LzEwLE90aGVyLE1hbnVhbCxDQUQsMjAxOS8wOS8xMCxBLDEwMTQsMjMwMSw1MDExMiwyMjAwMSwxMTEyLDAwMDAsMDAwMCwsLCwsLCwsLCwsLCwsLCwsLCwsLCwsLDI1LjQ5LCwsLFRlc3QgSm91cm5hbCBJbXBvcnQgQmF0Y2gxOiBTZXAtMTksVGVzdCBKb3VybmFsIEltcG9ydCBCYXRjaCBEZXNjIDE6IFNlcC0xOSwsVGVzdCBKb3VybmFsIEltcG9ydCBKb3VuYWwgTmFtZSAxOiBTZXAtMTksVGVzdCBKb3VybmFsIEltcG9ydCBKb3VuYWwgRGVzYyAxOiBTZXAtMTksLCwsLFRlc3QgSm91cm5hbCBJbXBvcnQgSm91bmFsIExpbmUgRGVzYyAxOiBTZXAtMTksLCwsLCwsLCwsLCwsLCwxLCwsLCwsLCwsLCwsLCwsLCwsLCwsLCwsLERSIENBTiBMRURHRVIsLCxTZXAtMTksRU5EDQpORVcsLDIwMTkvMDkvMTAsT3RoZXIsTWFudWFsLENBRCwyMDE5LzA5LzEwLEEsMTAxNCwyMzAxLDUwMTEyLDIyMDAxLDExMTIsMDAwMCwwMDAwLCwsLCwsLCwsLCwsLCwsLCwsLCwsLCwsLDI1LjQ5LCwsVGVzdCBKb3VybmFsIEltcG9ydCBCYXRjaDE6IFNlcC0xOSxUZXN0IEpvdXJuYWwgSW1wb3J0IEJhdGNoIERlc2MgMTogU2VwLTE5LCxUZXN0IEpvdXJuYWwgSW1wb3J0IEpvdW5hbCBOYW1lIDE6IFNlcC0xOSxUZXN0IEpvdXJuYWwgSW1wb3J0IEpvdW5hbCBEZXNjIDE6IFNlcC0xOSwsLCwsVGVzdCBKb3VybmFsIEltcG9ydCBKb3VuYWwgTGluZSBEZXNjIDE6IFNlcC0xOSwsLCwsLCwsLCwsLCwsLDEsLCwsLCwsLCwsLCwsLCwsLCwsLCwsLCwsRFIgQ0FOIExFREdFUiwsLFNlcC0xOSxFTkQNCg==</erp:Content> <!--CSV File Name:--> <erp:FileName>GlInterface2.csv</erp:FileName> <erp:ContentType>csv</erp:ContentType> </typ:document> <!--Zero or more repetitions:--> <typ:jobDetails> <!--GL Journal Import Job:--> <erp:JobName>/oracle/apps/ess/financials/generalLedger/programs/common,JournalImportLauncher</erp:JobName> <!--GL Journal Parameter List:--> <erp:ParameterList>300000001611378,Other,300000001611299,1,N,N,N</erp:ParameterList> </typ:jobDetails> <!--Optional:--> <typ:notificationCode>10</typ:notificationCode> <!--Optional:--> <typ:callbackURL>https://na1.ai.dm-us.informaticacloud.com/active-bpel/public/rt/5dRifDErel4eeSi9Ho0c8b/CallbackURL_InputWholePayload_v2_Test</typ:callbackURL> <!--Optional:--> </typ:importBulkDataAsync> </soapenv:Body> </soapenv:Envelope> |
More Details on NotificationCode:
The following table provides information on the notification codes:
| Digit Position | Digit Value | Meaning |
|---|---|---|
| First digit | 1 | E-mail notification |
| First digit | 2 | Bell notification |
| First digit | 3 | Email and bell notification |
| Second digit | 0 | Send in any case (import failed or succeeded) |
| Second digit | 1 | Send on import success |
| Second digit | 2 | Send on import failure |
Response:
<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsa="http://www.w3.org/2005/08/addressing"> <env:Header> <wsa:Action>http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/importBulkDataAsyncResponse</wsa:Action> <wsa:MessageID>urn:uuid:873b8ec9-5929-4ff0-b70f-e60682c21e74</wsa:MessageID> </env:Header> <env:Body> <ns0:importBulkDataAsyncResponse xmlns:ns0="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/"> <result xmlns="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/">73428</result> </ns0:importBulkDataAsyncResponse> </env:Body> </env:Envelope> |
The response code that returns the request identifier for the first import job in the joblist, which is a load interface job.
Note: This is an example from 19C instance.
Oracle Documentation on erpIntegrationService.