Need Data Script To Update "Enable Material Issue Request" Flag For EAM Work Orders In Any Status (Doc ID 2685223.1)

Last updated on JUNE 28, 2020

Applies to:

Goal

EBS version 12.2.8 EBS was implemented recently. At that time work orders were migrated from their old 12.1.3 system. Many of these work orders have the "Enable Material Issue Request" flag set to "Yes".

New business processes dictate that this flag is set to "No", as the client is running EAM Component Pick Release rather than creating Move Orders when the work orders are Released.

We are not able to update this flag through any API and are requesting a data script to update these values from the back end. We need all EAM work orders to have this flag changed to "No".

This problem is causing Material Allocations where we don't need them and there is no work around. How can this be resolved?
 

Solution

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