question List Collector showing as Sys_id when seen in the Demand record in SPM forum

List Collector showing as Sys_id when seen in the Demand record

Trupti Krishnam — Thu, 09 Oct 2025 14:46:02 GMT

I have a Record Producer where in I have a Field called = Impacted Business Unit which is a List collector and it is referencing to "Business Unit" Table and it is mapped to "Impacted business Applications" of Type -List , it is a custom field in the Demand Record. In the record producer Form level this field Impacted business Unit is showing the Right Display value but after the form submission In the Demand Record this field is setting to sys _id . I've checked with display checkbox on the business_unit table it is checked for name column but still it is not working . Can anyone help please

Re: List Collector showing as Sys_id when seen in the Demand record

Brad Bowman — Thu, 09 Oct 2025 15:01:01 GMT

Does your custom field on the Demand table also reference the Business Unit table? Why not use the out of box Impacted Business Units field?

Re: List Collector showing as Sys_id when seen in the Demand record

Vasantharajan N — Thu, 09 Oct 2025 15:01:08 GMT

@Trupti Krishnam - Can you confirm whether "impacted business Applications" field is having reference to Business Unit table same as your record producer variable referring to Business Unit table

Re: List Collector showing as Sys_id when seen in the Demand record

palanikumar — Thu, 09 Oct 2025 15:01:10 GMT

Hi,

From your message I understand that Record Producer is mapped to Business Unit table and Demand Record is mapped to Business Application table. Make sure both are mapped to same table, otherwise you will face this issue.

Re: List Collector showing as Sys_id when seen in the Demand record

Ankur Bawiskar — Thu, 09 Oct 2025 15:22:49 GMT

@Trupti Krishnam

share variable config screenshots.

Re: List Collector showing as Sys_id when seen in the Demand record

Trupti Krishnam — Thu, 09 Oct 2025 15:25:56 GMT

@Vasantharajan N yes the custum field is also having business unit

Re: List Collector showing as Sys_id when seen in the Demand record

Trupti Krishnam — Thu, 09 Oct 2025 15:29:23 GMT

This is the field on the demand table

This is a field on the Record producer

Re: List Collector showing as Sys_id when seen in the Demand record

Trupti Krishnam — Thu, 09 Oct 2025 15:46:06 GMT

yes , they are referring to the same table

Re: List Collector showing as Sys_id when seen in the Demand record

Trupti Krishnam — Thu, 09 Oct 2025 15:50:15 GMT

but still it is showing sys_id

Re: List Collector showing as Sys_id when seen in the Demand record

Brad Bowman — Thu, 09 Oct 2025 16:53:34 GMT

Your screenshots show your List field is referencing a different table than your List Collector variable...