My Oracle Support Banner

Duplicate Records Are Getting Created In Table "cmr_purchase_order_dtls" For Change Order. (Doc ID 2382821.1)

Last updated on MAY 21, 2018

Applies to:

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


On : 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" .




To view full details, 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 a vibrant support community of peers and Oracle experts.