My Oracle Support Banner

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:

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


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.

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

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

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.

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.




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.