Hello,
We are trying to create a new event & want to include a custom field – do you have any suggestions for the field highlighted in the print screen in yellow?
The custom field is using the following select statement :
SELECT CUSTOMER_ORDER_API.GET_AUTHORIZE_CODE(oe_order_no) from customer_order_shop_order c inner join shop_ord s on c.so_order_no=s.order_no and c.so_release_no=s.release_no and c.so_sequence_no=s.sequence_no where s.OBJKEY=:objkey
Thank you,
Joann
Hi
As per my understanding only functions allowed there, so you can not use select statement. To do so, you can create custom Oracle package and pack your select into the function . Second way is to create read only custom field on the shop order history, but in this case you should convert your event for CLT table.
It’s been a while since this was asked, but another way is to nest APIs. I tried the same type of event in our test instance and it worked fine.
customer_order_api.get_authorize_code(shop_ord_api.get_customer_order_no(&NEW:ORDER_NO, &NEW:RELEASE_NO, &NEW:SEQUENCE_NO))
Thank you for the suggestion! I will pass this information on.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.