Purchase Orders (P4310) issues the errors below,
| Message from webpage |
|
INFORMATION You are not authorized to run this application. |
and,
| Message from webpage |
|
TRANSACTION ERROR Transaction cannot be committed. It was canceled. |
when the processing option of P4310|Version has,
Tab 3 - Interfaces
5. Supplier Analysis (1 = Capture)
A user has updated the second item number using P4101 (Item Master Revision) without having Global Update on.
The second number is changed in the Item Master File (F4101) but F43090 holds old second item number.
A. Data from F4101
| ITM | LITM | AITM |
| 1234 | NewItem | NewItem |
B. Data from F43090
| ITM | LITM | AITM |
| 1234 | OldItem | OldItem |
C. The validation routine before insert a record on Second Item (F4101.LITM),
...
IN->[ 3] mnShortItemNumber [1234]
IN->[ 4] szSecondItemNumber [NewItem]
IN->[ 5] szThirdItemNumber [NewItem]
...
sql> SELECT * FROM PRDDTA.F43090 WHERE ( PCAN8 = 4343.000000 AND PCLITM = 'NewItem' )
: Which does not return any row
E. So INSERT INTO F43090 with Item Number - Short (F4101.ITM) which is 1234
sql> INSERT INTO JDE_CRP.CRPDTA.F43090 VALUES (4343.000000,1234.000000,'NewItem ','NewITem ',' ',118054,140366,' ',' ',' ',0.000000,0.000000,0.000000,0,0.000000,0.000000,9000.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,287670.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,' ',0,0.000000,0.000000,' ',' ','0')
ODBC:S DBPerformRequest req=08F0AF88 con=090129E0 env=01638228 dbc=08C70AE0 spid=98 VADC-JDD47 M (Satuser@VADC-JDD47)
ODBC[jdbodbc.C,3993] wSQLExecute failure. rc = -1
ODBC[jdbodbc.C,3993] STMT:00 [23000][2627] [Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint 'F43090_PK'. Cannot insert duplicate key in object 'PRODDTA.F43090'. The duplicate key value is (4343, , 1234).
ODBC[jdbodbc.C,3993] STMT:01 [01000][3621] [Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated.
ODB0000163 - wSQLExecute failure. rc=-1
JDB9900401 - Failed to execute db request
JDB3400009 - Failed to perform Insert for F43090
JDB9901232 - Canceling transaction because: TC052 InsertTable: Insert failed
Cancelling Transaction : 3871638538_2592_5640_562020588
Note: