Oracle Workflow Notification System

Good link covering notifications in depth.

Click here

XML Data : loading xml data into xml table and retrieving the same

LOAD DATA
INFILE *
INTO TABLE po_tab
APPEND
XMLTYPE (xmldata)
FIELDS
(xmldata CHAR(2000))

create table abc (a xmltype)

select * from abc

insert into abc values (xmltype('234tt'))

select extractvalue(a,'/st/b') "aaa" from abc

Workflow Notification Mailer Attributes

You can use special message attributes to control how a notification
mailer generates the e–mail message for a notification, if the recipient
has a notification preference to receive e–mail notifications. For
example, if you want to customize notifications from a particular
department, you can define these attributes for those notifications.
• #WFM_FROM – Define this attribute for a message to specify the
value that appears in the From field of the message header when
the e–mail notification message is delivered to a user. If the
#WFM_FROM message attribute is defined for a notification, the
notification mailer that sends the message will use the
#WFM_FROM attribute value in the From field for that message,
overriding the mailer’s From Address parameter value.
• #WFM_REPLYTO – Define this attribute for a message to specify
the address of the e–mail account that receives incoming
messages, to the which e–mail notification response should be
sent. If the #WFM_REPLYTO message attribute is defined for a
notification, the notification mailer that sends the message will
use the #WFM_REPLYTO attribute value as the reply address for
that message, overriding the mailer’s Reply To parameter value.
• #WFM_HTMLAGENT – Define this attribute for a message to
specify the base URL that identifies the HTML web agent that
handles HTML notification responses. This URL is required to
support e–mail notifications with HTML attachments. The
default URL is derived from the Workflow Web Agent specified
in the Global Preferences web page, but you can override this
default by defining a different value for this attribute. If the
#WFM_HTMLAGENT message attribute is defined for a
notification, the notification mailer that sends the message will
use the #WFM_HTMLAGENT attribute value as the HTML web
agent for that message, overriding the mailer’s HTML Agent
parameter value.

Oracle API's

1. API for updating organization Attributes. It updates mtl attributes that are specific to org and that do not exist in template.

Ego_Item_Pub.Process_Items();

2. API to assign Items to different organizations.

EGO_ITEM_PUB.Assign_Item_To_Org();


3. API for creation of OPM Items

Gmipapi.Create_Item();

4. API to create OPM Lot.

Gmipapi.Create_Lot();

Some Metalink notes for Diagnosing Module wise Workflow error

Running WFSTATUS and WFRETRY For Oracle Purchasing Workflows [ID 134960.1]

How to provide drop down list in a notification message

Requirement might be select a reason for rejection from the given drop down list when rejecting the notification. in such case the attribute attached to the notification message must be defined with source as respond and the Type as Lookup and attach the lookup type to the same attribute.

For further details and tested example please click here