cancel
Showing results for 
Search instead for 
Did you mean: 

0TCTTIMSTMP is not TIMES-converted

saravanan_a
Active Participant
0 Kudos

Hi Experts,

I am getting error in 0TCT_C22 and 0TCT_C23.

When I searched SDN,i got to know that in Time it should either be 59 or 01 and not 00.

But in my case, time stamp is 20121104062110 in PSA..

I tried to delete PSA request and execute IP manually, but still same error.. Please suggest me how to resolve this.

I dono what can I correct in PSA.

Thanks

SA

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos
saravanan_a
Active Participant
0 Kudos

Hi Murthy,

In thread which you gave is having time as 00.

As I mentioned in my post, I am not getting 00 in time-stamp and still getting error.

Regards,

Saravanan

pradeep_gupta
Active Participant
0 Kudos

Hi Saravanan,

Check the below notes :

Note 1713932 - Char value '20120321143760' of 0TCTTIMSTMP is not TIMES-conv

Note 979721 - Changes in the transfer rules for 0TCT_C21,0TCT_C22,0TCT_C23

Pradeep.

Former Member
0 Kudos

Hi,

I have also faced same issue earlier and I have written below code for 0TCTTIMSTMP to truncate the date which was resolved the issue.

0TCT_C21

RESULT = TRUNC( TRAN_STRUCTURE-STARTTIMESTAMP )

0TCT_C22

RESULT = TRUNC( TRAN_STRUCTURE-TSTMP_START )

0TCT_C23

RESULT = TRUNC( TRAN_STRUCTURE-STARTTIME)

Thanks

Bin

Former Member
0 Kudos

Hi

How is the transformation done? I mean how is the source field mapped to target field? If it is a direct mapping, check whether the source field and target field are of the same type. If not then use a piece of code or standard functiona available to change timestamp to time/date.

Let me know if you need further help.

Regards

Murthy