Using Agentry with Oracle apps EAM

[CRVMANISH]

Hello Experts,

Like SAP oracle has their own API, it can be web service or store procedure to modify standard objects.

In our case it will be workorder objects.

What are the option in Agentry as we cannot directly modify EAM tables.

Is it possible to call store procedure using SDML.

Regards

Manish

[bill_froelich]

Manish,

The standard SQL steps can be configured to call the stored procedures and populate using the transaction properties just like a direct SQL table update.

--Bill

[CRVMANISH]

Can you provide one example.

Regards

Manish

[Former Member]

If you are talking about a database store procedure, don't need the SDML part to call it, just use the default SQL command.  But for the data to fill it, you would need to use SDML to access the client data.

Stephen