cancel
Showing results for 
Search instead for 
Did you mean: 

Error in Query execution ORA-00904: "D2"."SID_0MAT_PLANT": invalid identifier

swati_gawade
Contributor
0 Kudos

Hi All,

I am facing below error in Query execution.

I have a filter on one of the navigational attribute of Mat_plant which is working fine for other queries.

Do you know how to resolve this issue?

Thanks,

Swati.

Accepted Solutions (1)

Accepted Solutions (1)

swati_gawade
Contributor

Issue resolved after re-creating DB indices

Answers (1)

Answers (1)

RamanKorrapati
Active Contributor
0 Kudos

Hi,

please try to SID test at RSRV for your mat_plant info object.

Try to run attribute change run on info object - 0mat_plant.

Try to run report thru RSRT and see.

Even its oracle error, please check/inform to DB or oracle team.

Thanks