Product Price Schedule (PPS) Error Messages
These are the more complicated errors associated with the PPS Line Type.
Error Message | Additional Info/Remedy |
---|---|
From Qty must be .0001 > prev To Qty. | The From Quantity value conflicts with an existing Product Price Schedule row or another pending PPS line for the Item ID/Item Revision ID/Price Catalog Code/ Start Date/End Date. If you want to have additional lines for the same Item ID/Item Revision ID/ Price Catalog Code/ Start Date/End Date, the From Quantity must be .0001 greater than the existing/pending To Quantity. There must be no overlapping and no gaps in the quantity values. For example, if you want one entry that covers From Quantity .0001 through To Quantity 4.9999, the next entry must have a From Quantity of 5.000 (.0001 greater than 4.9999). |
Must have .0001 From Qty. | Each PPS line for the Item ID/Item Revision ID/ Price Catalog Code/ Start Date/End Date must have a From Quantity = .0001. That is the default if no value is provided in the input file. |
Must have 9(10).9999 To Qty. | Each PPS line for the Item ID/Item Revision ID/ Price Catalog Code/ Start Date/End Date must have a To Quantity = 9999999999.9999. That is the default if no value is provided in the input file. |
No matching Prod Price Catalog record. | There is a PPS record in the input file without a corresponding PPC record (with the same Item ID/Item Revision ID/Price Catalog Code). |
PPS rejected, no matching Item. | There is a PPS record in the input file without a corresponding ITM record (with the same Item ID/Item Revision ID). |
PPS rejected. Bad ITM. | Unless there are additional error messages for this record, it probably contains no errors. It was rejected because it is dependent on an ITM record that was rejected. Correct the errors associated with the ITM record. |
PPS rejected. Bad PPC record. | The corresponding Product Price Catalog (PPC) record (with the same Item ID/Item Revision ID/Price Catalog Code) contains errors. Unless there are additional error messages for this record, it probably contains no errors. It was rejected because it is dependent on a PPC record that was rejected. Correct the errors associated with the PPC record. |
Start Dt must be day after prev End Dt. | The Start Date value conflicts with an existing Product Price Schedule row or another pending PPS line for the Item ID/Item Revision ID/Price Catalog Code/Start Date/End Date. If you want to have additional lines for the same Item ID/Item Revision ID/ Price Catalog Code/ Start Date/End Date, the Start Date must be one day later than the existing/pending End Date. There must be no overlapping and no gaps in the date values. For example, if you want one entry that covers Start Date 2003-01-01 through End Date 2003-06-30, the next entry must have a Start Date of 2003-07-01 (one day later than 2003-06-30). |
Parent Topic: Error Messages (Oracle)