My Oracle Support Banner

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

Last updated on FEBRUARY 15, 2019

Applies to:

Oracle Payables - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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