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