JDBC-XI-IDoc scenario -- Urgent

[Former Member]

Hi All,

I am doing a scenario JDBC-XI-IDoc.

Now the Oracle table in the source system, has a control table as well.

This control table has 2 fields MSGID and MSGTSTAMP. These 2 fields has to be updated for each record.

Now please tell me, how this can be handled?

The MSGID and MSGTSTAMP r created in XI, so we need to send it back to source system, but how?

Its urgent, early reply will b appreciated.

Thanks in advance.

Neetesh

[moorthy]

Hi,

You need to create Synch. communication between XI and JDBC.

<i>This control table has 2 fields MSGID and MSGTSTAMP. These 2 fields has to be updated for each record.</i>

>>> Is it mean, after posting idocs, it should update the MSGID and MSGTSTAMP to JDBC ? If so try to build SYnchronous communications between JDBC and Idoc via BPM.

When you get the IDoc acknowledgemnt, you can update this info into Oracle Database.

Hope this helps,

Regards,

Moorthy

[Former Member]

Hi Krishna,

Thanks a lot for the quick reply.

In my case, its that the MSGID and MSGTSTAMP are independent of the IDoc, ie, it has nothing to do with the reaching of the IDoc in the R/3 system. So, it should be something like- XI triggers IDoc to R/3 and almost at the same time, sends back the MSGID and MSGTSTAMP to JDBC.

So, the synch communication will should solve the problem, using the BPM. Please confirm.

Thanks, Bye

Neetesh

[moorthy]

Hi Neetesh,

Yes , you can do it using BPM.

<i>So, it should be something like- XI triggers IDoc to R/3 and almost at the same time, sends back the MSGID and MSGTSTAMP to JDBC.</i>

>>> Then I think you can do without Synch communication.

-Receive the Message in BPM(after mapping)

-Fork step to send both messages at same time

-Send to Idoc

-Send to JDBC

But you need to have 2 receivers.

1) BPM->Idoc

2) BPM->JDBC

It will do.

SO u can do without Synch communication also.

Pls acknowledge

Regards,

Moorthy

[Former Member]

Hi Neetesh,

IF you are using async JDBC, then you can do this without BPM.

All you have to do is make two receiver determination (one IDoc and one JDBC again)and don't put any condition, they will be called one after the other.

All you have to do is pass the messageID and stamp to it.

Regards

Vijaya

Message was edited by: vijaya kumari

[Former Member]

Hi Krishna / Vijaya

Thanks for your inputs.

Both inputs are valuable for me. I will implement the things suggested by you people and then let you know.

I will award points to both of you.

Thanks a lot for help.

Bye

Neetesh

PS:- In case I need more help, I will write to you people directly. Hope you wnt mind .. -:) Thanks.