Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Discounts and Promotionsmajorhave not tried2013-02-21 19:272013-03-14 16:57
ReporteradrianromeroView Statuspublic 
Assigned Tomigueldejuana 
PrioritynormalResolutionno change requiredFixed in VersionRMP21
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product VersionRMP19.2SCM revision 
Review Assigned Toadrianromero
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0023145: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0023113 closedguilleaer PL OBDISC_XY_GIFT is referencing a column that does not exist 

-  Notes
migueldejuana (developer)
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.

- Issue History
Date Modified Username Field Change
2013-02-21 19:27 adrianromero New Issue
2013-02-21 19:27 adrianromero Assigned To => marvintm
2013-03-13 17:09 migueldejuana Assigned To marvintm => migueldejuana
2013-03-13 17:16 migueldejuana Relationship added related to 0023113
2013-03-14 16:57 migueldejuana Review Assigned To => adrianromero
2013-03-14 16:57 migueldejuana Note Added: 0057261
2013-03-14 16:57 migueldejuana Status new => closed
2013-03-14 16:57 migueldejuana Resolution open => no change required
2013-03-14 16:57 migueldejuana Fixed in Version => RMP21

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker