This content has been marked as final. Show 8 replies
Yes. For example:
SELECT wf_notification.GetBody (35815463)
Attribute HR_NTF_EMBEDDED_REGION refers to Framework Region JSP:/OA_HTML/OA.jsp?OAFunc=-HR_COMP_NTF_SS-&NtfId=-35815463-.
I need the actual body message not just the call to the region. I want somehow to at least retrieve or call somewhere OAFunc=-HR_COMP_NTF_SS-&NtfId=-35815463-. to be able to retrieve what I need.
Does this make it clear? I need to be able to access the body via DATABASE. I want to get what is in HR_NTF_EMBEDDED_REGION .
As I understand now you want to get the OAF region HTML (which is displayed in notification when opened from worklist) in your third party application.
There is no straight way to do this as OAF regions are translated to HTML by oracle at runtime and also user credentials and other function security applied at that time.
wf_notification package provides getAttrDoc to get complete document in html format but it is implemented only for PLSQL document and not for OAF regions.
Conclusion is if we need to achieve this, we will have to find out how oracle translates the OAF region xml to html along with the data if any and implement the same into our application.
If you can provide me more information about your ADF application and in which context you want to display notification body in your appilcation, I can try to achieve the same at my end and let you know the results.
Also we can see if by any alternate way we can achieve your requirement.
Thank you very much for your answer. That is what I was afraid of. However, I do have the credentials for EBS (Username and Password) so maybe we can create the session and request the oracle to execute the function and then we could get the body back as an inline frame. I think that is the only way to do it.
This ADF application is basically a selfservice of HRMS. Easier interface etc. One of the module of this selfservice is Notification where the actual implementation is that the user can see whatever is in the WF_Notifications table but to take actions and to see the body the user has to click on the link and it is redirected to the actual HRMS system where the user needs to log in again (is there a way to propagate the session???) and after that see the notification in EBS.
I really appreciate your help on this.
Take a look at the following documents, which will hopefully provide some insight into the recommended approaches for ADF/eBiz integration:
- FAQ for Integration of Oracle E-Business Suite and Oracle Application Development Framework (ADF) Applications (Metalink Note 1296491.1)
- E-Business Suite Application Development Using Oracle Application Framework (OAF) and Application Development Framework (ADF) (Metalink Note 563047.1)
- Webcast Replay Available: Using Oracle ADF with Oracle E-Business Suite
Hope this is useful
Thanks for those links but like everywhere else they are more oriented to put ADF inside EBS and not the other direction. The tutorials they have is using EBS as main session provider. I'm just wondering how to get whatever I want from EBS creating in the background a session so if I render an inlineframe I don't need to log in again in EBS.