Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

IEXXMLGEN module: IEX Xml Generated and Delivery Fails (Very Critical)

866351Jul 6 2011 — edited Sep 21 2011
Hi,

Require help on "IEXXMLGEN module: IEX Xml Generated and Delivery" program. Customer is on 12.1.3 Instance.
This program is spawned from the mail program "Workflow Background Process - IEX: Strategy Fulfillment Mailer".

Following is the error message noticed from the log file of the program...

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
IEXXmlDelivery [Jul-06-2011 03:56:44]: call delivery
IEXXmlDelivery [Jul-06-2011 03:56:44]: call delivery with pdf document
IEXXmlDelivery [Jul-06-2011 03:56:44]:Delivery bldomain length 209002
IEXXmlDelivery [Jul-06-2011 03:56:44]:Delivery io_doc_result length 209002
IEXXmlDelivery [Jul-06-2011 03:56:44]: Before initializing Java system property $XDO_TOP = /opt/apps/r12/d1ebs/apps/apps_st/appl/xdo/12.0.0
IEXXmlDelivery [Jul-06-2011 03:56:44]: Java system property $XDO_TOP = /opt/apps/r12/d1ebs/apps/apps_st/appl/xdo/12.0.0
IEXXmlDelivery [Jul-06-2011 03:56:44]: Config file /opt/apps/r12/d1ebs/apps/apps_st/appl/xdo/12.0.0/resource/xdodelivery.cfg exists
IEXXmlDelivery [Jul-06-2011 03:56:44]: Is Right Fax Server Used N
IEXXmlDelivery [Jul-06-2011 03:56:44]: IPP/CUPS is Used CUPS
IEXXmlDelivery [Jul-06-2011 03:56:44]: Sending method: PRINTER
IEXXmlDelivery [Jul-06-2011 03:56:44]: sending by printer...
IEXXmlDelivery [Jul-06-2011 03:56:44]: sPrinter=/printers/auspr-fin04
IEXXmlDelivery [Jul-06-2011 03:56:44]: sDest=/printers/auspr-fin04
IEXXmlDelivery [Jul-06-2011 03:56:44]: Created delivery manager and delivery request
IEXXmlDelivery [Jul-06-2011 03:56:44]: Using server from the config file
IEXXmlDelivery [Jul-06-2011 03:56:44]: submitting request...
IEXXmlDelivery [Jul-06-2011 03:56:44]: xml_request_id : 10760
IEXXmlDelivery [Jul-06-2011 03:56:44]: sqlexp:oracle.apps.xdo.delivery.DeliveryException: For input string: "631null"
IEXXmlDelivery [Jul-06-2011 03:56:44]: sqlexp:java.lang.NumberFormatException: For input string: "631null"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:458)
at java.lang.Integer.parseInt(Integer.java:499)
at oracle.apps.xdo.delivery.http.HTTPUtil.getPort(HTTPUtil.java:212)
at oracle.apps.xdo.delivery.http.HTTPRequest.<init>(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.iex.xml.IEXXmlDelivery.delivery(IEXXmlDelivery.java:2435)
at oracle.apps.iex.xml.IEXXmlDelivery.runProgram(IEXXmlDelivery.java:558)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

IEXXmlDelivery [Jul-06-2011 03:56:44]: updateStatus: sTempStatus=OTHER PROCESSING FAILURE
IEXXmlDelivery [Jul-06-2011 03:56:44]:Failure Reason: Failed to sumbit delivery request. Check the corresponding profile values and config file
IEXXmlDelivery [Jul-06-2011 03:56:44]: IN sendSignalToWorkFlow
IEXXmlDelivery [Jul-06-2011 03:56:44]:In sendSignalToWorkFlow method Query to fetch Object_type and status : select object_type,status from iex_xml_request_histories where xml_request_id = :1
IEXXmlDelivery [Jul-06-2011 03:56:44]: IN sendSignalToWorkFlow l_object_type : IEX_STRATEGY
IEXXmlDelivery [Jul-06-2011 03:56:44]: Before calling SEND_DELIVERY_SIGNAL procedure
IEXXmlDelivery [Jul-06-2011 03:56:44]: after calling SEND_DELIVERY_SIGNAL procedure
IEXXmlDelivery [Jul-06-2011 03:56:45]: ErrorMessage ....null
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Following are the Action plan's provided to the customer:

Asked to regenerate IEX objects "forms executable and .." by following the note Doc ID 557452.1. Customer performed the same and it did not fix the issue.

Also, following is the code used by the customer as per xdodelivery.cfg

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8" ?>

<!--$Id: //IT/main/code/apps/oracle_apps/12/xdotop/resource/xdodelivery.cfg#1 $-->

<config xmlns="http://xmlns.oracle.com/oxp/delivery/config">

<filter>/usr/bin/pdftops {infile} {outfile}</filter>
<servers>
<server name="cupprinter1" type="cups_printer" default="true">
<uri>http://us-aus-ipprt01.natinst.com:631/printers/auspr-fin04</uri>
</server>

<servers>
<server name="AUTO_ROUTE" type="ipp_printer" default="true">
<filter>/usr/bin/pdftops {infile} {outfile}</filter>
<filterOutputContentTupe>application/postscript</filterOutputContentType>
</server>
</servers>

</config>


<?xml version="1.0" encoding="UTF-8" ?>

<!--$Id: //IT/main/code/apps/oracle_apps/12/xdotop/resource/xdodelivery.cfg#1 $-->

<config xmlns="http://xmlns.oracle.com/oxp/delivery/config">

<filter>/usr/bin/pdftops {infile} {outfile}</filter>
<servers>
<server name="cupprinter1" type="cups_printer" default="true">
<uri>http://us-aus-ipprt01.natinst.com:631/printers/auspr-fin04</uri>
</server>

<servers>
<server name="AUTO_ROUTE" type="ipp_printer" default="true">
<filter>/usr/bin/pdftops {infile} {outfile}</filter>
<filterOutputContentTupe>application/postscript</filterOutputContentType>
</server>
</servers>

</config>


<?xml version="1.0" encoding="UTF-8" ?>

<!--$Id: //IT/main/code/apps/oracle_apps/12/xdotop/resource/xdodelivery.cfg#1 $-->

<config xmlns="http://xmlns.oracle.com/oxp/delivery/config">

<filter>/usr/bin/pdftops {infile} {outfile}</filter>
<servers>
<server name="cupprinter1" type="cups_printer" default="true">
<uri>http://us-aus-ipprt01.natinst.com:631/printers/auspr-fin04</uri>
</server>

<servers>
<server name="AUTO_ROUTE" type="ipp_printer" default="true">
<filter>/usr/bin/pdftops {infile} {outfile}</filter>
<filterOutputContentTupe>application/postscript</filterOutputContentType>
</server>
</servers>

</config>


<?xml version="1.0" encoding="UTF-8" ?>

<!--$Id: //IT/main/code/apps/oracle_apps/12/xdotop/resource/xdodelivery.cfg#1 $-->

<config xmlns="http://xmlns.oracle.com/oxp/delivery/config">

<filter>/usr/bin/pdftops {infile} {outfile}</filter>
<servers>
<server name="cupprinter1" type="cups_printer" default="true">
<uri>http://us-aus-ipprt01.natinst.com:631/printers/auspr-fin04</uri>
</server>

<servers>
<server name="AUTO_ROUTE" type="ipp_printer" default="true">
<filter>/usr/bin/pdftops {infile} {outfile}</filter>
<filterOutputContentTupe>application/postscript</filterOutputContentType>
</server>
</servers>

</config>
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Please help in fixing the issue. This is very critical issue.

Thanks in advance,
Vijay

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 19 2011
Added on Jul 6 2011
1 comment
2,612 views