• RELEVANCY SCORE 3.72

    DB:3.72:Form &Amp; Lov Question 1c





    Hy,
    I builded a form on a procedure, which is editing entrys in two database tables.
    one in database table "PERSON" and the other one in "TEXT".
    Problem is that i changed the first textfield of the form into a selectlist with a 'LOV'.
    And now the LOV overrides the value of that item.
    I would like that the value which is given to that item, is still the first value in the selectlist but converted in one of the lov-values.
    is that possible ?

    Would be glad if someone could help me with that issue?
    philippsen

    DB:3.72:Form &Amp; Lov Question 1c

    Hy,
    what does PIPE ROW (my_record); do?
    How do i generate the return value?

    philipsen

  • RELEVANCY SCORE 3.42

    DB:3.42:Popup Key Lov On Tabular Form Element zp





    Basic question here, can I create a popup key lov on a tabular form element.

    When I create a popup lov (named) on the tabular form element, the lov displays the display_value within the popup window, but returns the key_value into the tabular form.

    There is no "popup key lov" on the tabular form element. Is this by design? Is there another way to do this?

    Thanks,

    Jerry

    DB:3.42:Popup Key Lov On Tabular Form Element zp

    I still haven't heard when this will be included as part of the report attribute tab, but have found a work-around. In your sql query you can use the apex_item package to do all the formatting you do in the report attribute section and if you go this route you can use the popup_key_from_lov package. Here's a link to the 3.0 user guide on the API.
    http://download.oracle.com/docs/cd/B32472_01/doc/appdev.300/b32471/api.htm#CHDHJICI

    As an example, if you currently had a tabular form with a query like:

    select empno, emp_name, dept_no

    and you wanted to make a popup key lov you can call the apex_item package directly in your query:

    select empno, emp_name, SELECT APEX_ITEM.POPUPKEY_FROM_LOV (3,dept_no,'DEPT') dept

    The first first parm is the column position. Internally, use of this function uses then next position as well (not on the screen though) so your next column would need to use 5 as the first parm. Hope that makes sense. A little reading of the link and it should be clear.

    I've read in a forum that if you use apex_item in your query you should not use the report attribute tab to format your report because the engine can not correctly keep track of column positions. I'm very new to this, so am not 100% sure on this. In my tabular form I'm mixing them and it seems to work (so far).

    (I really wonder why it's taking so long to get this added so you can add this attribute through the GUI with out having to mess with apex_item. I'm not a coder, so really don't like having to deviate off the path)

  • RELEVANCY SCORE 3.42

    DB:3.42:Adding A Value To An Lov In An Oracle Apps Form x1





    Hi Guys

    Im new to forms and customizations in apps as im sure will be apparent with the questions i have :-)I have a requirement to add a value to an LOV on a field in an oracle apps form.

    My question is

    1: How do i get the lov query?

    2: How do i edit an existing query.

    3: How can i solve this problem.

    Thanks

    DB:3.42:Adding A Value To An Lov In An Oracle Apps Form x1

    Hi Craig

    Ive worked with Value sets before and have used them with Concurrent program parameters but wasn't sure if they could be used with form fields.
    From your answer it seems like they can be so I'll look it up.

    Thanks for your help and yeah will keep in mind to post these EBS related questions in the right forum.

    J

  • RELEVANCY SCORE 3.27

    DB:3.27:Need To Show Default Value In A Form kx


    hi this is azhar..i have a question..

    i have created a form that displays values using a dyanimc lov however i need to show the default value as 'NA' which is one of the values in the lov..plz let me knw ...

    DB:3.27:Need To Show Default Value In A Form kx

    Hello Azhar,
    Just set the "Initial Value" property of the LOV's associated item to "NA".

    Hope this helps.
    Craig...

  • RELEVANCY SCORE 3.27

    DB:3.27:How To Create A Dynamic Lov &Amp; Rg On Runtime 97


    Hi all,Can anyone please tell me how to create dynamic LOV assign dynamic RG to it on run time according to previous data seletion.thanks regards.

    DB:3.27:How To Create A Dynamic Lov &Amp; Rg On Runtime 97


    949920 wrote:...
    Can anyone please tell me how to create dynamic LOV assign dynamic RG to it on run time according to previous data seletion.

    An LOV can only be defined during design. Once created, you can dynamically create and assign the Record Group (RG) that supplies the data to the LOV. This can be a drawback, but it is the way Forms works. If you need different layouts and column mapping from an LOV that is dependent upon choices a user makes during runtime, then you will need to create a seperate LOV for each situation in the Forms Builder. Then you can programatically assign LOV's to an item based on the user's choices as well as create/assign different RG's as needed during runtime.Craig...

  • RELEVANCY SCORE 3.26

    DB:3.26:When Value Doesn't Exist In Lov zs


    Hello Gurus,

    tried searching the forum for :

    I need to call a form when value doesn't exist in LOV
    then open form to add the new value to the LOV
    refresh the LOV in the called form

    Could you please help

    working on forms6i+10g

    DB:3.26:When Value Doesn't Exist In Lov zs

    Hi LTaura

    I need to call a form when value doesn't exist in LOV One solution to do this is to use the record group of the select statement as..

    BEGIN

    SELECT
    INTO variable value or for value
    FROM
    WHERE EMP_ID =:LOV_VALUE ENTERED;

    EXCEPTION

    WHEN NO_DATA_FOUND THEN

    MESSAGE ('No such value exist');

    CALL_FORM ('FORM_NAME');
    :GLOBAL.NEW_VALUE := :LOV_VALUE ENTERED;

    END;Well, now we catch the value in the exception in a Global variable...

    Form2 is opened now...

    In When-New-Form-Instance Trigger of form2 u will receive the value which doesn't exist in the related destination of such a form item called whatever...

    :form_item_name :=:GLOBAL.NEW_VALUE;Then u made the necessary changes save Form2 Now the new value of the Look Up Table is saved kept in the data base So the new LOV value will be successfully displayed when u click on the button of LOV.

    Hope this helps...

    Regards,

    Amatu Allah

  • RELEVANCY SCORE 3.18

    DB:3.18:Apex 4.0 Tabular Form - Lov Column Label Suddenly Displays Next To Data sk


    Hello. My question: How to hide/omit column labels that display next to LOV fields on a "manually created" tabular form? With APEX v4.0 installed, my manually created tabular form LOV fields are now displaying a column label next to them on the row. The database table column name is the label value. Before v4.0, only a column heading displayed above the LOV fields. Now both a column heading and a column label display for each LOV field. The Text fields display as before - having only a column heading. The label tag in the generated HTML is the same for both LOV and Text fields. An LOV field excerpt: {td headers="Trip Type" class="t20data"label for="f03_0003" class="hideMe508"TRIP_TYPE/labelselect name="f03" onChange="getFlightHours(this);" id="f03_0003"option value=""-/optionoption value="GHA" GHA/option .... (truncated for brevity)}. In case not all relevant info has been provided, please request more. Thank you.

    Edited by: BernardB on Jul 31, 2011 11:31 AM

    DB:3.18:Apex 4.0 Tabular Form - Lov Column Label Suddenly Displays Next To Data sk

    Hello. My question: How to hide/omit column labels that display next to LOV fields on a "manually created" tabular form? With APEX v4.0 installed, my manually created tabular form LOV fields are now displaying a column label next to them on the row. The database table column name is the label value. Before v4.0, only a column heading displayed above the LOV fields. Now both a column heading and a column label display for each LOV field. The Text fields display as before - having only a column heading. The label tag in the generated HTML is the same for both LOV and Text fields. An LOV field excerpt: {td headers="Trip Type" class="t20data"label for="f03_0003" class="hideMe508"TRIP_TYPE/labelselect name="f03" onChange="getFlightHours(this);" id="f03_0003"option value=""-/optionoption value="GHA" GHA/option .... (truncated for brevity)}. In case not all relevant info has been provided, please request more. Thank you.

    Edited by: BernardB on Jul 31, 2011 11:31 AM

  • RELEVANCY SCORE 3.16

    DB:3.16:Changes Lov For Category Field In Attachments Form 3k


    Hi,

    Is it possible to changes LOV for category field in attachments form ?

    rgds,
    eldin

    DB:3.16:Changes Lov For Category Field In Attachments Form 3k

    Is that in a form or html ?
    because I can not find it in a form

    thanking you in advance.

    eldin

  • RELEVANCY SCORE 3.15

    DB:3.15:Lov In Form Builder m8


    Hi,

    How can i move the LOV item up/down with the help of mouse roller.

    DB:3.15:Lov In Form Builder m8

    Hi,

    How can i move the LOV item up/down with the help of mouse roller.

  • RELEVANCY SCORE 3.13

    DB:3.13:Tabular Form - Displaying Number Of Rows Using Static Lov 1s


    hello,

    I have a tabular form report, in this I want to display number of rows.
    For this I have created an static LOVfor no of rows and passed a list of values say 10;10,25;25,50;50.....1000;1000
    but my question is like how can i display all the rows of the tabular form using the static lov ( like by having one of the values in LOV as ALL for no of rows to be displayed).

    can anyone help me out with this.

  • RELEVANCY SCORE 3.12

    DB:3.12:Question - Javascript With Lov 1a


    Hi,
    When a value of formfield(uses "pop-up LOV" to display) in Data Entry Form changes I want to dynamically change the value(eg: quantity) of another field in the form.

    I was able to call javascript [onChange="javascript:doSubmit('REQ');"] in the text field (instead of LOV type)and it works fine as I wanted it to. REQ is a after submit pl/sql process that calculates the quantity, price, etc. When I change the value of "text field" column then onChange javascript fires but when that field is based on LOV and I change the value (using LOV) then the javascript doesn't fire the change.

    Is there any sequence when does the javascript fires? I believe the LOV also uses javascript function, correct me if I am wrong.

    Could someone help me how to solve this? Thanks for your time.

    Taj

    DB:3.12:Question - Javascript With Lov 1a

    Tyler, Scott or anyone for some insights please. Thanks!

    Taj

  • RELEVANCY SCORE 3.12

    DB:3.12:Lov For Validation pz


    Hi there !
    I designed a form with a field which has a LOV. This field is not a database item, e.g. name of customer. The referring db item is the customer no. I have set "LOV for validation" to true. Now the problem is each time the form is opened and automatically queried (to show a spec. db record) the record status changes from "QUERY" to "CHANGED". When I set "LOV for validation" to false, this does not happen. How can I avoid this behaviour, because I am closing the form with "EXIT_FORM(ASK_COMMIT)". And the question to commit changes always shows up even if the user didn't chamge anything.
    Can anyone help me about this ?
    Regards,
    Kai
    null

    DB:3.12:Lov For Validation pz

    You're right. I'm using a POST-QUERY-Trigger, but I reset the record status there.
    I tested the form with "validate from LOV" with true (record_status = CHANGED) and with false (record_status = QUERY). So the problem is located in setting this property.
    null

  • RELEVANCY SCORE 3.06

    DB:3.06:Urgent Messagelovinput Question...... 7a


    Hi,

    I building one custom page. I that there is one Customer Lov(torch). I am getting

    Customer Id in the Process Form Request method

    if(pageContext.isLovEvent()){
    String lovInputSourceId = pageContext.getParameter(SOURCE_PARAM);
    .........
    .........
    }

    I need to display Customer Location in another Lov(torch) depending on customer id(user selection).

    How can i achieve this?

    When user selects Customer how can i dynamically display another Location Lov with the values..?

    Thanks in Advance.

    DB:3.06:Urgent Messagelovinput Question...... 7a

    Use search facility on forum. You will find more than 10-20 threads on similar issue.

    --Shiv

  • RELEVANCY SCORE 3.06

    DB:3.06:Lov , Execute-Query, Enter-Mode ? 1p


    when the form load , i execute a query. Then i want to choose from an lov
    a value and execute a query for a detail block, however, when i want to update
    the queried records, it doesn't work. The query mode has to be in enter mode.
    The question is how do we implement the enter mode logic into the lov
    button.
    Please explain how to do this in detail

    null

    DB:3.06:Lov , Execute-Query, Enter-Mode ? 1p

    BLOCKQUOTEfont size="1" face="Verdana, Arial"quote:/fontHROriginally posted by FLORESR:
    THANK YOU FOR YOUR REPLY
    I tried your code , but still does not put me in "enter query" mode to update or insert records on the detail block after your code is executed.

    HR/BLOCKQUOTE

    null

  • RELEVANCY SCORE 3.05

    DB:3.05:Lov Question m8


    Have a select list, the select list is a LOV. I need the LOV to display 2 different lists based on user groups in the same apex page ? Is it doable?

    example:
    group A: LOV will display V,W,X,Y,Z
    group B: LOV will display W,X

    Thanks.

    Wan

    DB:3.05:Lov Question m8

    Post APEX Q.s in the APEX Forum

    Oracle Application Express (APEX)

  • RELEVANCY SCORE 3.05

    DB:3.05:Lovs Again! How To Return Multiple Fields To Calling Form 9z


    Hi

    Newbie question, any help GREATLY appreciated :)

    Is there a simple and easy way to return more than one field from a LOV.

    I need this as I have a composite fk comprised of 2 fields, and as such need to return 2 fields from the LOV to the calling form.

    (My environment: JDeveloper 9.0.5.2 build 1618)

    CM

    DB:3.05:Lovs Again! How To Return Multiple Fields To Calling Form 9z

    Ah, I just found this old post of mine, and for future reference, realised that there's an easier way of doing it. See my more recent post:

    Re: Can return messageLovinput more than one value?

    The JavaBean method will work, but it's overkill when you can use the session to do the same thing.

    CM.

  • RELEVANCY SCORE 3.05

    DB:3.05:How To Create Popup Key Lov Item In A Tabular Form 99


    I have a tabular form and wanta create Popup Key LOV (Displays Description, Returns Key Value) Item. How to acheive it?
    ( only Popup Lov (Named LOV) and Popup LOV(Query Based Lov) avaiable in the drop-down menu of ITEM in a tabular form.)

    Thanks.
    Jen

  • RELEVANCY SCORE 3.01

    DB:3.01:Popup Lov (Display Description, Return Key), Query &Amp; Copy Return Results sp


    Suppose one used a PopUp LOV (display description, return key) on a master form.
    ie. select field_name||' - '||field_region d, field_id r
    from plants;
    Based on the PopUp row selected, in this case field_id, I would like to query the last record that someone entered on that field_id from observations table. Take the results and update my master record so the users would not have to fill out the master form everytime. This would allow the users to only have to modify a smaller set of items.
    Also, is this possible without a master page submit?
    Thanks!

  • RELEVANCY SCORE 3.01

    DB:3.01:Unable To Save Selected Lov Value After Form Submit 8f


  • RELEVANCY SCORE 3.01

    DB:3.01:Disable Lov In Tabular Form pf


    Hi,

    I have a tabular form with a LOV. Depending on value of this LOV I have to disable it, but when I will add a new row, this LOV must be enabled. How can I do that?

    Thanks
    Ricardo

    DB:3.01:Disable Lov In Tabular Form pf

    Hi,

    I have a tabular form with a LOV. Depending on value of this LOV I have to disable it, but when I will add a new row, this LOV must be enabled. How can I do that?

    Thanks
    Ricardo

  • RELEVANCY SCORE 3.01

    DB:3.01:Lov Issue Urgent z3


    Hi friends,

    please help on below issue

    1) if we enter % in LOV base filed , process form request event is not firing, how to get process form request handling when we enter %in LOV base filed.. please this is an urgent

    2)but if i click LOV torch then process form request event is executing

    Thanks
    krish.

    DB:3.01:Lov Issue Urgent z3

    this below is my PFR , page controller code

    public void processFormRequest(OAPageContext pageContext, OAWebBean webBean)
    {

    super.processFormRequest(pageContext, webBean);

    OAApplicationModule am = pageContext.getApplicationModule(webBean);

    if(pageContext.isLoggingEnabled(1))
    pageContext.writeDiagnostics(this,
    "---i am @ processformRequest()::Apraise person Id : " +
    null, OAFwkConstants.STATEMENT);

    if(pageContext.isLoggingEnabled(1))
    pageContext.writeDiagnostics(this,
    "---i am @ processformRequest()::Apraise person Id : " +
    null, OAFwkConstants.STATEMENT);

    String rowReference =
    pageContext.getParameter(OAWebBeanConstants.EVENT_SOURCE_ROW_REFERENCE);
    OARow RowEvent = (OARow)am.findRowByRef(rowReference);

    if(rowReference!=null)
    {
    String DestinationTypeCode =
    RowEvent.getAttribute("DestinationTypeCode").toString();
    if(pageContext.isLoggingEnabled(1))
    pageContext.writeDiagnostics(this,
    "---i am @ processformRequest()::Display DestinationTypeCode : " +
    DestinationTypeCode,
    OAFwkConstants.STATEMENT);

    if(RowEvent.getAttribute("ItemId")==null)
    {
    Number nitemid=null;

    if(pageContext.isLoggingEnabled(1))
    pageContext.writeDiagnostics(this,
    "---i am @ processformRequest()::Display itemid : " +
    nitemid,
    OAFwkConstants.STATEMENT);

    if ((DestinationTypeCode.equalsIgnoreCase("EXPENSE") || DestinationTypeCode.equalsIgnoreCase("MAINTENANCE")))
    {
    if(pageContext.isLoggingEnabled(1))
    pageContext.writeDiagnostics(this,
    "---i am @ processformRequest()::inside condition : " +
    DestinationTypeCode,
    OAFwkConstants.STATEMENT);
    pageContext.writeDiagnostics(this,
    "---i am @ processformRequest()::inside condition : " +
    nitemid,
    OAFwkConstants.STATEMENT);

    String MyWhereClause = "exists (select 1 from mtl_parameters " +
    "where ORGANIZATION_ID=qrslt.deliver_to_org_id " +
    "and process_enabled_flag='N')";
    pageContext.putSessionValue("MyWhereClause",MyWhereClause);
    pageContext.putParameter("MyWhereClause",MyWhereClause);
    pageContext.putTransactionValue("MyWhereClause",MyWhereClause);

    }
    }
    else
    {

    pageContext.putSessionValue("MyWhereClause","");
    }

    }
    }

    Regards
    krish.

  • RELEVANCY SCORE 3.00

    DB:3.00:Popup-Lov Referencing To Lov In A Tabular Form f8


    Hello,

    I have a tabular form with a lot of columns. One of them is a lov and one is a popup-lov. The values of the popup-lov should reference to the selected item of the lov.

    If I use ":Field" the popup-lov is empty. How can I reference to the column?

    Thx in advance!!!

    DB:3.00:Popup-Lov Referencing To Lov In A Tabular Form f8

    I get the value of the column with "apex_application.g_f01 (i)". Problem is that I don't know in which row somebody has clicked the symbol for the Popup-lov.
    Is it possible to get the row?

    In the corner of the browser stands "javascript: genList0_f07_3()". The last number is the row. It is possible to get the value for the row?

    Thx in advance!

  • RELEVANCY SCORE 3.00

    DB:3.00:Passing Of Lov fp


    How to PASS LOV (List of Values) from one form to another ?

    DB:3.00:Passing Of Lov fp

    Hi

    You cannot pass of lov, whatm you can share is REcord groups. If you are using Forms 6i refer to the online help about global record groups.

    Once you share record groups, you can create another LOV in the second form based on the Record group.

    HTH
    Arvind Balaraman

  • RELEVANCY SCORE 2.99

    DB:2.99:Multiple Select Lov Crashes In Developer 6i, Patch 5 k8


    We are using a multiple select LOV in a form previously working well (Developer 6i, patch 3). Now we have installed patch 5 and Designer release 3. The LOV is still opening but when we try to apply the selected records from the LOV the form crashes.

    DB:2.99:Multiple Select Lov Crashes In Developer 6i, Patch 5 k8

    Peter,

    I'm sorry, I have maked a mistake in my previous topic! I ment: Using Designer 6i release 3 and Developer patch 3b multiple select LOV's are working well.

    Kind regards,
    Oscar

  • RELEVANCY SCORE 2.99

    DB:2.99:Lov Form Frm-41003 &Amp; 40111 At Last Block zc


    I'm using Headstart and Designer 10 g to generate forms.

    On the lov form I'm getting FRM-41003 THis function cannot be performed here.

    On Find button I get FRM-40111 at last block

    I have only two blocks in this LOV form and the last block is QMS_LOV_BLOCK

    Any help.

    Thanks
    Vimal

    DB:2.99:Lov Form Frm-41003 &Amp; 40111 At Last Block zc

    I'm using Headstart and Designer 10 g to generate forms.

    On the lov form I'm getting FRM-41003 THis function cannot be performed here.

    On Find button I get FRM-40111 at last block

    I have only two blocks in this LOV form and the last block is QMS_LOV_BLOCK

    Any help.

    Thanks
    Vimal

  • RELEVANCY SCORE 2.99

    DB:2.99:Using Lov On Portal Form 7f


    This is a very simple question but I can't get it to work.

    I need to populate a form field with the value of a LOV. It's telling me that I can't associate a database table field with a LOV.

    If I create a custom field and associate a LOV, then how do I get the value to populate the database field.

    Femi

    DB:2.99:Using Lov On Portal Form 7f

    This is how I've done it. The code is in the onChange event for the combobox.

    var pieces = this.name.split('.');
    var myname = new String(pieces[0] + '.MASTER_BLOCK.SELECT_CO.01');
    var myname1 = new String(pieces[0] + '.MASTER_BLOCK.COMPANY_ID.01');
    var myname2 = new String(pieces[0] + '.MASTER_BLOCK.NAME.01');
    var ActionList = new String(pieces[0] +'.MASTER_BLOCK.MASTER_ACTION.01');
    {
    form.elements[eval(myname1)].value = form.elements[eval(myname)].options[selectedIndex].value;
    form.elements[eval(myname2)].value = form.elements[eval(myname)].options[selectedIndex].text;
    }

  • RELEVANCY SCORE 2.99

    DB:2.99:Execute Query From Lov sj


    Hi
    There is a Button that run LOV(Show LOV) ,
    how could make the Form Execute Query According to the user Selection from that LOV?

    Thanks

    DB:2.99:Execute Query From Lov sj

    I am unable to get the following code to work to perform a query based on an LOV. I've created a non-database item in a separate block to store the lov. When I attempt the query I receive FRM-40112 GO_ITEM TO NON-ENABLED ITEM. The item is query/insert enabled. Thoughts?

    DECLARE
    lov_value boolean;
    BEGIN
    go_item('BLOCK.FIELD');
    lov_value := show_lov('LOV');
    if not lov_value then
    exit_form; --Cancels the 'Enter-Query' Mode
    else
    execute_query;
    end if;

    END;

  • RELEVANCY SCORE 2.99

    DB:2.99:Populate Detail With Data km


    So, I have a form employee and I want to populate details when I pick one from LOV.
    The question is how can I position on specific record with key and display details on form?

    DB:2.99:Populate Detail With Data km

    If you used the wizard to create your master detail, then when you select a master, the detail for that master will display automatically.

  • RELEVANCY SCORE 2.97

    DB:2.97:How To Attach Item Lov To New Customized Form. 73


    Is it possible to attach Item Lov to new customized form in EBS12.04.
    For example
    I have created new form and i want to attach LOV of Item like in Requisition Form a LOV attached with Item Text Box.

    DB:2.97:How To Attach Item Lov To New Customized Form. 73

    Thanks avajain for reply,

    I can create new lov and attach it with item. But i want to call same API or LOV which is called from Purchasing--requisition--Item . Where from you select Item Class, Sub Class, serial.

    Regards,
    Fassi

  • RELEVANCY SCORE 2.96

    DB:2.96:Lov Choice List Always Select First Value &Amp; Can't Bind To Payload Component 83


    hi guys,

    need help from the adf guru :)

    so i have a project in BPM that generate a task form, so the element in the form is already bind to the payload by the default.
    and then one of the element should be fill with the value from another database table.

    explaination :
    form field : employee number, date, absence, desc.
    employee number field should get from table employee.

    if i try to use the selectOneChoice component and bind it to a VO and payload, it works.
    but what i want to try is to use the LOV. so in the input LOV pop up form i can perform a searching like employee email, employee name and then get the employee number to put it to the field in the task form.
    and another problem is whatever value i choose in the input LOV pop up form / LOV choice list value, it always get back with the first value.
    e.g : i hv e01, e02, e03 data. if i choose e02,e03 in the LOV, then it would get back to the task form with e01 value.
    i already define the Key attribute in the VO, EO.

    so do you guys hv any solution for this case ?

    thanks

    DB:2.96:Lov Choice List Always Select First Value &Amp; Can't Bind To Payload Component 83

    Yes , i got the same problem ,but it got corrected with key attribute.

    I guess you need to check the data type now.whether you are setting the right data type of lov attribute into your db column.

    Popz

  • RELEVANCY SCORE 2.96

    DB:2.96:Uix, Lov - Not Working Properly - Jdev 9051 8a


    I am following 'How To build a LOV with ADF UIX' howto. This is what happens after I open the lov window: I select a value in the lov table and click on the submit button. The lov window is closed, the page with the input form is submitted but the value I selected from the lov table is not inserted into the form.
    I am using jdev 9.0.5.1.
    Should the form be submitted after the lov window is closed? Why isn't the value from the lov inserted into the form?

    DB:2.96:Uix, Lov - Not Working Properly - Jdev 9051 8a

    Sorry for the confusion. I did change the code but I posted the old one. I got it working now. I don't really know what was wrong. It might have been something wrong with the model, because I created a new app workspace, with new entity objects and view objects and now it works.

    Thank you!
    Jasmina

  • RELEVANCY SCORE 2.96

    DB:2.96:Customization Of Lov 9p


    How to customize a lov in a form?

    DB:2.96:Customization Of Lov 9p

    Yes you have.
    1. Go to Form Personalization, choose the action Type as Built in
    2. Choose Builtin Type = "Create Record Group from Query"
    3. Enter your query in the Argument and enter the name of the Record Group.
    4. Create 2nd Action type as Property
    5. Choose the LOV you want to change, and assign the Group Name property using the Record Group Name you created in step 3.

    HTH.

  • RELEVANCY SCORE 2.95

    DB:2.95:Lov Needs Twice Selection za


    I am facing a problem in 9i DS forms application. I have a single record master form have 3 LOV's. After entering 1 record, i go for entering 2nd record using create_record. At this time, my first LOV is automatic display its needing selection twice. Other LOV's after that need single selection, so it is okay.

    I hope, my question is clear. Please help in solving the doubt as it is urgent.

    Regards.

    DB:2.95:Lov Needs Twice Selection za

    I am facing a problem in 9i DS forms application. I have a single record master form have 3 LOV's. After entering 1 record, i go for entering 2nd record using create_record. At this time, my first LOV is automatic display its needing selection twice. Other LOV's after that need single selection, so it is okay.

    I hope, my question is clear. Please help in solving the doubt as it is urgent.

    Regards.

  • RELEVANCY SCORE 2.94

    DB:2.94:Re: Lov Problems zz


    Thanks Robert.

    Just a last question.

    When i try changing the search form MAKE_ID to NAME, when the LOV window opens it displays me with nothing. (that is becuase it tries to bind MAKE_ID to NAME).

    I have read that by giving ${param.searchText} default value '%' it will show all values in the LOV table. Can you please tell me how to pass the % value to the ${param.searchText}?

    DB:2.94:Re: Lov Problems zz

    Ah ok... if the user just navigates to the page you could handle the "null" event...

    there you could look if you should reset the query....

    Decoumentation about the "null" event can found in the UIX guidelines in the Help of JDeveloper....

  • RELEVANCY SCORE 2.93

    DB:2.93:Master Detail Dependent Lov sp


    Hi ,JDeveloper Version:11.1.2.1.0I crated a master detail form. I have an LOV in master. And an LOV in detail. LOV values in the detail should be populated based on the selection of the value in the LOV of Master.Please give suggestions or any useful links to achieve this.

    DB:2.93:Master Detail Dependent Lov sp

    Check out Building model driven dependent list with Oracle ADF BCand How-to create dependent model-driven LOVTimo

  • RELEVANCY SCORE 2.93

    DB:2.93:Can Lov Views Use Entity Objects? 3f


    Hi,
    When i tried creating LOV search form using read only view , the search form was not functioning in JDeveloper 11g studio edition.But when i added entity objects to the view the seach form functioned properly as required.

    My question is read only LOV views made the search form function properly in JDeveloper 10g ,11g TP3 and TP4 but why not in 11g staudio edition.

    regards,
    vinitha

    DB:2.93:Can Lov Views Use Entity Objects? 3f

    Hi,

    sorry, but can you provide reproducible steps of what worked for you in teh past and what has stopped working in JDeveloper 11 production. Your question as is does not provide a handle for an answer

    Frank

  • RELEVANCY SCORE 2.92

    DB:2.92:Popup Lov Question p3


    Hi All,

    popup lov query is defined as 'select name, id from tire_models'. When I try to use it in wisard-generated tabular form it returns ID value instead of NAME. But if I create the same popup lov in manually-created form via htmldb_item.popupkey_from_query(4,model_id,'select name, id from tire_models',20) model_id this works fine and the corresponding field shows expected tire name.

    Has anyone encountered this before?

    DB:2.92:Popup Lov Question p3

    Hi All,

    popup lov query is defined as 'select name, id from tire_models'. When I try to use it in wisard-generated tabular form it returns ID value instead of NAME. But if I create the same popup lov in manually-created form via htmldb_item.popupkey_from_query(4,model_id,'select name, id from tire_models',20) model_id this works fine and the corresponding field shows expected tire name.

    Has anyone encountered this before?

  • RELEVANCY SCORE 2.92

    DB:2.92:Uix And Lov Once Again dk


    Hello to all,
    is there any documentation or demos with "crystal clear examples" on how to connect a LOV with an item in an edit/update form? From what I have read so far (I am new in all this) the messageLovField needs to be used (or is this wrong?). But the big question remains .... How do you connect the LOV query with the messageLovField? I am sure I am not asking for something too strange/hard.

    Thanks in advance
    Ioanna

    DB:2.92:Uix And Lov Once Again dk

    Hello to all,
    is there any documentation or demos with "crystal clear examples" on how to connect a LOV with an item in an edit/update form? From what I have read so far (I am new in all this) the messageLovField needs to be used (or is this wrong?). But the big question remains .... How do you connect the LOV query with the messageLovField? I am sure I am not asking for something too strange/hard.

    Thanks in advance
    Ioanna

  • RELEVANCY SCORE 2.92

    DB:2.92:Work Order Less Completion Form-Help fj


    Hello Guys i have a question on WIP- Work Order Less Completion Form.

    In the form when we enter the assemebly item and go to Components--Lot/Serial, In Lot entry form there is a field called Lot number which has LOV and also allows user to enter his own Value what he needs.

    My question is is there any controls in Oracle where we can prevent user from entering his value in the LOt number field,instead he has to select it from LOV only.

    Please help me on this.

    Thanks

    DB:2.92:Work Order Less Completion Form-Help fj

    Perhaps you could think about doing some sort of forms personalization. There is a MetaLink articl [ID 395117.1] for R12. Not sure which version you are on. Hope this helps!

  • RELEVANCY SCORE 2.90

    DB:2.90:Popup Key Lov Return Value In Tabular Form k1


    Hi,i have set a column attribute as a 'Popup Key LOV (query based LOV)' in a report that i'm using. Value displays fine, also when selecting the arrow button of the Popup LOV the list of values show up as expected.My question is, can the selected item be used and update the value accordingly?Thank youTeo

    DB:2.90:Popup Key Lov Return Value In Tabular Form k1

    Hi,i have set a column attribute as a 'Popup Key LOV (query based LOV)' in a report that i'm using. Value displays fine, also when selecting the arrow button of the Popup LOV the list of values show up as expected.My question is, can the selected item be used and update the value accordingly?Thank youTeo

  • RELEVANCY SCORE 2.89

    DB:2.89:Lov Return Value Question dx


    I would like to have an LOV that displays a date along with a time period.

    Example
    11/02/2009 AM
    11/02/2009 PM
    11/03/2009 PM

    This field will show the user which time slots are available for scheduling. In the database the date and time are stored in 2 different fields. Is there a way to populate both of these fields based on the above LOV. The data is being kept on a tabular form.

    Any help would be appreciated. Thanks!

    DB:2.89:Lov Return Value Question dx

    Jeff - altho the Original Poster's user's name is, indeed, similar to mine, it isn't me!

    Marion

  • RELEVANCY SCORE 2.89

    DB:2.89:Lov Return Multiple Values zs


    I want to create an LOV that returns data into two fields.

    LOV:
    SELECT NAME
    , ID
    FROM TABLE1

    FIELDS IN FORM:

    - LU_ID
    - LU_NAME

    The field LU_ID should be hidden.
    The field LU_NAME should trigger the lov.

    The lov should return NAME into LU_NAME and ID into LU_ID

    DB:2.89:Lov Return Multiple Values zs

    Can we do anything close to it if we have more than 1 table ?

    I.e., : in table 1 : id
    name
    state_id
    table 2 : state_id,
    state_name

    LOV : label - name, value - id
    But when we know the id, we can show in textbox state_name.

    Can we make this scenario to work ?

  • RELEVANCY SCORE 2.89

    DB:2.89:How Call Lov To Other Lov 8d


    Hi master

    I have two lov when I select value form one lov that call other lov asper selecte values

    Or how call lov to other lov

    Or any lov trigger where I write our code or call next lov or give new query
    Where he on_change lov trigger

    Please give me sample or idea

    Thanking you

    Aamir

    DB:2.89:How Call Lov To Other Lov 8d

    Hi master

    I have two lov when I select value form one lov that call other lov asper selecte values

    Or how call lov to other lov

    Or any lov trigger where I write our code or call next lov or give new query
    Where he on_change lov trigger

    Please give me sample or idea

    Thanking you

    Aamir

  • RELEVANCY SCORE 2.89

    DB:2.89:Storing Last Lov Size &Amp; Position zc


    Hi experts!

    I have following task:
    After user opened LOV and resized/moved it, next time same LOV is opened it should reuse last size/position.

    I haven't found any object property which sets this behavior to default. So, I decided to program it myself.

    First attempt was to put LOV state reading code (Get_LOV_Property) after call to List_Values / Show_LOV.
    But it returned LOV's size/position being actual before opening the LOV, which means changed LOV state is not saved after exiting it.
    Then I tried to cheat with timers: I created timer before a call to List_Values, and moved LOV state reading code into WHEN-TIMER-EXPIRED trigger. But it didn't help. Seems, when LOV is opened this trigger execution is suspended. I also made tricks with WHEN-MOUSE-MOVE - same result.

    Finally, there is my question: how to implement this feature?
    I'm using Forms 6.0.

    Waiting for your help,
    Alex

    DB:2.89:Storing Last Lov Size &Amp; Position zc

    I've testet it with 6i. You're right. This feature is different implemented than e.g. get_window_property.

    That means, that you have no chance to get the correct information on those x-, y-koords. Using the WHEN-MOUSE-MOVE may solve the problem, but with forms 9i/10g those events are obsolet.

    exc. for the bad news
    Gerd

  • RELEVANCY SCORE 2.89

    DB:2.89:Some Questions (Freinds It Is Very Important &Amp; Urgent) cp


    Hi Friends !
    Following are some questions... kindly if u can help for any or all?
    Q1) Want to generate all .fmb into .fmx using DOS batch programing or any other mathod.Is it possible at all ?
    Q2) As u know when the LOV invoked it shows your columns' values
    vertically as,
    Code Name
    01 abc
    02 cdef
    03 ghijk
    My question is that,is it possible at all if i could get the LOV
    horizontally as

    Code 01 02 03 -- --
    Name abc cdef ghijk -- -- etc... For the web in normal Builder ?

    Q3) I want to print the form(Form 6i) not as we can do by using the
    default menu's option "Print" which actually print the whole screen with
    menu buttons etc..
    I want to print the all values i.e information including those values
    which we see using scroll bar in the detail data block.As we can achieve
    it using report but report is not required.I remember that someone has
    told me using TEXT_IO package's functions.
    But i did not succeeded.Can u help me in this interesting assignment ?

    Q4) Want to print the images stored in the database as other normal
    fields using report. As the query ...select code,name,image from
    employee........ or using any other method.

    Q5) For the performance of Form's LOV prob. I found the .jar files named
    E:\Oracle\ias\6iServer\Forms60\Java\f60all.jar
    But I did not find any LIB directory in the Html page of my browser etc.
    Kindly may you exactly tell me where the LIB of html of browsers is ?
    MANY MANY THANKS !
    null

    DB:2.89:Some Questions (Freinds It Is Very Important &Amp; Urgent) cp

    Hi Friends !
    Following are some questions... kindly if u can help for any or all?
    Q1) Want to generate all .fmb into .fmx using DOS batch programing or any other mathod.Is it possible at all ?
    Q2) As u know when the LOV invoked it shows your columns' values
    vertically as,
    Code Name
    01 abc
    02 cdef
    03 ghijk
    My question is that,is it possible at all if i could get the LOV
    horizontally as

    Code 01 02 03 -- --
    Name abc cdef ghijk -- -- etc... For the web in normal Builder ?

    Q3) I want to print the form(Form 6i) not as we can do by using the
    default menu's option "Print" which actually print the whole screen with
    menu buttons etc..
    I want to print the all values i.e information including those values
    which we see using scroll bar in the detail data block.As we can achieve
    it using report but report is not required.I remember that someone has
    told me using TEXT_IO package's functions.
    But i did not succeeded.Can u help me in this interesting assignment ?

    Q4) Want to print the images stored in the database as other normal
    fields using report. As the query ...select code,name,image from
    employee........ or using any other method.

    Q5) For the performance of Form's LOV prob. I found the .jar files named
    E:\Oracle\ias\6iServer\Forms60\Java\f60all.jar
    But I did not find any LIB directory in the Html page of my browser etc.
    Kindly may you exactly tell me where the LIB of html of browsers is ?
    MANY MANY THANKS !
    null

  • RELEVANCY SCORE 2.89

    DB:2.89:How One Lov Can Be Used In Multiple Fields Of Form 6i s8


    How one LOV can be used in multiple fields of Form ?
    Mean I have an LOV. I want to use this in a datablock in mulple fields and want to replace a column of LOV in these form fields.

    DB:2.89:How One Lov Can Be Used In Multiple Fields Of Form 6i s8

    Rao Qamar Rasheed wrote:
    How one LOV can be used in multiple fields of Form ?
    Mean I have an LOV. I want to use this in a datablock in mulple fields You can assign a LOV to a filed at run time. Try this
    SET_ITEM_PROPERTY('Item_name',LOV_NAME,'Name_of_LOV');want to replace a column of LOV in these form fields.You can change LOV Record group name for a lov, but not drop a column and add a column.

    Hopes this helps

  • RELEVANCY SCORE 2.88

    DB:2.88:Tabular Form Popup Key Lov Fetch First Row? 8k


    Hi all,
    I need solution for tabular form with Popup Key LOV
    just simple populate one field With Popup Key LOV with one first value from select list LOV, instead of null - by default
    when push ADD ROW
    regards
    Gordan

    DB:2.88:Tabular Form Popup Key Lov Fetch First Row? 8k

    Hi all,
    I need solution for tabular form with Popup Key LOV
    just simple populate one field With Popup Key LOV with one first value from select list LOV, instead of null - by default
    when push ADD ROW
    regards
    Gordan

  • RELEVANCY SCORE 2.88

    DB:2.88:Automatically Querying A Form Based On Lov Change kc


    I have a Portal Form that includes and Combobox LOV based on the username. My question is: How can the form authomatically query or refresh following a change to the combobox LOV?
    For example, when I select "John Smith" in the LOV, the form refreshes and queries the "John Smith" record.

    Thank you.

    Edward_Girard@bigfoot.com

    DB:2.88:Automatically Querying A Form Based On Lov Change kc

    I have a Portal Form that includes and Combobox LOV based on the username. My question is: How can the form authomatically query or refresh following a change to the combobox LOV?
    For example, when I select "John Smith" in the LOV, the form refreshes and queries the "John Smith" record.

    Thank you.

    Edward_Girard@bigfoot.com

  • RELEVANCY SCORE 2.88

    DB:2.88:Lov Problem 73


    Can somebody help me?

    Have a key-next item on a form field. If a query returns more then one row then the LOV pops up. If user does not select a value from LOV and instead cancels the LOV the form fields still get populated??????????

    What is going wrong?

    DB:2.88:Lov Problem 73

    it depends on your statement on your key-next-item. maybe you can elaborate your key-next-item trigger.

  • RELEVANCY SCORE 2.88

    DB:2.88:Reports 10g: Using Select For Lov In Parameter 7a


    Running Oracle Reports 10.1.2.0.2 on IE WEB browser.

    Using SELECT statement for LOV in Parameter form causes LOV values to display embedded in the body of the parameter form.

    There is NO LOV button and NO drop-down list.

    Anyone else find this problem?

  • RELEVANCY SCORE 2.88

    DB:2.88:Lov Needs Twice Selection zx


    I am facing a problem in 9i DS forms application. I have a single record master form have 3 LOV's. After entering 1 record, i go for entering 2nd record using create_record. At this time, my first LOV is automatic display its needing selection twice. Other LOV's after that need single selection, so it is okay.

    I hope, my question is clear. Please help in solving the doubt as it is urgent.

    Regards.

    DB:2.88:Lov Needs Twice Selection zx

    I am facing a problem in 9i DS forms application. I have a single record master form have 3 LOV's. After entering 1 record, i go for entering 2nd record using create_record. At this time, my first LOV is automatic display its needing selection twice. Other LOV's after that need single selection, so it is okay.

    I hope, my question is clear. Please help in solving the doubt as it is urgent.

    Regards.

  • RELEVANCY SCORE 2.88

    DB:2.88:Automatically Querying A Form Based On Lov Change 77


    I have a Portal Form that includes and Combobox LOV based on the username.
    My question is: How can the form authomatically query or refresh following a change to the combobox LOV?
    For example, when I select "John Smith" in the LOV, the form refreshes and queries the "John Smith" record.

    Thank you.

    Edward_Girard@bigfoot.com

    DB:2.88:Automatically Querying A Form Based On Lov Change 77

    I have a Portal Form that includes and Combobox LOV based on the username.
    My question is: How can the form authomatically query or refresh following a change to the combobox LOV?
    For example, when I select "John Smith" in the LOV, the form refreshes and queries the "John Smith" record.

    Thank you.

    Edward_Girard@bigfoot.com

  • RELEVANCY SCORE 2.87

    DB:2.87:Item Lov On Miscellaneous Transaction Form fd


    Hi
    I want to customize Item LOV on miscellaneous transactions form in Oracle inventory module. I tried it through personalization by creating a record group but i found that there is no LOV attached with this field (LOV name required in Target Object field)

    Can anybody come up with a solution?

    Tauqir

    DB:2.87:Item Lov On Miscellaneous Transaction Form fd

    This is probably not the correct forum. Try eBusiness Suite forum instead.

  • RELEVANCY SCORE 2.86

    DB:2.86:Re: Lov &Amp; Query In Forms 10g Not Working pd


    Strange there is no error msg...

    Are you using SYSTEM.MESSAGE_LEVEL anywhere in the form that may be hiding the error msg?

    Maybe you have paths (e.g., for menus etc.) in the form that are valid for DevSuite, but invalid for app server.

    DB:2.86:Re: Lov &Amp; Query In Forms 10g Not Working pd

    Are there any other forms deployed on the OAS that has working LOVs???

    If so, I think there is a custom code or something that prevents you LOV from appearing, some applications do have that kind of security.

    But if non of the forms have working LOVs when deployed on the server that as Steve said T A R

    Regards,
    Tony

  • RELEVANCY SCORE 2.86

    DB:2.86:Duplication In Lov zs


    Hi,

    I have Search Form . I am using lov for the searching purpose. First i select a data from lov , i will assign all the data with respect to the selected data from lov to respective fields. my problem
    is i am again going to click the lov with out clearing the value from lov (lov inputtext) , the search window having the same data 3 times. how can i rectify this problem

    regards
    rajesh

    DB:2.86:Duplication In Lov zs

    Hi,

    I am working in Jdeveloper 11g service pack 2, adf. In my page i have search filter with three dependent combo box. Based on search the records populates in the search grid table. For example i have A, B, C three combos.....where B depends on A and C depends on the selection of B. based on C the search results come in the grid table.

    Search is working fine. But when i try to add new records in the search grid, the values that i select from the combo's A, B, C duplicates. That is new record added
    I am selecting example 1 in combo A and dependent values comes in both B and C. But when i again add new record then i see duplicates in the combo A...now Combo A has two 1's....similarly the values that i select in Combo B and C gets duplicates. I am using List of Values for A, B, C. and search criteria for the dependent combo's in their view object. Please somebody can let me know how to solve this problem. Thanks

  • RELEVANCY SCORE 2.86

    DB:2.86:Lov Refresh sf


    Is there a way to refresh a LOV in a form without refreshing the whole form?

    I have a form (form #1) that includes dynamic LOVs for several of the fields. I also have buttons to link to other forms (form #2,3,etc..) that will allow users to add items to the tables driving the LOVs.

    My question is, when the user returns to form #1, is there a way to refresh the LOV with the new data just entered without having to do a browser refresh, which causes any other data entered on the form to disappear?

    Thanks in advance,

    Judy

    DB:2.86:Lov Refresh sf

    Hi Judy
    It's not possible to just refresh the lov without refreshing the whole form..u must be knowing how to refresh the form..just add the following code in on change of the field...
    do_event(this.form, this.name, 1, 'CUSTOM', '');
    vishnu

  • RELEVANCY SCORE 2.86

    DB:2.86:2 Question About Super Lov Plugin z7


    Dears,
    Question 1 : i use Super LOV Plugin in item p2_search and i have form based table (emp table) , when i choose LOV from p2_search it's mapping all the values in emp form , i want when i use this action , apply change button appear and available to update the values.
    example in apex.oracle.com
    http://apex.oracle.com/pls/apex/f?p=36028:2:4197908469000::NO
    user:ahmed
    password:123

    workspace : elnoor
    application name : Application 36028 - Super LOV Search

    Question 2 : i am try to change plugin theme i use this code after head
    link rel="stylesheet" type="text/css"
    href="http://code.jquery.com/ui/1.9.1/themes/start/jquery-ui.css" /but no change .
    Ahmed

    DB:2.86:2 Question About Super Lov Plugin z7

    Gazak ALLAH khiran my brother , please what are you doing ? :)

  • RELEVANCY SCORE 2.86

    DB:2.86:How Can I Change The Look Of Lov Using Form Builder 10g? x7


    Hi All

    How can i change the display style of LOV?

    Thanks

  • RELEVANCY SCORE 2.85

    DB:2.85:Pass Parameter To Lov-Form k9


    How do i pass 1 or more parameters from a FORM to a LOV-FORM ?

    The purpose is to restrict the query in the LOV-FORM with values(*) from the calling FORM.

    (*)( values = 1 or more items )

    The LOV-FORM is called from an item with template/library = 'QMSSO$LOV_FORM_ITEM' !

    DB:2.85:Pass Parameter To Lov-Form k9

    Paulo,
    The code to call the LOV Form is generated automatically by Designer. It generates the following line of code in the KEY-LISTVAL trigger of the item in question.
    call_form('module',NO_HIDE,NO_REPLACE,QUERY_ONLY);

    You could try adding application logic to override this code. (See Designer online help for how to do this.)

    Regards,
    Lauri

  • RELEVANCY SCORE 2.85

    DB:2.85:Lov On Form Changes Db Row Values ma


    I add a lov to a form and experience that the lov does not retain the value coming from the DB row but overrides it with what ever the lov presents first. A very strange default behavior, but what does a newbie know. Can anyone sugesst how to correct this behavior. Many thanks!

  • RELEVANCY SCORE 2.85

    DB:2.85:Work Order Less Completion Form-Help ac


    Hello Guys i have a question on WIP- Work Order Less Completion Form.

    In the form when we enter the assemebly item and go to Components--Lot/Serial, In Lot entry form there is a field called Lot number which has LOV and also allows user to enter his own Value what he needs.

    My question is is there any controls in Oracle where we can prevent user from entering his value in the LOt number field,instead he has to select it from LOV only.

    Please help me on this.

    Thanks

    DB:2.85:Work Order Less Completion Form-Help ac

    Hi,

    Please see if these documents help.

    Note: 112055.1 - Lot/Serial Control Setups
    Note: 338189.1 - When Receiving an RMA, Lot Number LOV Shows All Lots

    Regards,
    Hussein

  • RELEVANCY SCORE 2.85

    DB:2.85:Jsp: Lov Question a1


    I have a BC4J/JSP application with no struts or UIX in 9.0.3.3 (1025). I have some questions about the LOV tag. I want to use this to popup an LOV that passes the ID of a field back to the originating form. I want that form to be able to display friendly text instead of the ID.

    For example, lets say that I have an employee edit screen which allows you to add a deparment to an employee by selecting them in a LOV. The tag for the LOV might look like this:
    jbo:InputSelectLOV datasource="dsEmp" dataitem="DeptId" displaydatasource="dsDept" displaydataitem="DeptName" displayvaluedataitem="DeptId" formname="myForm" /jbo:InputSelectLOV

    This would put a text field on the page with a button next to it. When the user clicks on the button it pops up a window with all the department names. The user clicks on a name and in the original field the id is shown. I want the Name to be shown.

    The other concern I have is that it doesn't indicate which choice was previously selected in the LOV. I.E. if we are editing an employee and changing their department, I want the LOV to indicate what the department was before we opened the LOV..

    Is there any way to implement these ideas without writing my own Javascript to handle it?

    DB:2.85:Jsp: Lov Question a1

    I have a BC4J/JSP application with no struts or UIX in 9.0.3.3 (1025). I have some questions about the LOV tag. I want to use this to popup an LOV that passes the ID of a field back to the originating form. I want that form to be able to display friendly text instead of the ID.

    For example, lets say that I have an employee edit screen which allows you to add a deparment to an employee by selecting them in a LOV. The tag for the LOV might look like this:
    jbo:InputSelectLOV datasource="dsEmp" dataitem="DeptId" displaydatasource="dsDept" displaydataitem="DeptName" displayvaluedataitem="DeptId" formname="myForm" /jbo:InputSelectLOV

    This would put a text field on the page with a button next to it. When the user clicks on the button it pops up a window with all the department names. The user clicks on a name and in the original field the id is shown. I want the Name to be shown.

    The other concern I have is that it doesn't indicate which choice was previously selected in the LOV. I.E. if we are editing an employee and changing their department, I want the LOV to indicate what the department was before we opened the LOV..

    Is there any way to implement these ideas without writing my own Javascript to handle it?

  • RELEVANCY SCORE 2.85

    DB:2.85:Passing Of Lov mf


    How to PASS LOV (List of Values) from one form to another ?

    DB:2.85:Passing Of Lov mf

    Please clear this question
    you will pass value from one form to another using global variable,parameter

    Reena

  • RELEVANCY SCORE 2.85

    DB:2.85:Populate Tabular Form Items Based On Lov In Header 1p


    Hi,

    I have an LOV (Select List with submit) defined as the item in the same region as a tabular form. I'm using the first row in the LOV as the default value.
    Following is the query for the LOV:
    SELECT team_code ||' - '|| description as d, team_id as r FROM cp_teams ORDER BY team_id

    If the user selects a value in the LOV it would then automatically refresh the tabular form based on LOV's return value. But initially I want the tabular form to be populated using the LOV's default value.

    Problem 1) When I log in for the first time and navigate to the page, the LOV displays correctly but it shows an error below it:
    report error:
    ORA-01722: invalid number
    Surprisingly, after I have submitted the list more than once, I never see this error again until I exit.

    Question 1) Does this mean that for the first time, the LOV is not being "submitted" and thus tabular form underneath it has nothing to show?
    How do I automatically submit the lov as soon as I navigate to the page?

    Problem 2) I have a field (item) TEAM_ID in the tabular form's query which should take the TEAM_ID passed from the LOV for every new record that is created.

    Question 2) How do I initialize this field for a new record from the "header" LOV? The ultimate objective is to have the TEAM_ID populated for all the records created in the tabular form.

    As you can see I'm a newbie to APEX so I'd appreciate any help.

    Thanks,
    Sunil

    DB:2.85:Populate Tabular Form Items Based On Lov In Header 1p

    Sunil,

    1. what is the null value for your header LOV. I usually use 0 or some other numerical values. You will need a computation for that LOV with a condition ITEM VALUE IS NULL in
    order to run it only once per session.

    2. In the properties of your column - Tabular Form Element - you can set the default value
    to an item value (application or page item name).

    Denes Kubicek
    -------------------------------------------------------------------
    http://deneskubicek.blogspot.com/
    http://www.opal-consulting.de/apex/f?p=107:7
    http://htmldb.oracle.com/pls/otn/f?p=31517:1
    -------------------------------------------------------------------

  • RELEVANCY SCORE 2.85

    DB:2.85:Bug - Popup Key Lov (Named Lov) In A Tabular Form Does Not Display Values 9k


    I have a tabular form and I'm setting one of the fields to a Popup Key LOV (named LOV). The named LOV is a static LOV. When the popup is displayed there are no values displayed. The same thing happens if I use a Popup LOV (named LOV).I created a sample application http://apex.oracle.com/pls/apex/f?p=15762:1 that shows what happens. When the job field popup is selected, no items are displayed. If I change the item to a Select List (named LOV) it works fine.

    DB:2.85:Bug - Popup Key Lov (Named Lov) In A Tabular Form Does Not Display Values 9k

    I have a tabular form and I'm setting one of the fields to a Popup Key LOV (named LOV). The named LOV is a static LOV. When the popup is displayed there are no values displayed. The same thing happens if I use a Popup LOV (named LOV).I created a sample application http://apex.oracle.com/pls/apex/f?p=15762:1 that shows what happens. When the job field popup is selected, no items are displayed. If I change the item to a Select List (named LOV) it works fine.

  • RELEVANCY SCORE 2.84

    DB:2.84:Dynamic Lov ds


    Hi,

    Can I change the source of the LOV at run time? I have forms and I need to change the LOV source based on another LOV in the same form.

    thanks,

    DB:2.84:Dynamic Lov ds

    Apex 4 and earlier versions, I believe

  • RELEVANCY SCORE 2.84

    DB:2.84:Doubt In Forms xs


    Hi All,

    I am using ORADEV10G.

    I have two questions

    1. First one is based on LOV. I have a LOV with three columns : Dept,Deptno,Description.
    On clicking the values in LOV, the Dept value and Description value should be displayed on the text box associated with the LOV. Is this Possible? If possible please help to do this.

    2.Second question is based on triggers.
    I have two LOV's in my form. First LOV is the DEPT LOV defined above with three columns : Dept,Deptno,Description.
    After selecting the Dept in first LOV, students corresponding to the Dept should be fetched in second LOV. I've done that too.

    But the problem is if the selected Dept has no student details then the second LOV should be disabled. In which trigger i have to do this?

    I gave my code on the when-validate-item trigger of text box associated with first LOV.

    If I select value in first LOV i.e. dept in first LOV, If the selected Dept have student details then it is displayed in second LOV.

    If I reselect the Dept having no student details the values in the second text box remains the same. It is not changing to null automatically after the Dept is selected.

    gave the code also.

    In when-validate-item trigger,

    Declare

    cursor c_dept (b_deptid number) is
    select count(id) from t_dept
    WHERE id = b_deptid ;

    l_count number;

    BEGIN

    IF :dept.dept_id IS NOT NULL THEN

    IF c_dept%ISOPEN THEN
    CLOSE c_dept;
    END IF;

    OPEN c_dept (:dept.dept_id);

    FETCH c_dept
    INTO l_count;

    CLOSE c_dept;
    END IF;

    if l_count = 0 then
    :dept.student := '';

    set_item_property('dept.student', INSERT_ALLOWED, property_false);
    set_item_property('dept.student', UPDATE_ALLOWED, property_false);

    elsif l_count 0 then
    :dept.student := '';
    set_item_property('dept.student', INSERT_ALLOWED, property_true);
    set_item_property('dept.student', UPDATE_ALLOWED, property_true);

    end if;

    END;

    Please help me out on this.

    Regards,
    Gopi.

    DB:2.84:Doubt In Forms xs

    What's your "LIST"

    if LIST means LIST-OF-VALUES (=LOV, =an own window opens where you can select an entry and which you can move) your Item is a text item then WHEN-VALIDATE-ITEM is perfect (forget POST-CHANGE), WHEN-LIST-CHANGED is completely wrong

    if LIST means LIST-Item, e.g.POPLIST, DROP-DOWN-LIST (i.e. this GUI-thing that shows allowed vaues in an area below/above of the item) or TLIST, then WHEN-LIST-CHANGED is your thing. But, ... there are limitations on changing the list when the record is initialized.

  • RELEVANCY SCORE 2.84

    DB:2.84:Portal Forms z1


    I have a form based on a table. I choose custom form layout. Many of the items on the form are linked to LOVs displayed as radio groups. My question is, how can I display the LOV options horizontally instead of vertically?

    Thanks!

    DB:2.84:Portal Forms z1

    Got it, thanks for your reply!

  • RELEVANCY SCORE 2.84

    DB:2.84:Steps To Create Lov Dynamically jj


    Hello All,I want to create LOV dynamically.in my Oracle Forms 6IIs there any code which can create LOV dynamically using coding.I can create Record group dynamically. but I want to create LOV dynamically not from object browser of Form Builder by pressing Add LOV option.Kindly help me.--------ThanksHARSH SHAH

    DB:2.84:Steps To Create Lov Dynamically jj

    Forms does not have a Built-in for dynamically creating an LOV; these objects can only be created in the Forms Builder during design time. You can, as numerous people have tried to demonstrate, change the Record Group an LOV uses dynamically. Unless you are changing the Column Mapping Properties of the LOV, using different Record Groups to supply the data for an LOV should work for you. If you need to change the Column Mapping Properties, then you will need to create multiple LOV objects with the different mapping you need and then assign the LOV to your Item dynamically.Hope this helps,Craig...

  • RELEVANCY SCORE 2.84

    DB:2.84:Commandlink Html-Rendering Out Of Sync With Its Hidden Input. fc


    Hi to everyone reading !!

    THE THEORY:

    When you include a commandLink in a form like the following one:

    h:form id="lov" target="list"
    h:inputHidden id="cod" value="#{bean.property}"/

    h:commandLink id="find" action="showValues" value=""
    f:verbatim/f:verbatim
    /h:commandLink
    /h:formJSF renders it like this one (not shown complete):

    a id="lov:find" href="#"
    onclick="document.forms['lov']['lov:find'].value='lov:find';
    document.forms['lov'].submit(); return false;"
    /aAnd automatically JSF renders this additional element inside the form:

    input type="hidden" name="lov:find" /I use that code to show a popup window that takes some data to determine its content (taken from the "popular" demo jsf-popup).

    THE FACT:

    The demo works fine, and behaves as expected.

    I take it as an example for a real application, but for some reason, the "name" attribute of the hidden field doesn't match that of the commandLink; the rendering is like this:

    a id="lov:find" href="#"
    onclick="document.forms['lov']['lov:_idcl'].value='lov:find';
    document.forms['lov'].submit(); return false;"
    /a
    ...
    input type="hidden" name="lov:_idcl" /I have to use some javascript code to open the popup, and in that code I have to make reference to the out-of-sync hidden input (expected name: "lov:find", actual: "lov:_idcl").

    THE QUESTION:

    How can I control the name of the hidden input that holds the name of the commandLink that submits the form?

    Thanks to anyone with an opinion on this.

    DB:2.84:Commandlink Html-Rendering Out Of Sync With Its Hidden Input. fc

    You cannot control it. In order to do this you'll have to overwrite the form renderer

  • RELEVANCY SCORE 2.84

    DB:2.84:Can We Attach Lov In Detail Form Of Master-Detail? ps


    Folks!

    Is it possable to attach LOV in detail form of master detail form.

    Kind Regards
    Abbas

    DB:2.84:Can We Attach Lov In Detail Form Of Master-Detail? ps

    I have had following visit but it is on tabular form
    Tabular Forms and Cascading LOV's

    and i am looking to add LOV in detail form of master detail form, please if anybody can give me some direction, will be very thnk full

    Kind Regards
    Abbas

  • RELEVANCY SCORE 2.83

    DB:2.83:Locking Lov Based On Another Lov. af


    Silly question.

    I Have 2 LOV fields on a form. I want that the descriptions in LOV 2 should be locked or set to null based on return values from

    LOV 1 before applying changes.

    DB:2.83:Locking Lov Based On Another Lov. af

    See this example:

    http://apex.oracle.com/pls/otn/f?p=31517:119

    Select Operations in the first list and there will be no managers selectable in the second LOV. This is basically the same logic.

    Denes Kubicek
    -------------------------------------------------------------------
    http://deneskubicek.blogspot.com/
    http://www.opal-consulting.de/training
    http://apex.oracle.com/pls/otn/f?p=31517:1
    -------------------------------------------------------------------

  • RELEVANCY SCORE 2.83

    DB:2.83:How Do You Pass Value From Popup Key Lov To An Other Item In Same Form 99


    Hi all,

    I've a question.
    I've created a form with a popup key LOV(LOV description, returns key value).
    In the same form I have items which need to be filled based on the return value of the pop_up before submit of the form.
    But after the user have selected a value out the LOV pop up , I can't fill the other item based of the return value of popup.It looks like the return value is inserted after submit. I have to do this form with a LOV.

    Does someone has a idea what I can do.

    Best Regards,
    Caroline

    DB:2.83:How Do You Pass Value From Popup Key Lov To An Other Item In Same Form 99

    Does anybody know how to pass value from Popup Key LOV to an other item in same form in apex 3.2.

    Best regards,
    Caroline

  • RELEVANCY SCORE 2.83

    DB:2.83:Restricted Item Lov For Inventory Modules Form s3


    Hi
    I want to customize Item LOV on miscellaneous transactions form in Oracle inventory module. I tried it through personalization by creating a record group but i found that there is no LOV attached with this field (LOV name required in Target Object field)

    Can anybody come up with a solution?

    Thanks,
    Mukarram

    DB:2.83:Restricted Item Lov For Inventory Modules Form s3

    Hi
    I want to customize Item LOV on miscellaneous transactions form in Oracle inventory module. I tried it through personalization by creating a record group but i found that there is no LOV attached with this field (LOV name required in Target Object field)

    Can anybody come up with a solution?

    Thanks,
    Mukarram

  • RELEVANCY SCORE 2.83

    DB:2.83:Cannot See Display As Text (Based On Lov, Saves State) 9c


    I have raised this question on the HTMLDB forum (Where is "Display as Text (based on LOV, saves state)" but in case its XE specific I am posting here too.
    I have a tabular form in the XE version of HTMLDB, and wish to use the "Display as Text (based on LOV, saves state)" option. However, this option does is not available to me - are there some conditions necessary for this option to be displayed?
    Thanks, Rob

    DB:2.83:Cannot See Display As Text (Based On Lov, Saves State) 9c

    Rob,

    I doubt it's an XE specific issue. I've asked for more information in the original thread.

    Sergio

  • RELEVANCY SCORE 2.83

    DB:2.83:Re: Performance Problem With Display As Text &Amp; Read-Only Lov Items ms


    Lee - The code for the Display as Text (based on LOV) item does not have the same optimization as the code for the popup key LOV item, the former probably resulting in full-table scans while the popup key method uses an inline view and a predicate that includes the key value. So as an experiment, you can try to use the same code that is used for the popup key item by setting the form item's Post Calculation Computation attribute to: wwv_flow_utilities.get_display_value_given_lov ('your lov SQL query', :item name);...where you plug in the SQL for the item's LOV query and the name of the form item in bind variable notation.

    Scott

    DB:2.83:Re: Performance Problem With Display As Text &Amp; Read-Only Lov Items ms

    Please lmerrick,

    Can you to give me your sample code to implante the performance fonctionality of LOV.

    Thanks in advance.

    Nasser.

  • RELEVANCY SCORE 2.83

    DB:2.83:Some Questions (Freinds It Is Very Important &Amp; Urgent) 3c


    Hi Friends !
    Following are some questions... kindly if u can help for any or all?
    Q1) Want to generate all .fmb into .fmx using DOS batch programing or any other mathod.Is it possible at all ?
    Q2) As u know when the LOV invoked it shows your columns' values
    vertically as,
    Code Name
    01 abc
    02 cdef
    03 ghijk
    My question is that,is it possible at all if i could get the LOV
    horizontally as

    Code 01 02 03 -- --
    Name abc cdef ghijk -- -- etc... For the web in normal Builder ?

    Q3) I want to print the form(Form 6i) not as we can do by using the
    default menu's option "Print" which actually print the whole screen with
    menu buttons etc..
    I want to print the all values i.e information including those values
    which we see using scroll bar in the detail data block.As we can achieve
    it using report but report is not required.I remember that someone has
    told me using TEXT_IO package's functions.
    But i did not succeeded.Can u help me in this interesting assignment ?

    Q4) Want to print the images stored in the database as other normal
    fields using report. As the query ...select code,name,image from
    employee........ or using any other method.

    Q5) For the performance of Form's LOV prob. I found the .jar files named
    E:\Oracle\ias\6iServer\Forms60\Java\f60all.jar
    But I did not find any LIB directory in the Html page of my browser etc.
    Kindly may you exactly tell me where the LIB of html of browsers is ?
    MANY MANY THANKS !
    null

    DB:2.83:Some Questions (Freinds It Is Very Important &Amp; Urgent) 3c

    Hi Friends !
    Following are some questions... kindly if u can help for any or all?
    Q1) Want to generate all .fmb into .fmx using DOS batch programing or any other mathod.Is it possible at all ?
    Q2) As u know when the LOV invoked it shows your columns' values
    vertically as,
    Code Name
    01 abc
    02 cdef
    03 ghijk
    My question is that,is it possible at all if i could get the LOV
    horizontally as

    Code 01 02 03 -- --
    Name abc cdef ghijk -- -- etc... For the web in normal Builder ?

    Q3) I want to print the form(Form 6i) not as we can do by using the
    default menu's option "Print" which actually print the whole screen with
    menu buttons etc..
    I want to print the all values i.e information including those values
    which we see using scroll bar in the detail data block.As we can achieve
    it using report but report is not required.I remember that someone has
    told me using TEXT_IO package's functions.
    But i did not succeeded.Can u help me in this interesting assignment ?

    Q4) Want to print the images stored in the database as other normal
    fields using report. As the query ...select code,name,image from
    employee........ or using any other method.

    Q5) For the performance of Form's LOV prob. I found the .jar files named
    E:\Oracle\ias\6iServer\Forms60\Java\f60all.jar
    But I did not find any LIB directory in the Html page of my browser etc.
    Kindly may you exactly tell me where the LIB of html of browsers is ?
    MANY MANY THANKS !
    null

  • RELEVANCY SCORE 2.83

    DB:2.83:When I Select Lov Not Getting Value Into Field pa


    Hi....

    I created lov and assign lov to field and lov values also is there
    if i select one value from lov it's not coming to field

    what i do please tell me any solution.

    FORM:10.2.0.2

    Regards
    mohan

    DB:2.83:When I Select Lov Not Getting Value Into Field pa

    Mohan,
    Now that your LOV is created, you do not need to use the LOV Wizard to assign a return value. Instead, open the Property Pallet for your LOV and select the Column Mapping Properties property. From this property popup, you can pick the LOV column and the Block.Item you want the column value mapped too.

    Hope this helps,
    Craig

    Hi Craig,

    Now i am getting lov in form.

    Thanks
    Mohan

  • RELEVANCY SCORE 2.83

    DB:2.83:Lov Taking Long Time To Open sz


    Hi all, I have LOV query in the form.1) I ran the LOV query in the TOAD some times it is taking 3 seconds and sometimes it is taking 6 min2) In the form in the LOV also taking same issuecould any one please help .

    DB:2.83:Lov Taking Long Time To Open sz

    What is your Forms and Database versions? How often does the data in the table(s) that your LOV query change? Have you noticed other "Network" slowness at the same time your LOV runs slowly? Craig...

  • RELEVANCY SCORE 2.83

    DB:2.83:Master-Detail Question :( xx


    I have a master-detail form. When I go to Detail and add row. I get a row with the fields I want. I have configured the first field of the row as LOV say Invoice_no. How can I fetch rest of the details relating to that Invoice_no which is selected from the LOV in the same row from which it was selected ?

    Thanks

    DB:2.83:Master-Detail Question :( xx

    I tried looking for it but I m not sure how to use it though :( A little help would be appreciated pls :)

  • RELEVANCY SCORE 2.83

    DB:2.83:Create Lov fs


    hi how to create LOV for textbox in a form which forms created from the view in data control. so tell me ho to create LOV for one field.

    DB:2.83:Create Lov fs

    BaiG wrote:
    Google is your friend

    http://www.oracle.com/technology/pub/articles/gauchman-lov.html

    http://www.google.kz/search?q=create+lov+in+ADF+10gie=utf-8oe=utf-8aq=trls=org.mozilla:en-US:officialclient=firefox-aThanks to Google to have the "caching" functionality since the 1st URL answers:

    "An error occurred while processing the request. Try refreshing your browser. If the problem persists contact the site administrator"

  • RELEVANCY SCORE 2.83

    DB:2.83:Item Lov On Miscellaneous Transaction Form 7x


    Hi
    I want to customize Item LOV on miscellaneous transactions form in Oracle inventory module. I tried it through personalization by creating a record group but i found that there is no LOV attached with this field (LOV name required in Target Object field)

    Can anybody come up with a solution?

    Salman

    DB:2.83:Item Lov On Miscellaneous Transaction Form 7x

    I think this is not relates to OAF Pages. Please confirm?

    Thanks
    --Anil

  • RELEVANCY SCORE 2.83

    DB:2.83:Lov Question a8


    Hello,
    I must enter query mode first before I display my LOV. In order to do that I always setup two buttons. One button says "Display List" and the second button says "Search New". So the person clicks on "Search New", my trigger simply enters into query mode. Then the person clicks "Display List" and my LOV displays nicely.
    The question is: how can I entery query and display my LOV right away without having to setup two buttons ?

    IF :System.Mode = 'ENTER-QUERY' THEN
    --ENTER_QUERY;
    IF Show_lov('LOV_TARGET_GROUPS') THEN
    execute_query;
    END IF;
    END IF;

    Notice that I commented out --ENTER_QUERY; because the form waits without displaying the LOV.

    Thanks,
    Bob

    DB:2.83:Lov Question a8

    Let's keep it simple

    1. When-button-press ("Search New")
    enter-query;

    2. When-new-item-instance of
    First navigable item in the block:

    IF :System.Mode = 'ENTER-QUERY' THEN
    IF Show_lov('LOV_TARGET_GROUPS') THEN
    execute_query;
    END IF;
    END IF;

    Slava.

    Hello,
    I must enter query mode first before I display my LOV. In order to do that I always setup two buttons. One button says "Display List" and the second button says "Search New". So the person clicks on "Search New", my trigger simply enters into query mode. Then the person clicks "Display List" and my LOV displays nicely.
    The question is: how can I entery query and display my LOV right away without having to setup two buttons ?
    IF :System.Mode = 'ENTER-QUERY' THEN
    --ENTER_QUERY;
    IF Show_lov('LOV_TARGET_GROUPS') THEN
    execute_query;
    END IF;
    END IF;
    Notice that I commented out --ENTER_QUERY; because the form waits without displaying the LOV.
    Thanks,
    Bob

  • RELEVANCY SCORE 2.83

    DB:2.83:Billing Address &Amp; Shipping Address In Project zz


    Hi,

    I have query in project that I have order form client A and client A has received order from client B.Now in project I have to enter Billing Address of client A and Shipping Address of client B in customers and contacts. I can enter Billing Address of Client A but can't find Client B Shipping Address in Shipping Address LOV.

    Can anybody help me to resolve the problem.

    Thanks
    Haresh

  • RELEVANCY SCORE 2.82

    DB:2.82:Item Lov On Miscellaneous Transaction Form zm


    Hi
    I want to customize Item LOV on miscellaneous transactions form in Oracle inventory module. I tried it through personalization by creating a record group but i found that there is no LOV attached with this field (LOV name required in Target Object field)

    Can anybody come up with a solution?

    Salman

    DB:2.82:Item Lov On Miscellaneous Transaction Form zm

    Hi
    I want to customize Item LOV on miscellaneous transactions form in Oracle inventory module. I tried it through personalization by creating a record group but i found that there is no LOV attached with this field (LOV name required in Target Object field)

    Can anybody come up with a solution?

    Salman

  • RELEVANCY SCORE 2.80

    DB:2.80:Combobox With Null Value (% For Query) dk


    Hi
    I'm quite new to Portal.
    I have several question about LOVs:

    1)
    I'm trying to make a master/detail form.
    I have a field (ID) for which has a made a LOV. I'd like to show it as combo box. I can do that. But then I can't see a NULL value, so when trying to execute query, I can't get all records but just those that correspond to current value of combo box.
    I managed to do it with popup item. So LOV should be proper. For LOV I have Show Null Value property set to %. If try to use this with property set to 'YES', the null value is shown, but query returns nothing - of course, there is no record whit this attribute set to null.

    2)
    Sometimes it happens that when I try to submit the changes made on form (OK button) I get the message: "List Of Values not specified for item."
    I do have LOV specified for all the items, there are Combo boxes, Popups, ....
    Is this a bug?

    3)
    Next thing is, when I'm inserting a detail row, I select a value from combo box, submit the changes and I get this message:
    No conversion performed for type INTEGER, value . (WWC-49102)

    LOV is: select name, id from table_name order by name
    Field I'm inserting into is id_fk in a table, corresponding to the id I get from LOV (constraint).
    What could be wrong?

    4)
    How is List Of Values mapped to database?
    I can see forms as packages in schema corresponding to provider. but don't know where it LOV. I can't find the call to a LOV in a form package. I thought I could change to code where LOV is being called to get the proper functionality, but...

    Thanks
    Rok

    DB:2.80:Combobox With Null Value (% For Query) dk

    Hi
    I'm quite new to Portal.
    I have several question about LOVs:

    1)
    I'm trying to make a master/detail form.
    I have a field (ID) for which has a made a LOV. I'd like to show it as combo box. I can do that. But then I can't see a NULL value, so when trying to execute query, I can't get all records but just those that correspond to current value of combo box.
    I managed to do it with popup item. So LOV should be proper. For LOV I have Show Null Value property set to %. If try to use this with property set to 'YES', the null value is shown, but query returns nothing - of course, there is no record whit this attribute set to null.

    2)
    Sometimes it happens that when I try to submit the changes made on form (OK button) I get the message: "List Of Values not specified for item."
    I do have LOV specified for all the items, there are Combo boxes, Popups, ....
    Is this a bug?

    3)
    Next thing is, when I'm inserting a detail row, I select a value from combo box, submit the changes and I get this message:
    No conversion performed for type INTEGER, value . (WWC-49102)

    LOV is: select name, id from table_name order by name
    Field I'm inserting into is id_fk in a table, corresponding to the id I get from LOV (constraint).
    What could be wrong?

    4)
    How is List Of Values mapped to database?
    I can see forms as packages in schema corresponding to provider. but don't know where it LOV. I can't find the call to a LOV in a form package. I thought I could change to code where LOV is being called to get the proper functionality, but...

    Thanks
    Rok

  • RELEVANCY SCORE 2.80

    DB:2.80:Re: Lov In Simple Parameter Form 1a


    ?

    Message was edited by:
    fqadri1

    DB:2.80:Re: Lov In Simple Parameter Form 1a

    hi i want that code this my email khalsa-82@hotmail.com

  • RELEVANCY SCORE 2.80

    DB:2.80:Re: Tabular Form With Popup Lov fx


    Anybody have any ideas?

    DB:2.80:Re: Tabular Form With Popup Lov fx

    I ended up demoralizing a portion of my data model. I was then able to add a popkey on a single record form. I did not use the tabular form and popkey combination as it does not work for me.

    In researching this issue I did see another workaround for the popkey usage on the tabular form. The work around can be seen on the "Software Projects, 0.9" demo app (page 35). The workaround is to have the LOV return the same column for both description, and return. The problem here is that the description value (text) is then saved to the database and used as a foriegn key. This was not an acceptable workaround as the value I would have used for description could change (user can change name...). I prefer to only use keys that are never seen by users and generated by sequences...

    Todd

  • RELEVANCY SCORE 2.79

    DB:2.79:Lov j9


    I would appreciate any suggestions on the following:

    I have a TextFieldContol in a Java form that is bound to an attribute to a RowSetAccess and displays data queried from a database table.
    An InfoSwing ButtonControl is provided in the form which which brings up an LOV by querying a master table. My question is how to populate the TextFieldContol when a value is selected in the LOV dialog box and the OK button (in the
    dialog box) is clicked.

    I have used the code provided in the online help on LOV's for the ButtonControl ActionPerformed Event

    Thanks.

    DB:2.79:Lov j9

    I would appreciate any suggestions on the following:

    I have a TextFieldContol in a Java form that is bound to an attribute to a RowSetAccess and displays data queried from a database table.
    An InfoSwing ButtonControl is provided in the form which which brings up an LOV by querying a master table. My question is how to populate the TextFieldContol when a value is selected in the LOV dialog box and the OK button (in the
    dialog box) is clicked.

    I have used the code provided in the online help on LOV's for the ButtonControl ActionPerformed Event

    Thanks.

  • RELEVANCY SCORE 2.79

    DB:2.79:Question Concerning Lovs za


    How can I get an LOV to do an automatic execute_query when an item is selected while the form is in query mode?

    DB:2.79:Question Concerning Lovs za

    There is a trigger called KEY-lISTVAL in this write code to show the lov attached to the item
    eg

    Declare
    a boolean;
    Begin
    a := show_lov('lov1');
    Execute_Query(No_Validate);
    End;

    This should solve ur problem.

  • RELEVANCY SCORE 2.79

    DB:2.79:Search Option In Lov Tp3 Vs Tp4 k7


    Hi
    I have a question for oracles boys.
    I have followed the andrejus example, for creating a Lov with search option.

    http://andrejusb.blogspot.com/2008/02/list-of-values-component-in-search-and.html

    After, a lot of headaches, and with andrejus help (Thanks, again). I realised that running in TP3 the search form, is available in the LOV, but not in TP4.

    So is this a BUG in TP4, or is something that you have made on purpose?

    And if its made on purpose how can we create an unbounded and not related to model LOV with search option using jdevTP4?

    Thanks,

    Rowan

    DB:2.79:Search Option In Lov Tp3 Vs Tp4 k7

    Hi, Andrejus
    And thanks for answer.
    I understand that this is not a bug, what im asking is if there is going to be that property in View layer that now it isnt that says to turn-off or turn-on Search option in TP4.

    Thanks again,

    Rowan

  • RELEVANCY SCORE 2.79

    DB:2.79:Basing An Lov On Another Lov mf


    In a HTML web form, how can I have a LOV (Drop-Down list) based on DEPT, that populates another LOV with all the employees from EMP in the department selected in the first LOV.
    I can do it in Javascript but I need to derive my values from tables.
    Thanks

    DB:2.79:Basing An Lov On Another Lov mf

    Hi,

    I dont think you can pass on the table values to a javascript function.

    You can definitely use the HTP cartridge functions to display table
    data in HTML. There would be a specific HTP or HTF function to build
    a form drop down list. I think it's a combination of htp.formSelectOpen
    and htp.formSelectOption. Check the documentation here:
    http://kontti.helsinki.fi:8889/ows-adoc/psqlwtl9.htm

    Populating the EMP LOV should be straight forward unless you are
    not looking to change the EMP LOV and DEPT LOV dynamically.

    Rgds.
    Amogh

  • RELEVANCY SCORE 2.79

    DB:2.79:Lov Problem While Registering In Applications 31


    i have designed a form with LOV but while registering in oracle apps it is showing form and all are working fine except the LOV, its also showing LOV s but not taking the value to the table nor selecting the value

    Message was edited by:
    shiva646

    DB:2.79:Lov Problem While Registering In Applications 31

    Can you explain little bit more or write the query which genarate lov

  • RELEVANCY SCORE 2.79

    DB:2.79:It Is Urgent &Amp; Important Questions Kindly ! 3k


    Hi Friends !
    Following are some questions... kindly if u can help for any or all?
    Q1) Want to generate all .fmb into .fmx using DOS batch programing or any other mathod.Is it possible at all ?
    Q2) As u know when the LOV invoked it shows your columns' values
    vertically as,
    Code Name
    01 abc
    02 cdef
    03 ghijk
    My question is that,is it possible at all if i could get the LOV
    horizontally as

    Code 01 02 03 -- --
    Name abc cdef ghijk -- -- etc... For the web in normal Builder ?

    Q3) I want to print the form(Form 6i) not as we can do by using the
    default menu's option "Print" which actually print the whole screen with
    menu buttons etc..
    I want to print the all values i.e information including those values
    which we see using scroll bar in the detail data block.As we can achieve
    it using report but report is not required.I remember that someone has
    told me using TEXT_IO package's functions.
    But i did not succeeded.Can u help me in this interesting assignment ?

    Q4) Want to print the images stored in the database as other normal
    fields using report. As the query ...select code,name,image from
    employee........ or using any other method.

    Q5) For the performance of Form's LOV prob. I found the .jar files named
    E:\Oracle\ias\6iServer\Forms60\Java\f60all.jar
    But I did not find any LIB directory in the Html page of my browser etc.
    Kindly may you exactly tell me where the LIB of html of browsers is ?
    MANY MANY THANKS !
    null

    DB:2.79:It Is Urgent &Amp; Important Questions Kindly ! 3k

    Some answers:
    Q1: You can use a DOS batch-program.
    You create two batch-files.
    The first you name for example complfmb.bat
    You put in one line:
    ifcmp60 module=%1 userid=user/passwd Logon=YES Batch=YES Window_state=Minimize

    You have to replace user/passwd by your own username/password.

    Then you create the second batch-file or you can just type it in. If you type it in, you have to go to the directory in which the fmb's reside.
    Type in:
    for %i in (*.fmb) do call complfmb %1

    This will loop all fmb-files in the current directory and for each fmb the forms-compiler will be run.

    This is quiet easy to do. You can also use a tool called FGenUtil (www.qss.nl).

    Q2: As far as I know this is not possible.

    Q3: example of TEXT_IO:

    declare
    cursor c
    is
    select to_char(sysdate,'DD-MM-RRRR') x
    from dual
    ;
    r c%rowtype;
    outfile text_io.file_type;
    begin
    outfile := text_io.fopen('c:\temp\filename.txt','w');
    text_io.put_line('Start of file');
    open c;
    fetch c into r;
    while c%found loop
    text_io.put(outfile,r.x);
    text_io.put(outfile,';');
    text_io.new_line(outfile);
    end loop;
    close c;
    text_io.fclose(outfile);
    end;

    Q4,Q5: I do not have an answer for these ones.

  • RELEVANCY SCORE 2.79

    DB:2.79:Dynamic Lov In Table Default Value aj


    Hi everybody,

    does anybody know about default values of a query based LOV in a table colomn (tabular form)??
    If I make no changes in my tabular form and submit I always get NULL for each value submitted.
    If I reselect the existing value of the LOV, it works.
    My question is,if there is a possibility to set default values or something?

    My query based LOV is as follows:

    SELECT distinct a.name CODE_DISPLAY,
    a.idee_id CODE_RETURN
    FROM cn_pl_projektidee a,
    cn_pl_std_peplanung b
    WHERE a.idee_ID = b.idee_id
    order by a.idee_id desc

    Greetings Patrick

    DB:2.79:Dynamic Lov In Table Default Value aj

    Ok, I got it, the problem solved, I changed the code of the update process for the tabular form... just like this:

    for i in apex_application.g_f01.first..apex_application.g_f01.last loop
    merge into cn_pl_std_peplanung dest
    using (

    select distinct
    apex_application.g_f01(i) pe_id,
    apex_application.g_f02(i) l_art_id,
    apex_application.g_f03(i) version_id,
    *(select idee_id from cn_pl_projektidee where name = apex_application.g_f04(i)) idee_id,*
    v_ilp abt_id,
    ....
    ....
    .....

  • RELEVANCY SCORE 2.79

    DB:2.79:What Good Is Lov Anyway? 11


    Heres the scenerio -

    You are in the web-based custom form you created. You have a list of values attached to Last Name text item. You select a name from the list. You execute the query and you get.... every record, not the one that you selected.

    Now you enter query mode first, where's the LOV? Why can't you access it?

    OK, so you select the name, then you enter query mode. Oh, when you enter query mode, it flushes the form. So the question persists. What the hell good is this stupid function? How can you make use of the LoV?

    DB:2.79:What Good Is Lov Anyway? 11

    LOV's are perfect at what they do, allowing you to bring a value back to a form for entering data, when you put the form in query mode, you are in query-by-example mode, this is generally used for finding data based on wild-card type values such as NAME LIKE 'M%' or SALARY 3000 even specific values as in your requirement, a query scratch pad if you like with no kind of field validation. Oracle Forms has always been like this and the whole of the Oracle EBS suite is built like this, i.e. simple forms have no LOVs in query mode, more advanced forms tend to use Find Windows (control blocks) for entering very specific values where you can choose from a number of available LOVs, from the Find Window you would then press a Find button or something that would invoke the actual query block and the PRE-QUERY trigger is generally used to set the query criteria as per the data entered on the Find Window.

    Forms can be coded to have LOVs in query mode but in any case, the LOV button will not appear in the right hand side of the item when in query mode.

  • RELEVANCY SCORE 2.79

    DB:2.79:Re:How To Clear The Lov Values In Form jp


    first you can set the value of parameter of second lov to null and bind lov to bean and set value to null.and refresh them programmtic

    DB:2.79:Re:How To Clear The Lov Values In Form jp

    Thanks for the reply.I have lot of items(LOV's) so in this case i need to get those all values instead of that any idea?

  • RELEVANCY SCORE 2.79

    DB:2.79:Adf Bc Vo View Criteria &Amp; Adf Faces Rc Lov Components Query? ja


    Hi JDev team

    I'm experimenting with the new ADF BC VO View Criteria features, and the ADF Faces RC LOV component in JDev 11g TP.

    First part, well done on the ADF RC LOV components, that's more like it!

    A question I have for you is if I setup a View Criteria for a VO, and I make that VO a basis for a LOV component on an ADF Faces RC page, how do I declaratively define the View Criteria at design time to be used by the LOV?

    From what I've discovered on dropping a LOV onto a page, within the page definitions a searchRegion tag is created as follows:
    searchRegion Criteria="__ImplicitViewCriteria__"
    Customizer="oracle.jbo.uicli.binding.JUSearchBindingCustomizer"
    Binds="MyView1Iterator"
    id="__ImplicitViewCriteria__Query"/I note the Criteria attribute of the searchRegion. I've tried to change this to a named View Criteria, but on displaying the LOV, the View Criteria is ignored and all records are returning.

    Any hints or tips on setting the View Criteria for the LOV please?

    Regards,

    CM.

    DB:2.79:Adf Bc Vo View Criteria &Amp; Adf Faces Rc Lov Components Query? ja

    Ah, thanks Ric, that makes sense. Thanks for the follow up.

    Regards,

    CM.

  • RELEVANCY SCORE 2.79

    DB:2.79:Lov Validation Using Forms Personalization 1f


    Hello Guys,

    I have a form where the field Lot number has LOV but its also allows user to enter new value which is not in LOV.my question is How can i validate the value entered by the user against values in LOV using Forms Personalization.If the value entered by the user is not in LOV ,it should not allow user to save.Please help me on this one.

    thanks

    DB:2.79:Lov Validation Using Forms Personalization 1f

    Hi,

    I believe this is explained in the forms personalization documents, so did you review it?

    Note: 279034.1 - Information About the Oracle Applications Form Personalization Feature in 11i
    Note: 468657.1 - How To Do Forms Personalization
    Note: 726324.1 - Forms Personalization and customize LOV
    Note: 395117.1 - Form Personalizations in Oracle E-Business Suite (Release 12)

    Regards,
    Hussein

  • RELEVANCY SCORE 2.79

    DB:2.79:Maybe A Noobie Question But! dc


    In the past Ive only created libraries that never grow.

    I am going to have a form that will grow contantly. So the LOV/s will grow time after time. I will have 3 or 4 LOV/s that need to be updated when new information is added. My question is what is the easiest way for this to happen?

    Thanks

    DB:2.79:Maybe A Noobie Question But! dc

    In the past Ive only created libraries that never
    grow.Not sure what the above means. Can you explain?

    I am going to have a form that will grow contantly.
    So the LOV/s will grow time after time. I will have 3
    or 4 LOV/s that need to be updated when new
    information is added. My question is what is the
    easiest way for this to happen?You can base LOVs on columns in your regular tables as well as creating special purpose tables for your LOVs alone. The advantage of doing the LOV off your regular data tables is that whenever new values get entered into your tables they 'automagically' appear in your LOV list. But because you'll probably want users to also be able to add new values in that column you use a popup LOV instead of a select list. The popup LOV allows users to type new values into the input field as well as selecting values from the popup list.

    Here's what I'm talking about. Say you were tracking cars and you had records in your data for Ford, Chevrolet and Chrysler. Someone comes along and has a Dodge. Well, Dodge isn't in the list yet so the user just types it in. The next user that wants to use Dodge clicks the popup LOV button and voila, Dodge appears in the list.

    This is accomplished with a select statement something like this:

    select distinct car_make d, car_make v from my_table_of_vehicles order by 1

    This will give you a distinct list of car makes and you won't have to create a special purpose table for it.

    Caveat: While this method is handy and it will work you need to understand that users could inadvertently create multiple entries for the same value. An example would be someone making an entry for Chevrolet and someone else adding Chevy. They really should be the same value but they are in fact different.

    The alternative to this is to create a data maintenance screen for your users to keep the allowed entries up to date in a special purpose table for your LOV.

    Earl

  • RELEVANCY SCORE 2.79

    DB:2.79:About Lov kk


    Hi all

    I have two lov on the form
    when i select value from one lov the second lov should get populate according to value of first lov.

    How can i do this.

    Thanks.

    DB:2.79:About Lov kk

    Hi,

    is this a PL/SQL error or a JavaScript error?

    If it's a PL/SQL error, have you installed the database part and created the necessary grants/synonyms in the case you have installed it into it's own ApexLib schema.

    It would really be easier if you write me an e-mail, because than you can send me attachments, like the HTML output of the page with debugging enabled.

    Thanks
    Patrick
    ------------------------------------------------------------------------------------
    Check out my APEX-blog: http://inside-apex.blogspot.com

  • RELEVANCY SCORE 2.79

    DB:2.79:Customize Lov cm


    Hello.

    I have two forms. In one form i create records with help of LOV (LOV is based on one table). I open another form which has some parameters from the first one. Now i use the same LOV (based on the same table). But in this LOV i want to see the LOV values used in first form on top of that LOV.
    Example.
    LOV is filed with:
    A
    B
    C
    D
    I insert in first form C, B and A.
    When i then open the LOV in the second form the LOV should look like:
    C
    B
    A
    D
    It's based on which LOV entries i insert in first form. LOV entries which have been used should appear on the top of LOV and then all others from the table on which LOV is created.

    Thanks

    DB:2.79:Customize Lov cm


    Sorry. In fact, that update of the last_insert_date must be done in the WHEN-BUTTON-PRESSED trigger which displayed the LOV. If you choose an value from the LOV then use an update to put sysdate in last_insert_date column, else null.

    Eugen