This content has been marked as final. Show 2 replies
I can only comment on the interconnect as it is all that I have used. It certainly has a standard Cross Reference transformation (XREF). You could use this to hold the relationship between your item numbers and theirs.
When your customer passes a "create order" message to your system, the item number can be populated with their side of the XREF table. When you find the corresponding item in your system, this item number would be passed as an OUT parameter back to the InterConnect XREF table. Now the XREF table holds the mapping between the two item numbers.
In subsequent transactions (say for example a Goods Received message), messages can use this now populated XREF table to map their item code to the one held on Oracle.
Whereas XREF's will be dymanically updated, Domain Value Maps could also be used. Using DVM's in your case may mean having to go through the exercise of mapping all their item codes to yours, and loading them into the static DVM table.
Regarding what solution to use? Good question!
XML Gateway seems to be a method by which you can exchange data into and out of Oracle Apps, but I don't think that solution gives you the actual conduit to connect to others systems. I may be wrong on this however.
InterConnect is the reverse of the above. That is, it provides that transportation and transformation of messages capability, but you have to create publishing and subscribing routines for message generation and consumption on the source and target systems.
ProcessConnect? Never used it. Can't say.
thanks for the feedback.
an looking at using interconnect as the go between from us to a third party solutino provider. We may ahve other systems that will also require connection to this solution provider which I think interconnect will do the job nicely.