"Japan, Salary Payment Report E-File(PAYJPSPE)" Prints Incorrect Address for Terminated Assignments (Doc ID 1932615.1)

Symptoms

Concurrent program "Japan, Salary Payment Report E-File"(PAYJPSPE) prints address with user defined address type rather than with the seeded address type.  If employee has multiple addresses with different types, Reporting Residential Address(JP_R) has a priority to be printed, and then Current Address(JP_C).

Steps to Reproduce:

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

1.  Create an user-defined address_type = XXTYPE.
2.  Enter SWOT agent information.
3.  Enter address for the employee.
   
   e.g.
   
   select address_id, date_from, date_to, address_type,address_line1, address_line2, address_line3
   from per_addresses
   where primary_flag = 'Y' and person_id = <&PERSON_ID>;
   
   ADDRESS_ID DATE_FROM  DATE_TO   ADDRESS_TYPE   ADDRESS_LINE1 ADDRESS_LINE2 ADDRESS_LINE3
   -------------- -------------- ----------- ------------------  ------------------ ----------------- -----------------
            11111  01-01-2010         null                  JP_C             Chiyoda                     1                    1
            11112  01-01-2010         null              XXTYPE             Chiyoda                     2                    2
   
   
4. Terminate the employment.
   
   Actual Termination Date: 12-31-2014
   Final Process Date: 12-31-2015
   
   
5. Run the concurrent programs "Payroll(Run)" and "Japan, Create Payroll Data for use in Reporting Form".
6. Run the concurrent program "Japan, Salary Payment Report E-File".
7. E-file (XML, PDF, CSV) prints the address with the custom address_type = XXTYPE.

Changes

Cause

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