Supplier Address Validation Forces City Name To Lowercase
Last updated on MARCH 08, 2017
|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.|
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
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.
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