Hello all,
I am trying to do a load from EBS12 into OBI Applications..everytime there is a task that uses a date, I am getting a date error...I changed the dates in dac..I tryied with runtime or static..I changed the configuration of my date to yyyy-mm-dd and nothing ever changes...
Those are the messages from the log:
DIRECTOR> VAR_27028 Use override value
DataWarehouse for session parameter:[$DBConnection_OLAP|http://forums.oracle.com/forums/].
DIRECTOR> VAR_27028 Use override value [ODBC_ORA|http://forums.oracle.com/forums/] for session parameter:[$DBConnection_OLTP|http://forums.oracle.com/forums/].
DIRECTOR> VAR_27028 Use override value [9] for mapping parameter:[http://mplt_sa_ora_codes.$$datasource_num_id/].
DIRECTOR> VAR_27028 Use override value --09/25/2008-- for mapping parameter:[http://mplt_bc_ora_codes_sales_picktype.$$last_extract_date/].
.....
WRITER_1_*_1> WRT_8124 Target Table W_CODE_D :SQL UPDATE statement:
UPDATE W_CODE_D SET SOURCE_CODE_1 = ?, SOURCE_CODE_2 = ?, SOURCE_CODE_3 = ?, SOURCE_NAME_1 = ?, SOURCE_NAME_2 = ?, MASTER_DATASOURCE_NUM_ID = ?, MASTER_CODE = ?, MASTER_VALUE = ?, W_INSERT_DT = ?, W_UPDATE_DT = ?, TENANT_ID = ? WHERE DATASOURCE_NUM_ID = ? AND SOURCE_CODE = ? AND CATEGORY = ? AND LANGUAGE_CODE = ?
WRITER_1_*_1> WRT_8124 Target Table W_CODE_D :SQL DELETE statement:
DELETE FROM W_CODE_D WHERE DATASOURCE_NUM_ID = ? AND SOURCE_CODE = ? AND CATEGORY = ? AND LANGUAGE_CODE = ?
WRITER_1_*_1> WRT_8270 Target connection group #1 consists of target(s) [W_CODE_D|http://forums.oracle.com/forums/]
WRITER_1_*_1> WRT_8003 Writer initialization complete.
READER_1_1_1> BLKR_16007 Reader run started.
READER_1_1_1> RR_4029 SQ Instance [http://mplt_bc_ora_codes_sales_picktype.sq_wsh_new_deliveries/] User specified SQL Query [SELECT DISTINCT WSH_NEW_DELIVERIES.DELIVERY_TYPE
FROM
WSH_NEW_DELIVERIES
WHERE
WSH_NEW_DELIVERIES.LAST_UPDATE_DATE > TO_DATE(*'2008-09-25 00:00:00', 'MM/DD/YYYY HH24:MI:SS'*)]
READER_1_1_1> RR_4049 SQL Query issued to database : (Thu Oct 02 15:12:32 2008)
WRITER_1_*_1> WRT_8005 Writer run started.
WRITER_1_*_1> WRT_8158
*****START LOAD SESSION*****
Load Start Time: Thu Oct 02 15:12:32 2008
Target tables:
W_CODE_D
READER_1_1_1> CMN_1761 Timestamp Event: [Thu Oct 02 15:16:11 2008]
READER_1_1_1> RR_4035 SQL Error [
FnName: Fetch Optimize -- [DataDirect][ODBC Oracle Wire Protocol driver]Error in row.
FnName: Fetch Optimize -- [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-01843: not a valid month
FnName: Fetch Optimize -- [DataDirect][ODBC Oracle Wire Protocol driver]Error in row.
FnName: Fetch Optimize -- [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-01002: fetch out of sequence
FnName: Fetch Optimize -- [DataDirect][ODBC Oracle Wire Protocol driver]Error in row.
I was never able and I don't know where is the setup for that MM/DD/YYYY that is showing there...that was the first configuration of my date...
Also, I put null on the dates of the SIL_ tasks as stated in the documentation...but nothing changed....
is there anyone who can help me?
thank you very much in advance