Duplicate PO Receipt Duplication Not Resolved by P2P Generic Datafix Patch 22311067 (Doc ID 2946240.1)

Last updated on MAY 09, 2023

Applies to:

Symptoms

Coming across with a duplicate PO receipt.

Ran the reporting script, r22311067q.sql, from P2P Generic Datafix patch 22311067.  Output lst file shows the following:

=========================================================================
Transactions causing duplicate actuals in Projects from PO Receipts
=========================================================================

SEGMENT1  |  SYSTEM_REFERENCE4  |  Interfaced Amount
------------------------- ------------------------------ -------------
XXXXXX  |  XXXXXXXX  |  1000.000

Running the datafix script did not resolve the issue.

Reviewed the rcv_receiving_sub_ledger table and see another record with the amount.

Replication Steps:

1. Download the P2P Generic Datafix patch 22311067.

2. Run the reporting script, r22311067q.sql.  Review the lst output for the problem record.

3. Run the datafix script, s22311067q.sql.  Verified that the problem record is not fixed by the datafix script.

Cause

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