4 Replies Latest reply: Apr 10, 2013 7:45 AM by Hussein Sawwan-Oracle RSS

    REP-0004: Warning: Unable to open user preference file

    996528
      I have created new Custom concurrent program . when i was running time its show below error

      Enter Password:
      REP-0004: Warning: Unable to open user preference file.
      MSG-01000: XXTCMPOXACTPO : Error accessing table FINANCIALS_SYSTEM_PARAMETERS . Contact your System Administrator.
      REP-1401: 'afterpform': Fatal PL/SQL error occurred.
      ORA-01422: exact fetch returns more than requested number of rows

      In Report -> afterform trigger

      /**** Afterparamet form trigger codes ****/



      BEGIN
      select set_of_books_id
      into l_sysparam_sob_id
      from financials_system_parameters;
      EXCEPTION
      WHEN NO_DATA_FOUND THEN
      FND_MESSAGE.set_name('SQLGL', 'MRC_SYSTEM_OPTIONS_NOT_FOUND');
      FND_MESSAGE.set_token('MODULE', 'XXTCMPOXACTPO');
      srw.message(2000, FND_MESSAGE.get);
      raise;
      WHEN OTHERS THEN
      FND_MESSAGE.set_name('SQLGL', 'MRC_TABLE_ERROR');
      FND_MESSAGE.set_token('MODULE', 'XXTCMPOXACTPO');
      FND_MESSAGE.set_token('TABLE', 'FINANCIALS_SYSTEM_PARAMETERS');
      srw.message('1000',fnd_message.get);
      raise;
      END;


      END;




      /****** end *******/

      can anyone help how to solve the issue. Its afterparamt code error or any other errors

      Regards
      sanjay

      Edited by: 993525 on Apr 10, 2013 5:00 PM