Getting An Error When Accessing ZA Payslip On Self-Service: JAVA.SQL.SQLEXCEPTION: ORA-06502
Last updated on APRIL 09, 2017
Applies to:Oracle HRMS (South African) - Version 12.1 HRMS RUP8 and later
Information in this document applies to any platform.
When attempting to open a payslip from Self-Service Employee, the following error occurs:
You have encountered an expected error. Please contact the System Administrator for assistance.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Steps to reproduce
The issue can be reproduced with the following steps:
Apply the patches:
- Patch 22673871
- Patch 22823312
- Patch 22637231
Use ZA HRMS Responsibility
1. Run Payroll
3. Check the online payslips from Self-Service Responsibility.
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