EAM-54563 CLONE - Work Orders | Cost Summary - unable to retrieve text error |
|
Description |
|
The cost summary tab cannot be opened if the work order has child work orders. It gives the Unable to retrieve error. In the log file it shows ORA-01722: invalid number. This seems to be related to the o7siddma function. It holds double quotes. If these are replaced by single quotes, the tab can be opened and the costs are calculated correctly. h4. Wrong ? SELECT ( ( ROUND( SUM( ( ( ( NVL( DECODE(v.inv_return, {color:red}*''+''*{color}, i.ivl_returnqty, i.ivl_invqty), 0 ) * NVL( i.ivl_price, 0 ) + NVL( i.ivl_invcalctaxamount, 0 ) + NVL( i.ivl_totextra, 0 ) ) / NVL( DECODE(v.inv_return,*{color:red} ''+''*{color}*, i.ivl_returnqty, h4. Okay ? SELECT ( ( ROUND( SUM( ( ( ( NVL( DECODE(v.inv_return, {color:#14892c}*'+'*{color}, i.ivl_returnqty, i.ivl_invqty), 0 ) * NVL( i.ivl_price, 0 ) + NVL( i.ivl_invcalctaxamount, 0 ) + NVL( i.ivl_totextra, 0 ) ) / NVL( DECODE(v.inv_return, {color:#14892c}*'+'*{color}, i.ivl_returnqty, h4. Actual results Cannot open the cost summary tab in work orders screen h4. Expected results Should be able to open cost summary tab h4. Steps to reproduce 1. Go to work - work orders 2. Select the All work orders dataspy and run it. 3. Select wo 426631 4. Open cost summary tab : unable to retrieve text |
EAM-54577 CLONE - CLONE - Work Orders | Closing - making any update erases longitude and latitude fields (EVT_LONGITUDE & EVT_LATITUDE). |