Duplicate Records Are Getting Created In Table "cmr_purchase_order_dtls" For Change Order.
(Doc ID 2382821.1)
Last updated on FEBRUARY 05, 2019
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" .
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