SuperStream Report Errors With "ORA-06502: PL/SQL: Numeric Or Value Error" When Run For All Superfunds (Doc ID 2077622.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle HRMS (Australia) - Version 12.1 HRMS RUP7 and later
Information in this document applies to any platform.

Symptoms

On : 12.1 HRMS RUP7 version, Australian Payroll

SuperStream Report works fine when run for specific Super Fund but it errors when run for all Superfunds.

ERROR
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3

SQL_NO 1108
TABLE_NAME pay_archive.process_employee
APP-PAY-06881: Error ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3
 has occurred in table pay_archive.process_employee at location 1108

Cause: an oracle error has occurred. The failure was reported on
table pay_archive.process_employee at location 1108 with the error text
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3

STEPS
The issue can be reproduced at will with the following steps:
1. Setup SuperStream
2. Run Quickpay for one employee.
3. Run Pre-payments.
4. Add employee in assignment set.
5. Run SuperStream Report for this assignment set for the employee's super fund:

  Report Format: CSV
  Mode: Contribution
  Registered Employer: Australian Bureau of Statistics
  Start Date: 26-OCT-2015
  End Date: 26-OCT-2015
  Super Fund: Colonial First State first Choice Employer Super
  Fund USI: FSF0361AU
  Payment Transaction Date:
  Payment Reference Number:
  Assignment Set: Troy
  Delete Archive Date: Yes

-> Success. The output file contains one record for this employee.

6. Run SuperStream Report for same assignment set and all superfunds:

  Report Format: CSV
  Mode: Contribution
  Registered Employer: Australian Bureau of Statistics
  Start Date: 26-OCT-2015
  End Date: 26-OCT-2015
  Super Fund: *All Superfunds
  Fund USI: *All Superfunds USI
  Payment Transaction Date:
  Payment Reference Number: 18 characters in length
  Assignment Set: Troy
  Delete Archive Date: Yes

-> The report completes but there is no output file. Errors in the log.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms