Hello, I've just realized we have about 100 packages that were entered as the wrong package number. The orders are paid and ticketed. Manually changing them be returning and rebooking them will be super time consuming and I need them the other packages because of a report.
I tested one order changing the following in SQL.
In T_LINEITEM I changed, package_no, perf_group_no and super_pkg_no
In T_SUB_LINEITEM I changed package_no
The changed order looks okay but I'm worried I'm going to blow something up.
Anyone have any experience with this? I think I got all the tables where the package data is stored.
Thanks in advance for your help!
Jessica
Jessica Jones-Deziel Did this end up working out for you?
Hi Jessica,
I believe it did but this was over three and a half years ago in v 12.1.1 so I'm not 100% sure if it would work now. The structure there hasn't changed much since then. I'd recommend opening a support ticket and we can help you look at your specific situation.
Please let me know if you have any other questions.
Okay, thank you!