Australian SOE Errors with ORA-01403 on PAY_AU_SOE_PKG for Balance Section
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.
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
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
The issue can be reproduced at will with the following steps:
1. Process payroll runs
2. Review SOE.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms