Symptoms
Issue with Decimal Data type fields
Diagnoses
When using OOB SQL broker and have a table which has field which uses a DECIMAL (10,2) data type. Using an insert store procedure on that table which has an optional parameters (@myDecimal DECIMAL(10,2) = NULL) and have created a SmO on the store proc. When you execute the method on the SmO, all decimal fields are shown as required fields. All other optional fields (string / number / date) work fine, as expected.
Resolution
This is a known issue. Coldfix available upon request.