How can it possible? Why the state is null? Because of that, I could not change to released to planned. Have you ever seen that error? And how can I solve it? I don't think changing the table manually is not a good idea.
Solved
State is not valid
+16Best answer by Janandi Vishaka
Hi,
The state column in the view is set from below method Purchase_Requisition_API.Finite_State_Decode__(rowstate) here rowstate = objstate
Please check whether the value in the objstate column has any spaces might not be visible at first glance copy the value and paste and see. If so you need edit this record then it will show the state.
Have you logged into the client using English or some other language? It could be something related to language as well.
BR,
Vishaka
This topic has been closed for comments
+9Hi,
Can you please raise a support case for investigations. By looking at this it is difficult to say, what has happened.
~Cheers - Chamika
+14Hi
I dont think this could be recreated. Seems like a one-off issue?
If you keep getting this error then that should likely be an effect of a modification. I havent seen something like this in the Core version
Regards
Susith
+9Very strange indeed. As Susith explains may be one-off incident, may be due to customization.
Piyal
+16I think the same. However, I could not find the source. There is only one record.
+8Hi,
The state column in the view is set from below method Purchase_Requisition_API.Finite_State_Decode__(rowstate) here rowstate = objstate
Please check whether the value in the objstate column has any spaces might not be visible at first glance copy the value and paste and see. If so you need edit this record then it will show the state.
Have you logged into the client using English or some other language? It could be something related to language as well.
BR,
Vishaka
+6initially System is not allowing to user to update state as blank through backend: Screenshot1
but if we put space there as values then system allow us to proceed and getting same error message. Screenshot 2,3:
Solution: Please remove the space from “Rowstate” field and update it with actual stage and proceed to change its status from Released to planned.
Hope it helps you.
Regards,
Ashok Kumar Saini
1 person likes this
+16Janandi Vishaka wrote:
Hi,
The state column in the view is set from below method Purchase_Requisition_API.Finite_State_Decode__(rowstate) here rowstate = objstate
Please check whether the value in the objstate column has any spaces might not be visible at first glance copy the value and paste and see. If so you need edit this record then it will show the state.
Have you logged into the client using English or some other language? It could be something related to language as well.
BR,
Vishaka
Yes, the problem about space there is after state and objstate. Thank you. Should I change it from the table directly?
+16ascheeka12 wrote:
initially System is not allowing to user to update state as blank through backend: Screenshot1
but if we put space there as values then system allow us to proceed and getting same error message. Screenshot 2,3:
Solution: Please remove the space from “Rowstate” field and update it with actual stage and proceed to change its status from Released to planned.
Hope it helps you.
Regards,
+8Hi,
yes you can write a simple update statement and update the value in the rowstate without spaces. or directly to it in table.
UPDATE purchase_requisition_tab
SET rowstate ='Released'
WHERE requisition_no =’enter no here’;
Best Regards,
Vishaka
+16Thank you
SELECT * FROM purchase_requisition_tab b where b.requisition_no = '147499' for updateLinkedin Profile: https://www.linkedin.com/in/hhy34/
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.