Issues Setting INVERT_SIGN / UJ_FLG value - Account Transformation Rules 10.1NW HANA

[hmarkillie]

Hi All

I am in the process of loading around 3000 rules directly into the UJP_CALC_ACCOUNT table for automated cash flow calculation on a 10.1 NW HANA system via a custom program

Loading the table has generally been successful, but I have encountered an issue setting the INVERT_SIGN flag. It appears that the flag is set (a check mark in the Web Admin tool, confirmed in the table in the backend) but it does not apply the required -1x to the rule results - ie The correct absolute value is calculated, but not with the correct sign.

I have used both a "Y" and and "X" in the relevant field and both of these load and lead to a validate set of rules, but neither works.

If i set the flag on a new rule in the Web Admin tool, the flag sets, the rule validates and generates the correct result - the sign is inverted as expected.

If I change the flag on one of my loaded rules with a sign inversion to remove the flag using the Web GUI, save the rule and then change it to flagged (ie invert sign) again, the required inversion does not work

So,

1. What is the character I should be using in the load file to set the flag? - Is it a special ASCII character, and if so which one?

2. Any ideas on why resetting the flag via the front end is not working?

Any advice

Thanks

Howard

Summary Extract of load file attached

CF Extract.txt.zip

[former_member186338]

Hi Howard,

If you are talking about UJP_CALC_ACCOUNT table then correct value for the field INVERT_SIGN is X.

Vadim

[hmarkillie]

Thanks Vadim

I have cleared out the table and reloaded using an "X" for the check box fields, still testing but no obvious issues so far

Howard