0023145: Function OBDISC_XY_GIFT Does not compile in Oracle

Openbravo Issue Tracking System - Retail Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0023145

Retail Modules

Discounts and Promotions

public

2013-02-21 19:27

2013-03-14 16:57

Reporter

adrianromero

Assigned To

migueldejuana

Priority

normal

Severity

major

Reproducibility

have not tried

Status

closed

Resolution

no change required

Platform

OS Version

Product Version

RMP19.2

Target Version

Fixed in Version

RMP21

Merge Request Status

Review Assigned To

adrianromero

OBNetwork customer

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0023145: Function OBDISC_XY_GIFT Does not compile in Oracle

Description

The error that shows in the SQL Manager when trying to recompile this function is:

Error(95,31): PL/SQL: ORA-00904: "IL"."QTYORDERED": identificador no válido

And the sentence that returns the error is:

                 select floor(il.qtyordered / coalesce(op.em_obdisc_qty + op.em_obdisc_gifqty, 1))
             into v_gift_chunks
             from c_invoiceline il, m_offer_product op
            where il.c_invoice_id = v_docId
                and op.m_product_id = il.m_product_id
                                and op.m_offer_id = p_rule_id
                and op.em_obdisc_is_gift = 'Y';

Steps To Reproduce

In description

Proposed Solution

Additional Information