This article outlines the cause of an Oracle NetSuite 'Record Not Found' error and how to resolve it.
This error may occur when queueing a new sync (Pull) operation for an Oracle NetSuite data connection.
Audience
This is an intermediate difficulty article. The steps to resolve must be taken by a user who can change other users permissions within the Oracle NetSuite organisation linked. This user would typically be an Oracle NetSuite Admin.
Pre-requisites
You will need a Codat account to be able to notice the error.
Your client must have access to the Oracle NetSuite account linked and have valid admin credentials to the Oracle NetSuite organisation.
Oracle NetSuite - FetchError - 400 Error - Reccord XXX was not found
Issue
A company is using a NetSuite Connection and datasets that were queued for a sync are returning FetchError as their latest status.
Diagnosis
You are likely to be affected by this issue if you are:
- getting FetchError on Oracle NetSuite Datasets
- a 400 BadRequest along with an error message similar to the error below when calling GET
/companies/{companyId}/data/history/{datasetId}using the Codat API:
Error from NetSuite: 400 BadRequest; {\"type\":\"https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1\",\"title\":\"Bad Request\",\"status\":400,\"o:errorDetails\":[{\"detail\":\"Invalid search query. Detailed unprocessed description follows. Search error occurred: Record 'Currency' was not found.\",\"o:errorQueryParam\":\"q\",\"o:errorCode\":\"INVALID_PARAMETER\"}]}\n",Cause
The user that authorized the connection does not have the correct permissions to access the record shown in the error message.
Resolution
The account needs the following permissions in NetSuite.
Please contact your client and ensure that the user has been assigned the correct permissions before attempting to sync this dataset again.
You can find the list of permissions that must be assigned to your Oracle NetSuite user here.
------------------------
If you have any questions on the information shared above, contact support@codat.io.