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:
PeopleSoft Enterprise FIN Asset Management - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |