@sphinks, how does your JSONPaths file look like? The order of jsonpaths have to match the order of your table columns. Take a look at this post explaining the significance of jsonpaths.
The error suggests that either subscriptionType or offer (both of which have a value starting with o) are attempted to be loaded into a column defined as double precision (either coupon_value or purchase_value). That is the jsonpaths do not follow the same order as the columns in your table definition.
Make sure the JSONPaths file reflects both the number of columns of your table and their order.