OCI-03404
For TIME_BUCKET function, fractional second is supported only if the specified datetime and the origin are Epoch Time, BINARY_FLOAT or BINARY_DOUBLE.
Cause
Fractional second is used when the specified datetime and the origin are not Epoch Time, BINARY_FLOAT or BINARY_DOUBLE.
Action
Check the datetime (the first argument) and the origin (the third argument), and ensure that they are Epoch Time, BINARY_FLOAT or BINARY_DOUBLE.