My Oracle Support Banner

Issue with Export of attachments when using ONLY BASE COLUMNS (Doc ID 2687878.1)

Last updated on JUNE 25, 2021

Applies to:

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

Symptoms

Not able to export siebel attachments for service requests, activities and opportunities through EIM

IFB file:

[Siebel Interface Manager]
PROCESS = EXPORT ACTIVITY

[EXPORT ACTIVITY]
TYPE = SHELL
INCLUDE = OPTY EXPORT ALL

[OPTY EXPORT ALL]
TYPE = EXPORT
BATCH = 101
ATTACHMENT DIRECTORY = <filesystem/location>
CLEAR INTERFACE TABLE = TRUE
TABLE = EIM_OPTY_DTL
ONLY BASE TABLES = S_OPTY, S_OPTY_ATT
ONLY BASE COLUMNS = S_OPTY.X_SR_ID,S_OPTY.BU_ID,S_OPTY.NAME,S_OPTY_ATT.FILE_EXT,S_OPTY_ATT.FILE_NAME,S_OPTY_ATT.PAR_ROW_ID
EXPORT MATCHES = S_OPTY, (BU_ID='1-OTZH')

 

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
References


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