WIP Mass Upload fails with WIP_LOWER_JOB_QTY error in Japanese session (Doc ID 1937298.1)

Last updated on JULY 19, 2016

Applies to:

Oracle Work in Process - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Open Interfaces

WIP Mass Upload fails due to WIP_LOWER_JOB_QTY error when customer is trying to reduce start quantity and Net quantity. This issue happens only in Japanese session.


ERROR
-----------------------
WIP_LOWER_JOB_QTY error genereted in WIP_INTERFACE_ERRORS

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

1. Create a wip job and release it.

Job:E000670679
Status:Released
Start Quantity:80
Net Quantity:80
Wip entity id:525311

--> No Sales order, reservation, and move order transaction are associated to the job.

2. Make sure all the quantity is in Queue step in the first operation.

Operation:10
Quantity in Queue:80

3. Prepare the data on WIP_JOB_SCHEDULE_INTERFACE to reduce the quantity.

NET_QUANTITY = 75
START_QUANTITY = 75

4. Run WIP Mass Upload and it ends with Warning Status.

5. We can see "WIP_LOWER_JOB_QTY" error in Japanese in WIP_INTERFACE_ERRORS.

 

This issue only happens when;
------------------------------
1. WIP mass upload runs in Japanese session.

2. There is the record in MTL_TXN_REQUEST_LINES which has TXN_SOURCE_ID= WIP_ENTITY_ID of the wip job.

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