1 Reply Latest reply: Jul 27, 2013 12:44 PM by Kashif M RSS

    ORA-01422: exact fetch returns more than requested number of rows in R12

    LnTInfotech

      Hi All,

       

      Getting the below error in custom report of purchasing.

       

      REP-1401: 'afterpform': Fatal PL/SQL error occurred.

      ORA-01422: exact fetch returns more than requested number of rows

       

      To overcome this error I have added some exceptional handling as per below and the report is completed with Normal with output but the ouput is repeating in 150 pages in R12 but the same output in 11i showing only one page. Please advise.

      when no_data_found then

                   :P_po_num_type := 'ALPHANUMERIC'; 

              when too_many_rows then

                   :P_po_num_type := 'ALPHANUMERIC';

              when others then

                   :P_po_num_type := 'ALPHANUMERIC';

       

      Regards,

      Sushant