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 later
Information in this document applies to any platform.
Not able to export siebel attachments for service requests, activities and opportunities through EIM
[Siebel Interface Manager]
PROCESS = 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')
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