• RELEVANCY SCORE 4.21

    DB:4.21:Re: R12 : Extending The Seeded Oaf Page. pk





    Hi

    VO substitution is enough ,no need to extend the AM.U can add your additional conditionns via controller extension.

    Thanx

    Pratap

    DB:4.21:Re: R12 : Extending The Seeded Oaf Page. pk

    Hi,

    You hae to copy your class files to JAVA_TOP and import the page files in mds repository.
    Then you have to create one function for the main page and attach it to the appropriate menu.

    For import command pls refer to developer guide.

    Thanks
    Anoop

  • RELEVANCY SCORE 4.19

    DB:4.19:Re: Deployment Of Oa Extension 8m





    When you extend a seeded vo and create your own VO you need to create substitution so OA can use your VO instead of the seeded one. Read the section on Extending OAF Applications in Dev guide for more details. If you have not created any substitutions you donot need to run jpximport.

    DB:4.19:Re: Deployment Of Oa Extension 8m

    Hi Ram

    I am trying import a seeded page (after few minor changes) using

    java oracle.jrad.tools.xml.importer.XMLImporter /appltop/115/eam/11.5.0/mds/workorder/webui/EAM_EASY_WORKORDER_PAGE.xml -username apps -password apps -rootdir /appltop/115/eam/11.5.0/mds/workorder/webui -rootPackage /oracle/apps/eam/workorder/webui -dbconnection "(description = (address_list = (address = (community = tcp.world)(protocol = tcp) (host =la0641.oracleads.com)(port = 1521))) (connect_data = (sid = LA0641)))"

    This is getting imported successfully,

    But when I try to access the relevant OA page, its asking for other relevant pages = could not find the reference of component oracle/apps/eam/wrkplan/webui/WOFailureEntryRN
    and subsequently other xml files and class files also.

    Where am I going wrong? Ny ideas / suggestions? I want to only replace the existing seeded file EAM_EASY_WORKORDER_PAGE.xml

    Thanks and Regards,
    Shuba
    --
    Subashini Bala

  • RELEVANCY SCORE 4.14

    DB:4.14:Re: Vo Extension- Extended Vo Name Is Reflected But Custom Query Not Reflected az





    Yes, I want my custom query to be there in the extended VO. Thank you.

    DB:4.14:Re: Vo Extension- Extended Vo Name Is Reflected But Custom Query Not Reflected az

    Hi There , Can you send me the screen shot from where you 're verifying VO query in application ? --Keerthi

  • RELEVANCY SCORE 3.75

    DB:3.75:Re: Doubt In Delete Exercise Of Oaf Tutorial p8


    But is it ecessary to add that end date in the EmployeeSummaryVO1 and VO ????Yes, As you are doing Delete Exercise. The VO Query should include EndDate column in VO as without it the Switcher functionality won't work.

    decode(nvl(to_char(EmployeeEO.END_DATE), 'N'),
    'N', 'DeleteDisabled', 'DeleteEnabled') AS DELETE_SWITCHER Thanks
    --Anil
    http://oracleanil.blogspot.com/

    DB:3.75:Re: Doubt In Delete Exercise Of Oaf Tutorial p8

    Ganesh

    you need to check your Page that you are not referring EndDate attribute any where.Else what you can do is in your VO query add one more attribute from EO as EndDate

    Thanks
    AJ

  • RELEVANCY SCORE 3.70

    DB:3.70:Re: Security Issue Of Using Oaf 8a


    any one out there???

    DB:3.70:Re: Security Issue Of Using Oaf 8a

    Hi,

    I do not see any secutiry issue in your code, just a suggestion that instead of putting page url in the forward call you can use AOL function and define your url in that function.

    pageContext.forwardImmediately("XX_PAYSLIP_FUNC_NAME", -- this is the AOL function name that holds your url
    OAWebBeanConstants.KEEP_MENU_CONTEXT,
    null, null, true,
    OAWebBeanConstants.ADD_BREAD_CRUMB_NO);

  • RELEVANCY SCORE 3.62

    DB:3.62:Re: Clob Column In Oaf zk


    Hi,

    I have a column varchar2(4000) in table which is used as EO object in OAF page. Which is used to display the email content from main person. This same can be resend many times.
    So, Now the requirement has changed to show the email content chain (resend email content).

    I am able to get the data but the data is not able to sit in the column with data type varchar2(4000). So, i approached in a way that the datatype in the table has been changed to 'CLOB' and the same changes are made in EO and respective VO.

    But still i am not able to show the data in the message text input box field.
    Oracle Jbo. AttrValueException JBO:27019. Get method for attribute 'EmailContent' in VO could not be resolved.

    Can any one please help me on this to resolve the issue. Thanks for early reply......

    DB:3.62:Re: Clob Column In Oaf zk

    Hi,

    I have a column varchar2(4000) in table which is used as EO object in OAF page. Which is used to display the email content from main person. This same can be resend many times.
    So, Now the requirement has changed to show the email content chain (resend email content).

    I am able to get the data but the data is not able to sit in the column with data type varchar2(4000). So, i approached in a way that the datatype in the table has been changed to 'CLOB' and the same changes are made in EO and respective VO.

    But still i am not able to show the data in the message text input box field.
    Oracle Jbo. AttrValueException JBO:27019. Get method for attribute 'EmailContent' in VO could not be resolved.

    Can any one please help me on this to resolve the issue. Thanks for early reply......

  • RELEVANCY SCORE 3.62

    DB:3.62:How To Make A Search Page xd


    Hiiii

    How to make a search page and create employee page in OAF using EO,VO,AM

    thanks

    DB:3.62:How To Make A Search Page xd

    HI,
    As i told before if u have any paticular doubt in create page then pls raise it,it will be very difficult for others to expalin things from scratch.
    Thanks

  • RELEVANCY SCORE 3.58

    DB:3.58:Error Msg : Fnd, Message Name: Fnd_Viewobject_Not_Found j8


    Hi ,

    I have a oaf requirement to add 3 input fileds to a page.

    My stanard VO is based on 4 EO's, So i directly Extended VO(included 3 new fields based on one EO)

    iam getting an error message on the page as

    -------------------------------------------------------------------------------------------------------------------------------------------------------------

    Message not found. Application: FND, Message Name: FND_VIEWOBJECT_NOT_FOUND. Tokens: VONAME = lxeSolutionsVO; APPLICATION_MODULE = oracle.apps.cs.knowledge.solution.author.server.CreateSolutionAM;
    --------------------------------------------------------------------------------------------------------------------------------------------------------------

    the Standard AM is unable to find extended VO

    i have done all steps like extension,substitution,moving xml/.class fiels to server,jpx importer,personaizations,bouncing server

    Can anyone guide me ,how to resolve this issue.

    Thanks

  • RELEVANCY SCORE 3.58

    DB:3.58:Re: Problem During Extention Of Vo 13


    I think ,I missing any things as i have not deploy any thing to server.First I want to check Extension from local mechine.

    Any update on this?

    Thanks

    DB:3.58:Re: Problem During Extention Of Vo 13

    Avaneesh,

    After extending the VO you wold have created new items using personalizations, during creation of these items you have to give viewAttributeName and viewInstanceName. When try to edit these items using personalizations to see the properties these two properties will not be visible. You should find them out from the personalization document only.

    Again the error now clearly indicates that you had given the newVO name MMPaymentSearchResultsVO as the view instance, you should not be doing that. You should give the new viewAttributeName you had added in MMPaymentSearchResultsVO and the viewInstance as the seeded VO CustomerSearchResultsVO.

  • RELEVANCY SCORE 3.50

    DB:3.50:What Are The Steps For Extending A Oaf Page (11iapplication Salary Screen) k3


    I couldn't proceed further beyond step 3 after following the instruction in OAF Developer's Guide, Chapter 9, Common BC4J Extension, page 890.

    In Step 3, it says...

    Create a new view object that extends the parent VO (you create the extended VO just as you would any other view object with the following difference: specify the name of the parent VO in the Extends View Object field in the first page of the wizard). Be sure to follow the naming standard described above.
    Note that the parent VO package must be included in your project before you can extend the parent VO.

    The issue I have now is, during the creation of a new VO, I need to extend the parent VO. However, I do not see any parentVO in the Parent window for me to select.

    I want to know what are the initial steps or normal steps you usually do when extending a OAF page, so I know where I missed.

    Thanks.

    **Purpose:
    To make the ViewAttribute:ProposalReason as a required field when entering a new salary record

    **Some information about the Salary screen:

    Page:
    /oracle/apps/per/saladmin/webui/NewSalaryPG

    Page Denefination:
    header: New Salary CO: NewProposalCO
    messageComponentLayout: (NewProposalRN)
    messageRadioGroup: "Reason for Change"
    VO:PerPayProposalsVO1 ViewAttribute:ProposalReason

    AM:oracle.apps.per.saladmin.server.SaladminAM

    VO:oracle.apps.per.saladmin.server.PerPayProposalsVO

    EO:oracle.apps.per.schema.server.PerPayProposalsEO

    CO:oracle.apps.per.saladmin.webui.NewProposalCO

    AM: Version:
    SaladminAMImpl.java 115.80

    VO Version:
    PerPayProposalsVOImpl.java 115.16
    PerPayProposalsVORowImpl.java 115.8

    EO Version:
    PerPayProposalsEOImpl.java

    Message was edited by:
    user562389

    DB:3.50:What Are The Steps For Extending A Oaf Page (11iapplication Salary Screen) k3

    I couldn't proceed further beyond step 3 after following the instruction in OAF Developer's Guide, Chapter 9, Common BC4J Extension, page 890.

    In Step 3, it says...

    Create a new view object that extends the parent VO (you create the extended VO just as you would any other view object with the following difference: specify the name of the parent VO in the Extends View Object field in the first page of the wizard). Be sure to follow the naming standard described above.
    Note that the parent VO package must be included in your project before you can extend the parent VO.

    The issue I have now is, during the creation of a new VO, I need to extend the parent VO. However, I do not see any parentVO in the Parent window for me to select.

    I want to know what are the initial steps or normal steps you usually do when extending a OAF page, so I know where I missed.

    Thanks.

    **Purpose:
    To make the ViewAttribute:ProposalReason as a required field when entering a new salary record

    **Some information about the Salary screen:

    Page:
    /oracle/apps/per/saladmin/webui/NewSalaryPG

    Page Denefination:
    header: New Salary CO: NewProposalCO
    messageComponentLayout: (NewProposalRN)
    messageRadioGroup: "Reason for Change"
    VO:PerPayProposalsVO1 ViewAttribute:ProposalReason

    AM:oracle.apps.per.saladmin.server.SaladminAM

    VO:oracle.apps.per.saladmin.server.PerPayProposalsVO

    EO:oracle.apps.per.schema.server.PerPayProposalsEO

    CO:oracle.apps.per.saladmin.webui.NewProposalCO

    AM: Version:
    SaladminAMImpl.java 115.80

    VO Version:
    PerPayProposalsVOImpl.java 115.16
    PerPayProposalsVORowImpl.java 115.8

    EO Version:
    PerPayProposalsEOImpl.java

    Message was edited by:
    user562389

  • RELEVANCY SCORE 3.45

    DB:3.45:Eam Vo And Eo Extension 77


    HI All,I have a task to extend the VO and EO, Work Order in Oracel EAM Standard Page. I already downloaded all the files needed and their respective entity files needed to perform my task. The files are downloaded to my OAF/Jdev/MyProjects/Oracle/Apps. and the work order was added to my project via the project properties. But while i tried to compile the script, i got a bunch of errors. Pls can someone provide me a solution to perform "Work Order" VO and EO extension.

    DB:3.45:Eam Vo And Eo Extension 77

    error description pleaseRegardsShobhit S

  • RELEVANCY SCORE 3.40

    DB:3.40:Vo Extension On 11.5.10 To R12 Upgrade 89


    Hi allI am working on a 11.5.10.2 to 12.1.3 upgrade.There is already several VO extended in 11i instance. Because of the upgrade, all related VO and ViewLink are re-built using the newer version.My question is Do I need to use remove the substitution (e.g., jdr_utils.deletedocument) and re-import the jpx file?Thanks in advance!

    DB:3.40:Vo Extension On 11.5.10 To R12 Upgrade 89

    Hi,Not required to remove the substitution. As substitution will just have the pointer which will point to the specific file at run time.U have to just change the vo related files if there any chnage from 11i to r12.ThanksBharat

  • RELEVANCY SCORE 3.39

    DB:3.39:Test Substitution Locally xp


    Hi,

    I am very new in OAF. We have number of OAF extension requirements. To start with how OAF extension works I went through Tutorial and browsed Dev Guide. Now, I want to test one simple LOV extension by modifying the supplier LOV on NonCatalogRequestPG page, the LOV region is ReqSupplierLovRN. This is what I did

    Copied required files to local drive
    Create new workspace and new project
    Add NonCatalogRequestPG and ReqSupplierLovRN to the project.
    Add ...lov.server.server.xml
    Create new bc4j package
    Create new VO which extends ReqSupplierVO. Modify the query in the extended VO.
    Substitude standard VO with new.
    Rebuild the project.
    Run NonCatalogRequestPG.xml from jDeveloper.

    I do not see the changes to the LOV. Can't we test customization locally? Is there something I am missing like adding all server.xml to the project?

    Any help would be greatly appreciated.

    NP

  • RELEVANCY SCORE 3.37

    DB:3.37:Exception Due To Recursive Substituion pa


    Hi all,

    I'm a new bie in OAF, I've Extended a VO in IRecuritment Today(Substituted the Extended VO for Seeded VO) and later got instructions that it the extension is not needed.
    To undo the changes i've substituted the Seeded VO for Extended VO. after Apache Bounce i'm facing the following error.

    oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidOperException: JBO-26036: Recursive substituion for xx.oracle.apps.irc.candidateSelfService.server.XXJobResultsVO.

    can someone please guide me how to get the functionality back......

    Edited by: Sravanth on Nov 23, 2009 7:20 PM

    DB:3.37:Exception Due To Recursive Substituion pa

    hi all,

    The Issue has been solved..

    I've Extended the XXJobResultsVO(extended VO) again to the Other VO (XXJobResultsVOEx)and i've Substituted the (XXJobResultsVOEx to XXJobResultsVO ) and it is working fine now.....

    but i got another problem now.... when i'm entering the data in that Page and clicking on next button to navigate to other Page...I'm encountering this error

    oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidObjNameException: JBO-25005: Object name 7 for type Variable is invalid

    can someone please helpme out of this Issue

    Edited by: Sravanth on Nov 23, 2009 7:36 PM

  • RELEVANCY SCORE 3.36

    DB:3.36:Re: How To Execute An Sql Query Inside Jdeveloper/Oaf? z7


    Thanks!

    DB:3.36:Re: How To Execute An Sql Query Inside Jdeveloper/Oaf? z7

    Hi! I got what is the problem. I again forgot the open and close parenthesis!Sorry for wasting your time with this...Thanks.

  • RELEVANCY SCORE 3.36

    DB:3.36:Re: Vo Extension Not Working In R12 9d


    You may refer below link for preparedStatment

    http://oracleanil.blogspot.com/2010/11/am-extension-in-oaf.html

    Navigate to section above Step 4 coding part.

    Thanks
    AJ

    DB:3.36:Re: Vo Extension Not Working In R12 9d

    My problem got resolved finally with help of AJ..

    thnx AJ...

  • RELEVANCY SCORE 3.36

    DB:3.36:Right Alignment Of Number Field In Oaf Page 9s


    Hi,

    I need to right align the column of the table which is of number type in OAF page. I have extended the VO of that page to add new columns. After VO extension i added the column to the page via personalization and gave the reference of view attribute name as per Extened VO. I have set the following properties for that column
    Item Sytle- Message Style Text
    Data Type- Number
    Nowrap=false
    Vertical Alignment=Middle
    View Attribute = Prior (same as Extended VO's column)
    View Instance = XXPayEmpAccrualActionInfoVO

    I need to set the value of this newly added column right align which is currently set as left align by default.

    I have tried the following links from OTN
    Re: Q: How to format number using personalization?
    Right align number field

    but while controller extension i m getting the following error-

    Message not found. Application: FND, Message Name: FND_VIEWOBJECT_NOT_FOUND. Tokens: VONAME = XXPayEmpAccrualActionInfoVO; APPLICATION_MODULE = oracle.apps.pay.selfservice.payslip.US.server.PayPayslipAM;

    The extended controller code is -
    public void processRequest(OAPageContext pageContext, OAWebBean webBean)
    {
    super.processRequest(pageContext, webBean);
    OATableBean tableBean = (OATableBean)webBean.findIndexedChildRecursive("PayPayslip4Ss");
    tableBean.queryData(pageContext, true);
    tableBean.prepareForRendering(pageContext);
    DataObjectList aColFormat01 = tableBean.getColumnFormats() ;
    oracle.cabo.ui.data.DictionaryData ColFormat01 =(oracle.cabo.ui.data.DictionaryData)aColFormat01.getItem(pageContext.findChildIndex(tableBean, "Prior"));
    ColFormat01.put(COLUMN_DATA_FORMAT_KEY,NUMBER_FORMAT);

    }

    Please can anyone provide me some pointer here..this is really urgent.

    Thanks in advance

    Renu

    Edited by: Renu Gupta on Jun 14, 2010 5:15 AM

    DB:3.36:Right Alignment Of Number Field In Oaf Page 9s

    Thanks sumit for your prompt reply..

    i made some changes in the code u have provide. changed code is -

    OAMessageStyledTextBean priorBean = (OAMessageStyledTextBean)webBean.findIndexedChildRecursive("xxAccPriorID");
    if(priorBean!=null)
    {
    priorBean.setAttributeValue(OAWebBeanConstants.CURRENCY_CODE,"USD" );
    }

    It worked fine.

    Thanks for ur all support
    Renu

  • RELEVANCY SCORE 3.30

    DB:3.30:Vo Extension Deployment? jc


    Can any one tell me about the VO extension deployment?--Thanks,SA

    DB:3.30:Vo Extension Deployment? jc

    Hi Dilip and BM,Thanks for your quick response.--Thanks,SA

  • RELEVANCY SCORE 3.30

    DB:3.30:Getting Problem While Extending Projectslovvo 33


    Hi OAF Guys,

    i want exchange ProjectsLovVO to restrict projects. But for this there is no VORowImpl.class file. When i followd the general process to extend the VO, when i compiling the java class, it is giving error. Why because in the extended java class it is calling super.getProjectId() and so on. But there is no VORowImpl.class parent file is not there.

    Is it possible to have only xml file for the LOV VO? In this situations how can i do extension?

    any one has know the solution, then reply asap

    Thanks Regards
    Pal.

  • RELEVANCY SCORE 3.30

    DB:3.30:Dynamic Vo fm


    Hi Experts,

    I am learning OAF, working on R12 EBS. I want to learn the 'Dynamic VO' concept. Could some body help me how to implement that with simple example.

    Doubts:

    Do we need create any dummy VO, page layout region and controller in Jdeveloper for Dynamic VO.

    Kindly help me with simple example, how to create Dynamic VO.

    Thanks in advance.

    DB:3.30:Dynamic Vo fm

    Hi,

    Always try to create a new thread for ur requirement. Instead of opening the existing thread.

    You don't need to create a dynamic view object for ur requirement.

    Regards,
    Gyan

  • RELEVANCY SCORE 3.30

    DB:3.30:Lov Auto Refresh Issue - Oaf Page 1k


    Hi,

    Currently we are facing one issue with one OAF page.
    We have one LOV in the page. Currently it is fetching the details as per the VO SELECT query associated with it and no issues in the query part.
    But, if you try to update the tables which are associated to the above VO query, the updated results are not showing in the LOV even after re-login also.
    One interesing thing is, we are able to get the updated results in the LOV once the server is bounced. Can any one pls let me know how to get this resolved and we are expecting this updated results needs to picked by LOV without bouncing the server.

    Best Regards,
    Hari

    DB:3.30:Lov Auto Refresh Issue - Oaf Page 1k

    Hi Ankul,

    We have already tried the approach which you have suggested. But still that did not worked.

    Best Regards,
    Hari

  • RELEVANCY SCORE 3.29

    DB:3.29:Re: How Can I Get The "Jdeveloper10g Oa Extension" 9p


    Thanks for replying. The R12 has been released in 25-jan-07.I have checked the relative document about OAF in R12.So I wanna found the new OAF developer tool for R12.

  • RELEVANCY SCORE 3.29

    DB:3.29:Re: Question About Extension/Substitution pp


    You can extend the VO and then through personalization add columns to page.

    To extend the VO, you need to get all VO related files from server, extend the VO by substituting the parent (base) VO and then deploy the custom VO on server and import the project.jpx

    Please go through extension and personalization given in OADevGuide.

    Thanks,
    Mitiksha

    DB:3.29:Re: Question About Extension/Substitution pp

    You need to do both i.e extension and substitution. First extend VO and add extra columns to it and then substitute the VO.

    Please gothrough Dev guide for details.

  • RELEVANCY SCORE 3.27

    DB:3.27:Re: How To Change Length Attribute Of An Standard Item? zm


    in the VO , attribute lngth it's taken from Database column, and it's ok (VARCHAR2(30) ). I suppose it corresponds with maximun length attribute, and not with length attribute. The problem is while displaying it.. I suppose it's in relation with the XML file... So I can't see how through VO extension I could modify the displaying length

    DB:3.27:Re: How To Change Length Attribute Of An Standard Item? zm

    Hi Kumar,
    that solution would be given completely developed by Oracle Support...
    I can't dedicate more time with this. it's clear that there's a bad behaviour. It's out of sense that Support answers saying that Partners have to fix it extending and Personalizing... They have, at least, to recognize it, and give the implemented solution instead of saying that it's the standard functionality... For sure we will change our support contract conditions for next year

    Regards,
    Jose

  • RELEVANCY SCORE 3.27

    DB:3.27:Vo Extension In Oaf (Expert Mode Disabled) 39


    Hi,I want to extend a VO but while extending the VO , the expert mode is coming in disabled mode and I am unable to edit the query part.Please suggest how to proceed.My VO has one View link also.

    DB:3.27:Vo Extension In Oaf (Expert Mode Disabled) 39

    I kept the java files in my project but now after extending the VO when i am rebuilding there are errors coming for the java file,do i need to remove the java files now?

  • RELEVANCY SCORE 3.27

    DB:3.27:Vo Extension In Oaf 77


    Hi All,I have requirement to Extend a Vo I-Recruitement i have got all the files to local system and saw them in J-Developerthe Vo which i want to extend is eo based vo and expert mode is not check Now is it possible to Extend that if so howThanks,Manoj Kumar Areti

    DB:3.27:Vo Extension In Oaf 77

    This seems to be related to EBS and since this forum is dedicated to Fusion you might want to post the question to Technology - OA Framework.Also this blog post may be useful.--Jani RautiainenFusion Applications Developer Relations https://blogs.oracle.com/fadevrel/

  • RELEVANCY SCORE 3.27

    DB:3.27:Oaf Customization mk


    Hi,

    I have added new fields in RN.xml and moved the file to the server and imported it. But my change is not seen in the page(About the page). The columns are already there in the VO and it is not a VO extension. What steps in addition to adding fields to PG.xml or RN.xml to be done?

    Thanks

    DB:3.27:Oaf Customization mk

    Apache bounce did not help.

    Can we customize a region like adding fields in the xml file itself and not through personalization in OAF?.

    Thanks

  • RELEVANCY SCORE 3.24

    DB:3.24:Vo Extension Issues sp


    My problem is data is not displaying in the extended column.Steps i followed:VO downloaded from server.created new extended VO.added the transient attribute.changed the SQL Query in expert mode and oracle positional.Transient column property "Updatable" to "Yes"All Attribute Mappings are correct.Substitution done.Files moved to server.JPX import done successfully.Apache bounce done.Through personalization added the column.and i returned to the page and queried the data.The value is not cmg in that field.When i queried that SQL stmt values are cmg in backend.Y values are not displaying in OAF Page when i Queried.Could anyone help me plz?

    DB:3.24:Vo Extension Issues sp

    Hi elcaro,manually added the following things1. SQL Query.2. Added View Attributes in XML likeViewAttribute Name="DepartmentName" EntityAttrName="DepartmentName" EntityUsage="DepartmentEO" AliasName="DEPARTMENT_NAME"/3. getters and setters in ViewRowImpl class.Next:SubstitutionFiles moved to server.JPX importApache bounceAdd column through personalization.

  • RELEVANCY SCORE 3.18

    DB:3.18:Oaf Vo Extension k8


    Hi,

    I have extended a VendorsVO.xml but internally the respective AM and CO are referring to SupplierVO.
    So its throughing an error that attribute set is not in SupplierVO.

    The downloaded supplier.server does not contain SupplierVO.xml it has only VendorsVO.xml , i m not able to run a page so please guide me a solution for the mentioned problem

    Thanks and Regards,

    Suraj Chandra Mohan

    DB:3.18:Oaf Vo Extension k8

    Hi, Suraj Chandra Mohan, Shankzzz

    Did you find any solution? I am facing the same problem.

    Thanks
    Amit

  • RELEVANCY SCORE 3.18

    DB:3.18:Remove Controller Extension In Oaf R12 71


    All, there are some custom controllers in isupplier page and the user wants to disable/remove them for time being.Can someone tell me how to disable/remove controller extensions?I know how to remove an extended VO, but I have no idea how to remove or disable extended CO.Thanks.

    DB:3.18:Remove Controller Extension In Oaf R12 71

    Go to about this page and see where the controller extension is. Figure out that region and click on personalize that region, then you will see for controller class, the extension is given.Simply click inherit for that region and apply.

  • RELEVANCY SCORE 3.17

    DB:3.17:Re: Interating Directly With Vo From Co In Tutorial, Why? j9


    Again as you said, the easier way is to extend the controller but the framework suggested option is to go for AM extension.

    --Shiv

    DB:3.17:Re: Interating Directly With Vo From Co In Tutorial, Why? j9

    If the VO attribute on which the MST is based is null, how is the expectation that either of the methods you have used will return a non-null value ?
    Thanks
    Tapash

  • RELEVANCY SCORE 3.17

    DB:3.17:Re: Extending Vo 9z


    Hi Jayakumar,

    Extending VO is a chapter in OAF Dev guide. All you need is to create a Custom VO in a similar directory structure (not same) and set the seeded VO in the 'extends VO' field. You would understand once you read the chapter in the dev guide.

    Regards
    Sumit

    DB:3.17:Re: Extending Vo 9z

    Hi Reetesh,

    Sorry for the late reply. No, I am not getting the option.

    Thanks,
    AJ

  • RELEVANCY SCORE 3.17

    DB:3.17:Vo And Eo Extension Simultaneously xc


    HI OAF Gurus,

    I have a question regarding the approach of Extension. Below is my scenario

    1) I have a VO that is based on a EO (lets call this VO1 and EO1)
    2) I need to have a few additional columns captured as part of the requirement, so i need to extend the EO and the VO
    3) I extended the EO1 to EO2, by including the additional columns necessary
    4) Now the question is regarding the VO extension. When I extend the VO1 to VO2, my question is
    a) Should VO2 be based on EO1 or the extended EO2?
    b) Is there a need to use the "extends " functionality to mention details about the VO1?
    c) Either approach i take, my issue is while running locally, after substituting, the VO substitution is not being visible, only the EO substitution is taking place
    (I have substited and also used -Djbo property)

    Any idea why?

    - Gautham Kanaparthy

    DB:3.17:Vo And Eo Extension Simultaneously xc

    Hi All,I also have the same requirement but i have one doubt...Can using EO and VO extension , i add the columns that are not in the EO base tables. the new columns are in the other table.if yes please suggest how..steps?ThanksMahesh

  • RELEVANCY SCORE 3.16

    DB:3.16:Am Extension For Adding New/Custom Vo km


    Hello All,

    I have created a new (custom) OAF page and a new VO for this page. In order not to instantiate this custom VO programmatically and do it declaratively, I extended AM of the page, which happens to be RootAM. I am assuming that it worked as there are no LOVs in the page where this RootAM is used. And this extended AM, I added the new VO I created.

    But if it was not possible to extend this RootAM for whatever reasons, how can I achieve this, i.e. instantiating VO declaratively.

    regards, Yora

    DB:3.16:Am Extension For Adding New/Custom Vo km

    For a custom page its always preferred to use custom AM. i.e. create custom AM and attch VO to it declaratively.

    There are few cases where you want to use custom VO's and you do not have an option of AM extension then create custom AM for the custom VO. Make the custom AM as nested AM to seeded AM.

    For further info refer http://apps2fusion.com/at/64-kr/404-nested-application-modules-in-oa-framework

    -Anand

  • RELEVANCY SCORE 3.15

    DB:3.15:Flexibility Of Pages Developed By Oaf Extension f8


    The pages developed in OAF Extension, can we get the same user friendliness, look and feel as developed in forms in terms of LOV,Grids,etc..

    DB:3.15:Flexibility Of Pages Developed By Oaf Extension f8

    You can use the CSS class to set the style or use CLAF from CU2 onwards to set the styles globally for any widget.

  • RELEVANCY SCORE 3.10

    DB:3.10:Re: Vo Extension 3f


    Is View Attribute also set properly?

    --Shiv

    DB:3.10:Re: Vo Extension 3f

    For the page you can get the MDS detail from the PG.xml file of the related page or you can also use XMLExporter, export command.

    For personalization, you can use the Functional Administrator responsibility to get the personalizations on a page.

    --Shiv

  • RELEVANCY SCORE 3.10

    DB:3.10:Standard Oaf Page Extension 7f


    i have to modify a standard OAF page to include a value to a List, and i need to call a xmlpublisher report from the stnadard page.

    for doing this can i follow this approach
    extend the VO and add my custom code to the existing CO or is there any other way to work with stnadard Oaf pages.

    Regards,
    Tataji

    DB:3.10:Standard Oaf Page Extension 7f

    Is there any other way around with out touching the controller code. our only concern is any future patches will wipe out our codes chnages in the controller.If you do not want to go for CO extension then you need to create a custom page which will be called when you select "Print Custom Report".

    From the custom page call XML report.

    -Anand

  • RELEVANCY SCORE 3.10

    DB:3.10:Re: Data Export Function Is Uncorrect sm


    Hi Tapash,

    The problem has been sloved...
    I viewed the tutorial code and found that the bingding style property in VO should be set to "Oracle positional". Then it is ok...

    What dose the "binding style" mean? Why the export is failed when this property is set to "Oracle Named"? (I am a beginner in OAF...)

    Thanks for your help
    Yan

    DB:3.10:Re: Data Export Function Is Uncorrect sm

    Jose,

    Use Jdev forum JDeveloper and ADF for ADF related issues.

    --Shiv

  • RELEVANCY SCORE 3.10

    DB:3.10:Re: Bouncing Apache For Oaf Deployment k3


    Tapash,
    I guess that he can see the UI changes on the page but not on BC4J objects like EO, VO.
    Thats' y i adviced to put debug comments and check the log, to atleast get an idea that may be even bc4j objects are working correctly and there may be so missunderstanding.
    --Mukul

    DB:3.10:Re: Bouncing Apache For Oaf Deployment k3

    Thanks Anoop,

    Is there any workarojng even not to bounce the OC4J?

    Navin

  • RELEVANCY SCORE 3.09

    DB:3.09:Vo Extensions Error : ' You Cannot Access This Draft Quote ' zj


    Hi Oaf Experts,

    After extending VO iam getting one error in the page ' You cannot access this draft quote ', by removing the vo extension the error is going,but the error is not related my VO, it is a Standard Error.

    can anybody help on this issue.

    thanks in advance.

    Edited by: user12260892 on Jan 14, 2010 4:44 AM

    DB:3.09:Vo Extensions Error : ' You Cannot Access This Draft Quote ' zj

    Hi Oaf Experts,

    After extending VO iam getting one error in the page ' You cannot access this draft quote ', by removing the vo extension the error is going,but the error is not related my VO, it is a Standard Error.

    can anybody help on this issue.

    thanks in advance.

    Edited by: user12260892 on Jan 14, 2010 4:44 AM

  • RELEVANCY SCORE 3.08

    DB:3.08:Advance Table Creation Without Vo 3a


    Hi,

    I am new to OAF can any one please help me how to create advance table without any VO .i want values to be hard coded directly .

    Please help me.

    DB:3.08:Advance Table Creation Without Vo 3a

    hi

    we cannot create Advanced table without VO , but for ur requirement directly hardcode the values in SQL Query itself

    regards
    SasiKasyap .

  • RELEVANCY SCORE 3.08

    DB:3.08:Hgrid Region Extension 3z


    Hi,

    I have a OAF page, which shows data in HGrid structure (/oracle/apps/qot/quote/line/webui/QotLinesRN). Hgrid structure is driven using View links.

    Requirement is to add couple of columns to this HGrid Region but we are not able to get the handle on all the rows present in the VO.

    When I'm trying to loop using row.next() it is erroring out stating a View link error.

    Do I have to add any other step while getting the access to the rows which are present in HGrid region.

    Please suggest the steps or process to follow.

    Thanks,
    achapla

    DB:3.08:Hgrid Region Extension 3z

    Hi,

    I have a OAF page, which shows data in HGrid structure (/oracle/apps/qot/quote/line/webui/QotLinesRN). Hgrid structure is driven using View links.

    Requirement is to add couple of columns to this HGrid Region but we are not able to get the handle on all the rows present in the VO.

    When I'm trying to loop using row.next() it is erroring out stating a View link error.

    Do I have to add any other step while getting the access to the rows which are present in HGrid region.

    Please suggest the steps or process to follow.

    Thanks,
    achapla

  • RELEVANCY SCORE 3.07

    DB:3.07:Re: How To Create A New Eo In Oaf? zj


    Hi Meher,

    I have created the EO and VO now how to capture values from pages and store in database.

    DB:3.07:Re: How To Create A New Eo In Oaf? zj

    Hi,

    ---Once check resp_key.
    ---ToolsPreferenceEmbeede OC4J:Select Local Host.

    Better to register in apps..:)

    Regards
    Meher Irk

  • RELEVANCY SCORE 3.06

    DB:3.06:I Am Getting An Blank Row File On Vo Extension 9m


    When creating an view extension on OAF VO - MgrTransactionsVO - I am getting odd results If I create VO files in oracle\apps\ap\pcard\server(wrong directory) it will create row file - if I create VO files in xxhtz\oracle\apps\ap\pcard\server(right directory) it does not create row file(actually does create but its blank). Is there a simple solution to this problem ?

    DB:3.06:I Am Getting An Blank Row File On Vo Extension 9m

    Hi,R u getting any error while extending VO in VO wizard.If no I suggest you to copy the Content of the row file from oracle\apps\ap\pcard\server to your custom path and change the path and required code to suit the custom folder.This is the simplest solution right now coming in mind.Br,906099

  • RELEVANCY SCORE 3.06

    DB:3.06:Re: Authentication From Oaf Jsp To Different Server c3


    The OAF forum is {forum:id=210}

    DB:3.06:Re: Authentication From Oaf Jsp To Different Server c3

    Thanks John. Can you plz provide me the link for OAF forum.

    Moved my post to OA Forum - Authentication from OAF jsp to different server

    Edited by: user8918217 on Nov 10, 2011 4:28 AM

  • RELEVANCY SCORE 3.06

    DB:3.06:Vo Extension 3d


    Can We do the Extension to a vo which has a view link ?.
    Means the vo to which i have to add the new fields had a viee link .

    DB:3.06:Vo Extension 3d

    Logically, one should do the Extension to a vo which has a view link ? This should be handle at substitution level.
    I have not tried this.

    Are you getting any issue?

  • RELEVANCY SCORE 3.05

    DB:3.05:Re Import Oaf Page f1


    Hi All,I am a newbie to OAF. I created an OAF application and import all my pages using import command. It works fine.But i change some UI elements in OAF page. I want to re-import the OAF page..Please help me out.Thanks in Advance

    DB:3.05:Re Import Oaf Page f1

    Run the import command again for that particular page.--Sushant

  • RELEVANCY SCORE 3.04

    DB:3.04:Re: How To Add A Custom Values In Oamessagechoicebean In Oaf as


    Hi,

    could you share me the steps you followed for VO extension ??

    In your scenario, you cannot use setPickListViewObjectDefinitionName api use setPickListViewUsageName instead.

    change the Co code as

    omb.setPickListViewUsageName("PicklistVO");
    pmb.setListDisplayAttribute("display");
    omb.setListValueAttribute("value");

    gk

    DB:3.04:Re: How To Add A Custom Values In Oamessagechoicebean In Oaf as

    Hi,
    okay, what query the extended VO shows the newquery or seeded qry? dont forget to bounce the apache service after extn
    if it still shows oldquery ,then redo vo extn

  • RELEVANCY SCORE 3.02

    DB:3.02:Defaulting Value For Invoice Currency Lov In Supplier Sites 1s


    Hi,

    I'm new to OAF and need to migrate form personalization in 11i for Supplier Sites to release R12.1.3 with following condition
    WHEN-NEW-RECORD-INSTANCE
    fnd_profile.value('ORG_ID') = 1 - Set Invoice Currency to USD and show message 'Invoice Currency change to USD'
    and :SYSTEM.RECORD_STATUS != 'QUERY'
    and :SYSTEM.RECORD_STATUS != 'CHANGED'

    fnd_profile.value('ORG_ID') = 2 - Set Invoice Currency to SGD and show message 'Invoice Currency change to SGD'
    and :SYSTEM.RECORD_STATUS != 'QUERY'
    and :SYSTEM.RECORD_STATUS != 'CHANGED'

    Understand that it must be done through CO Extension in processRequest.
    The objects structure are :
    -header: Key Payment Setups
    - stackLayout
    - table: Key Payment Setups
    - column: (InvCurrCol)
    -messageChoice: Invoice Currency
    with VO SitesVO and VO attribute InvoiceCurrencyCode.

    Kindly advice the code in processRequest method.

    Many thanks in advance,
    efends

    DB:3.02:Defaulting Value For Invoice Currency Lov In Supplier Sites 1s

    Hi,

    I'm new to OAF and need to migrate form personalization in 11i for Supplier Sites to release R12.1.3 with following condition
    WHEN-NEW-RECORD-INSTANCE
    fnd_profile.value('ORG_ID') = 1 - Set Invoice Currency to USD and show message 'Invoice Currency change to USD'
    and :SYSTEM.RECORD_STATUS != 'QUERY'
    and :SYSTEM.RECORD_STATUS != 'CHANGED'

    fnd_profile.value('ORG_ID') = 2 - Set Invoice Currency to SGD and show message 'Invoice Currency change to SGD'
    and :SYSTEM.RECORD_STATUS != 'QUERY'
    and :SYSTEM.RECORD_STATUS != 'CHANGED'

    Understand that it must be done through CO Extension in processRequest.
    The objects structure are :
    -header: Key Payment Setups
    - stackLayout
    - table: Key Payment Setups
    - column: (InvCurrCol)
    -messageChoice: Invoice Currency
    with VO SitesVO and VO attribute InvoiceCurrencyCode.

    Kindly advice the code in processRequest method.

    Many thanks in advance,
    efends

  • RELEVANCY SCORE 3.02

    DB:3.02:Re: Error In Vo Extension 3c


    Thanks for the link Anand..But it didn't help me :(..i m still facing the same error.

    One thing i found when i try to extend the VO on Attribute Mapping step (4), few Seeded VO's View Attributes got changed.
    for example- Seeded VO's view attributes is like "PersonFlexAttribute1" but while extension the VO this view attribute is changed like "PersonFlexAttribute1_1". i didn't understand how this attribute got changed.. there are many View attributes that got changed like this in the VO Extension Step(4) Attribute Mappings. This may be a reason for this error..but i m not sure about it.

    Could anyone suggest some solution to get rid of this error..

    Thanks
    Renu

    DB:3.02:Re: Error In Vo Extension 3c

    Folllow the link which I mentioned above carefully.

    It says add attributes at step 3 of 7. And then add at step 4 of 7. Later modify custom VO.xml so on....

    -Anand

  • RELEVANCY SCORE 3.02

    DB:3.02:How To Migrate Vo Extension From One Instance To Other 73


    Hi,

    How to Migrate VO Extension from One Instance to Other.

    Thanks
    Vishnu

    DB:3.02:How To Migrate Vo Extension From One Instance To Other 73

    Hi Vishnu,

    As Anil said perform these steps this will do the trick and before doing this don't forget to substitute standard VO with your extended VO after this .jpx file will be having information regarding substitutuion and then these information will be imported to database using jpx importer command.

    Regrads,
    Reetesh Sharma

  • RELEVANCY SCORE 3.02

    DB:3.02:Vo Extension Issue 3j


    Hi OAF experts,

    My requirement in OAF customization is to add some extra fields from custom table to the existing page . My approach is to create a New EO based on custom table and then create new VO extending the seeded VO.

    Say if i have created a extended VO .do i need to extend the seeded AM and controller too?

    please need help in this regard or provide your approach in this extension

    Regards
    Newbie

    DB:3.02:Vo Extension Issue 3j

    Hi

    no need to extended the AM never required for VO extension ,just extend the VO ,and modify the query in query block ,and import the jpx file

    thanx
    Pratap

  • RELEVANCY SCORE 3.02

    DB:3.02:Max Fetch Size Property For View Object zp


    Hi all,

    I am bit confused with the Max Fetch Size for View Object. I have gone through many forum threads regarding this issue. Specially in

    Max Fetch Size property For View Object in oaf

    Re: Maximum Number of Records in a VO

    Query has exceeded 200 rows

    From these threads what I am understood is,

    profile option that governs maximum fetch size of a VO:
    FND: View Object Max Fetch Size
    How can I get into the profile option??

    But still it is not recommended to set higher value on this.

    So if have VO query which results about 5000+ rows. What is the recommended way of handling this issue?

    Thanks
    Danesh

    DB:3.02:Max Fetch Size Property For View Object zp

    So if have VO query which results about 5000+ rows. What is the recommended way of handling this issue?This profile option was introduced for performance reasons, and 5000+ is too high.

    How To Display Larger Number Of Rows In Self Service Pages [ID 471151.1]
    How Does 'FND: View Object Max Fetch Size' Profile Option Relate To Internet Expenses? [ID 760895.1]

    Thanks,
    Hussein

  • RELEVANCY SCORE 3.01

    DB:3.01:Re: Oaf Vo Extension 1z


    Hi Deba,

    Oracle never ship any java files as it is. You might raise a SR and try to get but I am 100% sure they won't entertain.

    The decompilers are good to have a hold of the code in the CO but they do not decompile any class file 100%. we have to live with these two facts.

    Now coming back to your issue, you can decompile the class, have a look, then extend the CO as required. I have worked on these I Expense pages, can you reiterate your req'ment?

    Thanks
    Shanku

    DB:3.01:Re: Oaf Vo Extension 1z

    Hi Debadutta,
    Good to know that issue got resolved,
    could you please update how the issue got resolved,
    As I mentioned did you recreated the VO again in R12 or any other action resolved the issue.

    That information will help others, if they face the same issue in their implementation.

    Thanks,

    With regards,
    Kali.
    OSSi.

  • RELEVANCY SCORE 3.01

    DB:3.01:Locations Of Files df


    Hi OAF Gurus,

    I am newbie to OAF. I wanted to whether the location for all the OAF files is fixed.
    Why are all AM, VO files stored in server directory, whereas PG, CO in webui EO files in schema.server?

    Also is there any students guide (easy to start with material) available for OAF beginners?

    Regards

    DB:3.01:Locations Of Files df

    Basic java and sql knowledge is enough to learn OAF. You can start with OA toolbox tutorials and developers guide !

    See this thread
    Re: New to OAF Framework

  • RELEVANCY SCORE 2.99

    DB:2.99:Re: Error When Personalizing Page With New Item Created In Vo Extension jz


    Thanks

  • RELEVANCY SCORE 2.99

    DB:2.99:Help Needed With Md70 Document For Oaf Personlisations!!Urgent pc


    Hi everyone,
    I have done around 10 odd personalisations/extensions on a standard form and i am supposed to prepare a md70 document for the same.
    I have not seen any template for md70 which seems good enough to map the personalisation steps

    Moreover,how do i explain the VO and CO extension steps in the document,i am totally blank
    Please suggest something and please if anyone has a sample md70 done for oaf personlizations,i will be grateful if you could send it to hatsoffforu@gmail for refrence purpose alone

    Thanks in Advance

    DB:2.99:Help Needed With Md70 Document For Oaf Personlisations!!Urgent pc

    Hi Sumit,
    I have been through metalink but i could not find anything relevant.As far as other sources,i did put my query in mukul's blog too.The thing is i dont know too many OAF developers,so i gotta turn to the ones i know.
    I am anywas trying to draft the document based on d2k personlization putting pers snapshots and stuff,but since u guys have already worked on real time requirements,i just thought it will be better.cos i still don know how much too to explain in the doc

  • RELEVANCY SCORE 2.99

    DB:2.99:Vo Extension And Switcher dk


    Hi,

    I have a requirement to add a new column to a oaf results table (OLM, Search results for courses). This column should show either of the two images based on the value returned by a function.

    I have extended the standard VO to add a new statement in the select clause.

    "... decode(xxpkg.xxfn(l_var), 'Y', 'IMAGE1', 'IMAGE2')"

    Now, I was hoping that i could create a new item in the table region to add this new column and a Switcher to point to the image location based on the value in the column.

    However, I cannot find the Item Style of "Switcher" at Site Level. Can you guys please point me in right direction?
    How is the 'Switcher' added to a standard oaf table?

    Thanks,
    Abhijeet

    DB:2.99:Vo Extension And Switcher dk

    Can you please steps in detail ..As I have same requirement implementing switcher in table

  • RELEVANCY SCORE 2.97

    DB:2.97:Running Page In Oaf And Vo Extension s9


    Hi,

    I have extended a VO on my local machine and am running the page on my local machine itself. Yet I cannot see the extended VO in About this page.

    I created the substitution in project, do I need to load this into MDS as well even for pages run from local PC ? Also notice it takes a lot of time for my project to rebuild and page to finally render, any ideas why or how to optimize the runtime.

    Thanks
    Shanky

    DB:2.97:Running Page In Oaf And Vo Extension s9

    It wont show your extended VO, since it connects to the server, your extension needs to be on server.

  • RELEVANCY SCORE 2.95

    DB:2.95:Personalization To Restrict The Entry Of Only Upper Case In Oa Beans fz


    Hi Gurus,

    I have a requirement as follows:

    On a Given Seeded Oracle OAF Page, I want to restrict the user to enter letters only in UpperCase in a Text Box.
    I am not sure if we can achieve through the OAF Page Personalizations.

    This type of restriction has to be imposed on more than one Text box in the same Page/Region.

    So, I was wondering if there can be anything that can be done at the Page/Region Level, instead of doing it for each such Text box.

    Can anyone please let me know if such a thing can be achieved through simple OAF Page Personalizations
    (OR)
    Is the extension of the controller, then getting the AM, and then getting each such VO and use the toUpper() function in Java and put it back in the VO, before submitting is the only way.

    Thanks in Advance,
    Vijay

    DB:2.95:Personalization To Restrict The Entry Of Only Upper Case In Oa Beans fz

    Hi Vijay,

    You can extend the controller of seeded OA framework page.

    Please refer following forum link.

    http://forums.oracle.com/forums/message.jspa?messageID=3780118#3780118

    Thanks,
    Laukik Pachanekar

  • RELEVANCY SCORE 2.95

    DB:2.95:Re: Issue With Extend A View Object In Oaf R12 pk


    Hi,
    To check the substituted VO details you should give the customization path not the standard path in the printDocument,

    like jdr_utils.printDocument(''/oracle/apps/ota/learner/server/customizations/site/0/OfferingSrchResultVO');

    Thanks,

    With regards,
    Kali.
    OSSi.

    DB:2.95:Re: Issue With Extend A View Object In Oaf R12 pk

    Hi Ashraf,
    Good to know.

    Thanks,

    With regards,
    Kali.
    OSSi.

  • RELEVANCY SCORE 2.95

    DB:2.95:A Doubt On Customization az


    Hi,

    I read the following in OAF dev guide
    Extension is extending the functionality of an aplication using
    - Adding new functional flows.
    - Extending or overriding existing functional flows.
    - Extending or overriding existing business logic.

    I understand that Extending or overriding existing business logic is editing eithet AM,VO or VO etc ..in short BC4J objects.

    My questions is
    What does functional flow mean? Does it mean page flow?
    If yes Adding new functional flows OR Extending or overriding existing functional flows is nothing but creating a new Controller or editing the seeded ControllerImpl?

    Can you please clarify me on this doubt.

    Thanks,
    Gowtam.

    DB:2.95:A Doubt On Customization az

    Function Flow means Various real world entities completing a business cycle like
    P2P Cycle (procure to pay).

    Technically functional flow, a number of pages can be participate but this is always true.

    So again "Adding new functional flows OR Extending or overriding functional flows " may required Development , customization, personalization , setups depending on business requirements.

  • RELEVANCY SCORE 2.95

    DB:2.95:Re: Getting The Following Error While Extending Headervo,Linesvo -Urgent 3c


    Ajit,

    Your error text has oracle.apps.fnd.framework.OAException and you are talking about EO, VO, so it has to be OAF based page.

    --Shiv

    DB:2.95:Re: Getting The Following Error While Extending Headervo,Linesvo -Urgent 3c

    Ajit, can u clarify this was a jsp or oaf page? If this is a JSP page, how r u accessing VOs?

    --Mukul

  • RELEVANCY SCORE 2.95

    DB:2.95:How To Remove Substitution/Extension To A Vo Object In Oaf za


    Hi

    I've personalized a VO but now i wanna remove Substitution on this page i used the below procedure to delete personalization.

    Step 1.

    begin
    jdr_utils.printdocument('/oracle/apps/pa/ci/server/customizations/site/0/PaSupplierImplementVO');
    end;

    begin
    jdr_utils.deletedocument('/oracle/apps/pa/ci/server/customizations/site/0/PaSupplierImplementVO');
    end;Step 2.
    Bounce the Apache Server

    But when i requery the Page the VO still exists on the Page
    oracle.apps.pa.ci.server.CIStartingStatusVO
    bateman.oracle.apps.pa.ci.server.xxpaPaSupplierImplementVO
    oracle.apps.pa.ci.server.ImpactImplementationVO How can i remove the Substitution and use the Standard functionality

    Please help

    Thanks

    DB:2.95:How To Remove Substitution/Extension To A Vo Object In Oaf za

    commit;
    commit;
    commit;
    commit;

    I did not commit;

    Thanks Guyz

  • RELEVANCY SCORE 2.95

    DB:2.95:Re: Vo Extension Server.Xml Missing In $Java_Top 9j


    Yes this is normal.

    Create the business component package for java in Jdev mentioning the path till the server folder. It will create the server.xml file.

    Now you have to add all your VO,EO and AM's in this package by selecting the package in jdev and click on the file menu open button. Select all the files. Now all your VO,EO and AM's will be added to this server.xml

    ANoop

    DB:2.95:Re: Vo Extension Server.Xml Missing In $Java_Top 9j

    You can't personalize Substitution in funcational administrator..

    use jdr_utils.deleteDocument(); to delete the personalization..

    --Prasanna

  • RELEVANCY SCORE 2.94

    DB:2.94:Oaf Customization zc


    Hi,

    I have added new fields in RN.xml and moved the file to the server and imported it. But my change is not seen in the page(About the page). The columns are already there in the VO and it is not a VO extension. What steps in addition to adding fields to PG.xml or RN.xml to be done?

    Thanks

  • RELEVANCY SCORE 2.93

    DB:2.93:Query To Find The Vo, Am, Co Extensions In Oaf? df


    Hi, Could anyone please let me know how to find VO, AM, CO extensions in OAF?Thanks,Ram

    DB:2.93:Query To Find The Vo, Am, Co Extensions In Oaf? df

    Hi Sushant, Thanks for your reply, I wanted to know if there is a way that how the data from the JPX file is getting stored in the MDS? can I know the old and new substitutions data in VO or AM from table?Thanks,Ram

  • RELEVANCY SCORE 2.92

    DB:2.92:Re: Problem With Lov Query cj


    user21786,
    check the param type of cash_document_id in VO wizard, if its Number and if cash_doc_id is string, then u need to type cast string to Number, like this
    setNamedWhereClauseParam("CASH_DOCUMENT_ID",new oracle.jbo.domian.Number(Integer.parseInt(cash_doc_id)));

    By the way setNamedWhereClauseParam() i have always used in adf, never in oaf :) !

    --Mukul

    DB:2.92:Re: Problem With Lov Query cj

    Agreed, with the oracle.jbo.RowSet interface explanation, that was the missing part.
    Thanks
    Tapash

  • RELEVANCY SCORE 2.92

    DB:2.92:'Duplicate Case Label' Error In Generated Method Getattrinvokeaccessor() zc


    Hi,
    I'm using JDeveloper 10g with OA Extension to develop an OAF page. I have added an additional field to the backend table and have synchronized the EO and VO with the database. After this the VORowImpl.java shows a compilation error 'Duplicate case label' in the generated method getAttrInvokeAccessor().

    I can see there is indeed a duplicate label in the case statement but since it is a generated method, I'm not supposed to modify it. Is there a way to rectify this?
    Kindly help.

    Thanks
    -Madhuri

    DB:2.92:'Duplicate Case Label' Error In Generated Method Getattrinvokeaccessor() zc

    Thank You, Sumit. Your suggestion cleared the compilation error.
    -Madhuri

  • RELEVANCY SCORE 2.91

    DB:2.91:Need To Extend Vo For Pdf Of Oaf ms


    Hi Gurus,This is little.I know how to extend VO in normal oaf page through About this page.But I am not sure how to find VO of .pdf file of oaf page.Kindly, help me to overcome this issue.Thanks,Sunvin

    DB:2.91:Need To Extend Vo For Pdf Of Oaf ms

    Hi Sunvin,This forum is for ADF but not for OAF.Please post your query at below forumhttps://forums.oracle.com/community/developer/english/e-business_suite/technology_-_oa_frameworkRegards,Peddi.

  • RELEVANCY SCORE 2.90

    DB:2.90:When-Validate-Record Trigger In Oaf a8


    Hi All,
    Which is equivalent of WhenValidateRecord in OAF.
    My form is not EO based. It is VO based AdvanceTable Region. I am inserting and updating the data in that Region by Calling PL/SQL procedure.

    Please Help. I am new to OAF.

    DB:2.90:When-Validate-Record Trigger In Oaf a8

    Hi,

    You can try
    --ApplicationModule.getTransaction().isDirty() - This method tells you whether the transaction contains any changes in the view objects. This works for transactions made by entity object-based view objects only.
    --OAViewObject.isDirty() - This method tells you whether a particular view object contains changes or not. This works for both entity object-based view objects and view objects
    based on OAPlsqlViewObjectImpl

    Check
    http://kohlivikram.blogspot.com/2008/04/help-questions-in-oafpart-3.html

    Thanks,
    Jit

  • RELEVANCY SCORE 2.90

    DB:2.90:Eo Based Vo Extension - R12 sc


    Hi All

    I have posted a new article on VO extension.

    http://oracleanil.blogspot.com/2010/11/eo-based-vo-extension-in-oaf-r12.html

    Thanks
    --Anil
    http://oracleanil.blogspot.com

    DB:2.90:Eo Based Vo Extension - R12 sc

    Hi,

    Post your question in appropriate forums:

    General EBS Discussion

    or

    Technology - General Discussion

    -Anand

  • RELEVANCY SCORE 2.89

    DB:2.89:Oaf Question sp


    hican we send the VO for loop into AM how?

    DB:2.89:Oaf Question sp

    Hi Chintu_Apps,Please find the code below . Hope it helps you OAApplicationModule rootAM = pageContext.getRootApplicationModule(); OAViewObject ReqVO = (OAViewObject)rootAM.findViewObject("BidHeaderSectionsVO"); if (null!=ReqVO) { Row ReqRow = ReqVO.first(); if (null != ReqRow) { int idx = ReqVO.getRowCount(); for (int xx = 0; xx idx; xx++) { if (null != ReqRow) { // Do some work.... ReqRow = ReqVO.next(); } else {} } } }ThanksSandeep

  • RELEVANCY SCORE 2.88

    DB:2.88:Re: How To Execute A Query Than Open A Popup? m3


    - The "resultset" of the query has to be transformed to a xml. If some one can give me a clue how to do it would be nice;
    You can get the VO resultset as XML using writeXML method in VOImpl.- Finally, in the CO with the xml, open a popup passing the xml. How can this be done?.
    Is the new page being opened a OAF page ? if yes then you can just retain the AM when you go to the new page and you will have the VO with the data in it, you can then use the VO as is or write the XML from the VO data.If , on the other hand, your new page is not a OAF page and is a simple jsp, then
    I dont think it is a good idea to pass the entire resultset as a XML to the target page, instead, you can just popup the page on press of the button and execute and generate the XML in the target page.

    Thanks,
    Tapash

    DB:2.88:Re: How To Execute A Query Than Open A Popup? m3

    Tapash, it's in oracle/apps/fnd/framework/webui and a very useful class with a lot of static methods.

  • RELEVANCY SCORE 2.88

    DB:2.88:Vo Extensions Error c7


    Hi oaf experts,

    Iam having one Standard page,in that iam adding two custom fields,for this i have find out that standard vo and extended that.i have added two fields,custom table name,join conditions in the extendedvo.
    i have done all things like substutions,moving to server location,runned .java files in putty,

    bounced server,everything is ok with vo extension,

    when iam going in to respective page the new fields are displaying but one error message showing on the top of the page like below

    Message not found. Application: FND, Message Name: FND_VIEWOBJECT_NOT_FOUND. Tokens: VONAME = PFCBidHeaderVO; APPLICATION_MODULE = oracle.apps.pon.response.creation.server.ResponseAM;

    can anybody help on this

    thanks

    DB:2.88:Vo Extensions Error c7

    Please check to see that the .jpx file is imported into the MDS Repository or not

  • RELEVANCY SCORE 2.87

    DB:2.87:Re: How To Avoid Duplicate On Oaf Form cx


    hi,
    Tht s im asking hw u r goign to save via Eo rgTh..

    If ur vo eo based then
    Set tht attribute to Primary Key

    Nani:)

    DB:2.87:Re: How To Avoid Duplicate On Oaf Form cx

    Hi Nani,

    I am sharing this code which in working condition now.
    In below code I was just missing one IF condition ( if (sequence!=null)) in second loop, becoz of which it was throwing null pointer exception.

    Thanks for your kind help..

    public void ValidateSequence() {

    OAViewObject vo = (OAViewObject)findViewObject("XXBCR12ToolkitVO1");
    int rowcount = vo.getRowCount();
    System.out.println("rowcount"+ rowcount);
    String sequence[] = new String[rowcount];

    RowSetIterator SeqIterator;
    XXBCR12ToolkitVORowImpl row = null;

    SeqIterator = vo.createRowSetIterator("SeqIterator");
    SeqIterator.setRangeStart(0);
    SeqIterator.setRangeSize(rowcount);

    for (int i = 0; i rowcount; i++) {
    row = (XXBCR12ToolkitVORowImpl)SeqIterator.getRowAtRangeIndex(i);
    if (row.getAttribute("LegacyColumnSeqNum") != null)
    sequence[i] =
    row.getAttribute("LegacyColumnSeqNum").toString();
    //System.out.println("value of sequence:= "+i+"="+sequence[i] );
    }

    for (int i = 0; i rowcount; i++) {
    for (int j = i + 1; j rowcount; j++) {
    //System.out.println("Main "+sequence[i]+sequence[j]);
    if (sequence[i]!=null) {
    if (sequence[i].equals(sequence[j]))
    {
    System.out.println("inside if for: "+sequence[i]+sequence[j]);
    throw new OAException("Sequence value duplicated. Please enter enter sequence number.",
    (byte)0);
    }
    else {
    System.out.println("inside else for: "+sequence[i]+sequence[j]);
    }
    }
    }
    }
    }

  • RELEVANCY SCORE 2.87

    DB:2.87:Re: Replace Mod_Plsql In Oaf 9m


    Best way to get started is to go through the provided sample codes and some hands on practice.

    Once you have a feel of the capability of OAF, you will be in a better position to determine the best way to implement the solution in OAF. As for now, from the description it seems that all the mod_plsql code is doing is showing reading DB and data. So it depends on what kind of structure is used to show the data, whether you want the same structure in OAF also and similarly other aspects. IF its just a table with data, then a table bean with the associated VO will be enough. So in all, you need to analyze more :)

    --Shiv

    DB:2.87:Re: Replace Mod_Plsql In Oaf 9m

    Just one question: do I need JDev with OA extensions? Or without?
    Yes you do, Mukuls reply helpsAnd what are the OA extensions?
    You can take this as a plugin to Jdeveloper for doing development in OAF FWK.Thanks
    Tapash

  • RELEVANCY SCORE 2.86

    DB:2.86:Re: How To Deploy The Oaproject In To Oracle E-Business Suit 99


    hi avjain, the package what i have created is oracle/apps/ak/cms/ in this i have store my all oapages vo and Eo i executed the import command its was succesfully exeuted, i created a function with HTML CALL with path OA.jsp?page=/oracle/apps/ak/cms/LoginPage but the function is not available when i am trying to create menu, can u give me an idea how to resolve this.

    import
    D:\downloads\OAF\OAF1\jdevhome\jdev\myprojects\oracle\apps\AK\cms\LoginPage
    -jdk13 -mmddir "D:\downloads\OAF\OAF1\jdevhome\jdev\myhtml\OA_HTML\jrad" -username apps -password apps -rootdir D:\downloads\OAF\OAF1\jdevhome\jdev\myprojects\ -validate
    -dbconnection "(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.254)(PORT = 1521))
    (CONNECT_DATA =(SID = OASIS)))"

    i got
    import succesfull.

    DB:2.86:Re: How To Deploy The Oaproject In To Oracle E-Business Suit 99

    Your import command looks fine. Did you get any output for
    exec jdr_utils.printDocument('/oracle/apps/icx/stanford/webui/LoginPagePG');
    What is the web html call you had given while defining the function ?

  • RELEVANCY SCORE 2.86

    DB:2.86:Re: How To Set An Extended Vo As Picklist View Definition For An Attribute ca


    Hi,

    To set the VO attribute for the existing picklist, you can extend the controller.

    In the controller code, get hold of the message choice bean.
    set the property setPickListViewUsageName(),
    setListDisplayAttribute(),
    setListValueAttribute().

    If you dont want to do the controller extension, just hide the existing message choice bean and create a new bean.

    Hope this helps you.

    DB:2.86:Re: How To Set An Extended Vo As Picklist View Definition For An Attribute ca

    Hi,

    The syntax to create the VO is proper.

    In the code,
    *((OAMessageChoiceBean)localObject11).setPickListViewUsageName("xxx.oracle.apps.pa.oie.server.xxxCurrenciesVO");*((OAMessageChoiceBean)localObject11).setListDisplayAttribute("CurrencyCodeName");
    ((OAMessageChoiceBean)localObject11).setListValueAttribute("CurrencyCode");

    Check the setPickListViewUsageName method.
    Specify only the VO name here not the complete path.

    Put the debug messages to see where the page is erroring out.
    Bounce the apache once u done the changes.

    If possible post complete code.

    Thanks,
    Veena

  • RELEVANCY SCORE 2.86

    DB:2.86:In Which Case Vo Extension Is Not Upgrade Safe kj


    Hi all,

    In Which case Vo extension is not upgrade safe

    --
    kumar

    DB:2.86:In Which Case Vo Extension Is Not Upgrade Safe kj

    Hi Anand,

    The extended VO with extra parameters or validation is going to substitute the seeded VO after the deployment.
    So how does it matter after upgrade if any changes in the seeded VO causing VO extension to stop working?
    If this is the case, what is the best practice to customize a seeded VO.

    I am very new to OAF and started working on extending a seeded VO.
    Any pointers will be much appreciated.

    Thanks,
    -Mukesh.

  • RELEVANCY SCORE 2.86

    DB:2.86:Re: Sepl And Vo Extension xs


    i have done the jpximport and i can see the extended vo in the page but when i enable spell on the field i get this error

    oracle.apps.fnd.framework.OAException: Message not found. Application: FND, Message Name: FND_VIEWOBJECT_NOT_FOUND. Tokens: VONAME = xxEYReqSummaryVO; APPLICATION_MODULE = oracle.apps.icx.por.req.server.RequisitionAM;
    at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1223)

    but when i do the same customization on the standard vo by adding a new attribute and copying those file to unix box everything works fine .

    i am not sure even after doing the vo extenion and doing jpx import why its giving the above error .

    DB:2.86:Re: Sepl And Vo Extension xs

    is this the issue by any chance

    Subject: VO Substitution does not work in framework pages
    Doc ID: Note:418682.1 Type: PROBLEM
    Last Revision Date: 12-MAR-2007 Status: PUBLISHED
    Applies to:
    Oracle Applications Framework - Version: 11.5.10 to 11.5.10.4
    This problem can occur on any platform.

    Symptoms
    In Oracle Applications 11i, after extending any framework page by doing VO (View Object) substitution for any VO that is found in subtab in any region in the page either by adding a new attribute to the VO or changing any clause in the VO query such as adding condition for the WHERE clause.

    Then deploying the extension to the server successfully, and after that going to the extended page to check the substitution by pressing on (About this page) , and the result will be that you will be not able to see the new substituted VOs.

    Or in case of adding a new attribute to the VO, you will get a framework exception saying that the "new attribute" is not found.

    Cause
    This is caused by the following INTERNAL bug that is not published through Metalink to customers, and it is reported on R12 and backported to R11i :

    Bug 4970554 - VO SUBSTITUTION NOT WORKING

    Which say that: any substituted View Object used inside a SubTab Layout is not working because of a defect in the code of file (OAPageBean.java) for any version prior to (115.545.115104.3) in Oracle Applications 11i.

    Solution
    TIP: Click help for a detailed explanation of this page.
    Bookmark Go to End

    Subject: VO Substitution does not work in framework pages
    Doc ID: Note:418682.1 Type: PROBLEM
    Last Revision Date: 12-MAR-2007 Status: PUBLISHED

    In this Document
    Symptoms
    Cause
    Solution
    References

    --------------------------------------------------------------------------------

    Applies to:
    Oracle Applications Framework - Version: 11.5.10 to 11.5.10.4
    This problem can occur on any platform.

    Symptoms
    In Oracle Applications 11i, after extending any framework page by doing VO (View Object) substitution for any VO that is found in subtab in any region in the page either by adding a new attribute to the VO or changing any clause in the VO query such as adding condition for the WHERE clause.

    Then deploying the extension to the server successfully, and after that going to the extended page to check the substitution by pressing on (About this page) , and the result will be that you will be not able to see the new substituted VOs.

    Or in case of adding a new attribute to the VO, you will get a framework exception saying that the "new attribute" is not found.

    Cause
    This is caused by the following INTERNAL bug that is not published through Metalink to customers, and it is reported on R12 and backported to R11i :

    Bug 4970554 - VO SUBSTITUTION NOT WORKING

    Which say that: any substituted View Object used inside a SubTab Layout is not working because of a defect in the code of file (OAPageBean.java) for any version prior to (115.545.115104.3) in Oracle Applications 11i.

    Solution
    To implement the solution, please execute the following steps:

    1. Download and review the readme and pre-requisites for

    Patch 5883106 - 11i.ATG_PF.H.RUP3 OACORE fixes V4.8

    2. Ensure that you have taken a backup of your system before applying the recommended patch.

    3. Apply the patch in a test environment.

    4. Confirm the following file versions:
    OAPageBean.java Version: 115.545.115104.3
    You can use the commands like the following:
    $adident Header $OA_JAVA/oracle/apps/fnd/framework/webui/OAPageBean.class

  • RELEVANCY SCORE 2.85

    DB:2.85:Re: How To Return To The Parent Page In Oaf z7


    Please ask OAF question on the {forum:id=210}

    Timo

    DB:2.85:Re: How To Return To The Parent Page In Oaf z7

    Hi All,

    I have created a custom OAF page and linked the same with 3 standard OAF pages(Lets say Standard-Page1, Standard-Page2, Standard-Page3) in such a way that whenever I click the GO button in any of those standard pages it navigates to my custom page.

    As of now when I click the BACK button in the custom page it navigates back to Standard-page1(Because i have given the page1 Path in the pageContext.ForwardImmediately) only even though if I would have opened my custom page from standard-Page2 or 3.

    I need to understand what should I do to navigate back to the exact standard page from which the custom page has been opened.

    Any help on this would be greatly appreciated.

    Many thanks in advance!

    Kind Regards,
    Myvizhi

  • RELEVANCY SCORE 2.85

    DB:2.85:Changing Custom Vo cj


    Hi,

    In OAF we have got a custom extension, now I need to change one of the VO in this just need to add an additional where clause.

    I tried directly chaining the VO.xml file by adding extra clause then I have cleared the cache and also bounced the apache but the change but it's not picking up changed VO from the server.

    I was hoping this will work, I am trying this in one of the dev env and key thing here is it's a custom VO which I am trying to change so no need for substitution etc?

    Can some one please let me know if above approach will work or I need to follow the same steps as to change the seeded VO?

    Thanks

    DB:2.85:Changing Custom Vo cj

    thank you.
    I shall try this and let u know if any exception occurred.

  • RELEVANCY SCORE 2.85

    DB:2.85:Query In Oaf dc


    Hello all,
    We have a requiremnt like For an OAF seeded page (Item page in PIM), we need to display "last_updated_By" in the form. Is it possible through OAF personalization if the last_updated_by is in the VO?

    Regards,
    Sumi.

    DB:2.85:Query In Oaf dc

    Sumi,

    Best asked on the [url http://forums.oracle.com/forums/forum.jspa?forumID=210]OA Framework forum.

    John

  • RELEVANCY SCORE 2.85

    DB:2.85:Re: How To Add Attachments In Oaf Page 9s


    Please post OAF questions on the OA Framework forum:
    http://forums.oracle.com/forums/index.jspa?categoryID=84

    DB:2.85:Re: How To Add Attachments In Oaf Page 9s

    Hi,

    I have a requriement where i need to add an attachment in an OAF page and store that file (may be a doc or zip or anything) in a Custom table where i created a BLOB datatype.
    Is this possible if not how shall i add the attachement field in the OAF Form.

    Thanks
    Shubhadeep

    Edited by: Shubhadeep on Nov 19, 2008 10:31 AM

  • RELEVANCY SCORE 2.84

    DB:2.84:Oaf- Tutorial Exercise - Extending Vo 91


    Hi ,

    I am having a problem while working on the OAF- Tutorial Exercise for Extending VO. I am getting the below error when i try to rebuild my project (ExtendLan.jpr). This exercise involves extending a VO and creating a Additional Field in the Po Summary Page.

    Error Received during compilation :-

    Validation error in document "rkPoSummaryCreatePG":
    Invalid value "/oracle/apps/fnd/framework/toolbox/tutorial/webui/PoSummaryRN" for property "Extends" on component "/rk/oracle/apps/fnd/framework/toolbox/tutorial/webui/rkPoSummaryCreatePG.OrdersRN". Component "/oracle/apps/fnd/framework/toolbox/tutorial/webui/PoSummaryRN" cannot be referenced from "/rk/oracle/apps/fnd/framework/toolbox/tutorial/webui/rkPoSummaryCreatePG.OrdersRN" because it violates scope restrictions.

    I ignored the above warning message but still i am not getting the data in the new column . below are the steps followed to carry out the extension :-

    I am performing the foll steps documented in the Tutorial Exercise:-

    1) Created a OA Project . attach the necessary dbc file.
    2) Created a empty bc4j object ( which extends the VO PoSummaryVO ) and then create a VO gua.PoSummaryVO, modify the query to include the new column ( supplier name)
    3) Created a copy of PoSummaryCreatePG.xml in my project folder and named it as guaPoSummaryCreatePG.xml . here i manually created the webui folder.
    4) added the PoSummaryCreatePG.xml to my project and also its controller file.
    5) Personalized the new page and added the new column ( supplier name). But when i see the output of the page the new column is added but the data is blank.

    Kindly let me know if i am missing some steps while creating the VO or some class path variable setting or some files need to be included in my project.

    regards,

    Rajesh Khatri

    DB:2.84:Oaf- Tutorial Exercise - Extending Vo 91

    Dear Rajkumar,

    I am getting the value now. I had not given the correct view attribute during personalization. Currently i am running the page from Jdeveloper.

    Thanks a lot for your support.

    Rajesh Khatri

  • RELEVANCY SCORE 2.84

    DB:2.84:Re: Java.Sql.Sqlexception: Missing In Or Out Parameter At Index:: 4 df


    Hi John,

    This is one of the tough exception in OAF "oracle.jbo.SQLStmtException: JBO-27122". As I understood from your query you are trying to fetch a value from database using the stored function "XXCED_POEXT006_REQ_BO_PKG.GET_ITEM_AVAIL_RESER_QTY(:7,MtlSecondaryInventories.SECONDARY_INVENTORY_NAME,:6)" where MtlSecondaryInventories.SECONDARY_INVENTORY_NAME is a VO columns and :6 and :7 are positional parameters that VO accept at runtime.
    I think you should follow some other approach instead of modifying VO base query. You can add a field through personlization and then call this function through CallableStatement at page Controller Class where you can set the value of that field.

    Regards,

    Haroon

    DB:2.84:Re: Java.Sql.Sqlexception: Missing In Or Out Parameter At Index:: 4 df

    Anymore suggestions.Still throwing an error.It is an urgent requirement.

    Thanks
    John

  • RELEVANCY SCORE 2.84

    DB:2.84:How To Pass A Parameter To A Sql-Derived Attribute zd


    Hi. I'm new to the OAF technology. We're writing custom pages as extension to Oracle Apps. I created a View Object based on a query and one of the attributes is derived from a db procedure. The call to the db procedure requires a parameter whose value is coming from a different VO. Is this possible at all? Any help is very much appreciated.

    Thanks,
    Narissa

    DB:2.84:How To Pass A Parameter To A Sql-Derived Attribute zd

    hi

    your approach should be like this

    1.) extend the controller related to VO from which value is coming .

    2.) in the extended CO get the value from VO ,and created a simple set method and get method in the same extended CO ,call the set method to set the value which is coming from VO .

    3.) now in your extended Vo class u can call the get method of extended CO and can the that value which is coming from the previous VO

    thanx

    Pratap

  • RELEVANCY SCORE 2.84

    DB:2.84:Re: Vo Extension Of Advance Table s8


    Not sure, if something is going wrong in the attribute set up ( one of the set ups in VO extn) . I checked the properties of the exsting VO properties. It is same.

    DB:2.84:Re: Vo Extension Of Advance Table s8

    Hi,
    I saw one of your update on the thread Dynamic Switcher Region
    is this related to the same issue?

    And still you are facing the error in the VO Extn?

    Thanks,

    With regards,
    Kali.
    OSSi.

  • RELEVANCY SCORE 2.83

    DB:2.83:Error While Trying To Add A New Field In Search Criteria By Vo Extension 37


    Hi,
    I am trying to add a new field by using the VO extension to a seeded OAF page used to search Repository contracts.
    I get the following error on opening the page after I have compiled my code on server and bounced apache.
    Message not found. Application: FND, Message Name: FND_VIEWOBJECT_NOT_FOUND. Tokens: VONAME =SSPN_AdvancedSearchAttributesPVO; APPLICATION_MODULE = oracle.apps.okc.repository.search.server.ContractsAdvSearchAM;

    I extended the AM also after this to include the extended VO but still the error comes.

    This page is a dynamic search page where the results change based on the different search criteria.

    Cheers
    Swati

    DB:2.83:Error While Trying To Add A New Field In Search Criteria By Vo Extension 37

    I removed the AM extension.
    In the the View Instance property of the item while adding it I had put the VO name as AdvancedSearchAttributesPVO but actually I should put it as AdvancedSearchAttributesPVO1. I did this and error was gone.

  • RELEVANCY SCORE 2.83

    DB:2.83:Vo Extension Problem x1


    Hi oaf experts,

    I have a requirement to add 3 input items in a page.which will store in a custom table after clicking on save button
    So i extended VO(EO based VO),it's not working.
    i tried so many ways..

    posted in forum also

    Re: Error Msg : FND, Message Name: FND_VIEWOBJECT_NOT_FOUND

    Re: Extending EO based VO_new columns becoming Transient

    atlast i have created one new region,created 3 items in that.(created EO,VO,AM,CO and attached to region)

    now its working ,the custom values are storing in custom table.

    -----------------------------------------------------------

    ( a page is having both create and update buttons-- by clicking on create button one page will open.
    the above requirement is for create page which isdone.

    by clicking on Update button the above same page will be opend.with 3 new fileds,
    here the requiremnet is the 3 new fields should display the values(which are message text input items)

    how to achieve this thing.

    thanks.

    Edited by: user12260892 on Jan 4, 2011 10:42 PM

    DB:2.83:Vo Extension Problem x1

    Since you need to insert data into custom table, why dont you do it using plsql procedure ?

    Refer

    How to call the PL/SQL procedure from OAF.

    -Aanand

  • RELEVANCY SCORE 2.83

    DB:2.83:Is It Recommended To Delete All Content Of Myclasses &Amp; Myproject Folders? 33


    Hello all,
    I've got to do my first OAF VO extension. (hard work for a beginner!) Now.. I'm going to continue doing extensions and more... but my doubt is: Do i need to set in blank my local folders myclasses and myprojects (in JDeveloper structure) ? or.. is it recommended to have "clearer" new projects..?
    If not.. what are the mininum files and/or folders that these two directory must have?

    Thanks.

    DB:2.83:Is It Recommended To Delete All Content Of Myclasses &Amp; Myproject Folders? 33

    Just to add a point. At times it is good to delete the myclasses file if you see your code changes are not reflecting in Jdeveloper. This way you force the system to compile the java files again. But never ever delete myprojects...

    Regards
    Sumit

  • RELEVANCY SCORE 2.81

    DB:2.81:To Start Of With Oaf Extension cf


    Hi all,
    I am beginner to OAF. I have few personlization required using SPEL to make a column mandatory based on condition.
    I have gone through the threads in this forum and got an idea of how to do.
    My basic doubt is how to start it of. I got from the About page the details of the AM and VO objects, but how can i get the location where it is in the database.
    And how the class file can be used to add the objects.
    I am totally struck up. I am not able to understand what its stated in Devloper guide.
    I have been searching on this for entire 2 days..

    Please help me in this case on how to start with basics like getting the file from the server and the next steps to proceed..

    Regards

    DB:2.81:To Start Of With Oaf Extension cf

    First, in order to assign a value to SPEL, you'll need to create a custom VO. Here's a sample query I've used to create my VO to pull data pertainining to if an Attribute should be mandatory/rendered.

    SELECT min(descriptive_flex_context_code) descriptive_flex_context_code, min(Enabled) Enabled, min(END_USER_COLUMN_NAME) END_USER_COLUMN_NAME, min(required_flag) required_flag, min(application_column_name) application_column_name,
    min(xxx.LOV) LOV
    from
    (SELECT descriptive_flex_context_code,'Y' Enabled, END_USER_COLUMN_NAME, required_flag, application_column_name,
    decode(ffvv.flex_value,null,'N','Y') LOV
    FROM FND_DESCR_FLEX_COL_USAGE_VL fdfc,
    fnd_flex_values_vl ffvv
    WHERE (fdfc.APPLICATION_ID=20045)
    and (fdfc.DESCRIPTIVE_FLEXFIELD_NAME LIKE 'SPL Account Map')
    and fdfc.enabled_flag = 'Y'
    and fdfc.display_flag = 'Y'
    and fdfc.application_column_name = 'ATTRIBUTE5'
    and ffvv.flex_value_set_id(+) = fdfc.flex_value_set_id
    and rownum = 1) xxx

    Once the VO is created, I created several transient "boolean" attributes in my VO. These attributes will be assigned a value based on code I place in my *VORowImpl since this is the file which controls attribute assignments.
    But before that, in my *VOImpl, I've defined a custom method which is used to execute the VO from my AM.

    public class Ref5PVOImpl extends OAViewObjectImpl
    {
    /**
    *
    * This is the default constructor (do not remove)
    */
    public Ref5PVOImpl()
    {
    }
    public void initRef5PVO()
    {
    // setWhereClause("descriptive_flex_context_code in (select vendor_name from spl_account_map where cont_cd = :1)");
    setWhereClauseParams(null); //Always reset
    // setWhereClauseParam(0, acct);
    // System.out.println("value_selected customer "+acct);
    executeQuery();

    }
    }

    In my *VORowImpl, I've added custom code to my Attribute methods so that they return the proper values when invoked...

    public String getMakeRequired()
    {
    if (getRequiredFlag()!= null)
    {
    if ("Y".equals(getRequiredFlag()))
    //if(getMessageChoiceAttribute()==null)
    {
    System.out.println("Required returned yes");
    return "yes";
    }
    else
    {
    System.out.println("Required returned no");
    return "no";
    }
    }
    else
    {
    return "no"; //poplist will be disabled - DFF is not configured
    }
    }

    public Boolean getOptionRender()
    {
    if (getLov()!= null)
    {
    // In this method check if the Message Text Input is valid
    if ("N".equals(getLov()))
    {
    System.out.println("OptionRender returned true "+ getLov());
    return Boolean.TRUE; //text input will be enabled if no LOV exists
    }
    else
    {
    System.out.println("OptionRender returned false "+ getLov());
    return Boolean.FALSE; //text input will be disabled if LOV exists
    }
    }
    else
    {
    return Boolean.FALSE; //text input will be disabled - DFF is not configured
    }
    }

    Then add your SPEL directive into your field's Property inpector...

    ${oa.Ref5PVO1.MakeRequired}

    ${oa.Ref5PVO1.OptionRender}

    Hope this helps...
    -Scott

  • RELEVANCY SCORE 2.81

    DB:2.81:Re: Disable Autocomplete Feature In Oaf 13


    Hi,

    any updates plz ..how to disable autocomplete in oaf

    DB:2.81:Re: Disable Autocomplete Feature In Oaf 13

    Hi,
    What I meant is, you can extend the controller and get the TextInputBean items handle and set the javascript.
    Thanks,

    With regards,
    Kali.
    OSSi.

  • RELEVANCY SCORE 2.81

    DB:2.81:Re: Oaf: "Back" Button Looses All Populated Values Thru Extension On Base Page. z7


    I thought that you created the pages so suggested you to retain the AM in the code while navigating from page 1 to page 2, but since this is not the case, we need to think of something else based on the reply to the following query.

    Are the seeded attributes getting retained and only the custom attributes that you have populated using the extended VO are getting lost ?

    Thanks,
    Tapash

    DB:2.81:Re: Oaf: "Back" Button Looses All Populated Values Thru Extension On Base Page. z7

    I think this thread is similar to this
    Re: how to enable the partial page rendering property at runtime

    If it is the same, then Ram is following up on that thread.

    Thanks
    Tapash

  • RELEVANCY SCORE 2.80

    DB:2.80:Re: Deep Into Oaf...T1-Extension And Personalization. pf


    jvm would not do anything on its own except or loading the classes, providing heap space for holding the object and provide the execution environment.
    All the logic that you say is there in OAF classes and jvm just executes what it gets.

    Tapash

    DB:2.80:Re: Deep Into Oaf...T1-Extension And Personalization. pf

    I favor learning things deep down, but I feel that at the moment the forum has not matured to that level, and we have bigger fish to catch.
    Moreover, the thread was not going anywhere, as we all were just speculating that FWK might be doing this or that, nothing conclusive.

    That explains why I was away from this thread :)

    Abdul, Unless you have worked for that particular tech stack development part or have gone through the underlying code, it would be impossible to put the complete details. There are lot of questions, but unless someone tries all those different scenarios together, again no concrete output. And looking at the day to day professional life pressure, i don't think someone will voluntarily spend that amount of time just to enlighten others :)

    --Shiv

  • RELEVANCY SCORE 2.80

    DB:2.80:What Is Difference B/W Oaf And Oaf Extension kc


    hi all,

    I was studying oa Framework, but I was confused when I come to know the terms of oaf extension and jsp.
    How can we identify which forms are oaf and jsp and all are designed in jdeveloper?

    Thanks

    DB:2.80:What Is Difference B/W Oaf And Oaf Extension kc

    Hello,

    I apologize for the late reply.

    TO know the procedure and the extension of building .OAF pages in EBS, visit, http://www.slideshare.net/iwareoracle/extensions-in-oaf (It has screenshots to explain you better).

    For building up a separate application that does not need to integrate at all with the E-Business suite, we need AJAX-style rich content page and for that we commonly use .JSP as the extension.

    While, for building up the application which is tightly integrated with the E-Business Suite, and that application needs EBS capapbilities (Like) Flexfields and personalization, we use OAF and the extension is OAF.

    Hope it helps !

    Queries Invited.

    Regards,
    Udit

    Edited by: Udit Kulshrestha on Aug 14, 2012 12:14 AM

  • RELEVANCY SCORE 2.80

    DB:2.80:Re: Update Query For Advanced Table. xz


    Hi,

    calling PL/SQL procedure can be a better solution if you are new to OAF.

    Iterate through your VO and then call PL/SQL procedure to save the data in tables.

    Please share the requirement and reason why you created one advanced table based on multiple EO's.

    Regards,
    Reetesh Sharma

    DB:2.80:Re: Update Query For Advanced Table. xz

    Thanks Riteesh for your help.

    I was able to resolve this but taking the default view object and for seeing the interface defination name I created a new default VO that I took in the Picklist View Definition.
    Now both the Picklist Value Attribute and the BC4J View Attribute is InterfaceIdNo.

    OAF is intelligent to pick the correct current value for Interface name ,so yes I did not require the join query altogether..

    thanks to both OAF and you :)

    Regards,
    Vishal

  • RELEVANCY SCORE 2.80

    DB:2.80:Extension Oaf Seeded Code kc


    Hi,
    What are all the things to be taken care while working for Extension on OAF and more over if i want to modify standard screen of Oracle (OAF) where the VO query have to be changed in its whereClause which is been dynamically added in VOImpl and VORowImpl so can i extend this. If yes what are the steps. If no what is the approach to fullfill this objective.
    Thanks.
    Suraj

    DB:2.80:Extension Oaf Seeded Code kc

    Hey Kali, I was just kidding, knew that was a typo.
    Thanks
    Tapash

  • RELEVANCY SCORE 2.80

    DB:2.80:Re: Oaf ks


    a) Go to at oracle.apps.aso.print.webui.MainCO.processRequest(MainCO.java:180). Get the AM method being invoked.
    b) In AM for tha VO, some bind parameter is being set, probably using setWhereClauseParams, but that bindVariable doesn`t exist in the sql query. Make sure you are using names in setWhereClauseParam instead of numbers.
    c) Check Binding Style in SQL statement tab for the VO. It should be set to Oracle Named

    DB:2.80:Re: Oaf ks

    paste the original query, and your new code.

  • RELEVANCY SCORE 2.80

    DB:2.80:Re: Need Help On Oa Frame Work Extension jd


    I guess a VO extension is already in place. You are trying to extend the extended VO. use jdr_utils.listcustomization to see if the VO extension is already created for the standard VO. Then you can proceed accordingly.Thanks,Viswanath

    DB:2.80:Re: Need Help On Oa Frame Work Extension jd

    Mohan, You should make the Work Order Type has PPR enabled by adding the above code in PR of CO.Then you handle the event in PFR. Inside the if condition,you set the transient attributes value to true or false. Based on the value set to the transient attribute, the other item(item which was personalized with value ${oa.voname.attr}) will rendered .Thanks,Viswanath

  • RELEVANCY SCORE 2.80

    DB:2.80:Oaf View Extension kf


    Hi,
    I have done view object extension in R12. My vo contain po_num and i added one trisient attribute. on the basis of po_num attribte i want to a use callable/prepared statement and assign the value to my trisent attribute at run time.view object can contain multiple row so how can i achive thid thing in VOImplROWImpl.

    DB:2.80:Oaf View Extension kf

    Hi,

    You can achieve this by two way:

    1. Controller:

    In processRequest, handle the extended vo.
    For ex - Seeded VO Name - POVO
    Extended VO - XXPOVO

    OAViewObject poVO=pageContext.getRootApplicationModule().findViewObject("POVO");
    Rows[] allRows=poVO.getAllRowsInRange();

    for(int i=0;iallRows.length;i++){
    XXPOVORowImpl curRow=(XXPOVORowImpl)allRows;
    int poNum=curRow.getPoNum();

    ur condition

    curRow.setTransientAttr("value to be set");

    }

    2. VORowImpl:
    in getTransientAttr() method return the value based on getPoNum().

    Regards,
    SAN