Guest_imported
New member
- Jan 1, 1970
- 0
Hi,
Version is 11.5.1, OS : HP-UX 64 bit.
I am checking for "Round to" feature in Price List, and mass adjustment in Price list.
I have a standard Price List, say PL-1, which I copied successfully using Copy Price List feature. This is working fine. The rounding factor is -5 which is copied to new price list PL-2.
I did an "Adjust Price List" on an item in PL-2. When I try to adjust by Amount (say add 0.0006) it says format should be FM99999999999999999D00. When I try to adjust by percent (say 10%), it gives an error : FDPSTP failed due to ORA-00904. A check of the log shows :
FDPSTP failed due to ORA-00904 : Invalid Column Name.
Any suggestions how to over come this?
I am using the adjust price list form only and not API.
Thanx in Advance.
Version is 11.5.1, OS : HP-UX 64 bit.
I am checking for "Round to" feature in Price List, and mass adjustment in Price list.
I have a standard Price List, say PL-1, which I copied successfully using Copy Price List feature. This is working fine. The rounding factor is -5 which is copied to new price list PL-2.
I did an "Adjust Price List" on an item in PL-2. When I try to adjust by Amount (say add 0.0006) it says format should be FM99999999999999999D00. When I try to adjust by percent (say 10%), it gives an error : FDPSTP failed due to ORA-00904. A check of the log shows :
FDPSTP failed due to ORA-00904 : Invalid Column Name.
Any suggestions how to over come this?
I am using the adjust price list form only and not API.
Thanx in Advance.