oracle to r/3 scenario

[Former Member]

hi i have a scenario.

that when i run one TCODE at that time i want some data from oracle table to r/3 Z Table.

how can i do this.

[MichalKrawczyk · Accepted solution]

Hi,

this is pretty easy:

1. TCOde can execute an RFC call to XI

2. XI will use a synchonous JDBC call to retrieve some data with select statement and send the

data back to XI

3. then XI will send it back to RFC and to your report

anyway the point is to use a synchronous JDBC receiver adapter to make a select statement

which will query the oracle db and get the result back

Regards,

Michal Krawczyk

[Former Member · Accepted solution]

if you have some blogs or screen short setps please provide me.

thanks.

[Former Member · Accepted solution]

Hi,

this may be of ur intrest

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

just instead of file use RFC

Regards,

Manisha

[Former Member · Accepted solution]

if you have more example please tell

me. thanks

[Former Member · Accepted solution]

Hi Alex,

I guess using that blog u can manage to complete scenario.

and need to add additional knowleadge of BPM and Sync Async configuration. for tht u can use

/people/arpit.seth/blog/2005/06/27/rfc-scenario-using-bpm--starter-kit

Regards,

Manisha