My Oracle Support Banner

EAM: Orphan Row Created By INTFC_PHY_B When INTFC_FIN And INTFC_PHY_A Are In ERR (Doc ID 1578946.1)

Last updated on APRIL 25, 2016

Applies to:

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


When the ps_intfc_fin and ps_intfc_phy_a rows ERR, the corresponding ps_intfc_phy_b row loads and inserts an orphan row in the ps_asset_comments table.

Expected Behavior
It is expected that the corresponding ps_intfc_phy_b row will be marked as ERR and a row will NOT be inserted into ps_asset_comments.

This issue can be replicated at will via the following steps:

1) Set your AM and GL periods to closed for the period for which you are loading data to ensure that the rows will error.
2) Load the interface id into AM via AMIF1000.
3) Verify the load_status of all 3 interface rows. Check the ps_asset_comments table for orphan rows.


To view full details, 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 a vibrant support community of peers and Oracle experts.