Login
Register

Home

Trainings

Fusion

R12

Blogs

Contact Us

R12
  • Register

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

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
 
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


Anil Passi

Overall Rating (0)

0 out of 5 stars

People in this conversation

  • Hi Anil,

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

    Thanks,
    Sri.

    Short URL:
  • Guest - Bharthi

    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

    Short URL:
  • Guest - Anil Passi

    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

    Short URL:
  • Guest - mrushad patel

    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.

    Short URL:
  • Guest - Anil Passi

    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

    Short URL:
  • 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.

    Short URL:
  • Guest - cayman

    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_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
    Enter 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)
    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

    Short URL:
  • Guest - Anil Passi

    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
    [url]http://www.google.com/search?q=site:apps2fusion.com+extend-oa-framework-in-r12-2[/url]

    [url]http://www.google.com/search?q=site:apps2fusion.com+oa-framework-r12-extension-example-2[/url]

    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

    Short URL:
  • Guest - Mani

    This presentation is really valuable.
    Thanks.
    Mani

    Short URL:
  • Guest - Sachin Ahuja

    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

    Short URL:
  • Guest - panks

    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

    Short URL:
  • Guest - Rahul Minocha

    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()

    Please help me out,
    Thanks

    Short URL:
  • Guest - kadhiresan

    Really very simple and understandable presentation.

    Excellent.
    Looking forward for more learning on OA Framework

    Short URL:
  • It's actually a cool and helpful piece of info.<br />I am happy that you just shared this helpful info with us.<br />Please stay us informed like this. Thank you for sharing.

    Short URL:

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Jul 2016  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
      1  2  3
  4  5  6  7  8

Enquire For Training

Related Items

Get Email Updates


Powered by Google FeedBurner