In IFS10 (and previous versions) there is BizAPI ConnectivityProcessingHandler:LoadInboxMessage that can load IN_MESSAGE and IN_MESSAGE_LINE from a XML.
I cannot find equivalent Projection in IFS Cloud.
Do you know if there is such projection and the name of that projection?
Neno
I’m answering my own question - there is no Projection for ConnectivityProcessingHandler:LoadInboxMessage . I had to develop PLSQL package and user PlSQL connector to get IN:MESSAGE data into Connectivity.
Hi NZCNESOSE,
Can you please explain a bit how you use PLSQL connector to get into the connectivity table?
/Jeewan
In short, you create a Oracle package function with following parameter signature:FUNCTION Load_Inbox(in_xml_ CLOB) RETURN CLOB
then, create IFS Connect address with type = PLSQL and enter name of the function and PLSQL parameter. Route your XML message to this address and you will get XML filen in in_xml_ CLOB variable.
Thereafter use Oracle XMLTABLE functionality to “convert” XML into usable cursor that can be used to insert data into In_Message nd In_Message_Line.
Thank you.
/Jeewan
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.