Find Receivables Customer Account Sites with all Child Resources
A billing manager wants to search for all transactions associated with a customer site to find out if any of the transactions are overdue. They find all sites in the account and fetch details of all child sites by using expand parameter value 'all'.
Here's an example of the resource URL to display data from the Receivables Customer Account Site Activities resource:
GET
fscmRestApi/resources/11.13.18.05/ receivablesCustomerAccountSiteActivities?finder=CustomerAccountSiteActivitiesFinder;AccountNumber=PERF_ACCT_BAT10_1000&expand=all
cURL Command
curl --location --request GET "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/ receivablesCustomerAccountSiteActivities?finder=CustomerAccountSiteActivitiesFinder;AccountNumber=PERF_ACCT_BAT10_1000&expand=all"
Supported media types:
- Content-Type: application/json
Example Response
Here's an example of the response body in JSON format:
{ "items": [ { "BillToSiteUseId": 100100148387733, "BillToSiteNumber": "PERF_SITE_BAT10_1017", "BillToSiteAddress": "PERF_ADDR_BAT10_1017 ", "AccountNumber": "PERF_ACCT_BAT10_1000", "AccountId": 100100148385906, "CustomerName": "PERF_CUST_BAT10_1000", "CustomerId": 100100148382061, "TaxRegistrationNumber": null, "TaxpayerIdentificationNumber": null, "TotalOpenReceivablesForSite": 10500, "TotalTransactionsDueForSite": 100500, "CreatedBy": "FUSION_APPS_CRM_SOA_APPID", "CreationDate": "2020-07-17T12:57:05.744+00:00", "LastUpdateDate": "2020-07-17T12:57:05.744+00:00", "LastUpdatedBy": "FUSION_APPS_CRM_SOA_APPID", "transactionAdjustments": [], "transactionPaymentSchedules": [ { "InstallmentId": 1347786, "InstallmentNumber": 1, "TotalOriginalAmount": 1200, "TotalBalanceAmount": 1200, "PaymentDaysLate": 2324, "InstallmentStatus": "Open", "TransactionNumber": "P_DM_BAT10_02_1444", "TransactionId": 1583789, "TransactionDate": "2014-03-17", "TransactionClass": "Debit Memo", "PaymentScheduleDueDate": "2014-04-16", "AccountingDate": "2014-03-17", "PurchaseOrder": null, "TransactionType": "Debit Memo", "ReceiptMethod": null, "EnteredCurrency": "USD", "TransactionSourceName": "Trans_Source_AI_1_3", "StructuredPaymentReference": null, "CreatedBy": "AR_MGR_OPERATIONS", "CreationDate": "2020-07-20T06:58:20+00:00", "LastUpdateDate": "2020-07-20T06:58:23+00:00", "LastUpdatedBy": "AR_MGR_OPERATIONS", "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesCustomerAccountSiteActivities/100100148387733/child/transactionPaymentSchedules/1347786", "name": "transactionPaymentSchedules", "kind": "item" }, { "rel": "canonical", "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesCustomerAccountSiteActivities/100100148387733/child/transactionPaymentSchedules/1347786", "name": "transactionPaymentSchedules", "kind": "item" }, { "rel": "parent", "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesCustomerAccountSiteActivities/100100148387733", "name": "receivablesCustomerAccountSiteActivities", "kind": "item" } ] } ], "standardReceipts": [ { "StandardReceiptId": 152602, "ReceiptNumber": "P_RC_BAT10_02_1425", "BusinessUnit": "Vision Operations", "LegalEntity": "Vision Operations", "ReceiptDate": "2020-07-20", "AccountingDate": "2020-07-20", "UnappliedAmount": 0, "AvailableAmount": 0, "ReceiptMethod": "Check - BofA", "ProcessStatus": "Closed", "State": "Applied", "Currency": "USD", "Amount": 1200, "DocumentNumber": null, "CreatedBy": "AR_MGR_OPERATIONS", "CreationDate": "2020-07-20T07:08:51+00:00", "LastUpdateDate": "2020-07-20T07:17:14+00:00", "LastUpdatedBy": "0", "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesCustomerAccountSiteActivities/100100148387733/child/standardReceipts/152602", "name": "standardReceipts", "kind": "item" }, { "rel": "canonical", "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesCustomerAccountSiteActivities/100100148387733/child/standardReceipts/152602", "name": "standardReceipts", "kind": "item" }, { "rel": "parent", "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesCustomerAccountSiteActivities/100100148387733", "name": "receivablesCustomerAccountSiteActivities", "kind": "item" } ] } ], "standardReceiptApplications": [ { "ApplicationId": 576355, "ApplicationDate": "2020-07-20", "ApplicationAmount": 1200, "ApplicationStatus": "Applied", "AccountingDate": "2020-07-20", "ReferenceInstallmentId": 1336128, "ReferenceTransactionNumber": "P_IN_BAT10_02_1425", "ReferenceTransactionId": 1553824, "ActivityName": null, "StandardReceiptId": 152602, "ReceiptNumber": "P_RC_BAT10_02_1425", "EnteredCurrency": "USD", "ReceiptMethod": "Check - BofA", "ProcessStatus": "Closed", "IsLatestApplication": "Y", "CreatedBy": "AR_MGR_OPERATIONS", "CreationDate": "2020-07-20T07:08:51+00:00", "LastUpdateDate": "2020-07-25T03:56:58+00:00", "LastUpdatedBy": "AR_MGR_OPERATIONS", "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesCustomerAccountSiteActivities/100100148387733/child/standardReceiptApplications/576355", "name": "standardReceiptApplications", "kind": "item" }, { "rel": "canonical", "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesCustomerAccountSiteActivities/100100148387733/child/standardReceiptApplications/576355", "name": "standardReceiptApplications", "kind": "item" }, { "rel": "parent", "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesCustomerAccountSiteActivities/100100148387733", "name": "receivablesCustomerAccountSiteActivities", "kind": "item" }, { "rel": "child", "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesCustomerAccountSiteActivities/100100148387733/child/standardReceiptApplications/576355/child/standardReceiptApplicationDFF", "name": "standardReceiptApplicationDFF", "kind": "collection" } ] } ], "creditMemoApplications": [], "creditMemos": [ { "CreditMemoId": 1612378, "CreditMemoNumber": "P_CM_BAT10_02_1425", "CreditMemoDate": "2014-03-17", "TransactionClass": "On Account Credit Memo", "AccountingDate": "2014-03-17", "PurchaseOrder": null, "TotalOriginalAmount": -1200, "TotalBalanceAmount": -1200, "AvailableAmount": -1200, "TransactionType": "Credit Memo", "InstallmentId": 1379430, "CreditMemoCurrency": "USD", "CreditMemoStatus": "Open", "CreatedBy": "AR_MGR_OPERATIONS", "CreationDate": "2020-07-20T07:01:40+00:00", "LastUpdateDate": "2020-07-20T07:04:52+00:00", "LastUpdatedBy": "AR_MGR_OPERATIONS", "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesCustomerAccountSiteActivities/100100148387733/child/creditMemos/1612378", "name": "creditMemos", "kind": "item" }, { "rel": "canonical", "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesCustomerAccountSiteActivities/100100148387733/child/creditMemos/1612378", "name": "creditMemos", "kind": "item" }, { "rel": "parent", "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesCustomerAccountSiteActivities/100100148387733", "name": "receivablesCustomerAccountSiteActivities", "kind": "item" } ] } ], "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesCustomerAccountSiteActivities/100100148387733", "name": "receivablesCustomerAccountSiteActivities", "kind": "item" }, { "rel": "canonical", "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesCustomerAccountSiteActivities/100100148387733", "name": "receivablesCustomerAccountSiteActivities", "kind": "item" }, { "rel": "child", "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesCustomerAccountSiteActivities/100100148387733/child/creditMemoApplications", "name": "creditMemoApplications", "kind": "collection" }, { "rel": "child", "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesCustomerAccountSiteActivities/100100148387733/child/creditMemos", "name": "creditMemos", "kind": "collection" }, { "rel": "child", "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesCustomerAccountSiteActivities/100100148387733/child/standardReceiptApplications", "name": "standardReceiptApplications", "kind": "collection" }, { "rel": "child", "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesCustomerAccountSiteActivities/100100148387733/child/standardReceipts", "name": "standardReceipts", "kind": "collection" }, { "rel": "child", "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesCustomerAccountSiteActivities/100100148387733/child/transactionAdjustments", "name": "transactionAdjustments", "kind": "collection" }, { "rel": "child", "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesCustomerAccountSiteActivities/100100148387733/child/transactionPaymentSchedules", "name": "transactionPaymentSchedules", "kind": "collection" } ] } ], "count": 1, "hasMore": true, "limit": 1, "offset": 0, "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesCustomerAccountSiteActivities", "name": "receivablesCustomerAccountSiteActivities", "kind": "collection" } ] }