DRM 11.1.2.4: DRG Workflow Request Submission using Batch Client

In the previous blog you have seen how to load request items from a file, sometimes being a DRM developer you may end up doing the same on a regular basis,

We can automate the request submission using the Batch client, provided we have a properly formatted input file with the request items.


"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 = RequestSubmit

/delim=                 Printable delimiter character the request items file use
s - single character (|~`:, etc) | tab | comma | space | #nnn  (#33 - #126)
/conn=                  (optional) Name of external connection pointing to locat
ion 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 extern
al 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