Hi @Rpauley ,

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

Hi @Rpauley ,

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 

Hi @Rpauley ,

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

Hi @Rpauley ,

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

@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)

Hi @Rpauley ,

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

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,

@EntNadeeL and @william.klotz 

Didnt even notice the space, it works now thank you both for your help