E1: UPGTC: Table Conversion Error For Table F0911 - SQL000000X - DBSQLInsertFromSelect: Build more-than-one-table query failed / TCE9000 Errors (Doc ID 1283069.1)

Last updated on MAY 30, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version SP24 and later
Information in this document applies to any platform.

Symptoms

Scenario 1

In this scenario here, customer is upgrading from JD Edwards EnterpriseOne ERP 8.0 to 9.0 application release level and doing a Data Only Upgrade Conversion for Production Environment.
Scheduled Table Conversion for F0911 *MERGE failing, error in the "Insert" for temporary table F0911TCTEMP.
They have recently updated their Tools Release level up to TR 8.98.4.1, then they completed and tested the PY900 upgrade. So this PD900 upgrade is been done in a different Tools Release level than the other upgraded environments as DV900 and PY900.
Error found in the jde.log:

(...) 5100/368 WRK:Starting jdeCallObject Thu Jan 13 13:15:34.310000 dbsql_i.c375 SQL000000X - DBSQLInsertFromSelect: Build more-than-one-table query failed
5100/368 WRK:Starting jdeCallObject Thu Jan 13 13:15:34.310001 dbbndwhe.c460 OCI0000038 - Unable to bind where value - :KEY1
5100/368 WRK:Starting jdeCallObject Thu Jan 13 13:15:34.310002 dbbndwhe.c466 OCI0000039 - Error - ORA-01036: illegal variable name/number
5100/368 WRK:Starting jdeCallObject Thu Jan 13 13:15:34.310003 dbinsel.c542 OCI0000176 - Failed to bind where-clause values - INSERT INTO PRODDTA.F0911TCTEMP (GLKCO, GLDCT,GLDOC, GLDGJ, GLJELN, GLEXTL, GLLT, GLPOST, GLICU, GLICUT, GLPM05, GLPM01, GLPM02, GLPM03, GLPM04, GLPM06, GLPM07, GLPM08, GLPM09, GLPM10, GLABT1, GLABR1, GLABT2, GLABR2, GLABT3, GLABR3, GLABT4, GLABR4, GLITM, GLDICJ, GLDSYJ, GLTICU, GLCO, GLANI, GLAM, GLAID, GLMCU, GLOBJ, GLSUB, GLSBL, GLSBLT, GLPN, GLCTRY, GLFY, GLFQ, GLCRCD, GLCRR, GLHCRR, GLHDGJ, GLAA, GLU, GLUM, GLGLC, GLRE, GLEXA, GLEXR, GLR1, GLR2, GLR3, GLSFX, GLODOC, GLODCT, GLOSFX, GLPKCO, GLOKCO, GLPDCT, GLAN8, GLCN, GLDKJ, GLDKC, GLASID, GLBRE, GLRCND, GLSUMM, GLPRGE, GLTNN, GLALT1, GLALT2, GLALT3, GLALT4, GLALT5, GLALT6, GLALT7, GLALT8, GLALT9, GLALT0, GLALTT, GLALTU, GLALTV, GLALTW, GLALTX, GLALTZ, GLDLNA, GLCFF1, GLCFF2, GLASM, GLBC, GLVINV, GLIVD, GLWR01, GLPO, GLPSFX, GLDCTO, GLLNID, GLWY, GLWN, GLFNLP, GLOPSQ, GLJBCD, GLJBST, GLHMCU, GLALID, GLALTY, GLDSVJ, GLTORG, GLREG#, GLPYID, GLUSER, GLPID, GLJOBN, GLUPMJ, GLUPMT, GLDOI, GLBCRC, GLCRRM, GLPRGF, GLTXA1, GLEXR1, GLTXITM, GLACTB, GLGPF1, GLACR, GLDLNID, GLCKNU, GLBUPC, GLAHBU, GLEPGC, GLJPGC, GLRC5, GLSFXE, GLOFM) SELECT T0.GLKCO, T0.GLDCT, T0.GLDOC, T0.GLDGJ, T0.GLJELN, T0.GLEXTL, T0.GLLT, T0.GLPOST, T0.GLICU, T0.GLICUT, NVL(T1.GLPM05, ' '), NVL(T1.GLPM01, ' '), NVL(T1.GLPM02, ' '), NVL(T1.GLPM03, ' '), NVL(T1.GLPM04, ' '), NVL(T1.GLPM06, ' '), NVL(T1.GLPM07, ' '), NVL(T1.GLPM08, ' '), NVL(T1.GLPM09, ' '), NVL(T1.GLPM10, ' '), NVL(T1.GLABT1, ' '), NVL(T1.GLABR1, ' '), NVL(T1.GLABT2, ' '), NVL(T1.GLABR2, ' '), NVL(T1.GLABT3, ' '), NVL(T1.GLABR3, ' '), NVL(T1.GLABT4, ' '), NVL(T1.GLABR4, ' '), NVL(T1.GLITM, 0), T0.GLDICJ, T0.GLDSYJ, T0.GLTICU, T0.GLCO, T0.GLANI, T0.GLAM, T0.GLAID, T0.GLMCU, T0.GLOBJ, T0.GLSUB, T0.GLSBL, T0.GLSBLT, T0.GLPN, T0.GLCTRY, T0.GLFY, T0.GLFQ, T0.GLCRCD, T0.GLCRR, T0.GLHCRR, T0.GLHDGJ, T0.GLAA, T0.GLU, T0.GLUM, T0.GLGLC, T0.GLRE, T0.GLEXA, T0.GLEXR, T0.GLR1, T0.GLR2, T0.GLR3, T0.GLSFX, T0.GLODOC, T0.GLODCT, T0.GLOSFX, T0.GLPKCO, T0.GLOKCO, T0.GLPDCT, T0.GLAN8, T0.GLCN, T0.GLDKJ, T0.GLDKC, T0.GLASID, T0.GLBRE, T0.GLRCND, T0.GLSUMM, T0.GLPRGE, T0.GLTNN, T0.GLALT1, T0.GLALT2, T0.GLALT3, T0.GLALT4, T0.GLALT5, T0.GLALT6, T0.GLALT7, T0.GLALT8, T0.GLALT9, T0.GLALT0, T0.GLALTT, T0.GLALTU, T0.GLALTV, T0.GLALTW, T0.GLALTX, T0.GLALTZ, T0.GLDLNA, T0.GLCFF1, T0.GLCFF2, T0.GLASM, T0.GLBC, T0.GLVINV, T0.GLIVD, T0.GLWR01, T0.GLPO, T0.GLPSFX, T0.GLDCTO, T0.GLLNID, T0.GLWY, T0.GLWN, T0.GLFNLP, T0.GLOPSQ, T0.GLJBCD, T0.GLJBST, T0.GLHMCU, T0.GLALID, T0.GLALTY, T0.GLDSVJ, T0.GLTORG, T0.GLREG#, T0.GLPYID, T0.GLUSER, T0.GLPID, T0.GLJOBN, T0.GLUPMJ, T0.GLUPMT, T0.GLDOI, ' ', ' ', ' ', ' ', ' ', 0, ' ', ' ', 0, 0, ' ', ' ', ' ', ' ', ' ', 0, 0, ' ' FROM PRODDTA.F0911 T0,PRODDTA.F0911T T1 WHERE ( T0.GLLT <> ? ) AND ( T0.GLKCO = T1.GLKCO (+) AND T0.GLDCT = T1.GLDCT (+) AND T0.GLDOC = T1.GLDOC (+) AND T0.GLDGJ = T1.GLDGJ (+) AND T0.GLJELN = T1.GLJELN (+) AND T0.GLEXTL = T1.GLEXTL (+) AND T0.GLLT = T1.GLLT (+) )
5100/368 WRK:Starting jdeCallObject Thu Jan 13 13:15:34.310004 dbinsel.c549 OCI0000177 - Error - ORA-01036: illegal variable name/number
5100/368 WRK:Starting jdeCallObject Thu Jan 13 13:15:34.310005 Jdb_drvm.c1906 JDB9900191 - Failed to insert the results of a select
5100/368 WRK:Starting jdeCallObject Thu Jan 13 13:15:34.310006 Jdb_exet.c10174 JDB3400025 - Failed to execute InsertFromSelect
5100/368 WRK:Starting jdeCallObject Thu Jan 13 13:15:34.310007 tcapi.c3198 TCE9000 - ITCEMergeTable - JDB_InsertFromSelect failed on business view V890911, temporary table F0911TCTEMP.
5100/368 WRK:Starting jdeCallObject Thu Jan 13 13:15:34.326000 Jdb_rq1.c5758 JDB3700001 - Failed to validate Request handle

 

Scenario 2

Customer upgrading from EnterpriseOne ERP 8.0 to E1 9.1 application release level with TR 9.1.0.5. When attempting to run TC for F4311, the following error occurs in the jde.log:

(...) 11236/9464 WRK:Starting jdeCallObject   Wed Sep 12 12:12:07.300000 dbsql_i.c375      SQL000000X - DBSQLInsertFromSelect: Build more-than-one-table query failed
11236/9464 WRK:Starting jdeCallObject         Wed Sep 12 12:12:07.300002 dbbndwhe.c462  OCI0000038 - Unable to bind where value - :KEY1
11236/9464 WRK:Starting jdeCallObject         Wed Sep 12 12:12:07.300003 dbbndwhe.c468  OCI0000039 - Error - ORA-01036: ÅܼƦWºÙ/¸¹½XµL®Ä
11236/9464 WRK:Starting jdeCallObject         Wed Sep 12 12:12:07.315000 dbinsel.c542       OCI0000176 - Failed to bind where-clause values - INSERT INTO PRODDTA.F4311TCTEMP (PDKCOO, PDDOCO, PDDCTO, PDSFXO, PDLNID, PDMCU, PDCO, PDOKCO, PDOORN, PDOCTO, PDOGNO, PDRKCO, PDRORN, PDRCTO, PDRLLN, PDDMCT, PDDMCS, PDBALU, PDAN8, PDSHAN, PDDRQJ, PDTRDJ, PDPDDJ, PDOPDJ, PDADDJ, PDCNDJ, PDPEFJ, PDPPDJ, PDPSDJ, PDDSVJ, PDDGL, PDPN, PDVR01, PDVR02, PDITM, PDLITM, PDAITM, PDLOCN, PDLOTN, PDFRGD, PDTHGD, PDFRMP, PDTHRP, PDDSC1, PDDSC2, PDLNTY, PDNXTR, PDLTTR, PDRLIT, PDPDS1, PDPDS2, PDPDS3, PDPDS4, PDPDS5, PDPDP1, PDPDP2, PDPDP3, PDPDP4, PDPDP5, PDUOM, PDUORG, PDUCHG, PDUOPN, PDUREC, PDCREC, PDURLV, PDOTQY, PDPRRC, PDAEXP, PDACHG, PDAOPN, PDAREC, PDARLV, PDFTN1, PDTRLV, PDPROV, PDAMC3, PDECST, PDCSTO, PDCSMP, PDINMG, PDASN, PDPRGR, PDCLVL, PDCATN, PDDSPR, PDPTC, PDTX, PDEXR1, PDTXA1, PDATXT, PDCNID, PDCDCD, PDNTR, PDFRTH, PDFRTC, PDZON, PDFRAT, PDRATT, PDANBY, PDANCR, PDMOT, PDCOT, PDSHCM, PDSHCN, PDUOM1, PDPQOR, PDUOM2, PDSQOR, PDUOM3, PDITWT, PDWTUM, PDITVL, PDVLUM, PDGLC, PDCTRY, PDFY, PDSTTS, PDRCD, PDFUF1, PDFUF2, PDGRWT, PDGWUM, PDLT, PDANI, PDAID, PDOMCU, PDOBJ, PDSUB, PDSBLT, PDSBL, PDASID, PDCCMP, PDTAG, PDWR01, PDPL, PDELEV, PDR001, PDRTNR, PDLCOD, PDPURG, PDPROM, PDFNLP, PDAVCH, PDPRPY, PDUNCD, PDMATY, PDRTGC, PDRCPF, PDPS01, PDPS02, PDPS03, PDPS04, PDPS05, PDPS06, PDPS07, PDPS08, PDPS09, PDPS10, PDCRMD, PDARTG, PDCORD, PDCHDT, PDDOCC, PDCHLN, PDCRCD, PDCRR, PDFRRC, PDFEA, PDFUC, PDFEC, PDFCHG, PDFAP, PDFREC, PDURCD, PDURDT, PDURAT, PDURAB, PDURRF, PDTORG, PDUSER, PDPID, PDJOBN, PDUPMJ, PDTDAY, PDVR05, PDVR04, PDPRJM, PDMERL, PDMCLN, PDMACT, PDKTLN, PDFTRL, PDDUAL, PDDRQT, PDDLEJ, PDCTAM, PDCPNT, PDCHT, PDCHRT, PDCHRS, PDCHMJ, PDBCRC, PDVR03, PDLDNM, PDMKFR, PDPMTN, PDUKID, PDRSHT, PDOSFX, PDSHPN, PDUNSPSC, PDCMDCDE, PDRSFX, PDWVID, PDCNTRTID, PDCNTRTDID, PDMOADJ, PDPODC01, PDPODC02, PDPODC03, PDPODC04, PDJBCD, PDSRQTY, PDSRUOM, PDCFGFL, PDPMPN, PDPNS) SELECT T0.PDKCOO, T0.PDDOCO, T0.PDDCTO, T0.PDSFXO, T0.PDLNID, T0.PDMCU, T0.PDCO, T0.PDOKCO, T0.PDOORN, T0.PDOCTO, T0.PDOGNO, T0.PDRKCO, T0.PDRORN, T0.PDRCTO, T0.PDRLLN, T0.PDDMCT, T0.PDDMCS, T0.PDBALU, T0.PDAN8, T0.PDSHAN, T0.PDDRQJ, T0.PDTRDJ, T0.PDPDDJ, T0.PDOPDJ, T0.PDADDJ, T0.PDCNDJ, T0.PDPEFJ, T0.PDPPDJ, T0.PDPSDJ, T0.PDDSVJ, T0.PDDGL, T0.PDPN, T0.PDVR01, T0.PDVR02, T0.PDITM, T0.PDLITM, T0.PDAITM, T0.PDLOCN, T0.PDLOTN, T0.PDFRGD, T0.PDTHGD, T0.PDFRMP, T0.PDTHRP, T0.PDDSC1, T0.PDDSC2, T0.PDLNTY, T0.PDNXTR, T0.PDLTTR, T0.PDRLIT, T0.PDPDS1, T0.PDPDS2, T0.PDPDS3, T0.PDPDS4, T0.PDPDS5, T0.PDPDP1, T0.PDPDP2, T0.PDPDP3, T0.PDPDP4, T0.PDPDP5, T0.PDUOM, T0.PDUORG, T0.PDUCHG, T0.PDUOPN, T0.PDUREC, T0.PDCREC, T0.PDURLV, T0.PDOTQY, T0.PDPRRC, T0.PDAEXP, T0.PDACHG, T0.PDAOPN, T0.PDAREC, T0.PDARLV, T0.PDFTN1, T0.PDTRLV, T0.PDPROV, T0.PDAMC3, T0.PDECST, T0.PDCSTO, T0.PDCSMP, T0.PDINMG, T0.PDASN, T0.PDPRGR, T0.PDCLVL, T0.PDCATN, T0.PDDSPR, T0.PDPTC, T0.PDTX, T0.PDEXR1, T0.PDTXA1, T0.PDATXT, T0.PDCNID, T0.PDCDCD, T0.PDNTR, T0.PDFRTH, T0.PDFRTC, T0.PDZON, T0.PDFRAT, T0.PDRATT, T0.PDANBY, T0.PDANCR, T0.PDMOT, T0.PDCOT, T0.PDSHCM, T0.PDSHCN, T0.PDUOM1, T0.PDPQOR, T0.PDUOM2, T0.PDSQOR, T0.PDUOM3, T0.PDITWT, T0.PDWTUM, T0.PDITVL, T0.PDVLUM, T0.PDGLC, T0.PDCTRY, T0.PDFY, T0.PDSTTS, T0.PDRCD, T0.PDFUF1, T0.PDFUF2, T0.PDGRWT, T0.PDGWUM, T0.PDLT, T0.PDANI, T0.PDAID, T0.PDOMCU, T0.PDOBJ, T0.PDSUB, T0.PDSBLT, T0.PDSBL, T0.PDASID, T0.PDCCMP, T0.PDTAG, T0.PDWR01, T0.PDPL, T0.PDELEV, T0.PDR001, T0.PDRTNR, T0.PDLCOD, T0.PDPURG, T0.PDPROM, T0.PDFNLP, T0.PDAVCH, T0.PDPRPY, T0.PDUNCD, T0.PDMATY, T0.PDRTGC, T0.PDRCPF, T0.PDPS01, T0.PDPS02, T0.PDPS03, T0.PDPS04, T0.PDPS05, T0.PDPS06, T0.PDPS07, T0.PDPS08, T0.PDPS09, T0.PDPS10, T0.PDCRMD, T0.PDARTG, T0.PDCORD, T0.PDCHDT, T0.PDDOCC, T0.PDCHLN, T0.PDCRCD, T0.PDCRR, T0.PDFRRC, T0.PDFEA, T0.PDFUC, T0.PDFEC, T0.PDFCHG, T0.PDFAP, T0.PDFREC, T0.PDURCD, T0.PDURDT, T0.PDURAT, T0.PDURAB, T0.PDURRF, T0.PDTORG, T0.PDUSER, T0.PDPID, T0.PDJOBN, T0.PDUPMJ, T0.PDTDAY, T0.PDVR05, T0.PDVR04, T0.PDPRJM, T0.PDMERL, T0.PDMCLN, T0.PDMACT, T0.PDKTLN, T0.PDFTRL, T0.PDDUAL, T0.PDDRQT, T0.PDDLEJ, T0.PDCTAM, T0.PDCPNT, T0.PDCHT, T0.PDCHRT, T0.PDCHRS, T0.PDCHMJ, T0.PDBCRC, T0.PDVR03, T0.PDLDNM, T0.PDMKFR, T0.PDPMTN, T0.PDUKID, T0.PDRSHT, NVL(T1.PDOSFX, ' '), NVL(T1.PDSHPN, 0), T0.PDUNSPSC, T0.PDCMDCDE, T0.PDRSFX, T0.PDWVID, T0.PDCNTRTID, T0.PDCNTRTDID, T0.PDMOADJ, ' ', ' ', ' ', ' ', ' ', 0, ' ', ' ', ' ', 0 FROM PRODDTA.F4311 T0,PRODDTA.F4311TA T1 WHERE  ( T0.PDMCU <> ? AND T0.PDCO <> ? )  AND  ( T0.PDKCOO = T1.PDKCOO (+)  AND T0.PDDOCO = T1.PDDOCO (+)  AND T0.PDDCTO = T1.PDDCTO (+)  AND T0.PDSFXO = T1.PDSFXO (+)  AND T0.PDLNID = T1.PDLNID (+)  )
11236/9464 WRK:Starting jdeCallObject         Wed Sep 12 12:12:07.315001 dbinsel.c549 OCI0000177 - Error - ORA-01036: ÅܼƦWºÙ/¸¹½XµL®Ä
11236/9464 WRK:Starting jdeCallObject         Wed Sep 12 12:12:07.315002 Jdb_drvm.c1785 JDB9900191 - Failed to insert the results of a select
11236/9464 WRK:Starting jdeCallObject         Wed Sep 12 12:12:07.315003 Jdb_exet.c10174 JDB3400025 - Failed to execute InsertFromSelect
11236/9464 WRK:Starting jdeCallObject         Wed Sep 12 12:12:07.315004 tcapi.c3372 TCE9000 - ITCEMergeTable - JDB_InsertFromSelect failed on business view V894311C, temporary table F4311TCTEMP..

 

Changes

Scenario 1 - Customer upgrading EnterpriseOne software to E1 9.0 application release level and doing a Data Only Upgrade Conversion for Production Environment; Scenario 2 - Customer upgrading EnterpriseOne software to E1 9.1 application release level and running scheduled TCs in the Table Conversion Workbench.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms