Error In Report Generation And Delivery (Report Generation And Delivery) Concurrent Program - OLFM

(Doc ID 2339854.1)

Last updated on DECEMBER 15, 2017

Applies to:

Oracle Lease and Finance Management - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Setups

The Report Generation and Delivery completes with this error in the log:

--------------------------------------------
oracle.apps.xdo.delivery.MissingRequiredPropertyException: Required property missing. Property name :[HOST]
at oracle.apps.xdo.delivery.AbstractDeliveryRequest.validateProperties(Unknown Source)
at oracle.apps.xdo.delivery.AbstractDeliveryRequest.submit(Unknown Source)
at oracle.apps.okl.xmlpublisher.OKLSendDocForReports.deliverReport(OKLSendDocForReports.java:605)
at oracle.apps.okl.xmlpublisher.OKLSendDocForReports.deliverXMLPublisherReport(OKLSendDocForReports.java:236)
at oracle.apps.okl.xmlpublisher.cp.JCP4OKLReportDelivery.runProgram(Unknown Source)
at oracle.apps.fnd.cp.request.Run.main(Run.java:156)

[Sep-07-2017 13:19:39]: exception :
java.lang.Exception: oracle.apps.xdo.delivery.MissingRequiredPropertyException: Required property missing. Property name :[HOST]
java.lang.Exception: oracle.apps.xdo.delivery.MissingRequiredPropertyException: Required property missing. Property name :[HOST]
at oracle.apps.okl.xmlpublisher.OKLSendDocForReports.deliverXMLPublisherReport(OKLSendDocForReports.java:258)
at oracle.apps.okl.xmlpublisher.cp.JCP4OKLReportDelivery.runProgram(Unknown Source)
at oracle.apps.fnd.cp.request.Run.main(Run.java:156)
Caused by: oracle.apps.xdo.delivery.MissingRequiredPropertyException: Required property missing. Property name :[HOST]
at oracle.apps.xdo.delivery.AbstractDeliveryRequest.validateProperties(Unknown Source)
at oracle.apps.xdo.delivery.AbstractDeliveryRequest.submit(Unknown Source)
at oracle.apps.okl.xmlpublisher.OKLSendDocForReports.deliverReport(OKLSendDocForReports.java:605)
at oracle.apps.okl.xmlpublisher.OKLSendDocForReports.deliverXMLPublisherReport(OKLSendDocForReports.java:236)
... 2 more
--------------------------------------------


Once the above errors are resolved these errors are found in the log:

-----------------------
java.lang.NullPointerException
at oracle.jbo.server.DBTransactionImpl.getSession(DBTransactionImpl.java:5492)
at oracle.jbo.server.DBTransactionImpl.refreshConnectionMetadata(DBTransactionImpl.java:4583)
at oracle.jbo.server.DBTransactionImpl.(DBTransactionImpl.java:522)
at oracle.apps.okl.xmlpublisher.OKLSendDocForReports.purgeParameterTable(OKLSendDocForReports.java:676)
at oracle.apps.okl.xmlpublisher.OKLSendDocForReports.deliverXMLPublisherReport(OKLSendDocForReports.java:246)
at oracle.apps.okl.xmlpublisher.cp.JCP4OKLReportDelivery.runProgram(Unknown Source)
at oracle.apps.fnd.cp.request.Run.main(Run.java:156)

exception :
java.lang.Exception: java.lang.NullPointerException
java.lang.Exception: java.lang.NullPointerException
at oracle.apps.okl.xmlpublisher.OKLSendDocForReports.deliverXMLPublisherReport(OKLSendDocForReports.java:258)
at oracle.apps.okl.xmlpublisher.cp.JCP4OKLReportDelivery.runProgram(Unknown Source)
at oracle.apps.fnd.cp.request.Run.main(Run.java:156)
Caused by: java.lang.NullPointerException
at oracle.jbo.server.DBTransactionImpl.getSession(DBTransactionImpl.java:5492)
at oracle.jbo.server.DBTransactionImpl.refreshConnectionMetadata(DBTransactionImpl.java:4583)
at oracle.jbo.server.DBTransactionImpl.(DBTransactionImpl.java:522)
at oracle.apps.okl.xmlpublisher.OKLSendDocForReports.purgeParameterTable(OKLSendDocForReports.java:676)
at oracle.apps.okl.xmlpublisher.OKLSendDocForReports.deliverXMLPublisherReport(OKLSendDocForReports.java:246)
... 2 more

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Complete an action that would trigger Report Generation and Delivery to run.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
The first set of errors will prevent the report from being emailed.  The second set has no functional impact, but can be confusing to a user as the request does complete in error.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms