Web ADI Not Recognizing Matching Null For Merge Fields (Doc ID 1980757.1)

Last updated on DECEMBER 21, 2016

Applies to:

Oracle Human Resources - Version 12.1 HRMS RUP6 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
On application of the <Patch 16655943> as per<Note 1308417.1>, the below issue has been introduced.

1. Dates in 'dd fmMonth yyyy' format are being merged as US dates and appear in the Word document in the format 'mm/dd/yyyy'.
2. Merge fields containing spaces are merged as nulls.
3. Numbers in text fields are merged as numeric e.g. missing leading zeros.


HISTORY OF THE ISSUE:
Customer has letters for category Recruitment created using Web ADI. These letters have have if...else...then mail merge condition checking if the field value is null.
These letters are working fine on 11i but the same templates when migrated to R12 platform do not work.

IF customer substitutes the null with a space in data source and modify the the condition on space, it is picking up the values correctly.

As an example: following doesn't work in R12 but works in 11i, provided in source we have null in email_address field
{IF {MERGEFIELD EMAIL_ADDRESS} = "" "The email Address is null" "The email address is filled"

As a workaround, customer has modified the view to replace null with space ie. nvl(email_address,' ') email_address and modified the template as follows
{IF {MERGEFIELD EMAIL_ADDRESS} = " " "The email Address is null" "The email address is filled"

The condition with space worked fine. There was a possibility that in R12, the Web ADI is not recognizing the null value while doing the mail merge.

Reviewed below note:
Web Adi Downloads in HRMS Null Values Create Blank Lines (<Note 1308417.1>)
After verifying the file version, this patch was applied.

Patch Results:
The patch now merges null fields correctly but has introduced the following issues:
1. Dates in 'dd fmMonth yyyy' format are being merged as US dates and appear in the Word document in the format 'mm/dd/yyyy'.
2. Merge fields containing spaces are merged as nulls.
3. Numbers in text fields are merged as numeric e.g. missing leading zeros.


EXPECTED BEHAVIOR
The patch should not have introduced new issues.


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

1. Applied the <Patch 16655943> as per <Note 1308417.1> to handle the issue of Web ADI (in R12) not recognizing the null value while doing the mail merge.

2. However, the patch introduced the above issues.



Cause

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