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

Last updated on MARCH 02, 2023

Applies to:

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.

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.