Validation rule for Project Profile

[former_member358181]

Hi,

We have already created four project coding mask (EX-2828/BDC/00000) and fifteen of Project Profile. And only eight project profiles are using by define the project coding mask, others as per Project specific of any starting four number.

We were maintained the validation rule as below

Prerequisite - -PROJ-PSPID :5-8: = 'BCDS'

Check - PROJ-PROFL = '0000010'

Because of this validation system was allowing any stating four numbers (ex- 1235, 3528, 5285) in project def. So we want to continue the same project coding mask (Ex.1235/BCDS/000000) which has already created. But it is not possible to create the same project coding mask without delete all created the previous project.

Because of that we are trying to build the new validation rule.

Prerequisite – PROJ-PROFL = '0000010'

Check - PROJ-PSPID :1-4: = '1235' AND PROJ-PSPID :5-8: = 'BCDS'

After this validation rule, system is not allowing to save the project and given the error message. But when we are give already created the project coding mask (Ex-2828), then allow to saving the project.

Please suggest how to build the validation rule.

Devendra

[former_member388328]

Hi Devendra,

Can you please explain what do you want to validate in the PROJ-PSPID :1-4: = '1235'. Are you checking only for project created with starting 1235.

Thanking you

Vengaiah

[former_member358181]

Hi Vengaiah,

Yes, I want to validate for Project created with starting 1235 for project profile - 0000010.

I have tried the below validation but any starting number is allowing to create the project.

Prerequisite - -PROJ-PSPID :1-4: = '1235'

Check - PROJ-PROFL = '0000010'

Devendra

[former_member388328]

Hi Devendra,

I think logic should be ...

Prerequisite- PROJ-PROFL = '0000010'

Check -PROJ-PSPID :1-4: = '1235'

Try above validation.

Thanking you

Vengaiah

[former_member358181]

Hi Vengaiah,

Thanks of respond, as per suggested I have tried the same validation and working.

Project def. 1235/BCDS/000000

Is it possible to validation for "1235/BCDS" for project profile - 0000010.

Devendra

[former_member388328]

Hi Devendra,

You mean to say if project starts with 1235/BCDS then system should check whether profile is

0000010.

Thanking you

Vengaiah

[Former Member]

You can change your validation check as below:

PROJ-PSPID :1-9: = '1235/BCDS'

[Paulo_Vitoriano]

Coding masks symbols are not counted, so PROJ-PSPID :1-8: = '1235BCDS'