Nationality Code Generated In IRAS8A Is Different From What Is Entered In People Screen
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
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