Error in Select: ORA-00904 Invalid Identifier

Seems the issue is related to the custom filed X_CERTREQ

Please follow the below steps
 

1. Unpublish the custom field X_CERTREQ

2. Open Refresh Server Cache Window and refresh cache for Dictionary, security, Reference and Object Connection

3. Go back to Custom fields list and Republish the Custom Field again.

4. Resynchronize the tasks.
   
   If it's not resolved, please create a support ticket to IFS, then our technical consultants will investigate the issue further and give a proper answer.
   
   Best Regards
   -Kelum 

Hello, this option did not work, unfortunately… any other solutions?

ynwkm wrote:

Why is this error popping up?
Would love help on this.
Thank you!

Can you RMB in the header, show SQL statement and post a screenshot of it?

anmise wrote:

ynwkm wrote:

Why is this error popping up?
Would love help on this.
Thank you!

 

Can you RMB in the header, show SQL statement and post a screenshot of it?

@anmise

 

This here, right?
(tried to adjust CF by adding ‘_DB’, but it made no difference.

Hi 

This error suggests that the source data view/table doesn’t have the field name available. 

Ensure the source field names are exactly as expected

Cheers Lee