Duplicate Records Are Getting Created In Table "cmr_purchase_order_dtls" For Change Order.
Last updated on MAY 21, 2018
Applies to:Oracle Fusion Cost Management Cloud Service - Version 11.13.17.09.0 and later
Information in this document applies to any platform.
On : 11.13.17.09.0 version, Receipt Accounting
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 po
where po_number = ''
To not see duplicate rows for the same PO, after a change order is made for charge account
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" .
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