My Oracle Support Banner

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

Last updated on MARCH 08, 2017

In this Document

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.


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.

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

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


- 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.

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.


To view full details, 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 a vibrant support community of peers and Oracle experts.