Hello,
I need to get Pdf report sent to the default Printer .when the shipment’s status change to Closed .
Thanks,
Hello,
I need to get Pdf report sent to the default Printer .when the shipment’s status change to Closed .
Thanks,
Hello
below script connect PDF to existing report archive ADDITIONAL_INV_Q_R_CODE_REP, but I think it can be used for any other reports:
DECLARE
result_key_ NUMBER := 179065;
print_ATTR_ VARCHAR2(200);
PRINT_JOB_ID_ NUMBER;
LAYOUT_NAME_ VARCHAR2(200);
BEGIN
CLIENT_SYS.CLEAR_ATTR(print_ATTR_);
CLIENT_SYS.ADD_TO_ATTR('PRINTER_ID','PDF_PRINTER',PRINT_ATTR_);--printer_id_ := Printer_Connection_API.Get_Default_Printer(Fnd_Session_API.Get_Fnd_User, 'ADDITIONAL_INV_Q_R_CODE_REP');
PRINT_JOB_API.NEW(PRINT_JOB_ID_, print_ATTR_);
LAYOUT_NAME_ := REPORT_LAYOUT_DEFINITION_API.GET_DEFAULT_LAYOUT('ADDITIONAL_INV_Q_R_CODE_REP');
CLIENT_SYS.CLEAR_ATTR(print_ATTR_);
CLIENT_SYS.ADD_TO_ATTR('PRINT_JOB_ID',PRINT_JOB_ID_,print_ATTR_);
CLIENT_SYS.ADD_TO_ATTR('RESULT_KEY',result_key_,print_ATTR_);
CLIENT_SYS.ADD_TO_ATTR('LAYOUT_NAME',LAYOUT_NAME_,print_ATTR_);
CLIENT_SYS.ADD_TO_ATTR('OPTIONS','COPIES(1)',print_ATTR_);
CLIENT_SYS.ADD_TO_ATTR('LANG_CODE','en',print_ATTR_);
CLIENT_SYS.ADD_TO_ATTR('LOCALE_LANGUAGE','en',print_ATTR_);
CLIENT_SYS.ADD_TO_ATTR('LOCALE_COUNTRY','US',print_ATTR_);
PRINT_JOB_CONTENTS_API.NEW_INSTANCE(print_ATTR_);
PRINT_JOB_API.PRINT(PRINT_JOB_ID_);
END;
Hı,
You must write custom Event , when table of Logocal unit rowstate updated.
report hasn’t any parameters:
is there any other option?
Hello,
Best regards
Bartłomiej Pobocha
But i need to send it automatically to the Printer . without opening to preview the shipment Report .
Scenario : when the shipment status changes ,the report Shipment will be send to the printer .
Thank you.
Hi
In your case we may have to save the result key value of the printed report in shipment window or some where else, using a custom or customized field. Then we can re-view that report from report archive in the moment of closing the shipment. That’s the solution I can think of.
Thanks..
Hello Kavin,
I have an existing shipment report (name :Dispatch_rep) .I want to get a pdf(Dispatch_rep) already printed to the default printer . when the shipment status is Closed.
Thank you.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.