Supplier Address Validation Forces City Name To Lowercase (Doc ID 1358721.1)

Last updated on MARCH 08, 2017

In this Document
  Symptoms
  Cause
  Solution
  References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Symptoms

On 12.1 version, Find that using the suggestions box when entering an incomplete address, creates all the address information in lowercase, even though the City, County information are entered in uppercase in TCA.

EXPECTED BEHAVIOR
-----------------------
That the suggestions functionality keeps the upper case on the information as it has been entered in TCA.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
- Login to Oracle Payables responsibility
- Navigate to: Supplier / Entry / Supplier
- Query a supplier
- Go to Address Book
- Click on Create button
- Entered the following information (This is an example for US however the issue applies to any address type):

123 Main Ave
Oakland  -> Notice the information is entered in lowercase
CA

Name: OAKLAND

- Click on continue

-> Error
These address elements are not validated: POSTAL_CODE. Correct the invalid elements, or continue and save the invalid address.

- Review the suggestions; choose the first one: Oakland, Alameda, 94601

-> This is the issue: The AP system put everything in lowercase, even though the information is in upper case in TCA. When reviewing the information in the TCA module the City is OAKLAND and county is ALAMEDA, in upper case.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create valid checks as their validation system requires the address to match the case of the address in TCA.

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