Work Order Release related issue in PM

[Former Member]

Hi Experts,

I am using the WorkOrderRelease template in BLS to release the work order in PM.After creating transaction in BLS , I created Query Template for the same.

Now In both BLS as well as in Query template its working fine.

But when i am trying to create the Display template for the same, i am not able to retrieve column names from OutputXML file automatically once query template is selected .

Please guide me.

Saumil

[Former Member]

Hi

Thanks Jamie.I couldnt able to exactly know why automatically it was not fetching column on Query selection but your solution has solved my purpose.

Regards

Saumil

[Former Member]

Hi Jamie,

ya i also know that it returns only one coulmn ' Message ' as output but thats the only field which will tell the status of releasing action like whether my Order is released or it is already been previously released or there are some other errors. So because of this i need to display that column for which i am not able to create the display template.

Please suggest.

Thanks & Regards

Saumil

[jamie_cawley]

You either need to add a valid order to the query template and not test it or the easier thing to do, would be to just type in "Message" as the "Column Name" and add it on the Data Mapping tab.

Regards,

Jamie

[Former Member]

Hi Jamie,

ya i m using the correct version of template (11.5) with SAP xMII 11.5.

I did as told by you.

After selecting the query template name while creating display template for the same , i got following error in Java Console:

ERROR - Unable To Obtain Column getKeys

Thanks & Regards

Saumil

[jamie_cawley]

When the display templates attempts to load the columns it will need to run the query to obtain them. If you tested your query already, than you inputs will no longer be valid because the order will all ready be released. The transaction only returns one column "Message". You really don't need a display template for this. You could just execute the transaction on a page and alert out the response of it. Check the script assistant for the applet method to do this.

Regards,

Jamie

[Former Member]

Hi,

ya i have mapped imput as well as output parameters(OutputXML file) both in the query template......still not able to retrieve columns in display template.

Regards,

Saumil

[jamie_cawley]

Turn on the java web start console and reopen the workbench so the console open with it. Retry and post the error.

Are you using the correct version of the template? Meaning the 12.0 version template works only in 12.0 and the 11.5 only works in 11.5.

Regards,

Jamie

[jamie_cawley]

Did you map and assign the inputs in the query template?

Regards,

Jamie