My Oracle Support Banner

EAM PMWO(s) Generating Erroneous Purchase Requisitions For Non-stock Inventory Items. (Doc ID 2723994.1)

Last updated on NOVEMBER 02, 2020

Applies to:

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



We have lot of Assets on Weekly & Monthly preventive maintenance Schedules. Starting September 1st 2020, PMWO(s) generated by through eAM Maintenance Workbench started triggering purchase requisitions for subset of non-stock direct items on Material requirements tab.
Almost all PMWO(s) generated have non-stock items on Material requirements - However, the PR(s) did not triggered for all non-stock Items.

We never had purchase requisitions created for non-stock items on PMWO(s) before.

Our Preventive Maintenance schedule definitions are configured to generate PMWO(s) at WO status Released. Attached is the Screen shot of PM schedule definition for reference. Our Users do not update Material requirements tab options at all - One observation is that, The "Auto Request Material" Flag value is not consistent across non-stocks items on the WO(s) - Some Non-stocks has it set to "Yes" and for Others its set to "No". There are instances, where the Flag is set to "Yes" for a non-stock item and a Purchase Requisition is not generated.

Expected result: We need help in identifying the change and revert back the systems behavior to not create PR(s) for non-stocks items on PMWO(s) .

Additional information from the customer

We created couple of WO(s) to test the behavior.

The issue is happening for all WO(s) - PMWO(s) created via maintenance Workbench and regular WO(s) created manually - however, our non- PMWO WO(s) utilizes MU(s) that are configured to have non-stock item quantities required as 0.

The Issue is also occurring when a non-stock Items is manually added to the WO material requirements tab for all WO(s).

Here is the interesting point- Not all non-stock items are triggering purchase requisitions - even when the required quantity is greater than 0.

Question: For some non-stock Items, the Auto request Material Flag on table "WIP_REQUIREMENT_OPERATIONS" is getting set to YES and for others it is set to NO. The required quantity is greater than 0 in both cases. Just curious, on how the FLAG derive its value.


We need help in identifying the change and revert back the systems behavior to not create PR(s) for non-stocks items on PMWO(s) .

The issue can be reproduced at will with the following steps:

  1. Run Preventive Maintenance schedule
  2. generate PMWO(s) at WO status Released




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.