EAM: Asset Adjustment Gets Loaded from Project Costing With No Asset Posted to Asset Management. (Doc ID 3025260.1)

Last updated on MAY 31, 2024

Applies to:

Symptoms

Loaded Asset from Project Costing with Trans Load Type = Fin Add has Load Status - Excluded due to Capitalization Threshold limitation error.
The adjustment, however, were loaded successfully making asset not visible to AM, and unable to retrieve from AM page.
Related data appears inconsistent in multiple AM records, Asset does not exist except to PS_COST record.

Error / Warning Message:

Steps to replicate:

1.  Define Project General Info:
     (Project Costing > Project Definitions > Define Project General Info)
     - General Information tab.
     - Asset  Integration Rules tab.    
    At save, click on Project Activities link.    
2.  In Define Project Activities, link Activity to the Project.    
     (Project Costing > Project Definitions > Define Project Attributes)
3.  In Asset Management Definition, enable Use Cap Threshold option.
     (Set Up Financials/Supply Chain > Business Unit Related > Asset Management > Asset Management Definition)    
4.  In Asset Profiles page, link the Threshold ID i.e. CT_001.    
     (Set Up Financials/Supply Chain > Product Related > Asset Management > Profiles > Asset Profiles)
5.  Define Asset and reference the Profile.  Click Save.
     (Project Costing > Assets > Define Assets)    
    At save, click Relate by Asset link.    
6.  Link the Project ID and Activity fields to the Asset.
     (Project Costing > Assets > Define Assets)    
    At save, click Assign Transactions to Assets link.    
7.  Assign Transactions to Assets.
     (Project Costing > Assets > Define Assets > Assign Transactions to Assets)
8.  Add the transaction and process it by clicking Process Transactions button.
     (Project Costing > Transaction Definitions > Add Transactions)     
9.  Click Process Monitor link.     
10.  Review Transaction List for Project/Activity.
      (Project Costing > Transaction Definitions > Review Transaction List)    
11.  Go back to Transactions to Assets page, and click Assign Transactions link.  In Assign Transactions page,
     search for the transaction added.  Note that Profile ID and Asset ID have not been populated yet.
      (Project Costing > Assets > Define Assets > Assign Transactions to Assets)
12.  Select the particular transaction and click Assign Transaction button.    
13.  Send transaction to Asset Management, and run PC_AM process.
      (Project Costing > Assets > Define Assets > Assign Transaction to Assets > Send Assets to AM)    
14.  Review Interface Transaction for the Asset.  For the Asset, the FAD went to Load Status = Excluded    
      (Asset Management > Send/Receive Information > Interface Transactions > Review Interface Transactions)
15.  Now, create Asset Adjustment Transaction.  Then, click Process Transactions button.    
      (Project Costing > Transaction Definitions > Add Transactions)
16.  Check Review Transaction List, and Search.  Add trans is there, and now it adds the adjustment trans.    
      (Project Costing > Transaction Definitions > Review Transaction List)
17.  Select the adjustment transactions and click Assign Transactions button.  
      (Project Costing > Assets > Define Assets > Assign Transactions to Assets)
18.  Now, Profile ID and Asset IDs have been assigned.  Click Send to Asset Management.    
19.  This opens the Send Assets to AM page.
      (Project Costing > Assets > Define Assets > Assign Transactions to Assets > Send Assets to AM)    
20.  Run Send to Asset Management (PC_AM) process.    
21.  Review Interface Transactions.   
      (Asset Management > Send/Receive Information > Interface Transactions > Review Interface Transactions)
      Trans Type Fin Add for the Asset in Load Status ‘Excluded’, while it’s Trans Type Adjustment in Load Status ‘Loaded’.   

See replication here.

NOTE: In the <images or examples> <above or below> and/or the attached document, user details / customer name / address / email / telephone number represent a fictitious sample (based up made up data used in the Product name test environment).
           Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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.