Getting errors UPDATING an Item in a Price List in Bulk using Import Price Lists Batch FBDI — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Getting errors UPDATING an Item in a Price List in Bulk using Import Price Lists Batch FBDI

edited Aug 14, 2025 9:26AM in Pricing 3 comments

While trying to UPDATE an existing Price Lists' Items and Charges, getting the following errors:

  1. primary_pricing_uom_flag - Only one price list item record can be the primary pricing UOM for a combination of item and line type.
  2. item_number - The value of the attribute Item Number isn't valid.
  3. The request to do the operation failed because the record doesn't exist.

There were 4000 records in the FBDI, for 5 different Price Lists. 2400+ were successfully imported while the rest failed due to the above mentioned issues.

Also, I noticed that the same Price List has 2 different SOURCE_PRICE_LIST_IDs in QP_PRICE_LISTS_INT table, and both of them are imported.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!