1 Reply Latest reply on Jul 27, 2013 5:44 PM by Kashif Manzoor

    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