Find Receivables Customer Account Sites with a Specific Child Resource

A billing specialist wants to search for all the transactions and receipt applications associated with a customer account site to see the volume of transactions and payments that have occurred over the past month. They want to determine if the customer has any increased activity during the sales promotion period.

The billing specialist finds all sites in the customer’s account and fetches details of the Transaction Payment Schedules child resource using expand parameter.

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=transactionPaymentSchedules

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=transactionPaymentSchedules"

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",
      "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"
            }
          ]
        },
        {
          "InstallmentId": 1347787,
          "InstallmentNumber": 1,
          "TotalOriginalAmount": 1200,
          "TotalBalanceAmount": 1200,
          "PaymentDaysLate": 2324,
          "InstallmentStatus": "Open",
          "TransactionNumber": "P_DM_BAT10_02_1445",
          "TransactionId": 1583793,
          "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/1347787",
              "name": "transactionPaymentSchedules",
              "kind": "item"
            },
            {
              "rel": "canonical",
              "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesCustomerAccountSiteActivities/100100148387733/child/transactionPaymentSchedules/1347787",
              "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"
            }
          ]
        }
        ]
    ]
}