EAM: Interfacing a Voucher From Accounts Payable(AP) and Unitizing It to Adjust the Cost of the Assets in Asset Management Creates Duplicate Assets. (Doc ID 2879434.1)

Last updated on JULY 01, 2022

Applies to:

Symptoms

A Voucher has been interfaced from Accounts Payable(AP) to Asset Management to update the cost of the asset. The interface transaction is unitized into multiple(example 5) assets and the page is saved (keeping the asset id as 'NEXT'). Without returning to search page/refreshing the component and on the same unitize asset page asset ID details are updated and the page is saved once again.

Upon running AMIF1000 process it is observed that a 5 new asset were created and 5 existing assets cost was adjusted with voucher interfaced.

Steps to replicate:

The issue can be reproduced at will with the following steps:
1. Create Voucher.
    Menu > Accounts Payables > Vouchers > Add / Update > Regular Entry.

2. Run INTFAPAM process
    Menu > Account Payables > Batch Processes > Extracts and Loads > Load Assets Request.

3. Retrieve Voucher information.
    Menu > Asset management > Send/ Receive Information > Retrieve AP/ PO Information.

4. Unitize to create multiple asset say 5 assets and click on save. It is observed that 5 lines were inserted into interface tables with interface type FAD.
    Menu > Asset management > Send/ Receive Information > Interface Transactions > Unitize assets.
  
5. Without returning to search page/refreshing the component update the Asset ID and click on Save once again. It is observed that 5 lines were inserted into interface tables with interface type ADQ.
 
6. Run transaction loader.
     Menu > Asset management > Send/ Receive Information > Interface Transactions > Load into AM.

7. It is observed that a 5 new asset were created and 5 existing assets cost was adjusted with voucher interfaced. Expectation was to adjust the cost of the assets and not to create any duplicate assets.

Please review the attached replication steps.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.