My Oracle Support Banner

Resource Basis Is Changed Incorrectly via Wip Mass Load (Doc ID 2334024.1)

Last updated on FEBRUARY 18, 2019

Applies to:

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


Actual Behavior
In case that JOB has 3 resources in one operation Seq like below, if update any some date columns in resource Seq 20 via WIP Mass Load with BASIS_TYPE as null, the BASIS of res seq 20 is changed incorrectly from Item to Lot.

1. Resource before update run WIP Mass Load
Seq Resource UOM Basis  Usage
10   Res_A      HR    Item  72
20   Res_B      HR    Item  1
30   Res_B      HR    Lot    .01

2. Resource After update run WIP Mass Load
Seq Resource UOM Basis  Usage
10   Res_A      HR    Item  72
20   Res_B      HR    Lot    1                   <== Changed the Basis from Item to Lot incorrectly
30   Res_B      HR    Lot    .01

Expected Behavior
If wip_job_dtls_interface.BASIS_TYPE is NULL, the BASIS of resource seq should NOT be changed automatically via WIP Mass Load.

Steps to Reproduce

  1. Create WIP_JOB_SCHEDULE_INTERFACE and WIP_JOB_DTLS_INTERFACE to change date columns in operation resource with BASIS_TYPE as null.
  2. Run WIP mass load


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.