Current Position:Home > Forms Personalization - FRM-40502: ORACLE error: unable to read list of val

Forms Personalization - FRM-40502: ORACLE error: unable to read list of val

Update:11-30Source: network consolidation
Advertisement
Hi,
I am using Forms Personalization to create an LOV using builtin. In the Builtin, I have put the sql query under create record group from query. In the query, when I hardcode a value, in a where condition, the LOV works fine but when I replace the hardcoded value with :block.field value, it gives the error, FRM-40502: ORACLE error: unable to read list of values. Below is the part of the sql query where I am facing this issue.
"WHERE related_customer_id = :ORDER.INVOICE_TO_CUSTOMER_ID"
Please get back to me if anyone has faced similar problem.
Thanks all in advance,
Regards,
AN

The Best Answer

Advertisement
Please post a new thread for each issue. Tacking onto a 2 year old post is generally a bad idea.
Forms personalization is a feature in Oracle E+Biz Suite and as such you should post your question in this forum:
OA Framework
  • Forms Personalization - FRM-40502: ORACLE error: unable to read list of val Update:11-30

    Hi, I am using Forms Personalization to create an LOV using builtin. In the Builtin, I have put the sql query under create record group from query. In the query, when I hardcode a value, in a where condition, the LOV works fine but when I replace the

  • Frm-40502: oracle error: unable to read list of values Update:10-11

    Hi All, I am personalizing the assignment form, where we need to restrict the JOB LOV based on Organization value. In Forms Personalization we are creating the record group from query and attaching to Job field. The query is, SELECT DISTINCT j.NAME,

  • [SOLVED] FRM-40508:ORACLE error: unable to INSERT record Update:10-11

    Hi all, I have migrated this form from 4.5 to 10g (Version 10.1.2.0.2 ). This form inserts a record into the database table when all the fields in the form are filled and a button Save is presed. At the time when I press the Save button, I get this e

  • Frm-40505:ORACLE error: unable to perform query in oracle forms 10g Update:10-11

    Hi, I get error frm-40505:ORACLE error: unable to perform query on oracle form in 10g environment, but the same form works properly in 6i. Please let me know what do i need to do to correct this problem. Regards, PriyaHi everyone, I have block create

  • "FRM-40501: Oracle error: Unable to Reserve Record For Update or Delete" Update:11-30

    "FRM-40501: Oracle error: Unable to Reserve Record For Update or Delete" as I can unblock a session in the graphical surroundings of administration of the BD 10g of OracleFrom experience with this problem since the blocked customer form has been

  • FRM-40509: ORACLE error: unable to UPDATE record. Update:11-30

    FRM-40509: ORACLE error: unable to UPDATE record. what can i do?There will always be another error which tells you what the actual problem on the database is. Use the Display message key, or message out DBMS_ERROR_TEXTRead other 2 answers

  • About the FRM-40508 ORACLE ERROR, Unable to insert' Update:11-30

    Dear Friends: I use the Toolbar button to insert one record -- do_key('CREATE_RECORD') in the Toolbar_actions procedure, and then, input the value for this record, and then, click the "Save" button -- commit_form; in the when_button_pressed trig

  • FRM-40506: Oracle error: unable to check for record uniqueness Update:11-30

    Hello everyone I have an emergency problom. the context is: I have a master -detail structure in a form. first, my detail is a tabulation view, so it has severals records. Then, when i try to commit the form ii received the message <<<FRM-40506:

  • FRM-40501 ORACLE error: unable to reserve record for update or delete when Update:11-30

    Hello. I have two tab pages and one item on each page. Second tab page item, is mirror item of the first one. I use synchronize property on the mirrored one. When i try to update mirrored one i get that error: FRM-40501 ORACLE error: unable to reserv

  • FRM-40512 ORACLE ERROR UNABLE TO ISSUE SAVE POINT COMAND Update:11-30

    Dear Friends I am getting this FRM-99999 ERRORE 408 OCCURRED FRM-40655 SQL ERROR FORCED ROLLBACK CLEAR FROM AND RE-ENTER TRANACTION. FRM-40512 ORACLE ERROR UNABLE TO ISSUE SAVE POINT COMAND. I am calling the form using the following script : :global.