Issue with Export of attachments when using ONLY BASE COLUMNS
(Doc ID 2687878.1)
Last updated on JULY 08, 2020
Applies to:
Siebel Enterprise Integration Manager - Version 16.0 [IP2016] and laterInformation 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 |