Distribution - JDE1 (MOSC)

MOSC Banner

E900_why can't it update to database from E1 web P4205

edited Jan 6, 2015 10:00AM in Distribution - JDE1 (MOSC) 1 commentAnswered

hi,  from the debug log,  it failed to update to database...any reason why ?

Dec 26 14:14:26.078392 - 2976/3140 WRK:STORE_09D98938_P4205          SELECT  *  FROM PRODDTA.F49211  WHERE  ( UDDOCO = 14000170.000000 AND UDDCTO = 'ST' AND UDKCOO = '00010' AND UDLNID = 3200.000000 )
Dec 26 14:14:26.094000 - 2976/3140 WRK:STORE_09D98938_P4205          ORACLE DBFetch conn=0DAA2018 requ=09C80C38 maxrows=33
Dec 26 14:14:26.094001 - 2976/3140 WRK:STORE_09D98938_P4205          Fetched the record
Dec 26 14:14:26.094002 - 2976/3140 WRK:STORE_09D98938_P4205          Entering JDB_UpdateTable (Table F49211)
Dec 26 14:14:26.094003 - 2976/3140 WRK:STORE_09D98938_P4205          ORACLE DBInitReq conn=0DAA2018 requ=0E035C00 MYGKPUJDEDB (ORCL) new [  2]
Dec 26 14:14:26.094004 - 2976/3140 WRK:STORE_09D98938_P4205          UPDATE PRODDTA.F49211  SET UDDOCO=14000170.000000,UDDCTO='ST',UDKCOO='00010',UDLNID=3200.000000,UDVMCU='',UDTRP=0.000000,UDLOAD=0,UDDSGP='   ',UDBPFG='P',UDDSTN=0.000000,UDUM='  ',UDDEFF=' ',UDDUNC=0.000000,UDFDUC=0.000000,UDDREV=0.000000,UDFDRV=0.000000,UDANUM=0.000000,UDSIDT=0,UDINCY='   ',UDLDDT=0,UDLDTM=0.000000,UDDCDT=0,UDPCQY=0.000000,UDUOMC='  ',UDTEMP=0.000000,UDSTPU=' ',UDDNTY=0.000000,UDDNTP=' ',UDDETP=0.000000,UDDTPU=' ',UDVCF=0.000000,UDPRAS='A',UDCP01=' ',UDIQTY=0.000000,UDSTUM=0.000000,UDBUM6=' ',UDAMBR=0.000000,UDBUM3=' ',UDWGTR=0.000000,UDBUM5=' ',UDFRTV=' ',UDFRTD=' ',UDFRCC=0.000000,UDFRVC=0.000000,UDPVEH=' ',UDRLNO=' ',UDMCUR='            ',UDFLTN='        ',UDDSNN='     ',UDARCT='     ',UDSORG='               ',UDELTM=0.000000,UDPTNR=0.000000,UDIAN8=0.000000,UDPTC='   ',UDDOC=0.000000,UDDCT='  ',UDKCO='     ',UDCRR=-1.000000,UDCRCD='   ',UDTXA1='          ',UDEXR1='  ',UDFRDM=' ',UDFUPT='   ',UDRINO='               ',UDGLOC='               ',UDAUTA='                              ',UDALPH='                                        ',UDMET1='          ',UDOPN1=0.000000,UDPNR1=0.000000,UDMET2='          ',UDOPN2=0.000000,UDPNR2=0.000000,UDMET3='          ',UDOPN3=0.000000,UDPNR3=0.000000,UDARDT=0,UDARTM=0.000000,UDDPDT=0,UDDETM=0.000000,UDDSTJ=0,UDSTM=0.000000,UDEND=0,UDETM=0.000000,UDTV01=' ',UDTV02=' ',UDTV03=' ',UDTV04=' ',UDTV05=' ',UDTVCD='  ',UDTVQT=0.000000,UDTVDT=0,UDTVUM='  ',UDUSER='STORE',UDPID='EP4205',UDJOBN='MYGKPUJDEA',UDUPMJ=114360,UDTDAY=141422.000000,UDSBCK='0',UDEDCK='0',UDCMDM=' ',UDBBCK='0',UDRQSJ=0,UDPSDJ=0,UDADLJ=0,UDSUB='        ',UDSTTS='  ',UDRATT=' ',UDFUF1=' ',UDFRTC=' ',UDFRAT='          ',UDAFT='Y',UDOMCU='            ',UDOBJ='      ',UDLT='  ',UDFAPP=' ',UDDSPR=0.000000,UDDSFT=' ',UDDMT1='            ',UDDMS1=0.000000,UDCOT='   ',UDCMGL=' ',UDBALU=' ',UDAPOT=0.000000,UDACGD='   ',UDANI='                             ',UDAID='        ',UDOPOL=0.000000,UDOPBO='                              ',UDOPID='                              ',UDOPCS=0.000000,UDOPLL='Y',UDOPMS='Y',UDOPSS='Y',UDOPBA='Y',UDFXSR=' ',UDOPMG='                              ',UDOPSG='                              ',UDOPYN='N',UDOPSU=' ',UDPSJOBNO='               ',UDJOBSQ='               ',UDCARDNO='    ',UDDELBATCH='      ' WHERE  ( UDDOCO = 14000170.000000 AND UDDCTO = 'ST' AND UDKCOO = '00010' AND UDLNID = 3200.000000 )

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