My Oracle Support Banner

E1: ENV: R980011 Errors : DUPLICATE KEY F980011 / F980021, GET TABLE SPEC FOR TABLE XX VIEW YY FAILED (Doc ID 2632548.1)

Last updated on JANUARY 29, 2020

Applies to:

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

Symptoms

App.Release 9.2

Errors observed in JDE.LOG after running R9800011 version XJDE0001 (ALL Objects) Or each version separately: XJDE0002 (APPL), XJDE0003 (UBE), XJDE0004(BSFN), XKDE0005 (TBLE), XJDE007 (BSVW).
No errors reported in R980011 PDF.
Before each run, tables F980011 and F980021 are cleared by re-generating table in OMW.

List of Errors :

XJDE0001 ( ALL Objects )
Sum of errors listed below for each version

XJDE0002 ( APPL )

Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P0010 , W0010B , FORM , NAME , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P00422 , W00422B , FORM , ENFORCE , CHKB
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P0092 , W0092N , FORM , STATUS , EDIT
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (P0092 , W0092A , PID , VAR , , 0,
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (P0092 , W0092A , JOBN , VAR , , 0,
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P0092L , W0092LN , FORM , STATUS , EDIT
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (P0092L , W0092LA , PID , VAR , , 0,
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (P0092L , W0092LA , JOBN , VAR , , 0,
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P00950 , W00950X , FORM , USER , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P01012 , W01012A , FORM , TICKER , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P01012SS , S01012SSA , FORM , TICKER , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P01015 , W01015A , FORM , REGION , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P0101Z1 , W0101Z1A , FORM , TICKER , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P0112 , W0112A , FORM , RMK , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P01300 , W01300B , FORM , SUBJECT , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P01300 , W01300C , FORM , SUBJECT , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P01312 , W01312B , FORM , SUBJECT , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P01312 , S01312C , FORM , SUBJECT , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P01RS002 , W01RS002F , FORM , ROLE , EDIT
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (P051141 , W051141A , ICU , VAR , , 0,
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P05420 , W05420F , FORM , RESOURCE , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P05420 , W05420F , FORM , RESOURCE , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P059061 , W059061C , FORM , PCCD , EDIT
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (P0623 , W0623B , EV01 , VAR , , 0,
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (P079951 , W079951B , EV01 , VAR , , 0,
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P1201 , W1201G , FORM , BIN , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P1201 , W1201K , FORM , BIN , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P12215 , W12215B , FORM , BIN , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P1501 , W1501C , FORM , UNIT , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P15153 , W15153E , FORM , UNIT , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P1540 , W1540B , FORM , UNIT , EDIT
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (P159071 , W159071B , EV01 , VAR , , 0,
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P17022 , W17022A , FORM , FLOOR , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P30BREV , W30BREVA , FORM , ECPR , UDCE
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P30BREV , W30BREVA , FORM , KIT , EDIT
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (P31114 , W31114B , DTAI , VAR , , 0,
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P31B0740 , W31B0740B , FORM , ACTIVITY , EDIT
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (P31B5101 , S31B5101A , PID , VAR , , 0,
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (P34301 , W34301I , INT01 , VAR , , 0,
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P34401 , W34401B , FORM , MONTH , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P37300 , W37300C , FORM , RESOURCE , EDIT
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (P4004Z , W4004ZA , EDLN , VAR , , 0,
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P40314 , W40314A , FORM , UOM , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P40315 , W40315A , FORM , UOM , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P4074 , W4074A , FORM , TIER , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P40G0200 , W40G0200B , FORM , CLONE , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P40G03 , W40G03C , FORM , CLONE , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P40G0300 , W40G0300B , FORM , CLONE , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P40P011 , W40P011B , FORM , TACTIC1 , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P40P011 , W40P011B , FORM , TACTIC2 , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P40P011 , W40P011B , FORM , TACTIC3 , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P40P011 , W40P011B , FORM , TACTIC4 , EDIT
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (P4100A , W4100AA , SY , VAR , , 0,
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P41822 , W41822B , FORM , BIN , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P43E10 , S43E10B , FORM , UOM , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P43E83 , S43E83A , FORM , RESOURCE , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P44H201 , W44H201B , FORM , SWING , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P44H500 , W44H500A , FORM , SWING , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P44H500 , W44H500D , FORM , SWING , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P44H500 , W44H500F , FORM , SWING , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P44H602 , W44H602B , FORM , SWING , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P44H602 , W44H602D , FORM , SWING , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P44H602 , W44H602F , FORM , SWING , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P44H602S , W44H602SA , FORM , SWING , EDIT
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (P44H703 , W44H703B , HBLOT , VAR , , 0, Post Dial
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P450303 , W450303A , FORM , RESOURCE , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P58012A , W58012AA , FORM , TICKER , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P74U1501 , W74U1501C , FORM , UNIT , EDIT
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (P74U424A , W74U424AA , EV01 , VAR , , 0,
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (P75I20A , W75I20AB , CTRY , VAR , , 0,
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P75I322 , W75I322A , FORM , UTIME , EDIT
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (P75I601 , W75I601B , AA1 , VAR , , 0,
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P90CA080 , W90CA080A , FORM , TICKER , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P90CB060 , S90CB060A , FORM , REVENUE , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P91100 , W91100C , FORM , FOLDER , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P91300 , W91300C , FORM , SUNDAY , CHKB
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P91300 , W91300C , FORM , MONDAY , CHKB
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P91300 , W91300C , FORM , TUESDAY , CHKB
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P91300 , W91300C , FORM , WEDNESDAY , CHKB
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P91300 , W91300C , FORM , THURSDAY , CHKB
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P9500003 , W9500003F , FORM , EVENT , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P9500005 , W9500005B , FORM , EVENT , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P9500005 , W9500005C , FORM , EVENT , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P9500005 , W9500005F , FORM , EVENT , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P9500005 , W9500005H , FORM , COLUMN , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P95400 , W95400G , FORM , USER , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P9621 , W9621B , FORM , CLIENT , CHKB
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P9621 , W9621F , FORM , CLIENT , CHKB
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P9621 , W9621I , FORM , CLIENT , CHKB
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (P9621 , W9621B , DATP , VAR , , 0,
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (P9621 , W9621N , ISPTF , VAR , , 0,
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P96710 , W96710B , FORM , PERCENT , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P96710 , W96710M , FORM , PERCENT , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P968901 , W968901B , FORM , NAME , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P968901 , W968901C , FORM , NAME , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P968901 , W968901D , FORM , NAME , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P968901 , W968901G , FORM , NAME , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P96UCUST , W96UCUSTA , FORM , STATUS , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P96UCUST , W96UCUSTF , FORM , STATUS , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P9840TC , W9840TCB , FORM , TRACING , CHKB
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P98410 , W98410A , FORM , TRACING , CHKB
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P98413 , W98413D , FORM , TCTHROTTLE , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P986115 , W986115I , FORM , UNICODE , CHKB
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (P9881 , W9881D , EV01 , VAR , , 0,
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P98860 , W98860B , FORM , RESOURCE , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P988663 , W988663A , FORM , RESOURCE , EDIT
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P98LPSEC , W98LPSECQ , FORM , ATTEMPTS , CHKB
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (P98OWSEC , W98OWSECI , FORM , ATTEMPTS , CHKB
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (PCW082 , WCW082A , C9LVNO , VAR , , 0,
Cannot insert duplicate key in object 'x.F980011'. The duplicate key value is (PF30L110 , SF30L110B , FORM , TIMEUOM , COMB
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (PF30L703 , WF30L703A , PROID , VAR , , 0, Button Cl

XJDE0003 ( UBE )

Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (R04413C , S2 , DGJ , VAR , , 0,
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (R989200P , S25 , SY , VAR , , 0, 

• XJDE0004 ( BSFN )

Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (N4900140 , , GENLNG , VAR , , 0, CreateLoa
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (N4900540 , , SRCO , VAR , , 0, DeliverCo
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (N4900780 , , MOT , VAR , , 0, LoadConfi
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (R04413C , S2 , DGJ , VAR , , 0,

XJDE0005 ( TBLE )

Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (F41181 , INDEX , AN8 , TBLE , DTAN , 0, AN8, ITM
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (F41181 , INDEX , ITM , TBLE , DTAN , 0, AN8, ITM
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (F79A11 , INDEX , 79AGESID , TBLE , DTAN , 0, 79A 79AGE
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (FF30L707 , INDEX , PPHID , TBLE , DTAN , 0, ScenarioI
Cannot insert duplicate key in object 'x.F980021'. The duplicate key value is (FF30L707 , INDEX , FSCID , TBLE , DTAN , 0, ScenarioI

XJDE0007 ( BSVW

Get Table Spec for table F31B41 view V31B85B failed
Get Table Spec for table F4230 view V4230A failed
Get Table Spec for table F4230 view V4230A failed
Get Table Spec for table F7618B view V7618B failed
Get Table Spec for table F7618B view V7618B failed
Get Table Spec for table F76VLVCF view V76VLVCF failed
Get Table Spec for table FF30L704 view VF30L705 failed
Get Table Spec for table F0016D view V0016DA failed
Get Table Spec for table 102632 view V00052 failed
Get Table Spec for table 102633 view V000521 failed
Get Table Spec for table 102634 view V000522 failed
Get Table Spec for table F0016D view V0016 failed
Get Table Spec for table F0016D view V0016DA failed
Get Table Spec for table 5802 view V0030WA failed
Get Table Spec for table 30612 view V0087A failed
Get Table Spec for table F0088 view V0088A failed
Get Table Spec for table F0097 view V0097A failed
Get Table Spec for table 8812 view V0101A6A failed
Get Table Spec for table F0101Z1 view V0101Z1 failed
Get Table Spec for table 64832 view V01136A failed
Get Table Spec for table F0301 view V0301C failed
Get Table Spec for table 299 view V03103A failed
Get Table Spec for table 33016 view V0311C failed
Get Table Spec for table 64633 view V036003 failed
Get Table Spec for table F03B01 view V03B01A failed
Get Table Spec for table F03B01 view V03B01B failed
Get Table Spec for table F03BUI01 view V03BUI02A failed
Get Table Spec for table F03BUI01 view V03BUI07A failed
Get Table Spec for table 20209 view V04DOWNA failed
Get Table Spec for table 105560 view V04UI003A failed
Get Table Spec for table 105760 view V04UI003C failed
Get Table Spec for table 105560 view V04UI003D failed
Get Table Spec for table F76M0101 view V060116MX failed
Get Table Spec for table 336085 view V06106AA failed
Get Table Spec for table F075506 view V075506A failed
Get Table Spec for table 8811 view V0901A6A failed
Get Table Spec for table 8811 view V0901A6B failed
Get Table Spec for table F09E111 view V09E111 failed
Get Table Spec for table F09UI001 view V09UI001A failed
Get Table Spec for table F09UI002 view V09UI002B failed
Get Table Spec for table F105503 view V105503 failed
Get Table Spec for table F12UI001 view V12UI001A failed
Get Table Spec for table F31B312 view V31B312A failed
Get Table Spec for table F31B85T view V31B80E failed
Get Table Spec for table F31B83 view V31B83A failed
Get Table Spec for table F31B41 view V31B85B failed
Get Table Spec for table F31B86 view V31B86A failed
Get Table Spec for table F31UI001 view V31UI001A failed
Get Table Spec for table F31UI418 view V31UI418A failed
Get Table Spec for table 108890 view V32UI001A failed
Get Table Spec for table 108890 view V32UI001C failed
Get Table Spec for table F3411Z1 view V3411Z1A failed
Get Table Spec for table F4021W view V4021WA failed
Get Table Spec for table F4021W view V4021WB failed
Get Table Spec for table 21008 view V4101G failed
Get Table Spec for table F4230 view V4230A failed
Get Table Spec for table 51234 view V43UI142A failed
Get Table Spec for table 8809 view V4801A6A failed
Get Table Spec for table 8809 view V4801A6B failed
Get Table Spec for table 8810 view V4802A6A failed
Get Table Spec for table F4813 view V4813A failed
Get Table Spec for table F489111 view V489111A failed
Get Table Spec for table F489111 view V489111B failed
Get Table Spec for table 343581 view V740911A failed
Get Table Spec for table F74S0101 view V74S0101A failed
Get Table Spec for table F74U0204 view V74U0204 failed
Get Table Spec for table F74U0210 view V74U0210A failed
Get Table Spec for table F7618B view V7618B failed
Get Table Spec for table F76A9004 view V76A9004 failed
Get Table Spec for table F76B474O view V76B474OA failed
Get Table Spec for table F76M0101 view V76M0101A failed
Get Table Spec for table F76VLVCF view V76VLVCF failed
Get Table Spec for table F31B03T view V8931B03 failed
Get Table Spec for table F31B13T view V8931B13 failed
Get Table Spec for table F31B14T view V8931B14 failed
Get Table Spec for table F98730 view V9200A failed
Get Table Spec for table 32623 view V9200B failed
Get Table Spec for table F98730 view V9200F failed
Get Table Spec for table F949999 view V949999 failed
Get Table Spec for table F960092C view V960092O failed
Get Table Spec for table F960092C view V960092P failed
Get Table Spec for table F960092C view V960092Q failed
Get Table Spec for table F960092C view V960092R failed
Get Table Spec for table F960092C view V960092S failed
Get Table Spec for table F960092B view V960092T failed
Get Table Spec for table F960092B view V960092U failed
Get Table Spec for table F960092B view V960092V failed
Get Table Spec for table F960092C view V960092X failed
Get Table Spec for table F960092C view V960092Y failed
Get Table Spec for table 883 view V98305A failed
Get Table Spec for table F98614 view V98614A failed
Get Table Spec for table F98701 view V98701A failed
Get Table Spec for table F98714 view V98714A failed
Get Table Spec for table F98715 view V98715A failed
Get Table Spec for table F98742 view V98742A failed
Get Table Spec for table F98763 view V98763A failed
Get Table Spec for table F98764 view V98764A failed
Get Table Spec for table F98FLATM view V98FLATM failed
Get Table Spec for table FF30L704 view VF30L705 failed
Get Table Spec for table FF30L706 view VF30L706 failed

  

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.