@JLACSPEAR Did you ever resolve this issue? Ran into something similar only in my example my data source in CR is an IAL. I can view report in CR as IFSAPP and IFSPRINT and run the IAL as those users in PL/SQL.
Hi @Marcel.Ausan, original post was made by @Paresh Paresh if you got it resolved using Marcel’s steps would you mark it as solved. Thanks
Brilliant, I think this is the issue with what I am looking at. Thanks @Marcel.Ausan
@Paresh Did you ever resolve this or know what could of caused it?
Now I realized what’s wrong. The Customer Order No is created automatically by the system using coordinator group and next number only when the user leaves the field blank. But on the other hand, the mig job will not allow a null value since the order_no field is marked as K (key). Could you give it a try and leave the order_no blank? Normally most business objects will have a DB Sequence that will increase the number. Calling that sequence_name.next_val() will bring the next number, but for Customer Orders the logic is different. Even if you manage to create the orders via mig job with order no *1000 / *1001 / *1002 → the number in the coordinator groups is not increased, thus creating problems when another coordinator belonging to that group would want to create some orders → it will say order already exists. Hi Marcel,Where would you put sequence_name.next_val() into? I’m trying to achieve almost the same thing but for absence limits. Otherwise if user uses the migration job they
Hi both! @Marcel.Ausan @viraj_best1 That’s exactly what I just found as well. Stuck transactions on backend that need resolved with a script. Thanks for your quick replies!
Hi @viraj_best1 Did you ever get this resolved? I’m getting the same error and my work order is also connected to a project as all of it’s tasks are.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.