Siebel Open UI, Tools, Scripting and EAI (MOSC)

MOSC Banner

Truncate of S_SRC_POSTN

edited Mar 24, 2011 5:10AM in Siebel Open UI, Tools, Scripting and EAI (MOSC) 2 commentsAnswered
Hello,

I need to empty S_SRC_POSTN  table just before fill it again (both operation with the same EIM).
When I run the EIM, I have an error message saying : 
SBL-EIM-00404 : Error getting interface table names


Here is my IFB file:

;=====================================================
;Commentaire : INITIALISATION LIENS CAMPAGNE POSITION
;=====================================================

[Siebel Interface Manager]
PROCESS = CAMPAGNE

[CAMPAGNE]
TYPE = SHELL
INCLUDE = "DELETE TABLE"
INCLUDE = "CAMPAGNE POSITION" 
[DELETE TABLE]
TYPE = DELETE
BATCH = $BATCH_RANGE
TABLE = EIM_SRC
DELETE ALL ROWS = TRUE
ONLY BASE TABLES = S_SRC_POSTN
[CAMPAGNE POSITION]
TYPE = IMPORT
BATCH = $BATCH_RANGE
TABLE = EIM_SRC
USING SYNONYMS = FALSE
USE INDEX HINTS = TRUE
INSERT ROWS = S_SRC, FALSE

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center