EIM Delete S_ACCNT_POSTN Rows

(Doc ID 521536.1)

Last updated on OCTOBER 26, 2017

Applies to:

Siebel Enterprise Integration Manager - Version 7.5.3.4 SIA [16180] and later
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 7.5.3.4 [16180] Life Sci
Database: Oracle 9i
Application Server OS: Sun Solaris 8
Database Server OS: Sun Solaris 8

This document was previously published as Siebel SR 38-1563402017.


Symptoms

Due to some user error, we had assigned invalid positions for some specific Accounts. We would want to delete the Position assignment for these accounts using EIM.

We had pre-populated the following fields in the EIM table.

ROW_ID,
IF_ROW_BATCH_NUM,
IF_ROW_STAT,
PARTY_UID,
PARTY_TYPE_CD,
AC_BU,
AC_NAME,
AC_LOC,
AP_POSTN_BU,
AP_POSTN_DIVN,
AP_POSTN_LOC,
AP_POSTN_NAME
AP_ROW_STATUS


By doing the above we are not able to delete the errors from S_ACCNT_POSTN. EIM is complaining about .

Failed to resolve foreign key value. (severity 7)
GenericLog    GenericError    1    2004-10-20 14:38:15    Process [Delete Position Affiliation For Batch] had 2 rows fail
GenericLog    GenericError    1    2004-10-20 14:38:15     on EIM_ACCNT_CUT for batch 20041020 in step 2, pass 108:
GenericLog    GenericError    1    2004-10-20 14:38:15     Failed to resolve foreign key value. (severity 7)
GenericLog    GenericError    1    2004-10-20 14:38:15   
GenericLog    GenericError    1    2004-10-20 14:38:15    Interface table:
GenericLog    GenericError    1    2004-10-20 14:38:15    EIM_ACCNT_CUT (EIM_ACCNT_CUT)
GenericLog    GenericError    1    2004-10-20 14:38:15    -------------
GenericLog    GenericError    1    2004-10-20 14:38:15    AC_BI (Name)
GenericLog    GenericError    1    2004-10-20 14:38:15    AC_NAME (Name)
GenericLog    GenericError    1    2004-10-20 14:38:15    AC_LOC (Site)
GenericLog    GenericError    1    2004-10-20 14:38:15   
GenericLog    GenericError    1    2004-10-20 14:38:15    Base table:
GenericLog    GenericError    1    2004-10-20 14:38:15    S_ACCNT_POSTN (Position for Account)
GenericLog    GenericError    1    2004-10-20 14:38:15    -------------
GenericLog    GenericError    1    2004-10-20 14:38:15    OU_EXT_ID (Account)

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