ANNOUNCEMENT: community.oracle.com is currently Read only due to planned upgrade until 29-Sep-2020 9:30 AM Pacific Time. Any changes made during Read only mode will be lost and will need to be re-entered when the application is back read/write.
Has anyone encountered a similar issue? We are using the trunc() function in our project currently (12.2.8) for very large numbers (>= 10^15) and it is working as intended today. We're using the function to truncate any trailing decimals from this large number i.e. trunc(x,0). However, when we upgraded our project and tested the function again, trunc(x,0) instead exhibited a rounding behaviour to the nearest hundred. After some testing, we found this behaviour to be consistent for any value >= 10^13.
If anyone has encountered, is it a known bug, and is there any workaround or fix?