Solved

FSM 6u15 scheduled process date variable

  • 17 March 2022
  • 2 replies
  • 108 views

Userlevel 1
Badge +7

I am looking to create a scheduled task that would use the current date +90 days as an input paramater. do you have any suggestions on how i might accomplish this?

 

Specifically on the scheduled end date

<schedule_end_date>today + 90 days</schedule_end_date>
<perform_contract_pm_request_generation>
<parameters>
<posting_group>AMERICAS</posting_group>
<contract_id>
</contract_id>
<contract_version>
</contract_version>
<contract_type>
</contract_type>
<place_id>
</place_id>
<model_id>
</model_id>
<request_template_id>REQ-TEMPLATE</request_template_id>
<task_template_id>task Template</task_template_id>
<schedule_end_date>today + 90 days</schedule_end_date>
<purchase_order_id>
</purchase_order_id>
<consolidate_request>N</consolidate_request>
<break_on_model_id>N</break_on_model_id>
<break_on_contract>N</break_on_contract>
<break_on_contract_type>N</break_on_contract_type>
<break_on_planned_date>N</break_on_planned_date>
<bundle_pms>N</bundle_pms>
<variance_days>
</variance_days>
<consolidate_task>N</consolidate_task>
<autocreate_task>Y</autocreate_task>
</parameters>
</perform_contract_pm_request_generation>

 

icon

Best answer by SanjeewaJ 18 March 2022, 04:21

View original

This topic has been closed for comments

2 replies

Userlevel 5
Badge +12

Hi @graeme86 

Please try something like below. Note that, your system should have a task template called “task Template”. Or change the highlighted value to a task template id that exists.

 

<perform_batch>
  <sequential_dependent>
    <perform_evaluate_expression>
      <parameters>
        <table_name>task_template</table_name>
        <keys>
          <key_item>
            <column_name>task_template_id</column_name>
            <column_value>task Template</column_value>
          </key_item>
        </keys>
        <expression>Today()+Days(90)</expression>
      </parameters>
    </perform_evaluate_expression>

    <perform_contract_pm_request_generation>
      <parameters>
        <posting_group>AMERICAS</posting_group>
        <contract_id>
        </contract_id>
        <contract_version>
        </contract_version>
        <contract_type>
        </contract_type>
        <place_id>
        </place_id>
        <model_id>
        </model_id>
        <request_template_id>REQ-TEMPLATE</request_template_id>
        <task_template_id>task Template</task_template_id>
        <schedule_end_date xpath_node="//perform_evaluate_expression_result/response"/>
        <purchase_order_id>
        </purchase_order_id>
        <consolidate_request>N</consolidate_request>
        <break_on_model_id>N</break_on_model_id>
        <break_on_contract>N</break_on_contract>
        <break_on_contract_type>N</break_on_contract_type>
        <break_on_planned_date>N</break_on_planned_date>
        <bundle_pms>N</bundle_pms>
        <variance_days>
        </variance_days>
        <consolidate_task>N</consolidate_task>
        <autocreate_task>Y</autocreate_task>
      </parameters>
    </perform_contract_pm_request_generation>
  </sequential_dependent>
</perform_batch>

 

/Sanjeewa

Userlevel 1
Badge +7

Thank you very Much for the solution @SanjeewaJ