The CreatorCon Call for Content is officially open! Get started here.

Flow Designer action "Record Producer". Store record producer information.

Flavio4
Kilo Sage

Hello,

I'm trying to create Incident records in Flow Designer with the action Record Producer*.
The execution seems correct but the Record Producer column of the Incident table is not filled automatically. With an additional Update Record action, it works.

Is it normal?
I checked on a PDI and I understand that the column Record Producer might be a customisation of our.
Thank you for a confirmation.

If indee it is a customisation, how is stored out of the box the information that a (incident) record is created through which record producer?

Thanks
Flavio

* We use a rather "legacy" instance, UI 16, on Xanadu.

1 ACCEPTED SOLUTION

Hello @Flavio4, Yes, you are right, Ideally, there should be an entry in the sc_item_produced_record. I'm wondering whether any customization is throwing error internally that is causing the insertion in underlying table or somewhere its stopped. 

I doubt whether following is the case for you, but please refer:

 https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0744421.

 

Regards,

Nishant

View solution in original post

16 REPLIES 16

Flavio4
Kilo Sage

Thank you Nishant, interesting.

I see, though, that the mentioned record created with the FD action "Record Producer" is not in table "sc_item_produced_record".
I find records in "sc_item_produced_record" if I use the FD action "Update Record" to update the (custom) column "Record Producer" in the incident table.

Isn't the update of "sc_item_produced_record" supposed to be out of the box when creating the record with FD action "Record Producer"?
If so, what is more likely? Maybe something underlying (Business Rule at submit?) has been customised to prevent the creation of a record "sc_item_produced_record", if the incident custom column "Record Producer" is not filled?

Regards
Flavio

@Flavio4 

if record is not getting inserted into "sc_item_produced_record" table then it means OOTB it doesn't link the INC with that Record Producer.

Check the documentation what it says that will clarify

The only way for you is this

In the Step where you are updating INC you can set that Custom Column with the Record Producer from earlier Step

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

@Flavio4 

I could see you marked my response as correct earlier and now it's not.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

@Ankur 
Yes, I was too quick with clicking with bottons suddenly moving in the UI.

Actually there is one initial point that is not answered: where the information about the RP which produced the incident record is stored in OOTB version and why the OOTB FD Action "Record Producer" does not create an entry in sc_item_produced_record.

Nishant refers to:

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0744421

What do you think? How to check if the  'SC Catalog Item' version is customized or not?

Regards
Flavio


Hello @Flavio4, Yes, you are right, Ideally, there should be an entry in the sc_item_produced_record. I'm wondering whether any customization is throwing error internally that is causing the insertion in underlying table or somewhere its stopped. 

I doubt whether following is the case for you, but please refer:

 https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0744421.

 

Regards,

Nishant