How To Add new columns into Standard Work Order Report in eAM



  1. Download the report (rdf & rtf) from server. 
  2.  Rename the report by prefixing xx or anything you wish. 
  3.  Add the required columns in rdf by changing the query.
  4. Add the columns in rtf and give the xml tags.
  5. Register the concurrent program as custom name, attach to request group, add to responsibility and check the report.

How to find all cancel Requisitions

SELECT prha . *   FROM po_Requisition_headers_all prha , po_action_history pah   WHERE      1 = 1        AND pah . object_id ...