Field not found in QV

[vireshkolagimat]

Hi All,

I am using the below sql statement to extract the data from the oracle database. At at times i get the error as Field not found. The field is very much available and sometime the query just works fine.

Any suggestions what is going on at the back end?

Below is the query for your reference:

Field not found - <CUSTOMERCODE>
SQL SELECT
CUSTOMERCODE,
WAREHOUSECODE,
WAREHOUSENAME,
ORDER_NUMBER,
PRODUCTCODE,
INVOICENO,
INVOICEDATE,
SALESCOST,
SALESLISTVALUE,
SALESCOMMISSION,
SALESCUSTOMERGROUP,
SALESTERRITORY,
REGIONCODE,
CHANNELCODE,
SALESMANCODE,
ROUTECODE,
SALESUNIT,
SALESUNITFACTOR,
RETURNTYPE,
SALESQTY,
SALESVALUE,
ORDER_TYPE,
ORDER_LINE_ID,
ORDEREDDATE,
CUST_PO_NUMBER,
INV_LAST_UPDATE_DATE
FROM APPS.XXEGC_QV_SALES_HISTORY_V;

[vireshkolagimat]

Hi, the field divisioncode is available and it runs fine. But sometimes suddenly i start getting this error message.

Thank you.

[PrashantSangle]

are you facing any network drop issue?
AFAIK, This is usually happen if network is drop or as Tresesco Suggested table is locked by some other activity.

Regards,
Prashant Sangle