Skip to Content
0
Former Member
Jun 24, 2009 at 12:43 PM

Error in Custom E-Sourcing Report

92 Views

Dear all,

I would appreciate your inputs or sugggestions on an error I am receiving with a custom RFx Document Report. I get the error 'invalid column index' when I run the query in the preview mode or from the document.

Details of the Report:

We have a custom extension definition on the Rfx, which I am trying to query.

This is the query:

SELECT <%RESULTS%> FROM <%SCHEMA%>.FCI_RFX_DOC T1, <%EXT_TABLE(rfx.RFXDoc,CustomExtensionName)%> T2

WHERE T1.CONTEXTID = <%CONTEXT(rfx.RFXDoc)%> AND T2.PARENT_OBJECT_ID = T1.OBJECTID

It evaluates to:

SELECT T2.Ext_Field1, T2.Ext_Field2 FROM esource.FCI_RFX_DOC T1, esource.FCI_DYN_$2147483347 T2 WHERE T1.CONTEXTID = -2147483548 AND T2.PARENT_OBJECT_ID = T1.OBJECTID

Could you please let me know if you are able to identify the source of this error.

Thanks & Regards,

Reshma Varghese