Skip to Main Content

PeopleSoft Enterprise

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Where to find certification matrix of Peoplesoft/PeopleTools on Oracle/AIX?

MeowMeowMay 10 2012 — edited May 11 2012
I searched all over on metalink and can not find a documentation on the Peoplesoft Enterprise/Peopletools certification matrix, release schedule, nor product lifecycle support matrix.

Does anyone know where to find it? (Not through Metalink's Cerfication Tab)

Thanks,

Comments

Marwim
Hello 945437,

welcome to the forum.

Can you give us more details? Validating phone numbers is not a trivial task, see {thread:id=2414369}

Regards
Marcus
Karthick2003
945437 wrote:
Hi,

Can any one please help me to create a function or procedure to validate phone numbers of different country including country code + area code + local number.
What kind of validation you are looking for?
riedelme
945437 wrote:
Can any one please help me to create a function or procedure to validate phone numbers of different country including country code + area code + local number.
If you search online you might be able to find something already written. Writing your own will ensure that it does precisely what you want.

Start by working out the logic of what you want to do and then implement it. If you don't know how to go about it start with pseudocode - a list of steps to do what you want to do.

Regarding the issue of procedure or function consider how you intend to use the program. If you want to use it in SQL then you must use a function and obey a bunch of rules (don't do certain things) for that to work. If you merely want to validate from other PL/SQL then a procedure might be best. Generally functions return values and procedures perform actions but there is a lot of overlap betwee the two. Also if you use a function you can always use a wrapper procedure to call it later.

Pseudocode to perform your validation could look something like (and there are lots of ways to do this)

set valid/invalid switch to valid
use SUBSTR() to get the country code
use SUBSTR() to get the area code (first 3 digits)
validate the country code - store valid ones in a table and perform a lookup. Set valid/invalid switch to invalid if not found, then exit
validate the area code - store valid ones in a table and perform a lookup. set valid/invalid switch to invalid if not found, then exit
validate the rest of the phone number. Make sure all values are digits. set valid/invalid switch to invalid if not found, then exit
exit with valid/invalid switch set to valid
Marwim
use SUBSTR() to get the country code
use SUBSTR() to get the area code (first 3 digits)
You might be able to split the phone number if it is not stored as a single string, otherwise:

The country code has no fixed length http://en.wikipedia.org/wiki/List_of_country_calling_codes

The length of the area code might differ from country to country. Here in Germany it depends on the organization level. The capital of a federal state has 3 digits (e.g. Munich 089). Of course one less, if there exists a country code. The capital of a county has 4 digits and cities an other administrative districts within the county have 5 digits.

So you would need a complete ruleset for each country to validate a phone number.

Regards
Marcus
riedelme
Marwim wrote:
The length of the area code might differ from country to country. Here in Germany it depends on the organization level. The capital of a federal state has 3 digits (e.g. Munich 089). Of course one less, if there exists a country code. The capital of a county has 4 digits and cities an other administrative districts within the county have 5 digits.
You are right. A lot of what the OP will have to do will depend on how his data looks. I was assuming fixed width data (being optimisitic that such would make things easier) but since the OP did not provide any data that and other assumptions will have to be adapted to reality.

Anyway I was just trying to give the OP an example of how to get started :)
Marwim
Anyway I was just trying to give the OP an example of how to get started
But phone numbers are like a wild beast. Even with a lot of experience you can get hurt very badly, especially when someone treats them as numbers ;-) Therefore always caution beginners who want to tame them.
skummetha
Hi ,
Thank you all for your replies.

I have to validate phone numbers of five countries ( India,Malaysia,Singapore,Australia,Hongkong) , I have to check their country codes + area code + length(local number) of all cellular networks available in all the above countries and have to update a flag column with yes or no .
sb92075
945437 wrote:
Hi ,
Thank you all for your replies.

I have to validate phone numbers of five countries ( India,Malaysia,Singapore,Australia,Hongkong) , I have to check their country codes + area code + length(local number) of all cellular networks available in all the above countries and have to update a flag column with yes or no .
How do I ask a question on the forums?
2176552
Marwim
I have to validate phone numbers of five countries
Do you know the possible combinations of "country codes + area code + length(local number)"?
If yes, then post the rules and we can help you. If not, then your first step should be to find out, e.g. in a forum specialized on telecommunication.

Regards
Marcus
953480
Hi ,
You can perform this task using query... use substr and case
Gurjeet
Hi ,
You can perform this task using query... use substr and case
1 - 11
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 8 2012
Added on May 10 2012
3 comments
5,256 views