PO Revision Number Is Not Incremented After Cancelling a Line on a Standard PO (Doc ID 1597220.1)

Last updated on DECEMBER 19, 2016

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On Release 12.1.3 version, after application of the fix from Patch 16872052:R12.PO.B when canceling more than one PO lines in separate actions revision is not incremented anymore.
When first line is canceled revision will be incremented but when canceling other line revision will not be anymore incremented.

ACTUAL BEHAVIOR
---------------
PO Revision is not incremented when canceling more than one line is separate actions.

EXPECTED BEHAVIOR
-----------------------
PO Revision should be incremented after each line cancellation if this is done in separate steps.

ISSUE ANALYSIS
---------------------
The fix from Patch 16872052:R12.PO.B was intended to correct the fix from Patch 16445788:R12.PO.B and thus to prevent updating the action history when cancelling the line/shipment, but the fix is incorrect as at the same time it prevents performing the archive altogether, even if the document is revised when cancelling the line only.

So based on the above, now the archive happens only if the cancel is at header level. It does not matter anymore if cancel is at line level and the document is revised and set back to Approved. This causes the data corruption because the PO should be archived if the current revision in po_headers_all is different than the latest revision in po_headers_archive_all.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a PO with 4 lines. Approve.
2. Query at header level and check that revision is 0.
3. Select line 1 > cancel ==> Revision will change to 1. Note that PO is set back to approved, but in the archive tables the revision is 0.
3. Select line 2 > cancel ==> Revision will remain to 1 which is incorrect.

The issue is reproducible in Core Forms as well as the Buyer Work Center.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms