EIM Export Of S_ASSET with EIM_ASSET Errors with SBL-EIM-00101: Invalid arguments passed to EIM and ORA-01747 (Doc ID 2261459.1)

Last updated on APRIL 18, 2023

Applies to:

Symptoms

On : 8.1.1.14.17 [IP2014] version, EIM

EIM export using EIM_ASSET is erroring out.

The user interface error message is: SBL-EIM-00101: Invalid arguments passed to EIM

I have attached the ifb file and the log file (highest level), I mined the log file and found this SQL statement to be the issue.

UPDATE SIEBEL.EIM_ASSET IT
  SET (AST_BILLACCNTID_LO,
AST_BILLACCNTID_NA,
AST_BILL_NAME,
BILLACCNTID_BI,
) =
(SELECT I1.LOC,
I1.NAME,
BT.NAMEI1.BU_ID,

FROM SIEBEL.S_INV_PROF BT
,SIEBEL.S_ORG_EXT I1
WHERE (BT.ROW_ID = IT.T_ASSET_BILLPR AND
I1.ROW_ID (+) = BT.ACCNT_ID))
 WHERE (T_ASSET_BILLPR IS NOT NULL AND
IF_ROW_BATCH_NUM = ?)


ERROR
-----------------------
 SBL-EIM-00101: Invalid arguments passed to EIM
and
EIM log file has
EIMError0EIMErrorSubEvent0000000061f59040b40:002017-05-01 19:37:160Error SBL-EIM-00107: ODBC error S1000:

EIMError0EIMErrorSubEvent0000000061f59040b40:002017-05-01 19:37:160[tp][ODBC Oracle driver][Oracle]: invalid user.table.columORA-01747n,

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Export S_ASSET using EIM_ASSET interface table. 

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot .

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.