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"
        }
    ]
}