Narrowed it down and traced using TOAD - found a custom view which is feeding the API. The IFS ID has a ‘2’ at end of name -complicating things - as the view only includes the original username without the ‘2’ (long story) I activated the previous username in hopes of the email address (which is needed to populate the view) will be in play for Streams - That’s all I have for now - I need to dig further. Thanks! I will let you know what I find and thanks for your assistance!
Thanks for responding! Yes it’s getting more involved as I dig deeper - here’s more code:CREATE OR REPLACE PACKAGE IFSAPP.EDCO_COORDINATORS_API asmodule_ CONSTANT VARCHAR2(25) := 'EDCO';lu_name_ CONSTANT VARCHAR2(25) := 'EDCOCOORDINATORSAPI';lu_prompt_ CONSTANT VARCHAR2(25) := 'EDCOCOORDINATORSAPI';EDCO_K__VERSION CONSTANT VARCHAR2(8) := '1.0';EDCO_K__CRLF CONSTANT VARCHAR2(8) := utl_tcp.CRLF;EDCO_K__EXPAND_OUTPUT CONSTANT BOOLEAN := FALSE;EDCO_K__DEBUG_OUTPUT CONSTANT BOOLEAN := TRUE;EDCO_K__DEBUG_IDENTIFIER CONSTANT VARCHAR2(64) := 'EDCO_COORDINATORS_API';EDCO_K__ATTR_DATE_FORMAT CONSTANT VARCHAR2(64) := 'YYYY-MM-DD-HH24.MI.SS';EDCO_K__DEFAULT_VARCHAR2 CONSTANT VARCHAR2(8) := ' ';EDCO_K__DEFAULT_NUMBER CONSTANT NUMBER := 0;EDCO_K__DEFAULT_DATE CONSTANT DATE := NULL;EDCO_K__ALLOW_OBJECT_DUMP CONSTANT VARC
Hi! so much appreciated on your responses! We are on version 9.10The Event Action for this stream notification is a SQL coded event.DECLARE attr_ VARCHAR2(2000) :=''; status_ NUMBER :=0;BEGIN Client_Sys.Clear_Attr(attr_); Client_Sys.Add_To_Attr('ORDER_NO', '&NEW:ORDER_NO', attr_); status_ := IFSAPP.TRANSACTION_SYS.POST_LOCAL__( 'EDCO_COORDINATORS_API.send_COORD_MESSAGE' , attr_ , '###EDCO - SEND IFS STREAM MESSAGE ABOUT WEB ORDER TO COORD --- ORDER: &NEW:ORDER_NO' , sysdate , 'TRUE' );END;
Thanks! will do!
Thank you! I didn’t change that - but now I did - and voila! Although I ahd to go to a different template area than originally thought...I attached that to this message. Once again - many thanks!
Thank you for responding - much appreciated! However - yes here’s the screenshot of report templates - and I have logged on as the owner of the template and as IFSAPP - no show - see screenshot and previous screenshot - thank you so much for the help!
Thanks so much for responding Shawn! That confirms the original prognosis as well. Thanks!
Thank you for responding Shawn! The overview/screen is Inventory Parts. The form is Inventory Part. The field is Estimated Material Cost. And yes, you are correct - this field is located on a tab for the Inventory Part form - however, this field is found in the INVENTORY_PART_CONFIG. So….hope this helps!
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.