PS PUBLISH TO EBS CLOSES MES EXCEPTIONS AFTER PUBLISHING
(Doc ID 2647546.1)
Last updated on MARCH 11, 2020
Applies to:Oracle MES for Discrete Manufacturing - Version 12.2.7 and later
Information in this document applies to any platform.
On : 12.2.7 version, Other Components
System is automatically closing MES Exceptions after publishing data from
PS to EBS.
After publishing Work Orders from PS into EBS, all exceptions on Work Orders
operations are closing.
Customer has done internal investigation and found that the closing exception
is performing by function: WIP_WS_EXCEPTIONS.CLOSE_EXCEPTION_JOBOP.
This method is calling when department was changed, but in customer case they
are not changing the department, in PS there is no option for that.
They checked that for function CLOSE_EXCEPTION_JOBOP the input parameter
P_DEPARTMENT_ID is null, so next, inside in this function exception is
closing. Function CLOSE_EXCEPTION_JOBOP is calling by
There is the problem - why department_is is null, which causing that
system thinks that the department has been changed. This is not true
and it makes that exception is closing.
PROGRAM / FORM:
Create MES Exception for Work Order,
In PS, publish work order,
After that, Exception in MES is closed, there is no open exception.
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