We can automate the request submission using the Batch client, provided we have a properly formatted input file with the request items.
Please note that in this example, our DRM instance is on the D Drive.
"D:\products\DataRelationshipManagement\client\batch-client\drm-batch-client.exe" /URL=net.tcp://EPMSRV:5211/Oracle/Drm/Engine /log=D:\DRM\Data\Inbound\BatchLoad.log /u=Operations /pw=Welcome! /op=RequestSubmit /delim=tab /conn=Inbound /vabbrev="Vision Jan 2013" /hierarchy="Parent Total" /conn=Inbound /filename=AcctConditional-I.txt /workflowtask="Add Financial Account" /workflowmodel="New Financial Account" /requesttitle="Batch Request" /deleteonsubmitfailure=0
Submit Workflow Request:
/op = **Request** **Submit**/delim= Printable delimiter character the request items file use/conn= (optional) Name of external connection pointing to location where file specified with filename option resides/vabbrev= Name of version to use for created request/hierarchy= Name of hierarchy to use for loaded request items/filename= (optional) Name of request items file if using an external connection./infile= (optional) Path and file name for a local request items file to use./workflowtask= Name of the workflow task to use/workflowmodel= Name of the workflow model to use/requesttitle= Title of submitted request/deleteonsubmitfailure= Delete the draft request if submit fails validation – Y: Yes | N: No | T: True | F: False | 1 | 0/allowblankoverrides= (optional) If true, then blank values in the source file are treated as blank value overrides for each item, according to the /blankvalueindicator param- `/blankvalueindicator= (optional) If specified, any column value matching the blankvalueindicator will be interpreted as a blank value override.
If not specified, any blank column value will be interpreted as a blank value override.