Fusion US Payroll: SSN Masking Recommended By Oracle In ACA Implementation Guide Doesn't Work Correctly In 1095 Form (Doc ID 2929371.1)

Last updated on MAY 01, 2023

Applies to:

Symptoms

On : 11.13.23.01.0 version, US - United States Legislation

ACTUAL BEHAVIOR
---------------
SSN Masking recommended by Oracle in ACA Implementation guide doesn't work correctly in 1095 form.
Followed the instructions on how to mask SSN in the 2022 template and it doesn't print any SSN now.

EXPECTED BEHAVIOR
-----------------------
Masked SSN to be printed.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
To mask the SSNs of employees and their dependents:
1. Open the appropriate predefined 1095-C template.
a. From Tools, click Reports and Analytics.
b. Click >>, and select Shared Folders.
c. Expand Human Capital Management, Benefits, US, ACA, and then 1095c.
d. Open the appropriate predefined 1095-C template.
The template name is based on the form year, such as 2018, 2019, or 2020.
2. To mask the employee SSN:
a. Navigate to Part 1: box #2 Social security number (SSN).
b. Right click on SSN, and select BI-Publisher and then Properties.
c. Replace:
<?US_ACA_PER_PRIMARY_NID?>
with:
<?concat('XXX-XX-', substring(US_ACA_PER_PRIMARY_NID,string-length(US_ACA_PER_PRIMARY_NID)-4))?>

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.