UBAQ Analyze message references PartWhse.Plant

Epicor ERP 10
1

I am trying to develop a UBAQ to update the KanBan information in PartWhse. The selection criteria resides in the Part table (Part.InActive, Part.RunOut), so I have to join PartWhse and Part.

When I saved the query the first time I got three error messages:

  • Expression for PartWhse.Plant contains non-existent result column
  • Expression for PartWhse.PartNum contains non-existent result column
  • Expression for PartWhse.WarehouseCode contains non-existent result column

So I went back and added PartWhse.PartNum and PartWhse.WarehouseCode to the query. Now I am down to this single error message:

  • Expression for PartWhse.Plant contains non-existent result column

Hereā€™s the problem: there is no PartWhse.Plant field so I canā€™t add it. I didnā€™t find it in my BAQ field list, so checked the Data Dictionary just in case. Nothing doing.

Anyone seen this before or have any idea how to get around it? DMT will not let me make these changes because I actually want to remove the KBCode and associated values.

2

From Epicor KB:

Issue

UBAQ Trying to update a field in PartWhse but it is asking for field expression for PartWhse.Plant but this doenā€™t exist.

Error

One or more BPM directives are marked as outdated due to compilation errors. Please inspect and correct. Method: Ice.CPI001/EOInvUpdTEST.Update, Directive: ##BASE##, Compile error(s): Error CS1061: ā€˜Epicor.Customization.Bpm.Ubaq401F7C33CB8842F6866C1A07EA9EB9D4.ResultsUbaqTableā€™ does not contain a definition for ā€˜PartPlant_Plantā€™ and no extension method ā€˜PartPlant_Plantā€™ accepting a first argument of type ā€˜Epicor.Customization.Bpm.Ubaq401F7C33CB8842F6866C1A07EA9EB9D4.ResultsUbaqTableā€™ could be found (are you missing a using directive or an assembly reference?) [Update.Base.##BASE##.cs(131,67)] Error CS1061: ā€˜Epicor.Customization.Bpm.Ubaq401F7C33CB8842F6866C1A07EA9EB9D4.ResultsUbaqTableā€™ does not contain a definition for ā€˜PartPlant_Plantā€™ and no extension method ā€˜PartPlant_Plantā€™ accepting a first argument of type ā€˜Epicor.Customization.Bpm.Ubaq401F7C33CB8842F6866C1A07EA9EB9D4.ResultsUbaqTableā€™ could be found (are you missing a using directive or an assembly reference?) [Update.Base.##BASE##.cs(156,196)]

Resolution

In the Update > Update Processing tab for ttPartWhse enter in an expression Constants.CurrentPlant

2 Likes
3

Thanks for the tip - helped greatly!!!

4

Hello,
I know you were able to get around it using a UBAQ, but have you been able to figure out the DMT situation? It seems like I wonā€™t be able to DMT into the PartWhse table?

Thank you!

Edit:
I was able to fill the DMT-required PartWhse.Plant field using the PartPlant.Plant field that matched with the PartWhse when linking

PartWhse.PartNum == PartPlant.PartNum
PartWhse.WhseCode == PartPlant.PrimWhse

It also helps that we only have one plant.