Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0026468 | Openbravo ERP | 03. Procurement management | public | 2014-05-06 10:41 | 2014-05-06 12:46 |
|
| Reporter | gorkaion | |
| Assigned To | gorkaion | |
| Priority | normal | Severity | trivial | Reproducibility | N/A |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 20 | OS Version | Gentoo |
| Product Version | | |
| Target Version | 3.0PR14Q3 | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | gorkaion |
| OBNetwork customer | No |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0026468: Api change: Modify FK on delete clause |
| Description | The c_orderline_id FK on m_requisition_order table has been changed to include an "on delete cascade" clause. This will cause a change in the application:
Before: Removing a Purchase Order with a related Requisition will fail with a "linked items" error.
After: Removing a Purchase Order with a related Requisition will also try to remove the record in the requisition order table. There is a trigger in this table preventing to delete records of closed requisitions. This means that the automatic deletion will only happen on open requisitions.
Api-check test with the failure:
http://ci.openbravo.com/view/try/job/try-api/198/ [^] |
| Steps To Reproduce | N/A |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2014-05-06 10:41 | gorkaion | New Issue | |
| 2014-05-06 10:41 | gorkaion | Assigned To | => gorkaion |
| 2014-05-06 10:41 | gorkaion | Modules | => Core |
| 2014-05-06 10:41 | gorkaion | OBNetwork customer | => No |
| 2014-05-06 10:41 | gorkaion | Triggers an Emergency Pack | => No |
| 2014-05-06 10:55 | dmitry_mezentsev | Note Added: 0066834 | |
| 2014-05-06 11:16 | hgbot | Checkin | |
| 2014-05-06 11:16 | hgbot | Note Added: 0066836 | |
| 2014-05-06 11:16 | hgbot | Status | new => resolved |
| 2014-05-06 11:16 | hgbot | Resolution | open => fixed |
| 2014-05-06 11:16 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/api-checks/rev/7335ef336f63d21b8f3cce9d985f1060d6430e2e [^] |
| 2014-05-06 12:46 | gorkaion | Review Assigned To | => gorkaion |
| 2014-05-06 12:46 | gorkaion | Status | resolved => closed |