I’m looking to see if it is possible to generate a Streams notice when an IFS Error Message occurs. Specifically, I’m looking to build an alert for the Insufficient material error message when attempting to Ship WIP to a Supplier. Any help would be greatly appreciated. Thank you.
Best answer by ShawnBerk
Yes, this should be doable with a combination of these Event Actions to get the triggered notification directly into a stream
The second post is a little different in that it is around a background job error, but the concept should be similar. You just have to trace out using the debug tool how the message box is triggered and try to trigger the action associated with that event. I would think it possible with a custom event.
The second post is a little different in that it is around a background job error, but the concept should be similar. You just have to trace out using the debug tool how the message box is triggered and try to trigger the action associated with that event. I would think it possible with a custom event.
Hi @sawantrahul I did find the debug error/security check. However, reading the linked articles, I’m not sure how to go about actually building the Streams event when this error message triggers.
The error from debug is below. I'm not sure which Logical Unit I would use. I’ve tried looking for ShopOrderOperation and SecurityCheckpoint, but I’m not seeing which table to connect to and configure.
Start Time: 11:05:48 AM,527 Category : Server Invoke[PL/SQL Command] Sub Category : Error exception! Info : BEGIN &AO.SHOP_ORDER_OPERATION_API.Report_Ship_Wip_To_Suppl(:p0 ,:p1 ,:p2 ,:p3 ,:p4 ,:p5 ); commit; EXCEPTION WHEN &AO.Error_SYS.Err_Security_Checkpoint THEN raise; WHEN OTHERS THEN rollback; raise; END; Thread : 0x0011 - IFS Application Explorer Form Thread Requested URL : https://servername.domain.com:49080/main/default/plsqlgateway/AccessPlsql/Invoke?dlgShipWipToSupplier Redirected URL : Request Id : 87add8f7-b1e2-4f27-9f36-e5374cc4a027 Duration (ms): 212 DB Statements Executed : 4 DB Rows Fetched : 0 External Calls : -1 GZip Acc/Req/Resp : 1/1/1 Bytes Sent : 1561 Bytes Sent Compressed : 786 Bytes Sent Compression Ratio : 50% Bytes Received : 66730 Buffer Parsing (ms) : 0 Record Parsing (ms) : Exception : ORA-20110: Insufficient material. Issuing could not be done for the part
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.