EAM: AMIF1000 Is Failing At Step AMIF_FIN_PHY.410030.Step10 (Doc ID 1580065.1)

Last updated on OCTOBER 24, 2016

Applies to:

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

Symptoms

AMIF1000 is failing with the following error:

ERROR
----------
-- 10.54.25 Process 62646 ABENDED at Step AMIF_FIN_PHY.410030.Step10 (Action SQL) -- RC = 8647
ROLLBACK

"A statement contains a use of an untyped parameter marker, the DEFAULT keyword, or a null value that is not valid. SQLSTATE=42610 (SQLSTATE 42610) -418"

Here is the SQL that is failing:

%InsertSelect(ASSET_WARRANTY, AMIF_IPB_TMP, END_DT = %Bind(AMIF1KLOOP2_AET.END_DT), EFFDT = WARRANTY_EFFDT, VENDOR_ID = WARRANTY_VENDOR_ID, COVERAGE = COVERAGE50)
  FROM %Table(AMIF_IPB_TMP)
 WHERE PROCESS_INSTANCE = %ProcessInstance
  AND BUSINESS_UNIT = %Bind(AMIF1KLOOP1_AET.BUSINESS_UNIT)
  AND ASSET_ID = %Bind(AMIF1KLOOP1_AET.ASSET_ID)
  AND INTFC_TYPE = %Bind(AMIF1KLOOP1_AET.INTFC_TYPE)
  AND WARRANTY_EFFDT IS NOT NULL

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