I'm getting an error ORA-20115: OrderCoordinatorGroup.The "Co-ordinator group" has already been removed by another user. This happens when I save the customer order page, but the data in the database isn't actually deleted because on the purchase order page I can still create a PO using the same Coordinator. What else could be causing this? And how can I debug this issue? Please give me some advice.
Best answer by Edwards
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
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
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
