Error:  InsertFailed: Insert into <TABLE> ORA-01438: Value larger than specified precision allowed for this column.



Issue:


Some Oracle databases, by default, set the precision on integer fields to 8 decimal places and the generated Offline ID from MX_GENERATE_OFFLINE_ID ( -1 * abs( 0 + newGuid() ) is 10 decimal places.


Offline ID example:  -1804734786


Solution:  


Change both the OfflineID and MaximoID fields from Integer to Numeric, save changes, select the "UpdateTable" checkbox that appears, and save again.  This should now allow for the offline ID's to be created and stored properly.


CampMaster Offline IDs



For additional assistance please email support@datasplice.com and we'd be happy to help!