EAM: After Applying Fix for Bug 34425294, Performing IntraUnit Transfer AM Spreadsheet Upload and Load into AM (AMIF1000) Both Go to Success, But, Create Accounting Entries (AMAEDIST) Abends at Step IU_PROCESSOR.U400.U400-010 With Incorrect Depreciation. (Doc ID 2952141.1)

Last updated on DECEMBER 11, 2023

Applies to:

Symptoms

With AM Spreadsheet Upload IUT Transfers in Image 46 environment, fix for <Bug 34425294> gets user through the Load into AM (AMIF1000) process successfully.  However, with an asset with multiple cost rows based on multiple
department, and transferred to a different BU, that Depreciation calculation is in correct and Create Accounting Entry process (AMAEDIST) goes to 'No Success' with error.

Note that this type of transaction works as expected when done online using Cost Adjust/Transfer component.

Error:

Steps to replicate:

1.  Using Basic Add, add an Asset for with multiple cost rows for different DeptIDs in each Books.
    (Asset Management > Asset Transactions > Owned Assets > Basic Add)
    - Book CORP:
       DeptID 10000 = 800,000.00
       DeptID 15000 = 200,00.00
    - Book FEDERAL:
       DeptID 10000 = 800,000.00
       DeptID 15000 = 200,00.00
    * Business Unit US001
    * Asset ID 000000000233
2.  Run Depreciation Calculation.
    (Asset Management > Depreciation > Processing > Calculate Depreciation)
3.  Generate an IUT AM Spreadsheet Template.  
    (Set Up Financials/Supply Chain > Product Related > Asset Management > Import Spreadsheet Setup)
4.  Populate the template, including Business Unit From = US001, and Business Unit To = US004.
5.  Upload Spreadsheet Data.
    (Asset Management > Send/Receive Information > Import Data via Spreadsheet)
    AM_LOAD went to Success; Interface ID = 10000055
6.  Load Interface ID 10000055 into AM.
    (Asset Management > Send/Receive Information > Interface Transactions > Load into AM)
    AMIF1000 goes to Success.
7.  Review Interface Transactions for Interface ID 10000055 for Unit US001, US004.
    (Asset Management > Send/Receive Information > Interface Transactions > Review Interface Transactions)
    US001 – Asset ID 000000000233
    US004 – Asset ID 000000000007
8.  Run Depreciation Calculation for:  BU = US001; Asset ID = 000000000233 (ok)
    Run Depreciation Calculation for:  BU = US004; Asset ID = 000000000007 (Note:  Asset not found)
9.  Create Accounting Entries for:
     - US001: CORP-Asset ID 000000000233
     - US004: CORP-Asset ID 000000000007
    Run Status = No Success

See replication document 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.

Cause

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