Thank you, it helps to some extent. I am infact looking for more details on setDRMBatchClient.exe.
Assuming that webservices invocation is not feasible from EBS 11, is it advisable to use this exe for loading the CSV data (having hierarchies info) from EBS Server to DRM .
--> Transfer the CSV(ebsdata.csv) from EBS to DRM through FTP/Socket
--> Download the EBS hierarchy in DRM server
--> Run drm-batch-client.exe to load the hierarchies info to DRM
Please help me in validating this approach.
I can see a performance hit in the 3rd step which is taking sometimes 10 mts to load all hierarchies into DRM. Can someone tell me an alternative way to load the data to DRM using PL SQL instead of running drmbatchclient.exe ?
Does the batch client delete all records and reinserts again ? Why would it take 10 minutes sometimes to get executed?
Seeing several warnings in the logs as well ...
2/06/2014 12:11:34 PM - - Warning: Script action 8 returned status 'Failure' with message: DRM-15029: Node NTRMUN not found in Hierarchy GEOGRA..
5008: Node 204196 does not exist in Hierarchy
Your approach with running drm-batch-client.exe via the task scheduler should work and its up to your covenience.
More about the batch you can have a look at http://docs.oracle.com/cd/E40248_01/epm.1112/drm_user.pdf