My Oracle Support Banner

EAM9.2:Asset Loader (AMIF1000) Process Performance Due to Missing Criteria in Step AMIF_FIN_PHY.210020.Step10 (Doc ID 2619810.1)

Last updated on JANUARY 29, 2021

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.



There is performance issue for AMIF1000 process due to missing criteria in step AMIF_FIN_PHY.210020.Step10
Experienced very slow performance of Asset Loader (AMIF1000) after loading a large number of asset transactions with Mass Transaction Manager (MTM).
Review of step AMIF_FIN_PHY.210020.Step10, it appears to be executing multiple times for each line (once for each asset).

Steps to replicate:

1.  Create a new Asset Category (but do not enter the distributions) -- Asset Category = NEW1
     Then click the Save button.
2.  Add a new Run Control for Run Mass Transaction
3.  Enter the information shown and click the Run button:
           Transaction = RCT - Recategorization
           Selection Criteria:
           Business Unit = US004
           Asset Category = FF
           User Entered Values:
           Business Unit = US004
           Category To = NEW1
4.  Run MTMTOOL process. Take note of the Interface ID.
5.  Review Interface Transactions to see Assets each for the Books
     As each RCT transaction has In and Out lines, there are 20 lines total in the Interface ID.
6.  Add a new run control to use for Load into AM.
     Enter Interace ID and click Run button to run AMIF1000 process.
7. Click on the details link and Message Log link:
    Each of the assets has 20 entries in the log demonstrating each line was processed multiple times.

See attached replication document.


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

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