In this Article, we will see step by step, how to create a OAF notification and invoke it from workflow. 
The OAF notification has many advantages like User can personalize the notification region as per needs and moreover look and feel is same as ths standard notifications. Also these notifications can be personalized to change the text etc without any programming.
1) Create a Document type Item Atribute(Custom Req Line Fwk Region) and specify the value as displayed:
JSP:/OA_HTML/OA.jsp?OAFunc=XXC_POR_REQLINES_NTFN_RN-&reqHdrId=-&DOCUMENT_ID-&funcCurr=-&FUNCTIONAL_CURRENCY
XXC_POR_REQLINES_NTFN_RN ; This function is defined in Oracle Applications and points to the OAF page which we want to embed in the Notification region.
OAF page should be standalone Region(Stack Layout) with a Custom Application Module and Controller attached to it.
============
public void processRequest(OAPageContext pageContext, OAWebBean webBean)
{
super.processRequest(pageContext, webBean);
//We can get the parameters(reqHdrId and funcCurr) in the controller and initialize the VO to show the results as mentioned below:
String reqHdrId = pageContext.getParameter("reqHdrId");
String funcCurr = pageContext.getParameter("funcCurr");
Serializable aserializable[] = {
reqHdrId, funcCurr
};
CustomReqLineNotificationAMImpl am = (CustomReqLineNotificationAMImpl)
pageContext.getApplicationModule(webBean);
//We should never call getRootApplicationModule here as it gives the AM specified at
//the Notification Page level and not customApplicationModule
am.invokeMethod("initCustomNotificationVO",aserializable);
}
===========
2) Create a Message "Custom Requisition Approved JRAD" as shown below:
Message Body:
We can embed any message attribute in the body or subject by specifying &ITEM_ATTR_INTERNAL_NAME. In the below screenshot, we are calling XXC_REQ_LINE_FWK_RN message attribute, which will defined in the subsequent screen.
Create a Notification:
Use the notification in any of the workflow process and do not forget to set the values of message attributes before the notitification activity is invoked.
Points to remember:
-------------
*If we want to display any attribute at header level in the Notification page, we can define message attributes with internal Names(#HDR1) and set their values using Item Attributes.
*We can not call OAF notification using fnd_notification.send API as this API uses the default values of item attributes
*Do not forget to SFTP files on the Apps Tier and import the Custom Notification Region.
Comments
(15)
Subscribe to this comment's feed
Nice document
written by Kali , March 29, 2009
written by Kali , March 29, 2009
Puneet,
Very good document for the starters of OAF - Workflow.
Votes: +0
Very good document for the starters of OAF - Workflow.
report abuse
vote down
vote up
Good Work
written by GAURAV , April 06, 2009
written by GAURAV , April 06, 2009
Good Work Mr. Kakkar.
Votes: +0
report abuse
vote down
vote up
Iissues during integrating region .
written by Jk , April 07, 2009
written by Jk , April 07, 2009
Hi Puneet,
Thanks for this document.
There is one issue . In my notification page i am enable to embed OAF region , it show following error "Attribute INTEGRATED_REGION refers to Framework Region JSP:/OA_HTML/OA.jsp?page=tcsl/oracle/apps/pa/wfIntegartedRegion/webui/wfIntegartedRegionRN.
"
Plz help me out
Thanks
Votes: +4
Thanks for this document.
There is one issue . In my notification page i am enable to embed OAF region , it show following error "Attribute INTEGRATED_REGION refers to Framework Region JSP:/OA_HTML/OA.jsp?page=tcsl/oracle/apps/pa/wfIntegartedRegion/webui/wfIntegartedRegionRN.
"
Plz help me out
Thanks
report abuse
vote down
vote up
Changing &OIE_APEXP_BODY
written by Kumara , April 09, 2009
written by Kumara , April 09, 2009
Hi,
I'm trying to modify iEXPENSES , Approval Request Notification Message Body to send a reminder Notification.
I copied from existing Message OIE_REQ_EXPENSE_REPORT_APPRVL and Created a New Message. And Then called that after the Timeout. I'm getting the Reminder. But Instructions Section is not there in the Message. Any idea why?
Votes: +0
I'm trying to modify iEXPENSES , Approval Request Notification Message Body to send a reminder Notification.
I copied from existing Message OIE_REQ_EXPENSE_REPORT_APPRVL and Created a New Message. And Then called that after the Timeout. I'm getting the Reminder. But Instructions Section is not there in the Message. Any idea why?
report abuse
vote down
vote up
OAF and workflow
written by This e-mail address is being protected from spambots. You need JavaScript enabled to view it , May 05, 2009
written by This e-mail address is being protected from spambots. You need JavaScript enabled to view it , May 05, 2009
Hi,
In a workflow i have a OAF region refered as
JSP:/OA_HTML/OA.jsp?page=/oracle/apps/ap/invoice/request/negotiation/webui/NotifPGRN&INVOICEID=-&INVOICE_ID-
Now instead of this region i created a new region satisfying my requirements.
Then moved the region and importing to server.
In the Workflow i changed the new region name.
Now when i run my page the old region only displays. In the OAF page also i cant find the region to be called. But the region is available in the server.
Please anyone help me.
Thanks in Advance,
Jegan
Votes: +0
In a workflow i have a OAF region refered as
JSP:/OA_HTML/OA.jsp?page=/oracle/apps/ap/invoice/request/negotiation/webui/NotifPGRN&INVOICEID=-&INVOICE_ID-
Now instead of this region i created a new region satisfying my requirements.
Then moved the region and importing to server.
In the Workflow i changed the new region name.
Now when i run my page the old region only displays. In the OAF page also i cant find the region to be called. But the region is available in the server.
Please anyone help me.
Thanks in Advance,
Jegan
report abuse
vote down
vote up
Customizing the OAF region already used in Workflow.
written by Anoop Singh , May 14, 2009
written by Anoop Singh , May 14, 2009
Hi Puneet,
I have to customize an OAF region which is being used in workflow notification.
Can we do this.
Thanks
Anoop
Votes: +0
I have to customize an OAF region which is being used in workflow notification.
Can we do this.
Thanks
Anoop
report abuse
vote down
vote up
...
written by Kakkar , May 14, 2009
written by Kakkar , May 14, 2009
Hi Anoop,
Yes, you can customize the OAF region used by the notification by extending the controller.You can even do the personalizations if required.
Votes: +1
Yes, you can customize the OAF region used by the notification by extending the controller.You can even do the personalizations if required.
report abuse
vote down
vote up
$Flex$ not supported by Internet Expenses - Any Work Around
written by Sidharth Shah , July 21, 2009
written by Sidharth Shah , July 21, 2009
I am in the process of implementing 11.5.10 (11i) Oracle Internet Expenses module. We are facing a cute problem ‘$FLEX$’ when used in the KFF segments (COA), is not supported by any Oracle Self Service application. With the result, iExpense is not able to render the values and we are getting Null pointer exception, we applied the patch that Oracle suggested, but we still are not able to show other forms, as client has implemented View based value sets, which dynamically generates the parent child relationship.
client calls its COA as PTAEO (Project, Task, Award, Expense Type and Organization), the task associated with project are displayed, so on and so forth.
Has anyone come across this situation before and is there another way to achieve the same what $flex$ does.
STATEMENT IS: WHERE PROJECT_SEG = LTRIM(:$FLEX$.YUGL_PROJECTS.VALUE,'0')
All suggestions/solutions are welcomed.
IF you need more details, also let me know
Votes: +0
client calls its COA as PTAEO (Project, Task, Award, Expense Type and Organization), the task associated with project are displayed, so on and so forth.
Has anyone come across this situation before and is there another way to achieve the same what $flex$ does.
STATEMENT IS: WHERE PROJECT_SEG = LTRIM(:$FLEX$.YUGL_PROJECTS.VALUE,'0')
All suggestions/solutions are welcomed.
IF you need more details, also let me know
report abuse
vote down
vote up
...
written by chandrakala , September 09, 2009
written by chandrakala , September 09, 2009
Hil,
I am new to the OAF, I have a requirment like,
1. When I click on a reject button on a notification screen a check box has to appear.
2. How should I fetch the check box detail and insert it in a table?
Can u help me...
Thanks !!!
Votes: +0
I am new to the OAF, I have a requirment like,
1. When I click on a reject button on a notification screen a check box has to appear.
2. How should I fetch the check box detail and insert it in a table?
Can u help me...
Thanks !!!
report abuse
vote down
vote up
...
written by Gunabalan , February 05, 2010
written by Gunabalan , February 05, 2010
Good One Puneet..Very useful.
Votes: +1
report abuse
vote down
vote up
Error
written by PavanRanga , May 26, 2010
written by PavanRanga , May 26, 2010
I am getting below error. Please help me out ASAP
WebBean style not supported (page)
Votes: +1
WebBean style not supported (page)
report abuse
vote down
vote up
notification refresh
written by Onur , January 14, 2011
written by Onur , January 14, 2011
Hi,
We have implemented an OAF region type document in a workflow notification.
The region has retainAM=N parameter set in function properties, on top of that, we use vo.clearCache(); and vo.reset(); methods in processRequest for the vo in question.
While navigating through notifications using the same region in "workflow notifications", although the workflow notification subject changes accordingly, the region never refreshes and stays same as it has been rendered for the first time after user login.
I believe this could be due to "workflow notifications" oracle native parent screen retaining the AM, but haven't been able to solve the problem.
Any suggestions would be appreciated.
Votes: +0
We have implemented an OAF region type document in a workflow notification.
The region has retainAM=N parameter set in function properties, on top of that, we use vo.clearCache(); and vo.reset(); methods in processRequest for the vo in question.
While navigating through notifications using the same region in "workflow notifications", although the workflow notification subject changes accordingly, the region never refreshes and stays same as it has been rendered for the first time after user login.
I believe this could be due to "workflow notifications" oracle native parent screen retaining the AM, but haven't been able to solve the problem.
Any suggestions would be appreciated.
report abuse
vote down
vote up
can we attach documents while responding to a notification
written by kp , February 26, 2012
written by kp , February 26, 2012
hi
thanks for the nice article.Can we be able to attach document to a notifcation WHEN Responding.(Not while sending..this is easy)
plesae advice
Votes: +0
thanks for the nice article.Can we be able to attach document to a notifcation WHEN Responding.(Not while sending..this is easy)
plesae advice
report abuse
vote down
vote up
"Reason for Error" field in SYSADMIn for Iexpenses expense report
written by Ritwik , April 02, 2012
written by Ritwik , April 02, 2012
Hi Puneet,
I am stuck in between one of our requirement for which i need your guidance. The detailed requirement is given as below
Business Scenario :
Expense reports for credit card transactions are created in iexpenses responsiblity. During this process the accounting code combination which is generated is as per the auto-accounting setups as done. For one of the expense report this code combination has been disabled in GL as a result the expense report is hanging in SYSADMIN.
This notification in SYSADMIN has a column by the name "Reason for error" storing information about the reason for the error.
There are various transaction which are of these type in the applications for identifying which a custom report is being created. In this report we want to capture a column by the name "Reason for Error" for which we need to know the table and column where this information is being stored in backend so that the same can be mapped during preparation of custom report.
This information inspite of lot of analysis we are not able to find and need help in this regards.
Please suggest us a breakthrough.
In addition to this let me submit my analysis as done till date :
Analysing from OAF "About this page" section i have been able to extract the below query as given
select distinct ap_validation_error from ap_expense_report_lines
Output has three values as the output i.e.
FND
PA
Values have not been entered for one or more required segments.
But the value which we are seeing in the column "Reason for Error". is FNDFLEX-COMBINATION DISABLED.
I understand 'FND' but from where "FLEX-COMBINATION DISABLED" is coming.
I have also discovered that there is a AK region item defined in the application i.e.
Region Name : WF Server Side Validation Errors which has an attribute by the name : AP_WEB_REASON_FOR_ERROR i.e. long label "Reason for Error" .
Also there is a message defined with the name
"FLEX-COMBINATION DISABLED"
So far i have been able to reach till this point.
Can anyone help me in relating the AK region with the SYSADMIN notification page and the message and expense report lines table.
Kindly suggest us for a breakthrough and if possible kindly send the suggested approach to my mail as given i.e. This e-mail address is being protected from spambots. You need JavaScript enabled to view it '> This e-mail address is being protected from spambots. You need JavaScript enabled to view it
Thanks and Regards
Ritwik
Votes: +0
I am stuck in between one of our requirement for which i need your guidance. The detailed requirement is given as below
Business Scenario :
Expense reports for credit card transactions are created in iexpenses responsiblity. During this process the accounting code combination which is generated is as per the auto-accounting setups as done. For one of the expense report this code combination has been disabled in GL as a result the expense report is hanging in SYSADMIN.
This notification in SYSADMIN has a column by the name "Reason for error" storing information about the reason for the error.
There are various transaction which are of these type in the applications for identifying which a custom report is being created. In this report we want to capture a column by the name "Reason for Error" for which we need to know the table and column where this information is being stored in backend so that the same can be mapped during preparation of custom report.
This information inspite of lot of analysis we are not able to find and need help in this regards.
Please suggest us a breakthrough.
In addition to this let me submit my analysis as done till date :
Analysing from OAF "About this page" section i have been able to extract the below query as given
select distinct ap_validation_error from ap_expense_report_lines
Output has three values as the output i.e.
FND
PA
Values have not been entered for one or more required segments.
But the value which we are seeing in the column "Reason for Error". is FNDFLEX-COMBINATION DISABLED.
I understand 'FND' but from where "FLEX-COMBINATION DISABLED" is coming.
I have also discovered that there is a AK region item defined in the application i.e.
Region Name : WF Server Side Validation Errors which has an attribute by the name : AP_WEB_REASON_FOR_ERROR i.e. long label "Reason for Error" .
Also there is a message defined with the name
"FLEX-COMBINATION DISABLED"
So far i have been able to reach till this point.
Can anyone help me in relating the AK region with the SYSADMIN notification page and the message and expense report lines table.
Kindly suggest us for a breakthrough and if possible kindly send the suggested approach to my mail as given i.e. This e-mail address is being protected from spambots. You need JavaScript enabled to view it '> This e-mail address is being protected from spambots. You need JavaScript enabled to view it
Thanks and Regards
Ritwik
report abuse
vote down
vote up
Thanks,
Senthil