Skip to Content
0
Former Member
May 01, 2015 at 05:23 PM

query throwing error

20 Views

Hi,

We are on SAP Sourcing 7.0 SP03

Developed a custom query

SELECT

<%RESULTS%>

FROM

(

SELECT

T1.DISPLAY_NAME AS AUNIQUE_DISPLAY_NAME,

<%LOAD_PAGE(contracts.Agreement,T1.OBJECTID )%> AS AGREEMENT_LINK,

T1.UNIQUE_DOC_NAME AS CUNIQUE_DOC_NAME ,

1003 AS CLASSID,

E1.ZSUPPNAME AS SUPPLIER_ID,

T1.VENDOR_OBJECT_NAME AS VENDOR_OBJECT_NAME,

T14.DISPLAY_NAME AS ZCOMPANY ,

T13.DISPLAY_NAME AS STATUS ,

T1.EFFECTIVE_DATE_DATE AS EFFECTIVE_DATE,

T1.EXPIRATION_DATE_DATE AS EXPIRATION_DATE,

T1.DOC_OWNER_USER_OBJECT_NAME AS AGREEMENT_MANAGER


FROM

<%SCHEMA%>.FCI_AGREEMENT T1

LEFT OUTER JOIN <%COLLABCHECK_TBL(T1.OBJECTID, 1003)%>

LEFT OUTER JOIN <%EXT_TABLE(contracts.Agreement)%> E1

ON T1.OBJECTID = E1.PARENT_OBJECT_ID

LEFT OUTER JOIN <%SCHEMA%>.FCI_MAS_VALUE_LIST_VALUE T13

ON T1.STATUS_OBJECT_ID = T13.OBJECTID

LEFT OUTER JOIN <%SCHEMA%>.FCI_MAS_VALUE_LIST_VALUE T14

ON E1.ZCOMPANY_OBJECT_ID = T14.OBJECTID

<%DYN_JOIN%>



WHERE

T1.INACTIVE = 0

AND T1.IS_TEMPLATE =0

AND T1.CONTEXTID = <%CONTEXT(contracts.Agreement)%>

AND T1.PARENT_CLASS_ID = 1004

AND T1.PARENT_COLLN_ID = 1

<%AND_OP("UPPER(T1.DISPLAY_NAME)",<%?(T1.DISPLAY_NAME)%>)%>


<%AND_OP("UPPER(T1.VENDOR_OBJECT_NAME)",<%?(T1.VENDOR_OBJECT_NAME)%>)%>

<%AND_OP("UPPER(T1.DOC_OWNER_USER_OBJECT_NAME)",<%?(T1.DOC_OWNER_USER_OBJECT_NAME)%>)%>


<%AND_OP("T14.OBJECTID",<%?(T14.OBJECTID)%>)%>

<%AND_OP("T13.OBJECTID",<%?(T13.OBJECTID)%>)%>

<%DYN_FILTER%>

<%ORDERBY%>

)

Then

output to display 1 more custom field.

We are getting error

SQL Exception: ORA-00904:"D1"."DISPLAY_NAME_ID": invalid identifier

But we do not have D1 in our query string or result or filters.