Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023145Retail ModulesDiscounts and Promotionspublic2013-02-21 19:272013-03-14 16:57
Reporteradrianromero 
Assigned Tomigueldejuana 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product VersionRMP19.2 
Target VersionFixed in VersionRMP21 
Merge Request Status
Review Assigned Toadrianromero
OBNetwork customerNo
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023145: Function OBDISC_XY_GIFT Does not compile in Oracle
DescriptionThe 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 ReproduceIn description
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0023113 closed guilleaer PL OBDISC_XY_GIFT is referencing a column that does not exist 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-02-21 19:27adrianromeroNew Issue
2013-02-21 19:27adrianromeroAssigned To => marvintm
2013-02-21 19:27adrianromeroOBNetwork customer => No
2013-03-13 17:09migueldejuanaAssigned Tomarvintm => migueldejuana
2013-03-13 17:16migueldejuanaRelationship addedrelated to 0023113
2013-03-14 16:57migueldejuanaReview Assigned To => adrianromero
2013-03-14 16:57migueldejuanaNote Added: 0057261
2013-03-14 16:57migueldejuanaStatusnew => closed
2013-03-14 16:57migueldejuanaResolutionopen => no change required
2013-03-14 16:57migueldejuanaFixed in Version => RMP21

Notes
(0057261)
migueldejuana   
2013-03-14 16:57   
I tested the functionality which launch this function and it works well. Perhaps, it has been resolved with the fix of the related issue.