SAP Knowledge Base Article - Preview

2459868 - EIS Analytics DM_LOAD or DM_LOAD_MANUAL Failure produces ORA-00904: invalid identifier

Symptom

There is an error message similar to the following in the SAP Enterprise Inventory and Service-Level Optimization (EIS) Analytics DM_LOAD or DM_LOAD_MANUAL error log:

Data flow DF_F_Stocking_Point_Plan|Reader CachedComparisonTableReader3 
SQL submitted to Oracle Server <(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT =1521)))(CONNECT_DATA =(SID=)))>
resulted in error <ORA-00904: "TCRdr_1"."EFFECTIVE_LEAD_TIME": invalid identifier


Read more...

Environment

SAP Enterprise Inventory and Service-Level Optimization (EIS) Analytics

Product

SAP Enterprise Inventory and Service-Level Optimization Analytics all versions

Keywords

SmartOps, EIS, EIO, MIPO, Analytics, AIM, Oracle, DataMart, ATL, Data Services, ORA-00904, DM_LOAD, DM_LOAD_MANUAL, EFFECTIVE_LEAD_TIME, invalid, identifier  , KBA , SCM-EIS , SAP Enterprise Inventory and Service-Level Optimization , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.