We just found an issue trying to import the following CSV into Physical Inventory using the Import CSV Process

Open

For testing you would need to create a template. The import works from the window, but not from the process.

This is because the Import CSV Process is using the window -1 for the context and the DefaultEvaluatee has a couple of validations for windowNo >= 0

We are migrating an instance to release-12 and found the following issue:

There is a virtual column on C_Order with the following WHERE:

C_Order.AD_Client_ID IN (0,@AD_Client_ID@)

This was working fine in release-11, but fails in release-12.

We found the cause on this GridFieldVO line:

vo.ColumnSQL = Env.parseContext(ctx, -1, vo.ColumnSQL, false, true);

in release-11 this line was returning 0 for @AD_Client_ID@ context variable, but in release-12 is returning an empty string.

Following the implementation in release-11 the method org.compiere.util.Env.getContext(Properties, int, String, boolean) was called, and this method has a fallback to #context when the variable is not found.

In the DefaultEvaluatee implementation that method is not called, resulting in an empty string.

Additional findings from @Chuck Boecking:

Here are the implementations I have found. I hope this helps!

• Env.parseContext(...)

• MMailText.parse(...) and MMailText.parseVariable(...)

• Evaluator.java

• GridField.getDefaultFrom...(...)