My Oracle Support Banner

Enterprise Command Center - Space Utilization Data Load Error (Doc ID 2778171.1)

Last updated on NOVEMBER 02, 2021

Applies to:

Oracle Inventory Management - Version 12.2.5 and later
Oracle Enterprise Command Center Framework - Version 12.2.8 to 12.2.8 [Release 12.2]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
--------------------------

Recently upgraded to ECC version 6 and trying to run Inventory Space Utilization Data Load for the first time, but notice that it completed in error. See following errors in log request.
 
EXPECTED BEHAVIOR
---------------------------
Be able to successfully run Inventory Space Utilization Data Load without it completing in error.
 
ERROR
-------
Data load concurrent program failed

 JOB Details:
 Details of auditDataset#: 55418
  dataset: inv-space
  startTime: Thu Apr 29 15:03:36 EDT 2021
  endTime: Thu Apr 29 15:03:53 EDT 2021
  status: FAILURE
  total elapsed time: 0:0:17
  auditLoadRuleId:55419
  DatasetLoadRuleId:50976
  Load Type:FULL_LOAD
  sequence:1
  auditLoadDetailId:55420
  operation:INSERT
  sqlQuery:SELECT * FROM (SELECT SLOT.ECC_SPEC_ID, SLOT.SKU_ITEM_COMBINATION, SLOT.ORGANIZATION_CODE, SLOT.ORGANIZATION_ID, SLOT.COMPILE_NAME, SLOT.INVENTORY_ITEM_ID, SLOT.ITEM_NAME, SLOT.ITEM_DESCRIPTION, SLOT.SUBINVENTORY_CODE, SLOT.LOCATOR_CODE, SLOT.ITEM_CLASS, SLOT.CLASS_SEQ_NUMBER, SLOT.ITEM_SEQ_NUMBER, SLOT.ITEM_VELOCITY, SLOT.COMPILE_VALUE, SLOT.TOTAL_VELOCITY, SLOT.CLASS_CUMULATIVE_QTY, SLOT.LOCATION_AVAILABLE_UNITS, SLOT.LOCATION_MAXIMUM_UNITS, SLOT.LOCATOR_CLASS, SLOT.AVAILABLE_CAPACITY, SLOT.RESLOT, INV_ECC_SLOTTING_UTIL_PVT.get_slot_value(SLOT.RESLOT,SLOT.LANGUAGE ) RESLOT_DESC, SLOT.ONHAND_QTY, SLOT.ONHAND_QTY_PRIMARY, SLOT.PRODUCT_CATEGORY, SLOT.ZONE_NAME, SLOT.EMPTY_FLAG, INV_ECC_SLOTTING_UTIL_PVT.get_slot_value(SLOT.EMPTY_FLAG,SLOT.LANGUAGE ) EMPTY_FLAG_DESC, SLOT.LAST_UPDATE_DATE, SLOT.LANGUAGE, SLOT.LPN_NUMBER, SLOT.COST_GROUP, SLOT.OLDEST_RECEIPT_DATE, SLOT.LOT_NUMBER, SLOT.REVISION, SLOT.LOCATOR_ID, SLOT.ONHAND_STATUS, SLOT.SUBINVENTORY_STATUS, SLOT.LOCATOR_STATUS, SLOT.LOT_STATUS, SLOT.EXPIRATION_DATE, SLOT.LOC_ROWID, SLOT.LOT_ROWID, DECODE (SLOT.INVENTORY_ITEM_ID, NULL ,'N','N' ) RELEASE_LEVELFROM INV_ECC_SLOTTING_V slot WHERE LANGUAGE IN ( 'US') )PIVOT (MAX(ITEM_DESCRIPTION) AS ITEM_DESCRIPTION for LANGUAGE in ( 'US' "US"))
  startTime: Thu Apr 29 15:03:50 EDT 2021
  endTime: Thu Apr 29 15:03:50 EDT 2021
  status: FAILURE
  sql time: 0:0:0
  total elapsed time: 0:0:0
  statusMessage: There is an error while trying to ingest data for this load rule INV_ECC_SLOTTING_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset inv-space for job 55,417 ORA-00923: FROM keyword not found where expected
 oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)


STEPS
--------
1. Run request 'ECCRUNDL: ECC Run Data Load'.
2. Noticed that it completed in error.
3. Check log request and saw errors.
 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.