Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0026685 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Modules] Service Contract Management | major | have not tried | 2014-05-23 21:36 | 2014-06-03 17:49 | |||
| Reporter | sjkumar | View Status | public | |||||
| Assigned To | naiaramartinez | |||||||
| Priority | normal | Resolution | unable to reproduce | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | Oracle | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Regression date | ||||||||
| Regression introduced by commit | ||||||||
| Regression level | ||||||||
| Review Assigned To | vmromanos | |||||||
| 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. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  The Rate card line Circled is showing the Net Unit Price.doc [^] (381,440 bytes) 2014-05-27 18:41 | |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0067468) vmromanos (manager) 2014-05-27 12:32 |
Please reply to the email |
|
(0067492) sjkumar (reporter) 2014-05-27 18:41 |
I have uploaded the screenshot of how the comnputation is taking pricelist value instead of the NetUnitPrice, |
|
(0067562) vmromanos (manager) 2014-05-29 10:53 |
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. |
|
(0067571) vmromanos (manager) 2014-05-29 12:46 |
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. |
|
(0067592) sjkumar (reporter) 2014-05-29 23:45 |
The usage " Oracle Object Storage Service – GET and all other Requests" belongs to only one parent :"Oracle IaaS and PaaS Public Cloud Services" |
|
(0067616) vmromanos (manager) 2014-05-30 12:07 |
Anuja will try to reproduce the same scenario with the latest obx and let us know. |
|
(0067695) sjkumar (reporter) 2014-06-02 23:27 |
This works correctly with the latest obx version. Please close the issue |
|
(0067725) vmromanos (manager) 2014-06-03 17:49 |
Rejected as unable to reproduce by the reporter with the latest version |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |