EAM: Cancelled Asset Purchase Order Receipt with Multiple Funded Rows Gets Recorded as an Adjustment Instead of a Retirement. (Doc ID 3059891.1)

Last updated on NOVEMBER 20, 2024

Applies to:

Symptoms

Cancelling a PO Receipt with multi-funded Asset Information does not retire the Asset. A user can create a PO Receipt containing asset information and that creates the asset in the system.
Likewise, can cancel the same receipt which should retire the asset. When same transaction is performed for asset with single cost line, cancellation of receipt is sending RET line in AM pre-interface table PS_INTFC_PRE_AM,
whereas for multi cost line, it turns into an adjustment entries.

Expected behavior:

When cancelling a PO receipt, whether with single-funded (single chartfield distribution line) or multi-funded (multiple chartfield distribution lines with different funds), the system will correctly create
the INTFC_TYPE of 'RET' (RETIREMENT) rows on the INTFC_PHY_A table.

Steps to replicate:

  1.  Create an Asset PO with 1 Line and distributed to 2 multiple funded rows.
       (Purchasing > Purchase Orders > Add/Update POs)
  2.  Save and Return to Main Page.    
  3.  PO Budget Checked and Dispatched.
  4.  Add the Receipt from the PO.    
  5.  Click AM Status ‘Pending’ link to view the 2 Distribution Lines.    
  6.  Populate the Asset ID for the 2 distribution lines.    
  7.  Save.  Receipt 0000000165.  Receipt Status = Move to Destination.    
  8.  Review Interface Transactions:  Status = Loaded.  
  9.  Query PS_INTFC_FIN and PS_ASSET records and transaction are added.    
10.  Go to PO Receipt and click 'X' (to Cancel Receipt).    
11.  Query PS_INTFC_FIN record.  Added rows with INTFC_TYPE = ADQ.  Note that the expectation:  INTFC_TYPE = RET     
12.  Query PS_ASSET record.  ASSET_STATUS = I.   Note that the expectation:  ASSET_STATUS = D   

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.