Resolution:
How to create mulitple records in another repository based on the values of the current record?

Environment:

TIBCO Product name and version: TIBCO Collaborative Information Manager 8.0.0 (and earlier versions)
Operating System(s): All Operating Systems

Symptoms:

None

Cause:

N/A

Resolution:

SaveRecord workflow activity can be used to achieve this.  Here are the steps that you can follow:

1) Create a Master Catalog TEST with following additional attributes (of Type string): PID1, PID2, UOM1, UOM2

2) Create another Master Catalog TEST1 with default attributes.

3) Use EvaluateRuleBase activity to call rulebase which will populate the variable PRODUCTIDS (with value of PID1 and PID2) and UOMS (with value of UOM1 and UOM2).

4) Call SaveRecord workflow activity which will update TEST1 master catalog with the values of PRODUCTIDS and UOMS (2 records should get created / updated).

5) Finally call UpdateRecordState activity to set the status of created / updated records to CONFIRMED.

Attached is the validation rulebase and add record workflow (especially take a look at EvaluateRuleBase, MyProcessRecord and UpdateRecordStateAsApprovedTEST1 activities in workflow xml).

Please refer Workflow Reference Guide,  Activities : SaveRecord section for more details on SaveRecord workflow activity.

Attachments:

SaveRecord_for_adding_mulitple_records_in_different_repository.zip

References:

None

How to create mulitple records in another repository based on the values of the current record?