My Oracle Support Banner

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

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
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.