<-----Google Analytics Code Start----> <-----Google Analytics Code Close---->
Skip to content

Green

color

Default screen resolution  Wide screen resolution  Increase font size  Decrease font size  Default font size  Skip to content Default color Pink color Green color Green color

Who's Online

We have 14 guests online

Related Items

Home arrow Home arrow Brief History of OA Framework and Future
This website has now moved to http://apps2fusion.com





Brief History of OA Framework and Future | Print |  E-mail
Written by Anil Passi   
Tuesday, 30 October 2007
In this powerpoint presentation, you will see how Oracle's Self Service in eBusiness Suite has evolved over a period of time.
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

Comments (10)add
Excellant One!!
written by Srihari Balla , October 31, 2007
Hi Anil,

The presentation was excellant, It re-connected all the peices of info, that was puzzle to me so far,

Thanks,
Sri.

Attachment Issue on OAF - Please clarify
written by Bharthi , November 01, 2007
Hi Anil,

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_DOCUMENT_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_NAME, null, (select message_text from fnd_new_messages 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_path,
e.DATA_OBJECT_CODE,
e.DOCUMENT_ENTITY_ID,
'ALLOW_ATTACH_UPDATE' ALLOW_ATTACH_UPDATE,
'ALLOW_ATTACH_DELETE' ALLOW_ATTACH_DELETE,
ad.category_id category_id,
cl.user_name attachment_category_name,
ad.status,
ad.creation_date,
(select u1.user_name from fnd_user u1 where u1.user_id=ad.CREATED_BY) ATTACHED_BY_NAME,
decode(d.datatype_id, 5, d.description||'('||substr(d.FILE_NAME, 1, least(length(d.FILE_NAME),15))||'...)',
decode(D.FILE_NAME, null, (select message_text from fnd_new_messages 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.category_id, null, d.category_id, ad.category_id) category_id_query,
ad.seq_num
FROM FND_DOCUMENTS_VL d,
FND_ATTACHED_DOCUMENTS ad,
FND_DOCUMENT_ENTITIES e,
FND_USER u,
FND_DOCUMENT_CATEGORIES_TL cl,
FND_DM_NODES node
WHERE ad.DOCUMENT_ID = d.DOCUMENT_ID
and ad.ENTITY_NAME = e.DATA_OBJECT_CODE( )
and ad.LAST_UPDATED_BY = u.USER_ID( )
and cl.language = userenv('LANG')
and cl.category_id = decode(ad.category_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_query 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
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 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
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 2700.00 3086.78 1 7 0 0


Please suggest..

Thanks
Bharathi

...
written by Anil Passi , November 01, 2007
Hi 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,
Anil Passi
oa framework or adf?
written by mrushad patel , November 01, 2007
anil , this is a great site, very useful and interesting articles always!

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.

...
written by Anil Passi , November 01, 2007
Hi Mrushad,

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.

You 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,
Anil Passi
RE: Attachment Issue on OAF - Please clarify
written by Bharathi , November 02, 2007
Hi Anil,

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.

Thanks,
Bharathi.
setup r12 oa project
written by cayman , November 05, 2007
The client decided to go for R12 in the middle of implementation. We downloaded jDev patch p6197418_R12_Generic. We could make test_fwktutorial.jsp work. Next we copied icx,ap,pa *.xml and *.class from Unix to desktop. Also exported required *PG.xml from mds.

Now we want to create a new project in jDeveloper. We did following

New -> Workspace configured for Oracle Application
Add a new OA Project
Specified the workspace name and project name.

The workspace and project is created but jDev adds all files under JDEV_USER_HOMEjdevmyprojects 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
Enter workspace name
Select default directory i.e. USER_JDEV_HOMEjdevmyprojects
Check "Add new OA project"
Enter project name and directory (same as workspace)
select 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
...
written by Anil Passi , November 05, 2007
Hi Cayman

In R12, using jDev 10g, you do not need to import server.xml

I made a mention of that in articles linked as below
http://oracle.anilpassi.com/ex...r12-2.html

http://oracle.anilpassi.com/oa...ple-2.html

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

Tbanks
Anil Passi
Great work
written by Mani , November 27, 2007
This presentation is really valuable.
Thanks.
Mani
Validation in OAF
written by Sachin Ahuja , December 12, 2007
Hi Anil,

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
You must be logged in to a comment. Please register if you do not have an account yet.

busy