My Oracle Support Banner

HK: Error "ORA-1722" When Generating IR56G (Doc ID 2747663.1)

Last updated on APRIL 09, 2021

Applies to:

Oracle HRMS (Hong Kong) - Version 12.2 and later
Information in this document applies to any platform.


Problem Statement:

When trying to run the concurrent program "IR56G Employee Cessation departing Hong Kong" , the following error appears

REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1401: MSG-00222: ORA-01722: invalid number
ORA-06512: at "APPS.PAY_HK_IR56", line 453
ORA-06512: at "APPS.PAY_HK_IR56", line 230
REP-1401: 'beforereport': Fatal PL/SQL error occurred.
ORA-06503: PL/SQL: Function returned without value



Steps to Reproduce:
The issue can be reproduced at will with the following steps:

  1.  Login application and select Hong Kong HRMS Responsibility

  2.  Navigate to Process and Reports > Submit Process and Reports
  3.  Run the concurrent program "IR56G Employee Cessation departing Hong Kong"
  4.  In log file, the above error can be seen




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.