Object levels create WO or PM action not possible

Hi,

I’m not sure on which track that you test this? I have tried it in APP10 which work fine for me. In other words it is possible to enable the check boxes as long as there are NO PM or Work Orders. 

I can confirm it by the code as well. Please refer the below image,

Mayura Wasantha wrote:

Hi,

I’m not sure on which track that you test this? I have tried it in APP10 which work fine for me. In other words it is possible to enable the check boxes as long as there are NO PM or Work Orders. 

I can confirm it by the code as well. Please refer the below image,

  

 

Hi @Mayura Wasantha , tks for the info.

I’m in APPs 10 UPD8 production and UPD14 test.

Here is the same code:

I don’t understand why the system is not letting me change this option since there is no pm or wo for this level.

There is pm and wo for the childs bellow this level?

may this have impact in this function?

tks for help

Hi,

We have received a case- (Asset management team) for similar issue from another customer and we will look into this and update you as well. 

Hi @Bimsara Geethachapa , Thanks for the info.

Waiting for your feedback.

Br.

Lopes

Hi @lopespetro ,

Hope you are doing good. :)

To get some more understanding of the issue, can you check in the DB if there are any connected PMs, WOs(Historical and Active), Work Tasks, Task Steps for all of the objects of the above 2 object levels?

Attaching the SQL queries for your reference ( queries.txt ) 

Thank you,

Deshan

Hi @deshan.ekanayake , tks for the info.

I checked and there is no record for all of them.

Br.

Lopes

Hi @Bimsara Geethachapa , any news about it?

Tks a lot!

Hi Lopes,

I tried different flows, but any of them were not success! waiting for customer environment access to check the issue further.

Hi @Bimsara Geethachapa , tks for the feedback.

Hope you can find a solution for it.

Br.

Lopes

@deshan.ekanayake, @Bimsara Geethachapa  Hi both,

I see small issue in Exist_Pm_For_Object_Level and Exist_Wo_For_Object_Level methods. object_level could be null in the EQUIPMENT_OBJECT_TAB and there is no null check in the cursor while doing the check. May be that is creating this mess for customer as he might be having serial objects connected to PM/WO?

Best Regards,

Dilani

Had a further discussion regarding this. Not checking null is not an issue here since it cannot be set to null from this client itself. Sorry for misleading :( 

Best Regards,

Dilani