There are times, such as JD Edwards, where the decimal position is not stored in the actual database table. In one such instance JD Edwards stores the decimal positions in the Data Dictionary (F9210). in such cases we might need to manually update the EXTOL Schema to reflect the decimal positions.
Below are two pictures where we first retrieve the schema from the 11gR2 Oracle Database.
FROM: The initial retrieval of F47041.EDLN
TO: After we update the schema field F47041.EDLN to IMPLIED DECIMAL and 3 Decimal Positions.
Copyright 2013 @ www.seanhoppe.com
By: Sean Hoppe on