Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Populate a field

Highlighted
Deviga
Super Collector

Populate a field

Using a field "proj Request",am populating another field "Proj Manager".

Once i select a value for 'Proj Request' field and after population step, i then trying to change the field 'Proj Request'(ie delecting the current value and selecting another value).after deleting the field it passes the NULL value to the Token and so the RULE throws Error msg. so i cant populate.

Please Advise on this.
Thanks in Advance.

5 REPLIES
Shravan Kathuri
Senior Member

Re: Populate a field

Hi Deviga,

What is the SQL text that you have in the rule?

Thanks
Shravan kumar.
Deviga
Super Collector

Re: Populate a field

Hi,

I have attached the Sql query and error msg.


Thank u
Deviga
Super Collector

Re: Populate a field

Hi,

I hav attached query,error msg, dependency window and rule window for ur reference.

Thank you
Erik Cole
Honored Contributor

Re: Populate a field

Try replacing

and req.request_id = [REQ.P.MASTER_PROJ_REQ]

with

and req.request_id = nvl('[REQ.P.MASTER_PROJ_REQ]',0)

to handle the NULL token values.
Deviga
Super Collector

Re: Populate a field

Hi Cole,

Its working Fine.
Thank you for your advise.
//Add this to "OnDomLoad" event