SLT replication Issue

[former_member182537]

hi All,

We ar on SLT SP09 system and pulling data from SAP ECC system and sending to Oracle DB. We have requirement to add timestamp field in the tables from SAP ie we are adding these field in SLT only and entire structue is getting created in Oracle automatcially.

The data type of time stamp field we are adding is CHAR 40. Now we have written below FM and assigned via LTRS rules to pass the values to this field at run time and this output is in format that oracle has for CURRENT_TIMESTAMP but we keep on getting error and data is not able to insert into oracle tables.

Options tried-

1) we hard coded timetsamp value as '30-SEP-15 12.28.18.806529 PM' and this value was inserted into Oracle without any issues. and oracle data type is TIMESTAMP(6).

2)Now we tried to derive same value in same format at run time via calling fucntion module and it retruns us the value in exact same format as char28.

But we cant insert data into Oracle and it fails always with RC 3 , so cant understand why its not working.

Oracle guys said problem is on SAP side .

SQL exception occurred in receiver system (rfc dest. NONE)

Execution of program /1CADMC/OLC_800000000001012 failed, return code 3

Message no. DMC_RT_MSG046

Diagnosis

RC = 1: The conversion object is invalid
RC = 2: Error reading the
data
RC = 3: Error writing the data
RC = 4: Error calling a function
module
RC = 5: Error inserting into the internal tables of the generated
programs
RC = 6: Error in application log
RC = 7: Unspecified error
RC
= 8: Enforced job cancellation
RC = 9: Update of logging table in sender
system failed

System Response

RC > 0: Processing failure

Procedure

RC = 1: Regeneration of runtime-object
RC = 2: Analysis of system-log in
sender-system
RC = 3: Analysis of system-log in receiver-system
RC > 3:
Analysis of generated programs

Logs from SM21-as in screenshot atatched.

Strange thign is we tried to manaully insert table entry into one of tables then it accepts this and generates oracle time stamp though in same format.

Please can someoen advcie on this issue -what can be done - our maine requirement is to get time stamp field as DATE /timestamp data type in oracle to make select query easier (as we have been able to send timetsamp as VARCHAR in required format w/o any issues just with TIMESTAMP its creating problem.

looking for response.

thanks

[former_member182537 · Accepted solution]

HI gurus any advice pls

[former_member182537 · Accepted solution]

HI,

any advice pls ..

thanks

[Former Member · Accepted solution]

Hi Nilesh,

Is your issure resolved?

Regards

Sachin

[former_member182537 · Accepted solution]

this was handled in oracle itself via script as seems it was not posisble in SAP to get oracle time stamp and write to oracle DB in oracle data type.

thanks