Sagent: ORA-01727: numeric precision specifier is out of range in XML Source

Product Feature: Design Studio

XML source does not detect the data types automatically.  After loading XML Source, the user has to manually update the appropriate data type.
Refer "Schema Definition tab settings" of XML Source in Transform Reference Guide.
UPDATED:  August 30, 2017