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

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.

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

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