Openbravo Issue Tracking System - Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0026685 | Modules | Service Contract Management | public | 2014-05-23 21:36 | 2014-06-03 17:49 |
|
| Reporter | sjkumar | |
| Assigned To | naiaramartinez | |
| Priority | normal | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | unable to reproduce | |
| Platform | | OS | 30 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Regression date | |
| Regression introduced by commit | |
| Regression level | |
| Review Assigned To | vmromanos |
| Support ticket | |
| OBNetwork customer | |
| Regression introduced in release | |
|
| Summary | 0026685: Usage Computation is not calculating correctly. |
| Description | An order was pushed from GSI env to SPM env and in return it created the subscription :
Subscription Search Key :8809707
Parent Lines:
Oracle Database Public Cloud Services
Oracle IaaS and PaaS Public Cloud Services
RateCard Lines:
Oracle Database Backup Service – PUT, COPY, POST or LIST Requests
Oracle Storage Cloud - Object Storage - GB of Storage Capaci
Oracle Object Storage Service - Outbound Data Transfer
Oracle Object Storage Service – PUT, COPY, POST or LIST Requests
Oracle Database Backup Cloud - Object Storage - GB of Storag
Oracle Database Backup Service – GET and all other Requests
Oracle Object Storage Service – GET and all other Requests
Oracle Database Backup Service - Outbound Data Transfer
Oracle Database Backup
For One of the ratecard Line :" Oracle Object Storage Service – GET and all other Requests", the netunitprice passed from Order to SPM is 0.00376. where as in UI for that same line it shows as 0.00.
In database, we see the same line is populated with 0.000376 in obscntr_invoiceplan_templ (column :netunitprice)
When the Usage Computation was done for this line, the netunitprice got picked up from whatever is set up in pricelist against this product i.e 0.20. This is not correct.
We see here 2 issues
1)One the rounding is done upto 2 places of decimal when displaying in UI.
2)When the 'Usage Computation' is done, it should calculate based on the netunitprice defined against that product in subscribed service tab, Not from pricelist. |
| Steps To Reproduce | An order was pushed from GSI env to SPM env and in return it created the subscription :
Subscription Search Key :8809707
Parent Lines:
Oracle Database Public Cloud Services
Oracle IaaS and PaaS Public Cloud Services
RateCard Lines:
Oracle Database Backup Service – PUT, COPY, POST or LIST Requests
Oracle Storage Cloud - Object Storage - GB of Storage Capaci
Oracle Object Storage Service - Outbound Data Transfer
Oracle Object Storage Service – PUT, COPY, POST or LIST Requests
Oracle Database Backup Cloud - Object Storage - GB of Storag
Oracle Database Backup Service – GET and all other Requests
Oracle Object Storage Service – GET and all other Requests
Oracle Database Backup Service - Outbound Data Transfer
Oracle Database Backup
For One of the ratecard Line :" Oracle Object Storage Service – GET and all other Requests", the netunitprice passed is 0.00376. where as in UI for that same line it shows as 0.00.
In database, we see the same line is populated with 0.000376 in obscntr_invoiceplan_templ (column :netunitprice)
When the Usage Computation was done for this line, the netunitprice got picked up from whatever is set up in pricelist against this product i.e 0.20. This is not correct.
We see here 2 issues
1)One the rounding is done upto 2 places of decimal when displaying in UI.
2)WHen the 'Usage Computation' is done, it should calculate based on the netunitprice defined against that product in subscribed service tab, Not from pricelist. |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  The Rate card line Circled is showing the Net Unit Price.doc (381,440) 2014-05-27 18:41
https://issues.openbravo.com/file_download.php?file_id=6953&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2014-05-23 21:36 | sjkumar | New Issue | |
| 2014-05-23 21:36 | sjkumar | Assigned To | => vmromanos |
| 2014-05-27 12:32 | vmromanos | Note Added: 0067468 | |
| 2014-05-27 12:32 | vmromanos | Severity | critical => major |
| 2014-05-27 12:32 | vmromanos | Status | new => feedback |
| 2014-05-27 18:41 | sjkumar | Note Added: 0067492 | |
| 2014-05-27 18:41 | sjkumar | File Added: The Rate card line Circled is showing the Net Unit Price.doc | |
| 2014-05-29 10:53 | vmromanos | Note Added: 0067562 | |
| 2014-05-29 10:53 | vmromanos | Assigned To | vmromanos => naiaramartinez |
| 2014-05-29 10:53 | vmromanos | Status | feedback => scheduled |
| 2014-05-29 12:46 | vmromanos | Note Added: 0067571 | |
| 2014-05-29 12:46 | vmromanos | Status | scheduled => feedback |
| 2014-05-29 23:45 | sjkumar | Note Added: 0067592 | |
| 2014-05-30 12:07 | vmromanos | Note Added: 0067616 | |
| 2014-06-02 23:27 | sjkumar | Note Added: 0067695 | |
| 2014-06-03 17:49 | vmromanos | Review Assigned To | => vmromanos |
| 2014-06-03 17:49 | vmromanos | Note Added: 0067725 | |
| 2014-06-03 17:49 | vmromanos | Status | feedback => closed |
| 2014-06-03 17:49 | vmromanos | Resolution | open => unable to reproduce |
|
Notes |
|
|
|
|
Please reply to the email |
|
|
|
|
|
I have uploaded the screenshot of how the comnputation is taking pricelist value instead of the NetUnitPrice, |
|
|
|
|
After the call, we have detected that the computation is getting the wrong parent in case the subscribed services tab contains more than one basket.
Issue ready to be scheduled. |
|
|
|
|
Is it possible that the product that created the usage ("Oracle Object Storage Service – GET and all other Requests") belonged to both basket products ("Oracle Database Public Cloud Services" and "Oracle IaaS and PaaS Public Cloud Services") at the same time when the computation was created?
We know that this product is only "exploded" into one of the basket products at the subscribed services, but we are wondering if this product also belonged to the other parent basket product but it wasn't explode there. In that case the system behaviour would be OK.
|
|
|
|
|
|
The usage " Oracle Object Storage Service – GET and all other Requests" belongs to only one parent :"Oracle IaaS and PaaS Public Cloud Services" |
|
|
|
|
|
Anuja will try to reproduce the same scenario with the latest obx and let us know. |
|
|
|
|
|
This works correctly with the latest obx version. Please close the issue |
|
|
|
|
|
Rejected as unable to reproduce by the reporter with the latest version |
|