My Oracle Support Banner

EAM: AMIF1000 ABENDED AT STEP AMIF_FIN_PHY.310000.STEP10 using DB2 (Doc ID 2208591.1)

Last updated on MAY 27, 2021

Applies to:

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


Create the assets by using the excel to ci (INTFC_FINPHY_SS_A) in DB2
Excel to CI is able to load the data in interface table(INTFC_FIN).
While running the Asset Loader(AMIF1000) Process, AMIF1000 process is going to 'No Success'. with the fallowing error.
Process 42604 ABENDED at Step AMIF_FIN_PHY.310000.Step10 (Action SQL) -- RC = 8649
SQL Error: [IBM][CLI Driver][DB2] SQL0418N The statement was not processed because the statement contains an invalid use of one of the following: an untyped parameter marker, the DEFAULT keyword, or a null value. SQLSTATE=42610.

The issue can be reproduced at will with the following steps:
1. Load XLS in an env using DB2 
2. Launch AMIF1000 and get the error in an env using DB2




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.