When trying to run Order Export Utility, I'm getting the following error each time:
"Procedure or function "LP_ORDER_EXPORT" expects parameter '@mail_purpose', which was not supplied."
I get this same error whether I specify an Address Purpose or whether I leave it set to [none].
Everything seems to be set up correctly with the parameters.
Any idea what could cause this error?
Thanks,
Shelly Binkley
Business Systems Analyst
Kennedy Center
(I'm probably telling you stuff you know so ignore me if not relevant)
LP_ORDER_EXPORT is the custom procedure stuff before you get to the TP_ORDER_EXPORT so might be a bit of a personal thing.
eg: we add info into TW_ORDER_IMPORT local_use0 and local_use0 fields to indicate that the person is Yes or no to mail or email.
You may need to have a look in LP_ORDER_EXPORT and set a default in there.
Oh, that makes more sense! I feel dumb that I didn't remember "LP" means it's a customization. I looked at LP_ORDER_EXPORT with my boss and it in fact had more issues than just the @mail_purposes parameter. Thanks for setting me on the right track!
Hey that's cool. New org / new local procs. The amount of time I've spent importing and exporting files it was only now that I examined it in detail alongside you. As with most DB things it's usually only when it goes wrong that we need to unpick the processes.