Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Retrieve receivables invoices from REST API within date range
Hello,
We are trying to retrieve all the receivables invoices within a creation date range.
However, when using the REST API below we are getting an error message:
REST API: {ORACLE ERP}/fscmRestApi/resources/11.13.18.05/receivablesInvoices?offset=0&limit=10&finder=invoiceSearch;BillToCustomerNumber=1659812492620001,TransactionType="FR1-F Vente de Packs"&orderBy=TransactionDate:desc&onlyData=true&orderBy=TransactionDate:des&onlyData=true&totalResults=true&q=CreationDate BETWEEN '1999-01-01T08:30:40' AND '1999-12-01T08:30:40'
Error message: An instance of type java.sql.Timestamp cannot be created from string BETWEEN '1999-01-01T08: 30: 40'. The string value must be in format YYYY-MM-DDTHH:MI:SS.sss+hh:mm.
0