Skip to main content
Question

Active separate already exist error on creating work order

  • December 15, 2022
  • 3 replies
  • 99 views

Forum|alt.badge.img+3
  • Do Gooder (Customer)

Active separate already exist error on creating work order

please help me to resolve this problem .

index not assign next number to work order 

3 replies

  • Superhero (Employee)
  • December 15, 2022

Has this started happening all of a sudden? Have you done any database copies or similar and the sequence hasn’t been reset? 

The work order number should be generated by a Oracle Sequence (PCM_COUNTER_WO_SEQ). 

 

What value to you get if you run 
 

SELECT PCM_COUNTER_WO_SEQ.nextval FROM dual

What version of IFS Applications or IFS Cloud are you working with?


Forum|alt.badge.img+3
  • Author
  • Do Gooder (Customer)
  • December 15, 2022

ifs applicaton


Forum|alt.badge.img+3
  • Author
  • Do Gooder (Customer)
  • December 15, 2022

we are using index for wo_no which is differnet for different site