Error Messages (Oracle)
Several error messages may appear on the screen when you execute Import Items.
"The application was unable to <perform database action> on tables <table list>." This error message is usually preceded by a SQL Error dialog box that shows the SQL statement that failed execution. Open a Windows text editor application such as WordPad or Notepad, and switch back to the SQL Error dialog box. Using your mouse, highlight the entire text of the SQL statement that failed execution and press Ctrl-Insert. This copies the text to the Windows Clipboard. Switch back to the text editor, left-click the mouse anywhere in the editing window, and press Shift-Insert. This pastes the SQL text from the Clipboard into the editing window. The text can now be printed and saved for use by Technical Support personnel.
- Related Topics:
- Report Error Messages
There are many error messages that may occur during the validation phase of this process. These messages are listed on the Error Report. - General Report Error Messages
These generalized errors may occur during the validation phase of the Import Items process. - Item (ITM) Error Messages
These are the more complicated errors associated with the ITM Line Type. - Part (PRT) Error Messages
These are the more complicated errors associated with the PRT Line Type. - Item Unit of Measure (IUM) Error Messages
These are the more complicated errors associated with the IUM Line Type. - Item Unit of Measure Conversion (UMC) Error Messages
These are the more complicated errors associated with the UMC Line Type. - Item Vendor (VND) Error Messages
These are the more complicated errors associated with the VND Line Type. - Item Cost (CST) Error Messages
These are the more complicated errors associated with the CST Line Type. - Item Project Cost (IPC) Error Messages
These are the more complicated errors associated with the IPC Line Type. - Item Lead Time (ILT) Error Messages
These are the more complicated errors associated with the ILT Line Type. - Item Text (TXT) Error Messages
These are the more complicated errors associated with the TXT Line Type. - Item User-Defined (UDF) Error Messages
These are the more complicated errors associated with the UDF Line Type. - Alternate Part (APT) Error Messages
These are the more complicated errors associated with the APT Line Type. - Substitute Part (SPT) Error Messages
These are the more complicated errors associated with the SPT Line Type. - Part Project (PPJ) Error Messages
These are the more complicated errors associated with the PPJ Line Type. - Project Substitute Part (PSP) Error Messages
These are the more complicated errors associated with the PSP Line Type. - Item Product (PRD) Error Messages
These are the more complicated errors associated with the PRD Line Type. - Product Price Catalog (PPC) Error Messages
These are the more complicated errors associated with the PPC Line Type. - Product Price Schedule (PPS) Error Messages
These are the more complicated errors associated with the PPS Line Type. - Product Cost Schedule (PCS) Error Messages
These are the more complicated errors associated with the PCS Line Type. - Product Warranty Cost Schedule (PWS) Error Messages
These are the more complicated errors associated with the PWS Line Type. - Project CLIN (CLN) Error Messages
These are the more complicated errors associated with the CLN Line Type. - PCP Error Messages
These are the more complicated errors associated with the PCP Line Type. - CLIN Price Schedule (CPS) Error Messages
These are the more complicated errors associated with the CPS Line Type. - CLIN Cost Schedule (CCS) Error Messages
These are the more complicated errors associated with the CCS Line Type. - CLIN Warranty Cost Schedule (CWS) Error Messages
These are the more complicated errors associated with the CWS Line Type.