|
Description |
|
When saving a custom field on the Permit to Work screen and you try to filter or do a dataspy using that custom you get the error The SQL Statement is invalid: ORA-00904: "PTW_CODE": invalid identifier. Verified on the following environments with the steps below: # Create a custom field (select checkbox Include in Grids), and associate it to entity PTW in Associate Custom Fields screen. # Then go to the Permit to Work Screen and add a detaspy filter for the custom field you created (filter dropdown, Click here…) # Select an operator (e.g., "Equals" or "Contains") add a value and hit Run or Save. Here is when error the error message appears. Expected behavior: Run or save dataspy for custom fields Current behavior: dataspy does not run and instead the error message appears. For additional details, please refer to the attached screen captures. |