Export Receivable Billing History Extract
Let's consider this extract generation scenario for your receivables billing history:
Requirement | Description |
---|---|
Data | High volume of receivables billing history |
Frequency | Daily |
Source | Oracle Receivables Cloud |
Target | Third party application |
Example URL
Here's an example of the resource URL:
POST
fscmRestApi/resources/11.13.18.05/erpintegrations/
Example Request ExportBulkData
Here's an example of the request body:
{
"OperationName" : "exportBulkData",
"JobName":"oracle/apps/ess/financials/commonModules/shared/common/outbound/,ReceivablesBillingHistoryExtract",
"ParameterList":"204,#NULL,#NULL,#NULL,#NULL,#NULL,#NULL,#NULL,#NULL,#NULL,#NULL,#NULL,#NULL,1,FULL_EXTRACT,#NULL,#NULL,#NULL,ReceivablesBillingHistoryExtract,#NULL",
"CallbackURL" : "http://servername.fa.us2.oraclecloud.com/fscmPojoService/ErpIntegrationCallbackService?wsdl",
"NotificationCode":"10",
"JobOptions":""
}
Example Response ExportBulkData
Here's an example of the response body:
{
"OperationName": "exportBulkData",
"DocumentId": null,
"DocumentContent": null,
"FileName": null,
"ContentType": null,
"FileType": null,
"DocumentAccount": null,
"Comments": null,
"ProcessName": null,
"LoadRequestId": null,
"JobPackageName": null,
"JobDefName": null,
"ReqstId": "186622",
"RequestStatus": null,
"JobName": "oracle/apps/ess/financials/commonModules/shared/common/outbound/,ReceivablesBillingHistoryExtract",
"ParameterList": "204,#NULL,#NULL,#NULL,#NULL,#NULL,#NULL,#NULL,#NULL,#NULL,#NULL,#NULL,#NULL,1,FULL_EXTRACT,#NULL,#NULL,#NULL,ReceivablesBillingHistoryExtract,#NULL",
"NotificationCode": "10",
"CallbackURL": "http://servername.fa.us2.oraclecloud.com/fscmPojoService/ErpIntegrationCallbackService?wsdl",
"JobOptions": "",
"StatusCode": null,
"ESSParameters": null,
"links": [
{
"rel": "self",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/erpintegrations/exportBulkData",
"name": "erpintegrations",
"kind": "item"
},
{
"rel": "canonical",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/erpintegrations/exportBulkData",
"name": "erpintegrations",
"kind": "item"
}
]
}
Example Request GetDocumentForDocumentId
Here's an example of the request body:
curl -i -u "<username>:<password>" -H "Content-Type: application/vnd.oracle.adf.resourceitem+json" -X GET https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/erpintegrations?finder=DocumentRF;docId=233799
Example Response GetDocumentForDocumentId
Here's an example of the response body:
{
"items": [
{
"OperationName": "getDocumentForDocumentId",
"DocumentId": "233799",
"DocumentContent": "VVNELElOUiwyMDE3LzAxLzAxLDIwMTcvMDEvMDEsQ29ycG9yYXRlLDYwLCwgDQpVU0QsRVVSLDIwMTcvMDEvMDEsMjAxNy8wMS8wMSxDb3Jwb3JhdGUsNjAsLCANCg==",
"FileName": null,
"ContentType": null,
"FileType": null,
"DocumentAccount": null,
"Comments": null,
"ProcessName": null,
"LoadRequestId": null,
"JobPackageName": null,
"JobDefName": null,
"ReqstId": null,
"RequestStatus": null,
"JobName": null,
"ParameterList": null,
"NotificationCode": null,
"CallbackURL": null,
"JobOptions": null,
"StatusCode": null,
"ESSParameters": null,
"links": [
{
"rel": "self",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/erpintegrations/getDocumentForDocumentId",
"name": "erpintegrations",
"kind": "item"
},
{
"rel": "canonical",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/erpintegrations/getDocumentForDocumentId",
"name": "erpintegrations",
"kind": "item"
}
]
}
],
"count": 1,
"hasMore": false,
"limit": 25,
"offset": 0,
"links": [
{
"rel": "self",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/erpintegrations",
"name": "erpintegrations",
"kind": "collection"
}
]
}