3 Replies Latest reply: Nov 20, 2012 1:53 AM by 975131 RSS

    Error During  Batch Element Entry validation

    919526
      Am Getting the following Error when i try to validate a Batch using BEE Process

      ===============================================================================
      Oracle Human Resources Generic Process
      Started at : 13-NOV-2012 13:23:05
      Chunk Size : 20
      Threads : 1
      Logging Category :
      User Messaging : N
      Interlock : N
      Trace : N
      RR Buffer Size : 500
      RRV Buffer Size : 500
      Bal Buffer Size : 500
      EE Buffer Size : 500
      Logging Area :
      Assignment ID for Start:
      Assignment ID for End o:

      -------------------------------------------------------------------------
      PL/SQL Output
      -------------------------------------------------------------------------
      -------------------------------------------------------------------------
      HR_6881_HRPROC_ORA_ERR
      SQLERRMC ORA-01422: exact fetch returns more than requested number of rows
      ORA-06512: at "APPS.PY_ROLLBACK_PKG", line 3239
      ORA-06512: at line 2

      SQL_NO 4809
      TABLE_NAME py_rollback_pkg.rollback_payroll_action
      APP-PAY-06881: Error ORA-01422: exact fetch returns more than requested number of rows
      ORA-06512: at "APPS.PY_ROLLBACK_PKG", line 3239
      ORA-06512: at line 2
      has occurred in table py_rollback_pkg.rollback_payroll_action at location 4809

      Cause: an oracle error has occurred. The failure was reported on table py_rollback_pkg.rollback_payroll_action at location 4809 with the error text ORA-01422: exact fetch returns more than requested number of rows
      ORA-06512: at "APPS.PY_ROLLBACK_PKG", line 3239
      ORA-06512: at line 2
      .

      Action: Please contact your support representative.

      Kindly Assist with any inputs ..