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 11.13.17.09.0 and later
Information 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 po
where 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" .


Changes

 

Cause

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