My Stuff
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.
Comments
-
Hi @Mikko De La Fuente-Oracle , but In Oracle documentation, scale has the minimum value -84 which is more than -127, nor did I see intermediate values, either -127 or 0+ after data analysis, also didn't find any logic, these values are not so big to round to 127 digits: it looks more like a bug or some default or…
-
fyi @Erick Dela Rosa-Oracle , double-quotes work: SELECT TOP 1 "group" FROM EntityGroupMember
-
not everything is as good as we would like ? SELECT t.level FROM CustomerGroupPricing t works fine, but SELECT t.group FROM CustomerGroupPricing t doesn't work(
-
HI @Erick Dela Rosa-Oracle , this works, thanks so much!
-
Hi Erick, There is no answer in the community. The issue is still exists. Curious why NetSuite does not support a syntax available even in the earliest versions of Oracle?
-
Hi Mikko, yes, I still need assistance on this. Just to add more context: We are implementing a replication service, The connection to Netsuite fails on a big query (eg: transaction_lines with 10M rows). the timeout is not constant, rather looks like a random value, starts from 3 hours, sometimes it can reach up to 10-20…
-
Hi Mikko, yes, sure, we use this code: _command = _connection.CreateCommand(); _command.CommandText = _commandText; _command.CommandTimeout = 0; return await _command.ExecuteReaderAsync(CommandBehavior.SingleResult); Additionally, fetching large data volume will result to timeout due to custom field limitation. See…
-
Hi Mikko, We use our dotNet client (C#) via NetSuite ODBC driver.