E1: 31: P31123 / P31114 WO Status Updated Incorrectly With Different UOM and Threshold Percent (Doc ID 2143076.1)

Last updated on JANUARY 03, 2023

Applies to:

Symptoms

E1 9.1 / P31114 Completions

Work Order status advances incorrectly when reporting completion quantity in a UOM different from the work order UOM and a Threshold percent is defined in the P31114 processing options.

When using Super Backflush (P31123) that calls a version of Completions (P31114) that is setup with both a Completed Status Code and a Completion Threshold and completing a quantity on a
work order in a UOM different from the work order UOM (conversions correctly setup) and the converted quantity completed is not equal to or greater than the threshold quantity, the work
order status is updated to the Completed Status instead of the Partial Work Order Status.

For example:
UOMs: 1 CR (carton) = .5 M (thousand)
P31114 called version from P31123 WO Status processing options:
    1. Partial WO Status Code = 45
    2. Completed Status Code = 88
    3. Completion Threshold = 90.00
Work order quantity = 4 M
Complete 4 CR.
Work order status is incorrectly updated to 88. 4 CR = 2 M which is only 50%
of the order. So the work order status should be updated to the Partial WO Status Code of 45.

Expected Behavior: Update the work order (from P31123 completions) to the correct status code based on quantity completed and threshold percent.

Business Impact: Due to this issue the status on many work orders is incorrect which negatively impacts downstream transactions which depend on the work order status, such as accounting (R31802A and R31804).

Changes

Cause

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