EAM: Asset Transfer TRF Using Spreadsheet Template To The Same Department Resulted In Incorrect Activity_SW on the COST_BAL_VW Table. (Doc ID 3036702.1)

Last updated on JULY 25, 2024

Applies to:

Symptoms

Asset Transfer TRF using Spreadsheet Template to the same department resulted in incorrect activity_sw  on the COST_BAL_VW table.

The issue can be reproduced at will with the following steps:
1. Create a transfer template (SetUp Financials / Supply Chain – Product Related – Asset Management – Import Spreadsheet SetUp – Define AM Spreadsheet Template). Make sure the department is selected.
2. Create an asset (Asset Management – Asset Transactions – Owned Assets – Basic Add). Capitalize the asset by providing a department for all the books.
3. Calculate depreciation for the above asset (Asset Management – Depreciation – Processing – Calculate Depreciation).
4. Create accounting entries for the above asset (Asset Management – Accounting Entries – Create Accounting Entries).
5. Use the spreadsheet from step 1 to enter transfer the asset from step 2 to the same department.
6. Upload the spreadsheet (Asset Management – Send  Receive Information – Import Data via Spreadsheet – Upload Spreadsheet Data). Note the generated interface id.
7. Review the interface transactions from step 6 (Asset Management – Send / Receive Information – Interface Transactions – Review Interface Transactions).
8. Verify the data on the COST_BAL_VW table and observe that the activity sw is not correctly populated.

Cause

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