You will get an insight into the reasons for its evolution and of course how the current OAF technology will change in Fusion[ADF]
Please click here to access the powerpoint presentation
Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.
Apps2Fusion are passionate about Fusion Cloud E-Learning and classroom trainings. Training is our core business and we have been doing this for many many years. We work hard to advise trainees with right career paths. We have published various five star rated Oracle Press Books each was best sellers in its category. We have helped many and could help you as well.
Apps2Fusion Articles 
Comments
The presentation was excellant, It re-connected all the peices of info, that was puzzle to me so far,
Thanks,
S ri.
Please suggest some solution to proceed with the below senario..
We have created new webform for Intercompany transactions using OA Framework.
As per our logic we use to save all the data in intermediate tables, while confirmation it will update main GL tables.
In that one PG file, we r using standard AttachmentTable Item Style. while uploading any attachment this webform fails to complete successfully, and the web form just sits "loading" for hours, eventually the user will close the browser window and then be forced to recreate the transaction as the attachment phase is step 4 of 5 this often happens over and over again causing much annoyance to the user base.
This is not all the case.. Some times we can able to attach the file. It does not seem to matter if the attachment is large or small, or where the user is sitting.
we had look into trace .. we found that following query is taking long time.. which is oracle standard code...
SELECT * FROM (SELECT distinct ad.ATTACHED_DOC UMENT_ID,
ad.DOCUMENT_ID AS DOCUMENT_ID,
ad.LAST_UPDATE_ DATE,
ad.LAST_UPDATED _BY,
u.USER_NAME LAST_UPDATED_BY _NAME,
ad.ENTITY_NAME,
ad.PK1_VALUE,
ad.PK2_VALUE,
ad.PK3_VALUE,
ad.PK4_VALUE,
ad.PK5_VALUE,
decode (d.dm_node, null, (select short_name from fnd_dm_nodes where node_id = 0), 0, (select short_name from fnd_dm_nodes where node_id = 0), node.short_name ) LOCATION,
d.DOCUMENT_ID DOCUMENT_ID1,
d.DATATYPE_ID,
d.DATATYPE_NAME ,
d.DESCRIPTION,
decode(d.FILE_N AME, null, (select message_text from fnd_new_message s where message_name = 'FND_UNDEFINED' and application_id = 0 and language_code = userenv('LANG') ), d.FILE_NAME) FILE_NAME,
d.MEDIA_ID,
d.dm_type,
d.dm_node,
d.dm_folder_pat h,
e.DATA_OBJECT_C ODE,
e.DOCUMENT_ENTI TY_ID,
'ALLOW_ATTACH_U PDATE' ALLOW_ATTACH_UP DATE,
'ALLOW_ATTACH_D ELETE' ALLOW_ATTACH_DE LETE,
ad.category_id category_id,
cl.user_name attachment_cate gory_name,
ad.status,
ad.creation_dat e,
(select u1.user_name from fnd_user u1 where u1.user_id=ad.C REATED_BY) ATTACHED_BY_NAM E,
decode(d.dataty pe_id, 5, d.description|| '('||substr(d.F ILE_NAME, 1, least(length(d. FILE_NAME),15)) ||'...)',
decode(D.FILE_ NAME, null, (select message_text from fnd_new_message s where message_name = 'FND_UNDEFINED' and application_id = 0 and language_code = userenv('LANG') ), D.FILE_NAME)) FILE_NAME_SORT,
d.usage_type,
d.security_id,
d.security_type ,
d.publish_flag,
decode(ad.categ ory_id, null, d.category_id, ad.category_id) category_id_que ry,
ad.seq_num
FROM FND_DOCUMENTS_V L d,
FND_ATTACHED_DO CUMENTS ad,
FND_DOCUMENT_EN TITIES e,
FND_USER u,
FND_DOCUMENT_CA TEGORIES_TL cl,
FND_DM_NODES node
WHERE ad.DOCUMENT_ID = d.DOCUMENT_ID
and ad.ENTITY_NAME = e.DATA_OBJECT_C ODE( )
and ad.LAST_UPDATED _BY = u.USER_ID( )
and cl.language = userenv('LANG')
and cl.category_id = decode(ad.categ ory_id, null, d.category_id, ad.category_id)
and d.dm_node = node.node_id( )) QRSLT WHERE ((entity_name = :1 and pk1_value = :2 and category_id_que ry in (1, :3) ) and datatype_id in (6,2,1,5) AND (SECURITY_TYPE= 4 OR PUBLISH_FLAG='Y ')) ORDER BY SEQ_NUM
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Pars e 1 200.00 546.00 1 2 0 0
Execute 1 2400.00 2514.28 0 2 0 0
Fetch 1 100.00 26.50 0 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
tota l 3 2700.00 3086.78 1 7 0 0
Please suggest..
Than ks
Bharathi
This looks more like a tuning Issue, rather than OAFwk issue.
Are you running gather stats regularly enough?
Also, analysing the explain plan for the query will help.
Thans,
A nil Passi
what r your thoughts on the path that a 'traditional' apps developer should follow now to get to grips with java based screens for apps. I know apps well but no java experience, should i spend lots of effort on oa framework or try and get to grips with ADF, given that that will be the future. i understand someof the business components stuff is shared between the 2 technologies , but adf seems to be very different when it comes to the 'frontend ' design.
In fusion apps, the current core datamodel will largely remain the same.
But yes, there will be a lot more java. From what I have been hearing, Version 1 of Fusion will still use PL/SQL API's, whereas the later version of Fusion [call it V1.1 or V2] will have no place for pl/sql.
So, yes, java will be the choice. You must first learn java conceptually to begin with, as there is no point in delaying the inevitable.
Yo u are spot on about ADF. BC4J in OAF and ADF will be similar to an extent, but rest will be very different. Learn OAF only as much as is needed to get your work done, and spend rest of your energy in learning ADF & SOA. It appears OAF will have shelf life of another 4-6yrs, until customers on 11.5.10 & R12 move to fusion.
Also, get used to jDeveloper tool, as BPEL, ESB, ADF, SCA is all integrated within jdeveloper. Most likely Fusion Version 1 development kit will be plugged into jDeveloper version 11g.
Thanks,
A nil Passi
This Query is not written by us. This is oracle standard query....
which is coming from AttachmentTable ItemStyle.
tuning is not possible in this case.. What can be the alternative for this same ? Please suggest.
Thank s,
Bharathi.
Now we want to create a new project in jDeveloper. We did following
New -> Workspace configured for Oracle Application
Add a new OA Project
Specifi ed the workspace name and project name.
The workspace and project is created but jDev adds all files under JDEV_USER_HOME\ jdev\myprojects which includes all xml, jsp under fnd, icx, ap, pa subdirectories. Then offcourse we are not able to run *PG.xml (e.g. ShoppingHomePG. xml) due to some blank *VO.xml.
Is this the right way of creating project in jDev 10g? OR Should we create empty project and then add content to it? jDev 9i (EBS 11i), never added files by itself, we had to add files (server.xml) to project manually..
Any help will be great!
I am doing following
File -> New
Workspace configured for Oracle Application
Ent er workspace name
Select default directory i.e. USER_JDEV_HOME\ jdev\myprojects
Check "Add new OA project"
Enter project name and directory (same as workspace)
sele ct DB connection and DBC file.
for me all files jsp and xml are getting added under my project. It includes EVERYTHING under fnd, ap, icx, pa (Its a LOT)
Again,I am on patch 6197418
In R12, using jDev 10g, you do not need to import server.xml
I made a mention of that in articles linked as below
www.google.com/search?q=site:apps2fusion.com+extend-oa-framework-in-r12-2
www.google.com/search?q=site:apps2fusion.com+oa-framework-r12-extension-example-2
Also, you must import all the libraries into your project path, when creating the project.
If still you get Blank VO files, then raise a SR on Metalink
Tbank s
Anil Passi
Thank s.
Mani
We want to achieve personalization in OAF. What we want to do is as soon as some value is update on OAF Page we want to capture both old and new value into some table and this we want to do thru personalization .
Please suggest how I can achieve this.
Thanks & Regards
Nice presentation, Helped a lot to get clear Picture as, how we are (with oracle technology) inching closer towards Fusion.
Keep it up. Looking forward to learn lot more from you.
Thanks a lot.
regards,
Pankaj
I have to import a form from server and run it on my Jdev9i.
The form consists of many tabs i.e pages.At first in the home page it should ask for the organization name which is a kind of login id.
But when i m trying to run any of the pages , only the home page is run with the following error. Moreover it is not asking for the organization name which is a must to navigate through the application.
No method with signature - No method with signature - getRespId()
Pl ease help me out,
Thanks
Excellent.
Look ing forward for more learning on OA Framework
I am happy that you just shared this helpful info with us.
Please stay us informed like this. Thank you for sharing.
RSS feed for comments to this post