R12
  • Register

Oracle Gold Partners, training schedule is listed here designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

Fusion Apps Linkedin  |  Like us on Facebook  |  Get notified for our new articles  |  Twitter  | Linkedin Page | YouTube

 

User Rating: 0 / 5

Star inactiveStar inactiveStar inactiveStar inactiveStar inactive
 
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   

0 #1 Ashutosh Raman 2007-10-31 21:51
Hi Anil,

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

Thanks,
S ri.
Quote
0 #2 Bharthi 2007-11-01 14:16
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_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
Quote
0 #3 Anil Passi 2007-11-01 14:23
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,
A nil Passi
Quote
0 #4 mrushad patel 2007-11-01 23:41
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.
Quote
0 #5 Anil Passi 2007-11-01 23:53
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.

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
Quote
0 #6 Bharathi 2007-11-02 05:14
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.

Thank s,
Bharathi.
Quote
0 #7 cayman 2007-11-05 19:48
The client decided to go for R12 in the middle of implementation. We downloaded jDev patch p6197418_R12_Ge neric. We could make test_fwktutoria l.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
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
Quote
0 #8 Anil Passi 2007-11-05 20:34
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
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
Quote
0 #9 Mani 2007-11-27 10:52
This presentation is really valuable.
Thank s.
Mani
Quote
0 #10 Sachin Ahuja 2007-12-12 05:13
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
Quote
0 #11 panks 2008-05-06 07:29
Hi Anil,
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
Quote
0 #12 Rahul Minocha 2008-10-31 06:44
Hi Anil
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
Quote
0 #13 kadhiresan 2009-10-08 09:31
Really very simple and understandable presentation.

Excellent.
Look ing forward for more learning on OA Framework
Quote
0 #14 กระปุก 2014-04-13 04:38
It's actually a cool and helpful piece of info.
I am happy that you just shared this helpful info with us.
Please stay us informed like this. Thank you for sharing.
Quote

Add comment


Security code
Refresh

Search Trainings


Enquire For Training

Related Items

LOGIN

About Apps2Fusion

Apps2Fusion are passionate about training. Trainnig is our core business and we have been doing this for many many years. We thrive to meet expectations of our trainees. We work hard to ensure trainees get the right courses sold to them, with advise for their career paths. We have helped many consultants in past with training & mentoring and  we have helped them achieve great heights. We could help you as well. Get in touch with us.