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:
TkVXLCwyMDE5LzA5LzEwLE90aGVyLE1hbnVhbCxDQUQsMjAxOS8wOS8xMCxBLDEwMTQsMjMwMSw1MDExMiwyMjAwMSwxMTEyLDAwMDAsMDAwMCwsLCwsLCwsLCwsLCwsLCwsLCwsLCwsLDI1LjQ5LCwsLFRlc3QgSm91cm5hbCBJbXBvcnQgQmF0Y2gxOiBTZXAtMTksVGVzdCBKb3VybmFsIEltcG9ydCBCYXRjaCBEZXNjIDE6IFNlcC0xOSwsVGVzdCBKb3VybmFsIEltcG9ydCBKb3VuYWwgTmFtZSAxOiBTZXAtMTksVGVzdCBKb3VybmFsIEltcG9ydCBKb3VuYWwgRGVzYyAxOiBTZXAtMTksLCwsLFRlc3QgSm91cm5hbCBJbXBvcnQgSm91bmFsIExpbmUgRGVzYyAxOiBTZXAtMTksLCwsLCwsLCwsLCwsLCwxLCwsLCwsLCwsLCwsLCwsLCwsLCwsLCwsLERSIENBTiBMRURHRVIsLCxTZXAtMTksRU5EDQpORVcsLDIwMTkvMDkvMTAsT3RoZXIsTWFudWFsLENBRCwyMDE5LzA5LzEwLEEsMTAxNCwyMzAxLDUwMTEyLDIyMDAxLDExMTIsMDAwMCwwMDAwLCwsLCwsLCwsLCwsLCwsLCwsLCwsLCwsLDI1LjQ5LCwsVGVzdCBKb3VybmFsIEltcG9ydCBCYXRjaDE6IFNlcC0xOSxUZXN0IEpvdXJuYWwgSW1wb3J0IEJhdGNoIERlc2MgMTogU2VwLTE5LCxUZXN0IEpvdXJuYWwgSW1wb3J0IEpvdW5hbCBOYW1lIDE6IFNlcC0xOSxUZXN0IEpvdXJuYWwgSW1wb3J0IEpvdW5hbCBEZXNjIDE6IFNlcC0xOSwsLCwsVGVzdCBKb3VybmFsIEltcG9ydCBKb3VuYWwgTGluZSBEZXNjIDE6IFNlcC0xOSwsLCwsLCwsLCwsLCwsLDEsLCwsLCwsLCwsLCwsLCwsLCwsLCwsLCwsRFIgQ0FOIExFREdFUiwsLFNlcC0xOSxFTkQNCg==
GlInterface2.csv
csv
/oracle/apps/ess/financials/generalLedger/programs/common,JournalImportLauncher
300000001611378,Other,300000001611299,1,N,N,N
10
https://na1.ai.dm-us.informaticacloud.com/active-bpel/public/rt/5dRifDErel4eeSi9Ho0c8b/CallbackURL_InputWholePayload_v2_Test
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:
http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/importBulkDataAsyncResponse
urn:uuid:873b8ec9-5929-4ff0-b70f-e60682c21e74
73428
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.