Record Producer on Request Management tables is not supported - this error showed up on sc_request extended table. Is this not allowed?

[pankajsharma1]

Hey all,

I was trying to create a record producer on an extended table of sc_request. I ran into this error:

"Record Producer on Request Management tables is not supported"

But, then it got created anyways and seems to be working just fine. I wanted to check is it not the best practice? Or the error itself is the error?

Pankaj

[pankajsharma1]

Musab .. thanks for your answer. Is this a SNOW best practice = "Record producer is for task based records and not for service based records like Request , Requested item etc" ?

What if I want to create a request that starts with a different prefix than REQ? Can't I just use a record producer to create a record in any generic table and then use that record to create a request in a table that extends Request and uses a different prefix in its auto number? I can do that using flow in flow designer. 

Thanks for brainstorming this with me.

Pankaj

[Musab Rasheed]

Your first question

Is this a SNOW best practice = "Record producer is for task based records and not for service based records like Request , Requested item etc" ? It's not best practice , it's the setup or limitation like that

Second one

What if I want to create a request that starts with a different prefix than REQ? Can't I just use a record producer to create a record in any generic table and then use that record to create a request in a table that extends Request and uses a different prefix in its auto number? I can do that using flow in flow designer. As mentioned earlier you cannot create record producer with table extending from sc_request so create table which either extends task table or not extend anyone and then create record producer and from record producer record using workflow or flow designer you can try creating record similar to REQ that might work.

Regards