Variables not accessible through script/workflow for custom table extended from sc_req_item that is created through a Record Producer


Description

Variables not accessible through script/workflow for custom table extended from sc_req_item that is created through a Record Producer

Resolution

Creating Requested Items through a Record Producer is not supported.
The custom table extended from the "sc_req_item" table. OOB, this is not Extensible but it was set to be so in the instance.

A Record Producer was used to create the custom Requested Item records. This is not advisable and is mentioned to no do so in the below Documentation:
Record Producer

Record Producers will store variables on the "question_answer" table.
Requested Items will store variables on the "sc_item_option_mtom" table.

Because the custom Requested Item was created from a Record Producer, it stores the Variables on the question_answer table.
When you run the Code: "gr.variables.getElements()" it tries to pull from "sc_item_option_mtom" table since it extends from the Requested Item table.

So, do not use Record Producer to create Requested Items, including ones from your custom table. This is not supported.