Tuesday, November 24, 2009

Batching in ORACLE -B2B

Batching is a way of grouping the transaction set.In case of inbound to ORACLE B2B the debatching is done automatically however in case of outbound the transactions can be batched based on the user criteria.It can do Batching for a specific message type of a Trading partner,Batching multiple messages of a specific trading partner,Batching multiple messages of more than one trading partner.

In order to enable the debatching one need to update the following table

B2B_BATCH_EVENT

The different fields in this table are

ID -Its a randomly generated guid
Expire_time -Date time when the bathing occurs.
Interval -Interval in which the next batching should start(in minutes)
totpname -Trading partner name to which file is to be sent.
Doctype -doctype name eg-EDI
DocTypeREv -document revision
Msgcount -default set to 1
State -default set to 1
Enable-set to 1 when batching is enabled else 0.
Criteria1-It can be set to values according to the document.Used for full batching support

No comments: