FullLoadConfig INV-SU Stalls -- SQL Queries Hang

(Doc ID 2147365.1)

Last updated on NOVEMBER 07, 2017

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Endeca Integration (v5 and lower)

ACTUAL BEHAVIOR
---------------
 Space Utilization and Labor Utilization hang
When I hard code these values (to '30' for instance) in their respective workspace.prm files, the full data loads complete
Only null does not complete successfully

SU:
-- MAX_AGE_OF_ONHAND=NULL
-- MAX_AGE_OF_INV_TRANSACTIONS=NULL

LU:
-- MAX_AGE_OF_TASKS=NULL
looked in the workspace.prm file and found that the value of the ${MAX_AGE_OF_ONHAND} token is supposed to be NULL so I went ahead and hard coded that value and re-ran the query in sqldeveloper. Unfortunately, I received the same result as the query never completed.

I then replaced the tokens with numeric values (4, 8, 10, etc.) and only then did the query complete and return some data. As of right now, we are using this numeric hard code workaround but I'd like to know what, if anything, needs to be changed to the Out Of The Box versions of INV-Space Utilization and INV-Labor Utilization so that these queries are successful as-is Out Of The Box ?




Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms