Skip to main content
Solved

Correct site is not fetching in labor class LOV in routing template

  • September 21, 2022
  • 1 reply
  • 137 views

Isuru Hindurangala
Do Gooder (Employee)
Forum|alt.badge.img+1

In Routing Template window, the labor class listed in the LOV, is not taken from the site which is on the routing template header. please see the screenshot attached.

  1. Log into IEE
  2. Go to “ Routing Template” Window
  3. Add new record > Select site 623 > Save
  4. Add new Operation > Select labor Class by using LOV

LOV window not fetching correct labor classes according to the site. 

Issue can be observed in APP10 UPD 9.


 

 

 

 

Best answer by Tharindu Sooriyaarachchi

Hi @Isuru Hindurangala,

I have investigated a same kind of issue. The labor class column is fetching data from LABOR_CLASS view passing the contact as below.

LABOR_CLASS(CONTRACT)

If you look at the debug console when clicking LOV, you can see contract is not passing correctly.

-- Context: dlgDynamicLov

select LABOR_CLASS_NO,LABOR_CLASS_DESCRIPTION,SCHED_CAPACITY,CAPACITY_CALC_BASE,STATE from IFSAPP.LABOR_CLASS where CONTRACT is not null and OBJSTATE in ('Active');

 

There is a hidden column called site and the value is not fetching correctly to pass the value to LABOR_CLASS view. Therefore, the correct labor class will not be fetched. This is a bug in tbwRoutOperationTmpl.cs file and this has been fixed by UPD 10 patch: 155201.

 

Best Regards,

Tharindu

View original
Did this topic help you find an answer to your question?

1 reply

Tharindu Sooriyaarachchi
Hero (Employee)
Forum|alt.badge.img+6

Hi @Isuru Hindurangala,

I have investigated a same kind of issue. The labor class column is fetching data from LABOR_CLASS view passing the contact as below.

LABOR_CLASS(CONTRACT)

If you look at the debug console when clicking LOV, you can see contract is not passing correctly.

-- Context: dlgDynamicLov

select LABOR_CLASS_NO,LABOR_CLASS_DESCRIPTION,SCHED_CAPACITY,CAPACITY_CALC_BASE,STATE from IFSAPP.LABOR_CLASS where CONTRACT is not null and OBJSTATE in ('Active');

 

There is a hidden column called site and the value is not fetching correctly to pass the value to LABOR_CLASS view. Therefore, the correct labor class will not be fetched. This is a bug in tbwRoutOperationTmpl.cs file and this has been fixed by UPD 10 patch: 155201.

 

Best Regards,

Tharindu


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings