How to create rib object for XItem API from a data table
Hi All,
I am trying to create item into RMS using mass upload.
We are using RIB eWay and XItem Interface.
I found below information on a forum.
There is a bypass option, where one omits the JMS/AQ layer and directly talks (in PL/SQL) to the RIB consumer API, in this case procedure RMSSUB_XITEM.Consume().
In this case one needs to convert the Excel to e.g. CSV, read the CSV as an external table, transform/format the data to an Oracle Object data structure, that implements RIB_OBJECT type.
This is not so complicated, however does not have the robustness of the RIB error hospital etc. and is not loosely coupled and asynchronous.