Oracle B2B File Import Activity Using REST API
Oracle Content Server (UCM) URL: https://<pod-name>/cs
Oracle Content Server REST API endpoint: https://<pod-name>/resources/latest/erpintegrations
https://docs.oracle.com/en/cloud/saas/financials/21d/farfa/op-erpintegrations-post.html
Upload File
Endpoint: https:///fscmRestApi/resources/11.13.18.05/erpintegrations
Sample Request
{
"OperationName":"uploadFileToUCM",
"DocumentAccount":"ic$/incentiveCompensationTransaction$/import$",
"ContentType":"txt",
"FileName":"aTest2.csv",
"DocumentContent":"VHJhbnNhY3Rpb25UeXBlLEF0dHJpYnV0ZU51bWJlcjMsQXR0cmlidXRlTnVtYmVyMixJbnZvaWNlRGF0ZSxJbnZvaWNlTnVtYmVyLEF0dHJpYnV0ZTM0LFNvdXJjZUV2ZW50RGF0ZSxBdHRyaWJ1dGVOdW1iZXI0LEF0dHJpYnV0ZU51bWJlcjUsVHJhbnNhY3Rpb25BbXRTb3VyY2VDdXJyLFRyYW5zYWN0aW9uUXR5LFNvdXJjZUN1cnJlbmN5Q29kZSxBdHRyaWJ1dGUyLEF0dHJpYnV0ZTMsQXR0cmlidXRlNSxBdHRyaWJ1dGU2LEF0dHJpYnV0ZTM1LEF0dHJpYnV0ZTcsQXR0cmlidXRlOCxBdHRyaWJ1dGUxNCxBdHRyaWJ1dGU0LFRlcnJOYW1lLEF0dHJpYnV0ZTE1LEF0dHJpYnV0ZTksQXR0cmlidXRlMzAsQXR0cmlidXRlMTAsQXR0cmlidXRlMzEsQXR0cmlidXRlMTEsQXR0cmlidXRlMjEsQXR0cmlidXRlMjIsQXR0cmlidXRlMjMsQXR0cmlidXRlMjQsQXR0cmlidXRlMjUsQXR0cmlidXRlMTksQXR0cmlidXRlMjAsQXR0cmlidXRlMTIsQXR0cmlidXRlMTMsQXR0cmlidXRlMzMsQnVzaW5lc3NVbml0TmFtZSxTb3VyY2VCdXNpbmVzc1VuaXROYW1lLFByb2Nlc3NDb2RlLEF0dHJpYnV0ZTI4LEF0dHJpYnV0ZTE3LEF0dHJpYnV0ZTE2LEF0dHJpYnV0ZTM2LEF0dHJpYnV0ZTEsQXR0cmlidXRlMjksU291cmNlVHJ4TnVtYmVyLFBhcnRpY2lwYW50SUQKSU5WT0lDRSwyMDIyLDMsMTAvMTQvMjAyMSwxNjQyNjkyNywsMTAvMTQvMjAyMSw2MzAsMCw2MzAsNTAsVVNELFNNX1VTX09VLFVTIC0gQ3JpdGljYWwgQ2FyZSwxMDAwMSwwMSAtIEVhc3QgWm9uZSwiU29sbGksIFZpY3RvciIsMTMwMTIsMDIgLSBQZW5uLVlvcmssIkpvaG1hbm4sIEt1cnRpcyIsMTAxMjAsMDIgLSBWQSAtIDAyLCJSaWNoYXJkcywgU2NvdHQiLFJPQ0hFU1RFUiBHRU5FUkFMIEhPU1BJVEFMLDUzNzAwLDA1MzcwMCAtIFJPQ0hFU1RFUiBHRU5FUkFMIEhPU1BJVEFMLDUxNzc1LDA1MzcwMCAtIFJPQ0hFU1RFUiBHRU5FUkFMIEhPU1BJVEFMICg1MTc3NSksQ2FyZGlvIFRob3JhY2ljLFByZXNzdXJlIE1vbml0b3JpbmcsRElTUCBQcmVzc3VyZSBCYWdzLENsZWFyIEN1ZmZzIChEIEZ1c29ycyksQ2xlYXIgQ3VmZnMgKEQgRnVzb3JzKSxNWDQ3MDUsTVg0NzA1IC0gQ0xFQVItQ1VGRkA1MDBNTCBQUkVTU1VSRSBJTkZVU09SICAgICAxMC9DQSxST0NIRVNURVIgR0VORVJBTCBIT1NQSVRBTCwwNTM3MDAgLSBST0NIRVNURVIgR0VORVJBTCBIT1NQSVRBTCwwNTM3MDAgLSBST0NIRVNURVIgR0VORVJBTCBIT1NQSVRBTCAoNTE3NzUpLFNNX1VTX09VIEJVLFNNX1VTX09VIEJVLENDUkVDLFJPQ0hFU1RFUiBSRUdJT05BTCBIRUFMVEggU1lTVEVNLDI0MTk5LE9QRU4sVVMgLSBTVFJBVEVHSUMgQUNDVFMgLSBBVlAgVU5BU1NJR05FRCBURVJSSVRPUlksQlVDS0VUIDIsQlVDS0VUIDIsMTY0MjY5Mjc6NTE3NzU6TVg0NzA1LDNFKzE0CklOVk9JQ0UsMjAyMiwzLDEwLzE0LzIwMjEsMTY0MjY5MjgsLDEwLzE0LzIwMjEsMTgyNywwLDE4MjcuMzYsMTkyLFVTRCxTTV9VU19PVSxVUyAtIENyaXRpY2FsIENhcmUsMTEwMDIsMDIgLSBDZW50cmFsIFpvbmUsIlNwYXR6LCBSeWFuIiwxMTAzMCwwOSAtIE1pZFdlc3QsIkdpb3Zhbm5pbmksIE1pY2hhZWwiLDExMzA5LDA5IC0gVkFWQyAtIDA3LCJKZW5zZW4sIEFsZXgiLDA2MDAxMSAtIFNUIExVS0VTIFJFR0lPTkFMIE1FRElDQUwgQ0VOVEVSLTA2MDAxMSw2MDAxMSwwNjAwMTEgLSBTVCBMVUtFUyBSRUdJT05BTCBNRURJQ0FMIENFTlRFUi0wNjAwMTEsNTQ2OTQsMDYwMDExIC0gU1RMVUtFJ1MgUkVHIE1FRElDQUwgQ0VOVEVSICg1NDY5NCksQW1idWxhdG9yeSBJbmZ1c2lvbixBbWJ1bGF0b3J5IFB1bXAgRGlzcG9zYmxzLENBREQgRGlzcG9zYWJsZXMsQ0FERCBNZWRpY2F0aW9uIENhc3NldHRlcywxMDBtbCBFcGlkIENhc3NldHRlcyBDQURELDIxLTczMDAtMjQsIjIxLTczMDAtMjQgLSBSRVNFUlZPSVIsIENBU1NFVFRFLCAxMDBNTCwgRlMsIFlFTExPVyAgICAgMTIvQlgiLDA2MDAxMSAtIFNUIExVS0VTIFJFR0lPTkFMIE1FRElDQUwgQ0VOVEVSLTA2MDAxMSwwNjAwMTEgLSBTVCBMVUtFUyBSRUdJT05BTCBNRURJQ0FMIENFTlRFUi0wNjAwMTEsMDYwMDExIC0gU1RMVUtFJ1MgUkVHIE1FRElDQUwgQ0VOVEVSICg1NDY5NCksU01fVVNfT1UgQlUsU01fVVNfT1UgQlUsQ0NSRUMsTm9uSFNNLE5vbkhTTSxOb25IU00sTm9uSFNNLEJVQ0tFVCAyLE5vbkhTTSwxNjQyNjkyODo1NDY5NDoyMS03MzAwLTI0LDNFKzE0CklOVk9JQ0UsMjAyMiwzLDEwLzE0LzIwMjEsMTY0MjY5MzgsLDEwLzE0LzIwMjEsNDEzLDAsNDEyLjg4LDIsVVNELFNNX1VTX09VLFVTIC0gQ3JpdGljYWwgQ2FyZSwxMDAwMSwwMSAtIEVhc3QgWm9uZSwiU29sbGksIFZpY3RvciIsMTMwMTIsMDIgLSBQZW5uLVlvcmssIkpvaG1hbm4sIEt1cnRpcyIsMTEzMDcsMDIgLSBWQyAtIDA1LCJCcm93biwgQW1hbmRhIiw4OTAyMDUgLSBQRU5OIFNUQVRFIEhFQUxUSCAtIEhBTVBERU4gTUVESUNBTCBDRU5URVIsODkwMjA1LDg5MDIwNSAtIFBFTk4gU1RBVEUgSEVBTFRIIC0gSEFNUERFTiBNRURJQ0FMIENFTlRFUiwxNDg0NDM2LDg5MDIwNSAtIFBFTk4gU1RBVEUgSEVBTFRIIC0gSEFNUERFTiBNRURJQ0FMIENFTlRFUiAoMTQ4NDQzNiksVHJhY2hlb3N0b215LFNpbGljb25lIFRyYWNoZW9zdG9teSBUdWJlcyxESVNQIEJpdm9uYSBORU8vUEVEIFRyYWNoZW9zdG9teSBUdWJlcyxOL1AgRmxleHRlbmQsVFRTIE5lbyBGbGV4dGVuZCBTdHJhaWdodCBOZWNrLDY3TkZQUzM1LDY3TkZQUzM1IC0gTkVPTkFUQUwgVFJBQ0hFT1NUT01ZIFRVQkUgMy41IFRUUyBGTEVYVEVORCBTVFJBSUdIVCBGTEFOR0UgICAgIDEvRUEsODkwMjA1IC0gUEVOTiBTVEFURSBIRUFMVEggLSBIQU1QREVOIE1FRElDQUwgQ0VOVEVSLDg5MDIwNSAtIFBFTk4gU1RBVEUgSEVBTFRIIC0gSEFNUERFTiBNRURJQ0FMIENFTlRFUiw4OTAyMDUgLSBQRU5OIFNUQVRFIEhFQUxUSCAtIEhBTVBERU4gTUVESUNBTCBDRU5URVIgKDE0ODQ0MzYpLFNNX1VTX09VIEJVLFNNX1VTX09VIEJVLENDUkVDLE5vbkhTTSxOb25IU00sTm9uSFNNLE5vbkhTTSxCVUNLRVQgMSxOb25IU00sMTY0MjY5Mzg6MTQ4NDQzNjo2N05GUFMzNSwzRSsxNApJTlZPSUNFLDIwMjIsMywxMC8xNC8yMDIxLDE2NDI2OTM5LCwxMC8xNC8yMDIxLDg0LDAsODMuODEsMTAsVVNELFNNX1VTX09VLFVTIC0gQ3JpdGljYWwgQ2FyZSwxMDAwMSwwMSAtIEVhc3QgWm9uZSwiU29sbGksIFZpY3RvciIsMTAwMTAsMDMgLSBDYXBpdGFsLCJEb2VobmVyLCBKb2huIiwxMTEwNCwwMyAtIFZDIC0gMDgsIlZhY2Nhcm8tR2xhbmZpZWxkLCBKYW1pZSIsVEhFIFJFQURJTkcgSE9TUElUQUwgJiBNRURJQ0FMIENFTlRFUiw1MjE1MCwwNTIxNTAgLSBUSEUgUkVBRElORyBIT1NQSVRBTCAmIE1FRElDQUwgQ0VOVEVSLDIyNzc2MSwwNTIxNTAgLSBSRUFESU5HIEhPU1BJVEFMICYgTUVESUNBTCBDRU5URVIgKDIyNzc2MSksVHJhY2hlb3N0b215LFBWQyBUcmFjaGVvc3RvbXkgVHViZXMsRElTUCBQZXJjdXRhbmVvdXMgKFBDVC9QRFQpIGFuZCBJQyxVbmlwZXJjIChJbm4gQ2FubiksMTAwLzg5MCwxMDAvODkwLzA3MENaLCIxMDAvODkwLzA3MENaIC0gUkVQTEFDRU1FTlQgSU5ORVIgQ0FOTlVMQSBGT1IgVU5JUEVSQyBBREpVU1RBQkxFIEZMQU5HRSBUUkFDSEVPU1RPTVkgVFVCRSwiLFRIRSBSRUFESU5HIEhPU1BJVEFMICYgTUVESUNBTCBDRU5URVIsMDUyMTUwIC0gVEhFIFJFQURJTkcgSE9TUElUQUwgJiBNRURJQ0FMIENFTlRFUiwwNTIxNTAgLSBSRUFESU5HIEhPU1BJVEFMICYgTUVESUNBTCBDRU5URVIgKDIyNzc2MSksU01fVVNfT1UgQlUsU01fVVNfT1UgQlUsQ0NSRUMsQUxMU1BJUkUsMjQxMTIsIkVsYmVydCwgRGFuIixVUyAtIFNBRSAtIENlbnRyYWwgLSBHcmVhdCBMYWtlcyxCVUNLRVQgMSxCVUNLRVQgMSwxNjQyNjkzOToyMjc3NjE6MTAwLzg5MC8wNzBDWiwzRSsxNApJTlZPSUNFLDIwMjIsMywxMC8xNC8yMDIxLDE2NDI2OTQwLCwxMC8xNC8yMDIxLDU5MiwwLDU5MS41MiwyMCxVU0QsU01fVVNfT1UsVVMgLSBDcml0aWNhbCBDYXJlLDExMDAyLDAyIC0gQ2VudHJhbCBab25lLCJTcGF0eiwgUnlhbiIsMTMwMTAsMDcgLSBOYXNodmlsbGUsIkV2YW4sIFN0ZXZlIiwxMTMwMSwwNyAtIFZBVkMgLSAwMiwiRGF2aXMsIFRob21hcyIsMDMwNjgxIC0gU1QgRlJBTkNJUyBIT1NQSVRBTC0wMzA2ODEsMzA2ODEsMDMwNjgxIC0gU1QgRlJBTkNJUyBIT1NQSVRBTC0wMzA2ODEsNDE5MzUsMDMwNjgxIC0gS0VORFJJQ0sgTUVNT1JJQUwgSE9TUElUQUwgKDQxOTM1KSxQYWluIE1hbmFnZW1lbnQsRXBpZHVyYWwsRXBpZHVyYWwgQ29udGludW91cyxFcGlkdXJhbCBDb250aW51b3VzLEVwaWQgQ29udCBQcm9jIFRyYXlzL0tpdHMsMzA5Ny0yMCwzMDk3LTIwIC0gQ09OVElOVU9VUyBFUElEKEVERCkgICUgMTAvQ0EsMDMwNjgxIC0gU1QgRlJBTkNJUyBIT1NQSVRBTC0wMzA2ODEsMDMwNjgxIC0gU1QgRlJBTkNJUyBIT1NQSVRBTC0wMzA2ODEsMDMwNjgxIC0gS0VORFJJQ0sgTUVNT1JJQUwgSE9TUElUQUwgKDQxOTM1KSxTTV9VU19PVSBCVSxTTV9VU19PVSBCVSxDQ1JFQyxOb25IU00sTm9uSFNNLE5vbkhTTSxOb25IU00sQlVDS0VUIDIsTm9uSFNNLDE2NDI2OTQwOjQxOTM1OjMwOTctMjAsM0UrMTQKSU5WT0lDRSwyMDIyLDMsMTAvMTQvMjAyMSwxNjQyNjk1NCwsMTAvMTQvMjAyMSwyNjUsMCwyNjUsMSxVU0QsU01fVVNfT1UsVVMgLSBDcml0aWNhbCBDYXJlLDEwMDAyLDAzIC0gV2VzdCBab25lLCJUYWxsZXksIEp1c3RpbiIsMTAwMzAsMTEgLSBOb3J0aCBUZXhhcywiUm9tZXJvLUdlaWdlciwgTG9yaW5hIiwxMTQwMSwxMSAtIFZDIC0gMDQsIk1hcnNoYWxsLCBOZWlsIiwwMTE1NTIgLSBDT09LIENISUxEUkVOJ1MgTUVESUNBTCBDRU5URVIsMTE1NTIsMDExNTUyIC0gQ09PSyBDSElMRFJFTidTIE1FRElDQUwgQ0VOVEVSLDE0NTcwNjcsMDExNTUyIC0gQ09PSyBDSElMRFJFTidTIE1FRElDQUwgQ0VOVEVSICgxNDU3MDY3KSxUcmFjaGVvc3RvbXksU2lsaWNvbmUgVHJhY2hlb3N0b215IFR1YmVzLERJU1AgQml2b25hIFRyYWNoZW9zdG9teSBUdWJlcyxCaXZvbmEgQ3VzdG9tIExhYixDdXN0b20gQml2b25hIFR1YmVzLFNVMjBKTjU1TkdHODc4TixTVTIwSk41NU5HRzg3OE4gLSBDVVNUT00gNS41IEZJWEVEIENVRkZMRVNTIE5TICsxL0VBLDAxMTU1MiAtIENPT0sgQ0hJTERSRU4nUyBNRURJQ0FMIENFTlRFUiwwMTE1NTIgLSBDT09LIENISUxEUkVOJ1MgTUVESUNBTCBDRU5URVIsMDExNTUyIC0gQ09PSyBDSElMRFJFTidTIE1FRElDQUwgQ0VOVEVSICgxNDU3MDY3KSxTTV9VU19PVSBCVSxTTV9VU19PVSBCVSxDQ1JFQyxDSEEsMjQyMzgsIkNhcnRlciwgTmFuY3llIixVUyAtIFNBRSAtIENlbnRyYWwgLSBOYXNodmlsbGUsQlVDS0VUIDEsQlVDS0VUIDEsMTY0MjY5NTQ6MTQ1NzA2NzpTVTIwSk41NU5HRzg3OE4sM0UrMTQKSU5WT0lDRSwyMDIyLDMsMTAvMTQvMjAyMSwxNjQyNjk1NywsMTAvMTQvMjAyMSwyMzIsMCwyMzEuNTMsMjAwLFVTRCxTTV9VU19PVSxVUyAtIENyaXRpY2FsIENhcmUsMTAwMDEsMDEgLSBFYXN0IFpvbmUsIlNvbGxpLCBWaWN0b3IiLDEwMDEwLDAzIC0gQ2FwaXRhbCwiRG9laG5lciwgSm9obiIsMTAxMDEsMDMgLSBWQSAtIDAyLCJPcGVuLCAxMDEwMSIsQ0FSSUxJT04gTUFURVJJQUxTIE1BTkFHRU1FTlQsNTM0MDAsMDUzNDAwIC0gQ0FSSUxJT04gTUFURVJJQUxTIE1BTkFHRU1FTlQsNTE3MDQsMDUzNDAwIC0gUk9BTk9LRSBNRU1PUklBTCBIT1NQSVRBTCAoNTE3MDQpLFBJVkMsQ29udmVudGlvbmFsIENhdGhldGVycyxDb252ZW50aW9uYWwgQ2F0aGV0ZXIgQWxsLEpFTENPIEZFUCxKRUxDTyBGRVAgU3RyYWlnaHQsNDA1OTExLDQwNTkxMSAtIDIwRyBYIDEgMy80IEpFTENPIENBVEhFVEVSIFJBRElPUEFRVUUgICAgIDIwMC9DQSxDQVJJTElPTiBNQVRFUklBTFMgTUFOQUdFTUVOVCwwNTM0MDAgLSBDQVJJTElPTiBNQVRFUklBTFMgTUFOQUdFTUVOVCwwNTM0MDAgLSBST0FOT0tFIE1FTU9SSUFMIEhPU1BJVEFMICg1MTcwNCksU01fVVNfT1UgQlUsU01fVVNfT1UgQlUsQ0NSRUMsQ0FSSUxJT04gQ0xJTklDLDI0MTIyLCJCYXNzLCBSZWJlY2NhIixVUyAtIFNBRSAtIEVhc3QgLSBDYXJvbGluYXMsQlVDS0VUIDIsQlVDS0VUIDIsMTY0MjY5NTc6NTE3MDQ6NDA1OTExLAo="
}
Import Activity
Endpoint: https://<instance>/crmRestApi/resources/11.13.18.05/importActivities
{
"Name": "Craig_REST_API_Test_4",
"ObjectCode": "IncentiveTransaction",
"DecimalSeparator": ".",
"DateFormat": "ORA_ZCA_US_FORMAT",
"ImportMode": "CREATE_RECORD",
"TimestampFormat": "ORA_ZCA_US_FORMAT",
"FileEncoding": "ORA_ZCA_UTF8_ENCODING",
"Delimiter": "COMMA_DELIMITER",
"Schedule": "ONE_TIME_IMMEDIATE",
"Activate": "YES",
"HighVolume": "YES",
"DataFiles": [
{
"InputFileContentId": "UCMFA01250338"
}
]
}
Open Question
How to get the InputFileContentId from the Document ID in the Upload File Response?