Reference fields to sc_req_item table are not showing display value

Brian Bouchard
Mega Sage

It seems anywhere we have a reference field that refers back to the sc_req_item table the reference field is not showing the RITM number as expected. I have confirmed that Number is set to Display=true, but we still cannot see the actual RITM #s 

Examples: When looking at a PO Line Item should refers back to a RITMin the "Request Line" field, the value appears blank on the form, However, if you click the information icon to the right of the field, you can drill into the correct RITM, so we know it's assigned properly.

On notifications based on the sc_req_item table, when you do a preview and point to a specific right, the Preview Record field says "Requested Item:"  instead of the actual RITM number.

Approvals records for RITMs behave the same way as notifications previews.

Any thoughts on what could be causing this?  It feels like it's something on the RITM table definition since it seems to be affecting all the placed where a field is referencing this table, but I can't find anything that explains what's happening.

 

9 REPLIES 9

nataliya_b
Tera Guru

it might happened because you have two fields with display = true, go to table sc_req_item ->table columns, filter out display=false, make sure only number field has display true.

if there is only one column Number with display=true, uncheck and check again.

 

I've looked at this and only found the 1 field set to display=true. Tried your suggestion of unsetting and resetting, but I'm still experiencing the same issue.

what happens if you set up different field as display? how does it come out?

is your variable part of variable set?

Setting a different field to Display has the same results.  This isn't a variable on a catalog item that I'm referencing. It's the OOB references to RITMs.  The number field, which is set to Display is coming from the task table, and references to all other tables extended from task appear to be working as expected.
I've also looked for Dictionary overrides on this field for the sc_req_item table and did not see any.