My Oracle Support Banner

Supplier Registration Needs Data Format Validation for Bank Routing Number and Phone Number (Doc ID 2071849.1)

Last updated on OCTOBER 02, 2018

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


1) There is no specific data format for setting up questions like Banking
information which should have certain validations other than data type.
For e.g. In USA, Routing number for bank account should be 9 digits. But when
data type number is selected for such question on profile questions setup
page, the format allows decimal pattern number to be entered with 12 numbers
on left of decimal and 6 on right of decimal sign. There should be specific
data types or option to choose number of positions before decimal and after
decimal and format of number like we have in excel spreadsheets.
@ Also, for questions like phone number the data type of number is not
valid and there is no other correct data type or validations available.

2) Contacts step in supplier registration has Telephone number as a required
field, but user can enter random characters/numbers in telephone field.
There is no validation for telephone number format.


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

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