Tuesday, 10 September 2013

Purchase Order Import Error : Unit of Measure (value = EA) is invalid or inactive for item XXXXXX

During the import of Purchase order lines from the table po_lines_interface , we are often faced with the error message:

  • Unit of Measure (value = EA) is invalid or inactive for item XXXXXX
this error is reported for the below reason:
  • The table po_lines_interface has 2 columns : UOM_CODE and Unit Of Measure 
Either of these columns need to be populated
  • If we are populating the column : UOM_CODE then we need to give the code of unit of measure eg : EA in this column
  • If we are populating the column Unit Of Measure  then we need to populate the description of UOM code column in this field. If there is any discrepancy in this the above error will be reported

Thursday, 22 August 2013

Auto Invoice Error : Invalid Value of Conversion Type (CONVERSION_TYPE)

When we run the Auto Invoice Import Program the record errors out with the details Invalid Value of Conversion Type (CONVERSION_TYPE).
This Error occurs because of the below reason :

  1. The Conversion Type Specified is not defined in the system
  2. Some times the user by mistake updates the value of USER_CONVERSION_TYPE of the table : GL_DAILY_CONVERSION_TYPES where as the value needs to be picked from the field CONVERSION_TYPE.


Auto Invoice Error : The supplied unit of measure and the primary unit of measure of your system item must share the same unit of

When importing invoice from ra_interface_lines_All table the user can be faced with an error : The supplied unit of measure and the primary unit of measure of your system item must share the same unit of.
This error message is generally reported because of either of the below reason:

  1. The Unit of Measure specified for the item in ra_interface_lines_all is different from what is specified in the item setup
  2. The item is not assigned to the warehouse for which the invoice line is being tried to be imported