Nationality Code Generated In IRAS8A Is Different From What Is Entered In People Screen

(Doc ID 2242013.1)

Last updated on MARCH 08, 2017

Applies to:

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


On : 12.1.3 version  , Singapore Payroll

Nationality Code generated in IRAS8A is different from what is entered in People screen

There is an employee with Nationality as American. But in IRAS8A extract it is being generated with code 702 which is the code for "American Samoa".

The below piece of code seems to be causing the issue.

Package Body: pay_sg_iras_archive
Version: /* $Header: pysgirar.pkb 120.19.12010000.38 2017/02/23 23:25:57 jalin ship $ */

Line Number: 5538 to 5541

select meaning
  from hr_lookups
where lookup_type = 'SG_COUNTRY_CODE'
  and upper(description) like '%'||c_nationality||'%';

Returns wrong value as 721 where as it should be 503

Expect to see RFF AWO503 instead of RFF AWO721

The issue can be reproduced at will with the following steps:
1. Create an employee with Nationality as American
2. Generate IRAS 8A
3. Check the nationality code.



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