I have not been able to find anything after extensive searching, but I did come up with a way to achieve this. Under an Event you can create ‘Custom Attributes’ which allow you to make PL/SQL function calls. I simply added a new function in our custom utility API in PL/SQL that returns the value I need for the specific instance. Implement this in each of your instances (DEV, TEST, PROD, etc...) and when it calls the PL/SQL function it will get the correct value it needs. You can use the value in the Event Action just as you would any of the normal attributes that are passed from the event.
No, it is the end point URL in an Event Action
@NSRJMITCHELL thank you so much for sharing! love the Black IFS… how’d you do that? Using the “Graphite” theme that comes with IFS
Sure! This is the function I wrote in PL/SQL and the Routing Rule, Routing Address, and Presentation Objects are all attached. Hopefully that helps!FUNCTION Receive_EDI_Acknowledgements(doc_ IN CLOB) RETURN CLOB IS PROCEDURE Core(doc_ IN CLOB) IS CURSOR ACKS IS SELECT EXTRACTVALUE(COLUMN_VALUE, '/DocumentAck/AckStatusNotes') as NOTES, EXTRACTVALUE(COLUMN_VALUE, '/DocumentAck/AckStatus') as STATUS, TO_DATE(EXTRACTVALUE(COLUMN_VALUE, '/DocumentAck/Date'), 'YYMMDDHH24:MI:SS') as REC_DATE, EXTRACTVALUE(COLUMN_VALUE, '/DocumentAck/DocumentNumber') as DOCUMENT_NUMBER, EXTRACTVALUE(COLUMN_VALUE, '/DocumentAck/DocumentType') as DOCUMENT_TYPE FROM TABLE(XMLSEQUENCE(XMLTYPE(doc_).EXTRACT('/OUTPUT/*'))) t; BEGIN FOR ack_row IN ACKS LOOP INSERT INTO EDI_ACKNOWLEDGEMENT_CLT (CF$_ACK_NOTES, CF$_ACK_STATUS, CF$_DATE, CF$_DOCUMENT_NUMBER, CF$_DOCUMENT_TYPE, ROWVERSION) VALUES (ack_row.NOTES, ack_row.STATUS
I ended up creating a custom PL/SQL package function that accepts a clob and extracts the values using a cursor. I then iterate over the cursor and insert the values into the custom table. I call this custom function from a Routing Rule and Routing Address when the file is read in.
Re-installing the web logic and re-creating the project root solved this issue for me.
Thank you for the responses! I guess my question was worded poorly. I know about the ways of scheduling the task, I would like the frequency to be based on a dynamic date in the database. Essentially I need this task to run at the end of every accounting period quarter, however, these periods are not static dates and change year to year.
Does this also support date columns?
I see it in the Connectivity Inbox Messages as Accepted, I don’t see it in the Application Messages at all
IFS Pretty much only told me that I need additional training, and that I may be using the incorrect schema and directed me to the schema I am using.
I’m on version 10 update 8. I’m looking at the Receiver Customer Schedule API and it looks like it doesn’t even look at the part # on the line segment at all. I am going to put in a ticket to see if this is intended behavior. Thank you for all your help!
I found it… It shows the lines being applied to both part nos <?xml version='1.0' encoding='UTF-8'?><IN_MESSAGE xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="urn:ifsworld-com:schemas:inbound_distribution_transactions_receive_customer_schedule_response"> <MESSAGE_ID xsi:nil="1"/> <RECEIVER>EDI</RECEIVER> <SENDER>4311</SENDER> <SENDER_MESSAGE_ID xsi:nil="1"/> <RECEIVED_TIME xsi:nil="1"/> <VERSION xsi:nil="1"/> <CONNECTIVITY_VERSION xsi:nil="1"/> <SENDER_ID xsi:nil="1"/> <CLASS_ID>DELSCH</CLASS_ID> <OBJSTATE xsi:nil="1"/> <OBJEVENTS xsi:nil="1"/> <STATE xsi:nil="1"/> <LINES> <IN_MESSAGE_LINE> <MESSAGE_ID xsi:nil="1"/> <MESSAGE_LINE>1.0</MESSAGE_LINE> <NAME>HEADER</NAME> <C00 xsi:nil="1"/> <C01 xsi:nil="1"/> <C02 xsi:nil="1"/> <C03 xsi:nil="1"/> <C04 xsi:nil="1"/> <C05 xsi:nil="1"/&
I can’t seem to find the response you’re speaking of.
I’ve attached the file I’m using for testing.
@alackas How are you using Windows Auth to log into IFS?
Thank you!
Thank you @GPIE … do you know if there is an XSD (schema) I could use to accomplish this? I would map the incoming X12 to the IFD EDIFACT.
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.
