Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0021933 | Openbravo ERP | 03. Procurement management | public | 2012-10-15 11:23 | 2012-11-21 06:06 |
|
| Reporter | pramakrishnan | |
| Assigned To | pramakrishnan | |
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 30 | OS Version | Professional Appliance |
| Product Version | pi | |
| Target Version | | Fixed in Version | | |
| 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 | No |
|
| Summary | 0021933: API Change : Cascade on delete options for constraints in m_matchpo table |
| Description | When records are deleted from Goods Receipt Lines and Goods Shipment Lines, they are not removed from M_Matchpo. So we are not able to delete lines that are created from Orders. |
| Steps To Reproduce | 1. Use create from option to create lines in Goods Shipment from any Order.
2. Try to delete that line. It will show dependency error. |
| Proposed Solution | cascade on delete option is needed for the following fields in m_matchpo
1. m_inoutline_id
2. c_orderline_id
API change is needed. |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2012-10-15 11:23 | pramakrishnan | New Issue | |
| 2012-10-15 11:23 | pramakrishnan | Assigned To | => dmiguelez |
| 2012-10-15 11:23 | pramakrishnan | Modules | => Core |
| 2012-10-15 11:24 | pramakrishnan | Assigned To | dmiguelez => iciordia |
| 2012-10-15 12:04 | iciordia | Note Added: 0053349 | |
| 2012-10-15 14:44 | pramakrishnan | Note Added: 0053352 | |
| 2012-10-15 18:33 | iciordia | Note Added: 0053357 | |
| 2012-10-15 18:33 | iciordia | Assigned To | iciordia => pramakrishnan |
| 2012-10-16 13:06 | pramakrishnan | Status | new => scheduled |
| 2012-10-16 13:06 | pramakrishnan | fix_in_branch | => pi |
| 2012-11-14 13:36 | hgbot | Checkin | |
| 2012-11-14 13:36 | hgbot | Note Added: 0054225 | |
| 2012-11-14 13:36 | hgbot | Status | scheduled => resolved |
| 2012-11-14 13:36 | hgbot | Resolution | open => fixed |
| 2012-11-14 13:36 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/a7d41be10b1bb59d84f47a6667ffdbe483fdf776 [^] |
| 2012-11-14 16:09 | Sandrahuguet | Note Added: 0054236 | |
| 2012-11-14 16:09 | Sandrahuguet | Status | resolved => closed |
| 2012-11-21 06:06 | hudsonbot | Checkin | |
| 2012-11-21 06:06 | hudsonbot | Note Added: 0054379 | |
|
Notes |
|
|
|
Pandee, I don't see an evaluation of the risk of this api change. Please add it to the issue and I will react (talk to Eduardo for guidance).
Ismael |
|
|
|
|
|
This API change does not have any risk because, before doing the fix for the issue https://issues.openbravo.com/view.php?id=19043, [^] no action will trigger this cascade delete constraint as the completed goods receipt can never be deleted. But now I have added rows in m_matchpo before completing an shipment which throws the dependency error in goods receipt lines. This occurs only when creating lines from order since the cascade delete constraint is already present in m_matchinv. After discussing with Pablo Sarobe, he told the cascade delete constraint is only needed for the column m_inoutline_id and not for c_orderline_id. |
|
|
|
|
|
|
|
(0054225)
|
|
hgbot
|
|
2012-11-14 13:36
|
|
|
|
|
|
|
|
|
|
|