Concurrent program output delivery options in Oracle R12

Concurrent program output delivery options in Oracle R12

Oracle R12 has given the users a new set of delivery options. Users no longer need to run a concurrent program, save the output of the program on their local computer and then email, FTP, fax or print the output file. This task can be automatically handled directly from the SRS form.

Suppose if you had to print out a scheduled request everyday it would be a daily time consuming task. Oracle now allows you to get rid of this cumbersome process without the need of having a developer write code. It can be very simply done by configuring the request.

Here’s how it is done:

Submit a request



Click on Delivery Opts button



The Deliver form allows the output of the concurrent program to be sent to

Printer
Email
Fax
FTP directory
Email

Let us send the output as an email. Click on the Email tab



Click on From field



Notice that the From email id and the Subjects are populated automatically. The From email is being populated from the user settings.

Now enter the recipient email id



Press OK and submit the request. Once the request is over the email is sent out.



Notice that the PDF output is attached to the email.

FTP


Enter details


Check the FTP server directory



Print
To print the output of a concurrent program a printer has to be configured first.

Responsibility: System Administrator

Navigation: System Administration > Delivery Options


Click on Create


You can enter the IPP printer details in this form.

Important: The printer should be IPP enabled. IPP printers can be accessed via a URL. E.g. The IPP URL for the printer is

http://lndcds02.eu.*****.com:631/printers/DO_IT_LEX_T650

Host name: lndcds02.eu.*****.com

Port: 631
Printer Name: DO_IT_LEX_T650

If you enter the IPP URL in the web browser you will see the printer


Enter the IPP details in the form


Click on Apply button


The printer will appear in the Search page


The printer is completely setup now.

XDODelivery.cfg file has to be configured as well. This configuration is shown in this article. If the setup is not done, you will get errors in the OPP as shown below.

[12/3/13 2:14:43 AM] [OPPServiceThread1] Post-processing request 59483156.
[12/3/13 2:14:43 AM] [1940623:RT59483158] XML Publisher post-processing action complete.
[12/3/13 2:14:43 AM] [1940623:RT59483158] Completed post-processing actions for request 59483158.
[12/3/13 2:14:45 AM] [OPPServiceThread0] Post-processing request 59483157.
[12/3/13 6:18:15 AM] [OPPServiceThread1] Post-processing request 59483253.
[12/3/13 6:46:20 AM] [OPPServiceThread0] Post-processing request 59483263.
[12/3/13 6:46:20 AM] [1940623:RT59483263] Executing post-processing actions for request 59483263.
[12/3/13 6:46:20 AM] [1940623:RT59483263] Starting XML Publisher post-processing action.
[12/3/13 6:46:20 AM] [1940623:RT59483263]
Template code: XXEMPDET
Template app: AMW
Language: en
Territory: US
Output type: PDF
[12/3/13 6:46:21 AM] [1940623:RT59483263] XML Publisher post-processing action complete.
[12/3/13 6:46:21 AM] [1940623:RT59483263] CONC-OPP-DELIV BEGIN (REQID=59483263)
[12/3/13 6:46:21 AM] [1940623:RT59483263] Beginning print delivery
[12/3/13 6:46:21 AM] [UNEXPECTED] [1940623:RT59483263] java.lang.NumberFormatException: For input string: “631DO_IT_LEX_T650″
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:498)
at java.lang.Integer.parseInt(Integer.java:539)
at oracle.apps.xdo.delivery.http.HTTPUtil.getPort(HTTPUtil.java:212)
at oracle.apps.xdo.delivery.http.HTTPRequest.(HTTPRequest.java:134)
at oracle.apps.xdo.delivery.ipp.IPPDeliveryRequestHandler.submitRequest(IPPDeliveryRequestHandler.java:183)
at oracle.apps.xdo.delivery.AbstractDeliveryRequest.submit(AbstractDeliveryRequest.java:1270)
at oracle.apps.fnd.cp.opp.PrintDeliveryProcessor.deliver(PrintDeliveryProcessor.java:81)
at oracle.apps.fnd.cp.opp.DeliveryProcessor.process(DeliveryProcessor.java:91)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:176)
[12/3/13 6:46:21 AM] [1940623:RT59483263] Completed post-processing actions for request 59483263.

Fire the printer

Go to the SRS form and select the concurrent program.


Click on Delivery Opts button


Select Printers LOV


DONE IT Printer is selected automatically as it is the only printer setup. Click OK and submit the request. The output will be fired to the printer as well.

Important: If these attributes were to be set using PL/SQL then the API named, FND_DELIVERY, would have to be used.


Challa.