CLM Broken Query

[adrian_horton]

I have a CLM user who personalized her query layout by selecting all available fields in CLM version 7 SP10.  Now the user receives the following error:

PURCHASING_GRP has not been added to the schema for table FCI_CONTRACT.

This error could not be reproduced in QA.  Has anyone else experience such issue and have found a solution?

[kushagra_agrawal · Accepted solution]

Hi Adrain,

In order to fix it, duplicate the standard query ODP-ODP-AllSavedResults and in the Results field add T1.USER_ACCOUNT_OBJECT_NAME and also remove T1.USER_ACCOUNT_OBJECT_ID=<%CURRENT_USER_ID%> condition from WHERE clause , this will display the name of the user which has personalized the specific query, just delete the entry. The personalization of the user will be reset and the query will not throw error.

Hope it helps!

Best

Kushagra A

[adrian_horton · Accepted solution]

Thank you Kushagra, this worked to revert the personalized view to standard.