Good Afternoon
I am trying to pull in the DO Coordinator Field into my Shipment Data Set, i was able to pull in the DO State but the Coordinator Field is fighting me. any help would be greatly appreciated. Below is screen shots and my current attempt to get the Coordinator Field
&AO.Distribution_Order_API.Get_ DIST_ORDER_COORDINATOR (DIST_ORDER_COORDINATOR)
Best answer by EntNadeeL
View original
+21
Hi
Looks like the Get_Dist_Order_Coordinator takes one parameter which is the order number. Have you tried something like below?
&AO.Distribution_Order_API.Get_ Dist_Order_Coordinator(ORDER_NO)
Regards,
William Klotz
When i try it like that i get the below error message
+21
Hi
Here’s a screenshot from my PL/SQL Developer screen. Looks like maybe your query has a comma at the end of your select. What does your query look like?
Regards,
William Klotz
Sir,
i do not have a Developer screen like yours, i am working strictly out of the Data Source Designer, i am failry new to all of this and have learned alot and received alot of help on this site. i do not see any comma’s
+21
Hi
Can you provide a screenshot of your data source designer screen so I can see all the setup or export it and attach it to a message on the forum?
Regards,
William Klotz
Here is Screen Shot and Attachment
+21
Hi
I’m unable to test because we do not use Distribution Orders but I think it should work. I’ve also attached the exported lobby datasource and attached it.
Regards,
William Klotz
Still getting the same error as above, told ya this one was fighting me LOL
&AO.Distribution_Order_API.Get_ Dist_Order_Coordinator(ORDER_NO)
+21
Hi
Wow, I’m not sure what’s wrong. Unfortunately we do not use distribution orders or else I’d test it in my system. Let’s see if someone who has distribution orders up and running can give it a try.
Regards,
William Klotz
+9
Hi Everyone,
You both are doing the correct thing except I noticed a space between &AO.Distribution_Order_API.Get_ and Dist_Order_Coordinator(ORDER_NO). I got the same error and when I removed it, it worked fine.
After the space it seems like SQL is looking for the FROM key word.
Distribution_Order_API.Get_Dist_Order_Coordinator(ORDER_NO)
These stuff happen :)
Thanks,
Kind Regards,
Didnt even notice the space, it works now thank you both for your help
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
