"You have encountered an unexpected error. Please contact the System Administrator for assistance."
This error appears at random in iProcurement. For some reason, the PO_REQUISITION_LINES_U2 is validated sometimes when a non catalog item is sdded to cart.
This is the error detail.
Could this problem be caused by some unfinished requisition?
<!--StartFragment-->oracle.apps.fnd.framework.OAException: oracle.jbo.DMLConstraintException: JBO-26048: Constraint "PO_REQUISITION_LINES_U2" violated during post operation:"Insert" using SQL Statement "INSERT INTO PO_REQUISITION_LINES_ALL(REQUISITION_LINE_ID,REQUISITION_HEADER_ID,LINE_NUM,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,CREATION_DATE,CREATED_BY,DELIVER_TO_LOCATION_ID,TO_PERSON_ID,ITEM_DESCRIPTION,CATEGORY_ID,UNIT_MEAS_LOOKUP_CODE,UNIT_PRICE,QUANTITY,LINE_TYPE_ID,SOURCE_TYPE_CODE,ITEM_ID,ITEM_REVISION,SUGGESTED_BUYER_ID,ENCUMBERED_FLAG,RFQ_REQUIRED_FLAG,NEED_BY_DATE,BLANKET_PO_HEADER_ID,BLANKET_PO_LINE_NUM,CURRENCY_CODE,RATE_TYPE,RATE_DATE,RATE,CURRENCY_UNIT_PRICE,SUGGESTED_VENDOR_NAME,SUGGESTED_VENDOR_LOCATION,SUGGESTED_VENDOR_CONTACT,SUGGESTED_VENDOR_PHONE,SUGGESTED_VENDOR_PRODUCT_CODE,UN_NUMBER_ID,HAZARD_CLASS_ID,URGENT_FLAG,SOURCE_ORGANIZATION_ID,SOURCE_SUBINVENTORY,DESTINATION_TYPE_CODE,DESTINATION_ORGANIZATION_ID,DESTINATION_SUBINVENTORY,VENDOR_ID,VENDOR_SITE_ID,VENDOR_CONTACT_ID,WIP_ENTITY_ID,WIP_OPERATION_SEQ_NUM,ATTRIBUTE_CATEGORY,DESTINATION_CONTEXT,TRANSACTION_REASON_CODE,ORG_ID,CATALOG_TYPE,CATALOG_SOURCE,MANUFACTURER_NAME,MANUFACTURER_PART_NUMBER,REQUESTER_EMAIL,REQUESTER_FAX,REQUESTER_PHONE,UNSPSC_CODE,SUPPLIER_DUNS,NEW_SUPPLIER_FLAG,ITEM_SOURCE_ID,SUPPLIER_REF_NUMBER,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,CURRENCY_AMOUNT,NONCAT_TEMPLATE_ID,ASSIGNMENT_END_DATE,CONTRACTOR_REQUISITION_FLAG,LABOR_REQ_LINE_ID,SUGGESTED_VENDOR_CONTACT_FAX,SUGGESTED_VENDOR_CONTACT_EMAIL,ASSIGNMENT_START_DATE,ORDER_TYPE_LOOKUP_CODE,PURCHASE_BASIS,MATCHING_BASIS,NEGOTIATED_BY_PREPARER_FLAG,BASE_UNIT_PRICE,TAX_ATTRIBUTE_UPDATE_CODE) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29,:30,:31,:32,:33,:34,:35,:36,:37,:38,:39,:40,:41,:42,:43,:44,:45,:46,:47,:48,:49,:50,:51,:52,:53,:54,:55,:56,:57,:58,:59,:60,:61,:62,:63,:64,:65,:66,:67,:68,:69,:70,:71,:72,:73,:74,:75,:76,:77,:78,:79,:80,:81,:82,:83,:84,:85,:86,:87,:88,:89,:90,:91,:92,:93)".