Skip to main content

I am looking at implementing a functionality where the Purchase Order is converted to a csv format and emailed out to a supplier. I have been able to accomplish this through setting up Routing Rule , Routing address, a transformer and a custom event action on the PDF_REPORT_CREATED event which looks like this

DECLARE
  ORDER_NO_ VARCHAR2(200);
  MEDIA_CODE_ VARCHAR2(200);
  VENDOR_NO_ VARCHAR2(200);
  CONTRACT_ VARCHAR2(200);
BEGIN

  ORDER_NO_ := '&PDF_PARAMETER_6';
  MEDIA_CODE_ := 'INET_TRANS';
  VENDOR_NO_ := PURCHASE_ORDER_API.Get_Vendor_No ( ORDER_NO_ => ORDER_NO_ );
  CONTRACT_  := PURCHASE_ORDER_API.Get_Contract ( ORDER_NO_ => ORDER_NO_ );
IF  VENDOR_NO_  IN ('ABC') THEN
 PURCHASE_ORDER_TRANSFER_API.SEND_PURCHASE_ORDER( ORDER_NO_ => ORDER_NO_, MEDIA_CODE_ => MEDIA_CODE_ );
  COMMIT;
END IF;
  END;

 

This works fine and the vendor gets the .xml file which they save as a csv. However the name of the file is something like SEND_PURCHASE_ORDER_4a6a4055-c125-42f1-87dc-c269890c017a.xml. the vendor wants to receive the file so that the name contains the PO number.

 

I understand the Report rules can be used to accomplish something similar and I have downloaded the documentation from another IFS Community Post. However I do not understand how do I make the transformer come into play here (see attached screenshot of Action Properties)

Does anyone have any experience in this area? Thanks