My Oracle Support Banner

E1: 41: Improve Cycle Count Performance With Warehouse Items (Doc ID 2439241.1)

Last updated on NOVEMBER 05, 2018

Applies to:

JD Edwards EnterpriseOne Inventory Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Inventory

When running cycle count entry with over warehouse controlled items, it is throwing OCI0000178 - Unable to execute - INSERT INTO PRODDTA.F4142 error message in the debug log. A Web exception error is also issued stating Insert to F4141 failed.  Issue appears to happen on extremely large cycle counts. 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:


1. Enter several hundred/thousand cycle count records at a time using P41240.  The items must be warehouse controlled items


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.