Oracle Interface WIP Mass Load Refreshing Wip_operations When Releasing Job Via The Interface (Doc ID 2194934.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.2.5 version, Open Interfaces

ACTUAL BEHAVIOR
---------------
Oracle "WIP Mass Load" interface (wip_job_schedule_details) is behaving differently then the seeded Oracle form "WIP Discrete Jobs.

When we release the work order via the interface, all the operations are dropped, and refreshed from the most current routing's operations. We are NOT specifying a routing revision date. When releasing from the seeded form the wip_operations remain intact, and are not refreshed.

Same exact code functioning in 11.5.10, this issue we are experiencing is only in our test R12 environments.

EXPECTED BEHAVIOR
-----------------------
Oracle WIP Mass Load Interface and Seeded Oracle Form "WIP Discrete Jobs" should be in sync.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Work in Process
2. Discrete - > Discrete
3. Save the Job in UNRELEASED status.
4. “Release” the job via the interface with WIP Mass Load.
5. Check the WIP_OPERATIONS table.
6. Routing Revision date remains unchanged.
7. Operation dates changed.


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