Replies posted by Jouni
I have this kind of solution, what will create csv file so that there is line breaksEvent what will create messageDECLARE pick_list_no_ VARCHAR2(300) := '&NEW:PICK_LIST_NO'; l_refcursor SYS_REFCURSOR; l_xmltype XMLTYPE; bxml_ CLOB; BEGIN OPEN l_refcursor FOR select '2' ||';' || pick_list_no || ';' || Source_ref2 || ';' || Source_ref3 || ';' || Source_ref4 || ';' || part_no || ';' || -(qty_reserved - qty_picked)|| ';' || Fnd_Session_API.Get_Fnd_User || ';' || to_char(SYSDATE, 'DD.MM.YYYY') || ';' || to_char(SYSDATE, 'HH24:MI:SS') || ';' || contract as "C00"from PICK_SHIPMENT_RES_STOCK_UIV WHERE location_no = '3' and pick_list_no= pick_list_no_; l_xmltype := XMLTYPE(l_refcursor); bxml_ :=l_xmltype.getStringVal();plsql_rest_sender_api.Call_rest_Endpoint(rest_service_ => 'SEND_TO_KARDEX',xml_ => bxml_,http_method_ => 'POST',http_req_headers_ => 'Content-Type:application/xml',message_type_ => 'KARDEX')
@Nimesh Kasun If you press date on line, you get card what you used, if you press operation you get card what is have.I lack knowledge, what are the step to get field visible there, when you add content to card.Which LU to add field in EE and what need to do in Aurena side?
I don’t have answer, but related questionI got task relating datamatrix yesterday from customer and just make first test, but seems that datamatrix not return value it have. Instead it returns www.ifsworld.com as your code above. Did you get Datamatrix give output something else www.ifsworld.com? I haven’t yet possibility to test real print out, but at least report designer not show real data.
If you go to your report rule and condition RMB edit expression 1You can see that there is no Company on report xml data. So your condition won’t ever match.You need to use site or make select or use api function to get company based on site at expression1 field
Unfortunately I don’t don’t neither have clear answer for you, but some more variables to consider. Delivery term; are goods sold on your premises or delivered to customer Partial deliveries; how those should be counted I assume there is no standard wayt to handle this, depends on company and business where they are. But if you can define rules how to calculate, that is most probably possible to implement to IFS with custom fields, LU’s and events. -Jouni-
It’s exactly as you wrote “ Perhaps it is the Report that searches for the Customer default Doc Text in addition to the Cust Order Doc Text. “ Print can fetch document texts several places and Customer order pick list print fetch those from Order and also behind customer.
I had about same request, but another way, customer ask possible SO’s for COL. (much easier case as you have). As there is no direct unique links, I made custom fiels what shows all possible SO’s, and that was fine for them. Maybe you can do something similar but another way. SELECT LISTAGG(SO, ' ; '|| CHR(13)||CHR(10)) WITHIN GROUP (ORDER BY SO) SO FROM ( SELECT order_no||' - '|| state||' - '|| revised_due_date||' - '|| revised_qty_due||' Qty' SO FROM shop_ord WHERE objstate NOT IN ('Closed','Planned','Cancelled') AND contract = 'xxxxx' AND part_no = :part_no )
Like this, select JT_TASK_UIV.STATE, JT_TASK_UIV.TASK_SEQ, JT_TASK_UIV.ACTUAL_OBJECT_DESCRIPTION, JT_TASK_UIV.REPORTED_DATE, JT_TASK_UIV.ACTUAL_FINISH, JT_TASK_UIV.ERROR_TYPE, JT_TASK_UIV.PERFORMED_WORK, JT_TASK_UIV.SITE, JT_TASK_UIV.ITEM_CLASS_ID, JT_TASK_UIV.ACTUAL_START, JT_TASK_UIV.ACTUAL_OBJECT_ID as "Serial Object", JT_TASK_UIV.PRIORITY_ID, JT_TASK_UIV.DESCRIPTION, EQUIPMENT_SERIAL_UIV.MCH_CODE, EQUIPMENT_SERIAL_UIV.MCH_LOC, EQUIPMENT_SERIAL_UIV.MCH_POS, to_char( JT_TASK_UIV.ACTUAL_FINISH,’WW’) AS week from &AO.JT_TASK_UIV LEFT OUTER JOIN &AO.EQUIPMENT_SERIAL_UIV ON &AO.JT_TASK_UIV.ACTUAL_OBJECT_ID = &AO.EQUIPMENT_SERIAL_UIV.MCH_CODE WHERE STATE IN ('Work Done','Finished','Released','Started','FaultReport','Work Started') Problem could be if JT_TASK_UIV.ACTUAL_FINISH is not date
One option Create new custom LU When change request is created launch event what add line to this LU, change request id and your own id what you combine in sql event action. Then custom field to original change request view to show value from this new custom LU Hopefully you got my point what I try to explain ;)
You can’t add info directly to that event, but you can do something when connecting events to chain To that original event create sql actions, and inside that you can fetch more data. Create new event what would send mail/ stream msg (this event is not launched any new or modify) Call this new event from original event action and forward those new parameters there. Another thread where is eg
I’m looking something what is more like configurable solution instead of modification. ;) I haven’t ever used mail reader, but if that can read mails and take attachments, then should be possible to route those to be saved some folder. Then it’s possible to read those eg with migration job. Need to check
Would you use (scheduled) event for this? Load data to IC_ tab Then sql event you can select distinct supplier Create header (I think there is procedure what returns created order number) Loop lines from IC_ tab for this supplier and create lines Migration this might be impossible since, that is not looping that sence and lost connection between runs. Just tought with out detailed thinking. When you run migration for headers, store created order numbers and supplier to some custom LU. Then run another migrations which should create lines for these orders.
OOB logic is inside api code, so not directly available or possible to use. So you can use existing OOB event. Create sql event action. Add there needed get or select searches to fetch needed extra data. Create new event (or use that what you already have made) and call that from original sql event action. Unfortunately I don’t have just now time to create better example, but maybe you get idea from below. declare arg_ VARCHAR(32000); msg_ VARCHAR(32000); BEGIN --here cursor or get function to fetch extra data --add data to msg attr, these are the values used in another event Client_SYS.Clear_Attr(msg_); Message_SYS.Add_Attribute(msg_, 'NEW:DELNOTE_NO','&NEW:DELNOTE_NO' ); Message_SYS.Add_Attribute(msg_, 'NEW:CONTRACT','&RECEIVER' ); --add data to event attr Client_SYS.Clear_Attr(arg_); Client_SYS.Add_To_Attr('EVENT_LU_NAME_', 'ExtDispatchAdvice', arg_); Client_SYS.Add_To_Attr('EVENT_ID_', 'xxxx_AUTO_RECEIVE_B', arg_); Client_sys.add_to_attr('EVENT_DATA_',msg_,arg_); --c
I have little bit same kind of cases. Customer order products, but those are first delivered to they terminal, there they handle those to final destination. We should anyhow in delivery phase mark pallets with both informations ‘Delivery address’ and ‘via address’. Now we plan to handle those so, that final address is added to some custom fields etc, and Via address is main address at customer order. I think this kind of ordering flow is std in SAP purchase, at least these both customers have SAP.
I can see the issue, but where this is problem? Worker can see from system or paper, that it need’s 5x0,2, I assume. From store that is roll etc and from there it’s needed as 1m. I had same thing earlier, but that was configured product, and there is possible to add several lines on strucutre and create rules for those. One option could be custom event, what will multiple some lines and adjust qty’s.
You have that OOB event what is trickered as you want. Can you just change event action of that? Or change action to sql type action, then you can fetch more data etc if you need. After that you can send mail from code or with another event. But as Rusiru wrote, more details would help. ;)
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.