Hello, Sorry for any inconvenience, I should have read the error message all the way through, lol! I just can’t access the link provided to get to an article that I was looking for to better understand the deployment process. I was sent that link from one of our cases. However, I can e-mail the community manager like the message says. Thank you for any help you can provide,Mike
OK, I accomplished this by using a Customer_Order_Line LU and the Customer_Order_Line_Tab trigger when the order line on an Internal Customer Order (Contract !=0) rowstate becomes “Released”. I just use the first line on the purchase order to find the External Customer No, then ultimately the priority from the customer record. I check to see if that is NULL or not.Here is the action:NEW:CONTRACT != 0, OLD_ROWSTATE != Released, NEW_ROWSTATE = ReleasedDECLARE attr_ VARCHAR2(32000); sql_msg_ VARCHAR2(32000); stmt_ VARCHAR2(32000); BEGIN stmt_ := 'DECLARE info_ varchar2(2000); objid_ varchar2(100); objversion_ varchar2(100); attr_ VARCHAR2(32000); action_ VARCHAR2(32000) := ''DO''; order_no_ varchar2(35) := ''&NEW:ORDER_NO''; order_po_no_ varchar2(35) := ''&NEW:DEMAND_ORDER_REF1''; cursor get_object IS select objid, objversion from customer_order where order_no = order_no_ and state = ''Released'';BEGIN open get_object; fetch g
Hey Damith, sure! Unfortunately, it still seems to run as a background job before the internal customer order is created, once we release the external customer order, so it’s not catching the internal order, even if the priority update is working. Still struggling with that.We don’t use DOP (yet), so the supply chain depth looks like this: (other screenshots and code below also) DECLARE attr_ VARCHAR2(32000); sql_msg_ VARCHAR2(32000); stmt_ VARCHAR2(32000);BEGIN stmt_ := 'DECLARE info_ VARCHAR2(32000) := NULL; objid_ VARCHAR2(100) ; objversion_ VARCHAR2(100); attr_cf_ VARCHAR2(32000); attr_ VARCHAR2(32000) := ''''; action_ VARCHAR2(32000) := ''DO''; order_no_ varchar2(35) := ''OLD:&ORDER_NO''; customer_no_ varchar2(35) := ''&OLD:CUSTOMER_NO''; internal_po_no_ varchar2(35) := ''&OLD:INTERNAL_PO_NO''; ico_priority_ varchar2(35) := ''&OLD:PRIORITY''; priority_ varchar2(35); cursor get_object ISselect objid, objversion, priority fro
Sorry, I meant CustomerOrder LU and Customer_Order_Tab. How would you set this event to know if the order is Created?
Hey Damith, Thank you very much for the response! Yes, I am now trying to use the Customer_Order view and Customer_Order table on a custom event. I am setting the custom event to be a background job that now work from when the Internal Custom Order is created and rowstate goes from != ‘released’ to ‘released’. From the internal order, I also have the internal PO like you said, but I am having trouble getting back to the External Order from the API, but I keep running into the requirement of the PO LINE_NO and RELEASE_NO, which these fields are not contained in this Customer_Order event.CUST_ORD_CUSTOMER_API.Get_Priority(customer_no_ => CUSTOMER_ORDER_API.Get_Customer_No(order_no_ => PURCHASE_ORDER_LINE_PART_API.Get_Demand_Order_No(order_no_ => &OLD:CUSTOMER_PO_NO,line_no_ => '1',release_no_ => '1')))ORCUSTOMER_ORDER_API.Get_Priority(order_no_ => PURCHASE_ORDER_LINE_PART_API.Get_Demand_Order_No(order_no_ => &OLD:CUSTOMER_PO_NO,line_no_ =>
Hey William, Thank you so much for replying, I really appreciate it. I see what you’re saying and I’ve attempted to put all that together. Unfortunately, I’m running into a road block below. Would you happen to have any suggestions? Unfortunately, I can’t use CUSTOMER_NO, because it’s always the same from that site (site 0). I’m attempting to get back to the External Customer or External Customer Order by the api below, but I keep running into the requirement of the PO LINE_NO and RELEASE_NO.CUST_ORD_CUSTOMER_API.Get_Priority(customer_no_ => CUSTOMER_ORDER_API.Get_Customer_No(order_no_ => PURCHASE_ORDER_LINE_PART_API.Get_Demand_Order_No(order_no_ => &OLD:CUSTOMER_PO_NO,line_no_ => '1',release_no_ => '1')))ORCUSTOMER_ORDER_API.Get_Priority(order_no_ => PURCHASE_ORDER_LINE_PART_API.Get_Demand_Order_No(order_no_ => &OLD:CUSTOMER_PO_NO,line_no_ => '1',release_no_ => '1')) Would you happen to know another wa
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.