The “X has already been removed by another user” usually indicates a record didn’t appear in a select.

Can you confirm that the coordinator group indicated in the coordinator setup also exists in the coordinator group form?
 

I’d check there first, and that it has a starting customer order No (third column there)

Otherwise, if you’d like to debug further, I’d suggest using the “Trace” tab in the debug window you displayed above. You can see some more detail of the PLSQL failure that way which will help in tracking down the issue.

Thanks,

LEDWARDS

​@Edwards thank you for your Answer.
this is my coordinator data
and I tried selecting every group, but I couldn’t save any of them.

and I copy sql in Trace tab run in pl/sql
 

Interesting.

Comparing the implementation between the Increase_Cust_Order_No and the increase_purch_order_no method used for purchase orders they are nearly identical. With that being the case it would seem to indicate that line 13644 of your Customer_Order_API above does not have the authorize_code_ populated.

 Do you have access to a test system and its database? In cases like that I’ll typically call the methods, modifying the code by inserting DBMS_OUTPUT statements and checking the variable values as they move through the call.

Which version of IFS cloud are you on? Was there any customizations done to the customer_order_api that might be consuming the attr_ variable in your customer_order_api.insert___ method?

LEdwards

IFS Cloud version is 24R1.
Yes, I customized customer_order_api.insert___,Generate_Co_Number___ and tried testing it. It looks like the authorize_code_ value being passed is empty.
 

I believe this might be your issue. Your replaced call of the generate CO method is missing the current_co_no value. based on this you are instead passing in the source_order_ value as the authorize code, which is why you are getting a no data found. 

so the generate_co_number method is getting:

newrec_.authorize_code -> current_co_no

source_order_ → authorize code

newrec_.contract → source_order_

Can you try in your $REPLACE above to instead call:

Generate_Co_Number___(newrec_.order_no, current_co_no_, newrec_.authorize_code, source_order_, newrec_.contract);

LEdwards

Yes, exactly! I forgot to include current_co_no_ in the Generate_Co_Number___ method. I just migrated from IFS 10, so there might be new parameters that IFS Cloud added that I didn't include. Thank you so much!  LEdwards