1 Reply Latest reply on Oct 17, 2006 11:54 AM by 518974

    Please Help me !!

    539984
      There is one issue when user try to go to lines level one error is coming out :
      APP-FND-01564: ORACLE error 1422 in FDFGVD

      Cause: FDFGVD failed due to ORA-01422: exact fetch returns more than requested number of rows.

      and when he click on the DFF field the error is :
      APP-FND-00730: This flexfield has an invalid value set. It may use a special value set that uses an Edit event user exit, and the user exit has failed. If you are using a form on a graphical user interface (GUI) you may have an invalid value set of a different type, possibly a table-validated value set where the table or view does not exist or where there is an invalid WHERE clause.

      Please let me know its a technical issue or functional issue and how to resolve it.I have used all the options but unable to resolve it.

      Please help me in resolving this issue.

      Regards
      Hemendra Singh Shaktawat
        • 1. Re: Please Help me !!
          518974
          Hi Hemendra,
          Please check the SQL Statement that is executed during the error. Seems to be more of a technical issue, but you can ascertain that only after checking the SQL query's behavior in your instance.

          HTH.