My Oracle Support Banner

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:

Oracle Enterprise Asset Management - Version 12.2.8 and later
Information in this document applies to any platform.


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?


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.