After RPC3 Patch Set, Orders Are Ignoring Existing Invoice Hold On The Lines And Closing (Doc ID 2167613.1)

Last updated on MAY 01, 2023

Applies to:

Symptoms

ACTUAL BEHAVIOR

After applying RPC3 patch set, Orders are ignoring the existing invoice hold on the lines and closing.

EXPECTED BEHAVIOR

Expecting the Invoice Hold to be respected as it was before the RPC3 patch set.

STEPS

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

  1) Create a reprice hold with "Reprice Line" with Workflow Item "OM Order Line" and workflow Activity " Reprice Line"

  2) Check the checkbox for Progress workflow on release

  3) Create a new Order

  4) Apply the hold "Reprice Line" from lines and Book the order

  5) Pick release and ship confirm the order

  6) Run the Workflow Background Program

  7) Observe Sales Order lines progressed to Close

The current process of order entry involves applying invoice line level holds on a booked order. After the order line is shipped out, the order line passes fulfilled status and due to the invoice hold being tied to the reprice activity the order line will sit at Awaiting Reprice Line Hold Release status until someone releases a hold. After applying the RPC3 patch, the order lines are not awaiting on reprice line hold, and they are getting closed after shipped and fulfilled status. The hold still shows as not released on these lines. After further analysis, found a discrepancy in the code between RPC3 and the existing instances:

Notice the hold being checked is looking at activity REPRICE_LINE in RPC3 instance, whereas, in the existing instances it is looking at REPRICE activity. Also, please refer to where the patch 15878522 was provided and now it is not available on the Oracle website.

 On the hold definition, if  the workflow activity associated to "Reprice Line" is changed, then it starts recognizing this hold on only the new order lines created after this change, but the existing order lines are not recognizing the hold and are getting closed even when the hold is there. On the other hand, if the existing hold definition workflow activity is left as "Reprice Line (1)", then it does not recognize the pricing hold that is applied on both new orders and existing sales orders

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.