Populate PR_POST_ADDR_ID (Doc ID 1911110.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Enterprise Integration Manager - Version 8.1.1.10 [23021] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.10 [23021] version, EIM

When attempting to run EIM job, the following error occurs.

ERROR
-----------------------

EIMError EIMErrorSubEvent 0 0000000c53b2009c:0 2014-07-01 09:57:57 Process [Import S_CON_ADDR/Set Primary] had all rows fail
EIMError EIMErrorSubEvent 0 0000000c53b2009c:0 2014-07-01 09:57:57 on EIM_POSITION for batch 1006485 in step 1, pass 246700:
EIMError EIMErrorSubEvent 0 0000000c53b2009c:0 2014-07-01 09:57:57 No rows exist in IF table for this batch. (severity 2, table aborted)
EIMError EIMErrorSubEvent 0 0000000c53b2009c:0 2014-07-01 09:57:57
EIMError EIMErrorSubEvent 0 0000000c53b2009c:0 2014-07-01 09:57:57 No rows exist in this interface table which correspond to this batch number.
EIMError EIMErrorSubEvent 0 0000000c53b2009c:0 2014-07-01 09:57:57 This means that no rows exist to be imported from this interface table.
EIMError EIMErrorSubEvent 0 0000000c53b2009c:0 2014-07-01 09:57:57
EIMError EIMErrorSubEvent 0 0000000c53b2009c:0 2014-07-01 09:57:57 Since there was a problem with the configuration of this interface table,
EIMError EIMErrorSubEvent 0 0000000c53b2009c:0 2014-07-01 09:57:57 processing was discontinued. However, processing of other interface tables will
EIMError EIMErrorSubEvent 0 0000000c53b2009c:0 2014-07-01 09:57:57 continue.
EIMError EIMErrorSubEvent 0 0000000c53b2009c:0 2014-07-01 09:57:57


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. You have populated EIM_POSITION table with column values as below


ROW_ID
IF_ROW_STAT
IF_ROW_BATCH_NUM
POS_ORG_BU
POS_ORG_LOC
POS_ORG_NAME
PARTY_TYPE_CD
PARTY_UID
ADDR_ADDR_NAME
POS_PR_POSTN_ADDR ('Y')
POS_NAME
POS_BU
ADDR_CON_BU
ADDR_CON_PRIV_FLG
ADDR_PERSON_UID
PAR_POSTN_BU
PAR_POSTN_DIVN
PAR_POSTN_LOC
PAR_POSTN_NAME
ADDR_RELATIONTYPEC

2. Define ifb file.

3. Run EIM job

3. You are getting the error below

"
EIMError EIMErrorSubEvent 0 0000000c53b2009c:0 2014-07-01 09:57:57 Process [Import S_CON_ADDR/Set Primary] had all rows fail
EIMError EIMErrorSubEvent 0 0000000c53b2009c:0 2014-07-01 09:57:57 on EIM_POSITION for batch 1006485 in step 1, pass 246700:
EIMError EIMErrorSubEvent 0 0000000c53b2009c:0 2014-07-01 09:57:57 No rows exist in IF table for this batch. (severity 2, table aborted)
EIMError EIMErrorSubEvent 0 0000000c53b2009c:0 2014-07-01 09:57:57
EIMError EIMErrorSubEvent 0 0000000c53b2009c:0 2014-07-01 09:57:57 No rows exist in this interface table which correspond to this batch number.
EIMError EIMErrorSubEvent 0 0000000c53b2009c:0 2014-07-01 09:57:57 This means that no rows exist to be imported from this interface table.
EIMError EIMErrorSubEvent 0 0000000c53b2009c:0 2014-07-01 09:57:57
EIMError EIMErrorSubEvent 0 0000000c53b2009c:0 2014-07-01 09:57:57 Since there was a problem with the configuration of this interface table,
EIMError EIMErrorSubEvent 0 0000000c53b2009c:0 2014-07-01 09:57:57 processing was discontinued. However, processing of other interface tables will
EIMError EIMErrorSubEvent 0 0000000c53b2009c:0 2014-07-01 09:57:57 continue.
"

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, you are unable to complete EIM job.

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