Support Article
Decimal Property truncating Scale when used with a Qualifier
SA-31857
Summary
Decimal Property Truncating Scale when used with a Qualifier for ja_JP locale.
When decimal property values are retrieved directly from DB using RDB-list method in an activity.
Error Messages
Not applicable
Steps to Reproduce
1.Set user locale to ja_JP
2.Launch SI Manager portal.
3.Click on Search Portal
4.Select Payments from Select Table drop-down.
5.Select Payment Details from Select List drop-down.
6.Select LON from Branch drop-down and then click Find.
7.Observe the Debit amount Column. (Here multiple results are shown in a repeat grid).
8.Double Click on any row to detailed single result in a modal dialog.(Here,Property values retrieved directly from DB using RDB-list method in an activity).
Root Cause
Each property qualifier provides additional information at runtime about the property, and may alter the behavior in computations or presentation of the property.
Hence, in cases where Qualifier is used, Qualifier value(for example, MSGCCY/.DBTCCY) should be provided at first than the Property value(.MSGAMT/.DBTAMT).
Here, Order is important and it matters, if qualifier value is not provided first,it is not taken into consideration.
So,while retrieving the values through a RDB-List method using Connect-SQL rule,order of retrieving values through SQL query becomes important.
Resolution
Modify the SQL query.
In particular here, the SQL query in the Custom Connect-SQL rule should be as below:
SELECT DBTCCY AS "DBTCCY", DBTAMT AS "DBTAMT", <other columns> FROM DATA.AMOUNT WHERE <clause>.
Published January 12, 2017 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.