My Oracle Support Banner

Importing file attachments by EIM (Doc ID 492008.1)

Last updated on NOVEMBER 09, 2018

Applies to:

Siebel Enterprise Integration Manager - Version 7.7.2.1 [18353] and later
IBM AIX on POWER Systems (64-bit)
Product Release: V7 (Professional)
Version: 7.7.2.1 [18353]
Database: Oracle 9.2.0.6
Application Server OS: IBM AIX 5L 5.2
Database Server OS: IBM AIX 5L 5.2

This document was previously published as Siebel SR 38-1962908231.
***Checked for relevance on 23-Jun-2014***

""CHECKED FOR RELEVANCE ON 11-DEC-2015""

Symptoms

We are trying to load invoice file attachments using EIM.
We followed the bookshelf instructions:

Siebel Enterprise Integration Manager Administration Guide > Importing Data > Special Considerations for Imports >
Importing File Attachments

and put the attached file in siebel_home/input directory in our Siebel server machine.

We obtain the following message from EIM log that has no sense for us (see enclosed log and ifb files)
In the other hand, if we try to specify a different input directory by using the following ifb header parameter: ATTACHMENT DIRECTORY = /siebel_prog/siebsrvr/input; we obtain the following error from EIM: “SBL-EIM-00204: Invalid configuration file (ifb) name.”

Are we skipping anything?



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
 EIM fails for importing file attachments with the following error:

NULL values in IF table for required base table columns. (severity 7)

Interface table:
EIM_INVC_DTL (EIM_INVC_DTL)
------------
X_FILE_DEFER_FLG (EIM FILE_DEFER_FLG Ext)
ATT_FILE_NAME (File Routing Processing Column)
X_FILE_AUTO_UPD_FLG (EIM FILE_AUTO_UPD_FLG Ext)
INVC_NUM (Invoice Number)
INVC_TYPE_CD (Invoice Type Code)
X_FILE_DOCK_REQ_FLG (EIM FILE_DOCK_REQ_FLG Ext)
X_FILE_DOCK_STAT_FLG (EIM FILE_DOCK_STAT_FLG Ext)

Base table:
S_INVOICE_ATT (Invoice File Attachment)

Actually all required user key columns are populated correctly, also 3 additional required columns are populated: ATT_FILE_NAME,ATT_FILE_EXT,ATT_FILE_SRC_TYPE
 Customer is using ATTACHMENT DIRECTORY parameter in .ifb to specify a different input directory. If customer did not specify ATTACHMENT DIRECTORY parameter which uses the default Siebel Server input directory siebsrvr/input then it works fine. The Siebel Server is on Unix platform, IBM AIX 5L 5.2.   Customer finds that ATTACHMENT DIRECTORY parameter on Unix platform requires enclosing the unix link to input directory path in double quotes and include the preceding backslash ("\path name"). For example:
ATTACHMENT DIRECTORY = "/siebel_prog/siebsrvr/input"

If not, then EIM fails during importing attachments with the (severity 7) error. The Documentation Enhancement BUG 10497236 has been raised to document this in EIM Admin Guide.

In Windows platform ATTACHMENT DIRECTORY works fine with or without double quotes:

ATTACHMENT DIRECTORY = "D:\EIM\input"

or

ATTACHMENT DIRECTORY = D:\EIM\input


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