Is it a bad idea to import NEW distribution orders into IFS via sql insert statements? My gut tells me that it won’t work correctly. I imagine that when you create a Distribution Order in IFS it creates data in multiple tables that would cause issues if I only inserted into the main DO table.
Thanks!
Best answer by Charana Udugama
Hi
I did a little digging on this. So my short answer is not to do this.
There are multiple conditions being checked when a ‘Distribution Order’ is being created. For example, there are some calls to check in Purchase Order, Customer Order APIs. There are some records kept in DISTRIBUTION_ORDER_API and they are also being called and processed.
Also, as you suspected there are some data being created in the Distribution Order History tables as well and these are also being created depending on certain values on the row of the parent table.
As you can see, this is a complex operation and the code is and should handle it. Otherwise there could be errors popping in strange places. 😋
So it is a bad idea. 😃
Best Regards,
Charana
+12Hi
I did a little digging on this. So my short answer is not to do this.
There are multiple conditions being checked when a ‘Distribution Order’ is being created. For example, there are some calls to check in Purchase Order, Customer Order APIs. There are some records kept in DISTRIBUTION_ORDER_API and they are also being called and processed.
Also, as you suspected there are some data being created in the Distribution Order History tables as well and these are also being created depending on certain values on the row of the parent table.
As you can see, this is a complex operation and the code is and should handle it. Otherwise there could be errors popping in strange places. 😋
So it is a bad idea. 😃
Best Regards,
Charana
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
