EAM: ADD Spreadsheet Upload Does Not Create Assets (Doc ID 2525151.1)

Last updated on APRIL 28, 2020

Applies to:

Symptoms

On : FSCM 9.2 version 30/31, Interface

ACTUAL BEHAVIOR
---------------
The Spreadsheet upload created the asset in the interface tables and AMIF1000 ran to success but the asset is not created in the Book or Cost table.

EXPECTED BEHAVIOR
-----------------------
ADD Spreadsheet Upload does not create assets when the AM business unit is not linked to the default Journal Generator Ledger group.

REPLICATION STEPS
--------------------------------------------
1. Confirm AM business unit US001 is linked to the RECORDING/LOCAL ledger group/ledger
2. Ledgers for a Unit, confirm that the RECORDING ledger group is not the default ledger. The default ledger is the REPORTING.
3. Create a new spreadsheet template for ADD Asset template
4. Create spreadsheet template
5. Enter an asset into the ADD spreadsheet template
6. Upload the Asset from spreadsheet
7. Run the Load Spreadsheet Data (AM_LOAD) process
8. Confirm the Interface ID created
9. Run Load into AM (AMIF100) on interface ID
10. Confirm asset created into AM tables (ASSET, BOOK, BOOK_HIST, COST, and OPEN_TRANS)

*Replication_Steps

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.