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

Last updated on AUGUST 15, 2024

Applies to:

Symptoms

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,　ｔhe 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

Cause

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