The numbers being padded with additional zeros should be resolved by changing the "Expose NUMBER as:" setting on the Advanced tab of the source endpoint. Change that to VARCHAR and test to confirm. The value will be cast back to a number on the target.
Environment
Cause
By default, Oracle source endpoints are set to expose numbers as NUMERIC(38,10)
Related Content
https://community.oracle.com/tech/developers/discussion/2578171/largest-number-of-digits-for-number-...