My Oracle Support Banner

AMIF_FIN_PHY Creating Multiple Entries (Doc ID 2107593.1)

Last updated on NOVEMBER 23, 2019

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

 

Changes

 

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
Changes
Cause
Solution
References


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