0005017: The BOM_PRICESTD, BOM_PRICELIMIT and BOM_PRICELIST function get an error

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0005017

Openbravo ERP

02. Master data management

public

2008-09-11 12:27

2008-12-09 12:38

Reporter

networkb

Assigned To

Dowid

Priority

high

Severity

minor

Reproducibility

sometimes

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

2.35MP5

Target Version

Fixed in Version

2.35MP10

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0005017: The BOM_PRICESTD, BOM_PRICELIMIT and BOM_PRICELIST function get an error

Description

When the product that is parameter of the function is BOM and has price 0, and the products that belong to the bug also have price 0 (in the pricelist_version passed to the fuctions) you get an error because you don't have enough cursors to execute.
It happen because is a recursive function and never stop in this case.

Steps To Reproduce

Proposed Solution

Instead of using this line
IF(v_Price=0) THEN

use this other more restrictive

SELECT ISBOM INTO v_isBom FROM M_PRODUCT WHERE M_PRODUCT_ID=Product_ID;

IF(v_Price=0 AND v_isBom='Y') THEN

remember to declare v_isBom.

Additional Information