Find Receivables Customer Account Sites with a Specific Child Resource and Additional Filters
A billing specialist wants to search for a transaction to review the payment schedules associated with its customer site, receipts applied to the invoice, and credit memos created against the invoice. They want to check if the transactions for the customer have been created correctly.
The billing specialist looks for these using the TransactionLimitByDays and TransactionStatus attributes:
| Finder Attribute Name | Data Type | Accepted Values (case sensitive) | Default Value |
|---|---|---|---|
| TransactionLimitByDays | Integer | Any Positive Number | 90 |
| TransactionStatus | String | Open, Close, and Both | Open |
Note:
Data filtering with these two attributes can only be done for the Transaction Payment Schedules, Standard Receipts, and Credit Memos child resources.
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,TransactionLimitByDays=200,TransactionStatus=Open&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,TransactionLimitByDays=200,TransactionStatus=Open&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",
"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"
}
]
}