How to get "InterchangeControlNumber" in B2B message?

Yousra-85

Hi,

I'm having a soa composite interacting with oracle B2B. Oracle B2B generate internally a identifier for each message called "InterchangeControlNumber'" in Internal-Properties.

I want to know if there is any way to get the value of this identifier while generating the message in soa composite so that i can put it  in the message itself in another segment.

Dheeraj Kumar M at Accenture

Incase of inbound, it is driven by the incoming message from the partner and the same gets stored in Internal-properties

Incase of outbound, you can control by providing the custom values (your own logic to maintain the uniqueness of the number) and set it as part of internal-properties. This can be done easily in XSLT. If there is no value when it comes to B2B, it will generate automatically, based on a B2B database table as a sequence number

Regards,

Dheeraj

Yousra-85

Thanks you for your reply.

That's the point, is there any way to get the number generated by B2B database table incase of outbound.

Indeed, I can provide my own logic and put it in internal-properties. But my need is to take the one generated by B2B and use it in the core of the message.

Dheeraj Kumar M at Accenture

Oracle B2B uses the b2b_control_number table to generate new control number.

On a sidenote, Generally oracle does not entertain to access the table directly. Alternatively, there is a instance Message API (Java Utility), using which you can access many details about a particular message (including InterchangeControlNumber).

refer :

https://docs.oracle.com/en/middleware/soa-suite/b2b/12.2.1.3/b2b-ug/programmatically-accessing-instance-message-data.htm…

https://docs.oracle.com/en/middleware/soa-suite/b2b/12.2.1.3/instance-msg-ref/index.html

Regards,

Dheeraj

Dheeraj Kumar M at Accenture

were you able to resolve the issue? can you please update ?

Regards,

Dheeraj

Yousra-85

Hi, I'm sorry for being late. I haven't worked on the issue since then.

I don't think if this API will resolve my issue; for having  the instance information, I need to identify it, and I have no way to identify it , since I'm searching for the "InterchangeControlNumber'" itself!!

Dheeraj Kumar M at Accenture

even if you want to directly access the table also, you need to know the particular message, for which you can query for Interchange control number.

This API also does the same.

Since this is outbound, it is better to generate the control number from SOA and pass the same to B2B via Internal properties.

Regards,

Dheeraj

Yousra-85

Yes, I think the best solution.

Thanks for your help.

Dheeraj Kumar M at Accenture

You  are welcome !

Please see if you can mark the appropriate answer as correct and close the thread !!

Regards,

Dheeraj