Applies to:

Oracle Fusion Cost Management Cloud Service - Version 11.13.17.09.0 and laterInformation in this document applies to any platform.

Symptoms

On : 11.13.17.09.0 version, Receipt Accounting

ACTUAL BEHAVIOR ---------------Duplicate records are getting created in table "cmr_purchase_order_dtls" for change order.

The customer is using "cmr_purchase_order_dtls" table to fetch the PO data to generate to their custom "Uninvoiced Receipt Accrual Report" but they found that duplicate records are getting created for the PO which has Change order.Below is the query used by the customer to generate the data from the application:

select * from cmr_purchase_order_dtls powhere po_number = '[]'

EXPECTED BEHAVIOR-----------------------To not see duplicate rows for the same PO, after a change order is made for charge account

STEPS-----------------------The issue can be reproduced at will with the following steps:1. Create new PO and get it approved.2. Change the charge account on PO and approve the change order.3. Check the PO details in the table "cmr_purchase_order_dtls" .