Australian SOE Errors with ORA-01403 on PAY_AU_SOE_PKG for Balance Section (Doc ID 2005786.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

After applying
Patch 20502470:R12.PER.B - ENABLE SUPER FUND PARAMETER OPTIONAL FOR CSV FORMAT IN SUPERSTREAM REPORT
getting an error when reviewing the SOE via the forms interface.
Issue did not happen prior to the patch application.

All the information under the "Balance" section does not appear


ERROR
sqlerm ORA-01403: no data found
ORA-06512: at "APPS.PAY_AU_SOE_PKG", line 418
ORA-06512: at "APPS.PAY_AU_SOE_PKG", line 791


STEPS
The issue can be reproduced at will with the following steps:
1. Process payroll runs
2. Review SOE.

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