AMIF_FIN_PHY Creating Multiple Entries (Doc ID 2107593.1)

Last updated on MARCH 09, 2017

Applies to:

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

Symptoms

AMIF_FIN_PHY creating multiple entries


Step1: The AMIF100 Application Engine calls the INTFPHYA Section of AMIF_FIN_PHY.
Step2: INTFPHYA.Step10 checks for distinct number of BUs and does iterations that many number of times. Once for each BU.
Step3: In further steps, it is supposed to work on all assets of that particular BU in each iteration.
Step4: It works well for many steps until it reaches following DO SELECT steps
    AMIF_FIN_PHY.310130.Step17 (Do Select)
    AMIF_FIN_PHY.310140.Step17 (Do Select)
Step5: The above DO SELECT actions call other sections internally which insert data in tables.
 

Here the expectation is that it should consider assets of that particular BU as highlighted above in Step3, but instead it inserts rows in assets of all BUs.
 For Example:
 If there are 2 such BUs the asset location table will have 2 rows for each asset.
 If there are 13 such BUs the asset location table will have 13 rows for each asset

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms