SQLSyntaxErrorException: ORA-00904: "DELETE_TS": invalid identifier #3289
Description
Hi,
I having an issue after I opening the screen in a Cuba portal.
Despite of having the 'Delete_TS' in respective table column this error is occuring.
I've checked the logs for this issue in the cuba portal. In the log there call happening to a SQL query which I've never used in my project
In that Query this Delete_Ts column in present. The query I'm mentioning below.
SELECT * FROM (SELECT a.*, ROWNUM rnum FROM (SELECT ID AS a1, "ATTRIBUTE1" AS a2, "ATTRIBUTE2" AS a3, BU AS a4, DELETE_TS AS a5, DELETED_BY AS a6, DESCRIPTION AS a7, FLAG AS a8, LOGDATE AS a9, PLANID AS a10, RUNDATE AS a11, VERSION AS a12 FROM COST_PLANID_MASTER WHERE (DELETE_TS IS NULL)) a WHERE ROWNUM <= ?) WHERE rnum > ?
I don't understand from where this query coming from?
If having Idea about this issue. Your help is needful.