My Oracle Support Banner

Notifications With Embedded Framework Regions Not Sent From Connection refused (Doc ID 309856.1)

Last updated on MAY 27, 2018

Applies to:

Oracle Workflow - Version to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
REQAPPRV notifications
Any notification type with an embedded framework region
OWF.H 3258819
Checked for relevance on 06-JUL-2013


Notifications with embedded framework regions are not mailed or sent out.  Other non-framework notifications are mailed.  So far,  this has been observed in REQAPPRV notifications,  but this is not limited to this type of notification.


-- Check if a notification has a Framework Region
select notification_id,
wf_notification.isFwkRegion(notification_id) FWK
from wf_notifications
where notification_id = '&notification_id';

-- Which Notification Messages use Embedded Framework Regions
select message_type,
count(notification_id) COUNT
from wf_notifications
where wf_notification.isFwkRegion(notification_id) = 'Y'
group by message_type, message_name
order by 3 desc;
--find the most recent framework notification
select max(notification_id) from wf_notifications
where wf_notification.isFwkRegion(notification_id) = 'Y';
--Test the framework connection to this notification and upload test.log and mailerTest.log :
$AFJVAPRG -classpath ${AF_CLASSPATH} -Dnid=<notification_id> -Ddbcfile=$FND_SECURE/$TWO_TASK.dbc -Dappuser=0 -Dappresp=20420 -Dappid=1 -Durltimeout=120 -Dhtp=http -DAFLOG_FILENAME=mailerTest.log -DAFLOG_LEVEL=STATEMENT -DAFLOG_ENABLED=true -DdebugMailSession=Y




To view full details, 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 a vibrant support community of peers and Oracle experts.