DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

problem while converting a varchar2 to number in reports oracle EBS

2679576Sep 17 2015 — edited Sep 17 2015

HI,

i created a state with oracle reports when i integrated it to the EBS, it ended with error . When i lanced the reports in local it works i think the problem is in my request because when i eliminate the line of concerting a varchar2 to number it works. The column in which i has a problem is Mtli.Attribute1 because it is a varchar2 and i would like to convert it to number. Please could you help me i didn't know why it works on local but when i integrate it with the EBS , it finishes with error.





Select 
Mtli.Segment1||'.'||Mtli.Segment2||'.'||Mtli.Segment4 Code_Article,
Flx.Description Description,
Wsh.Inventory_Item_Id,
mtli.Description Description,
to_number(nvl(Mtli.Attribute1,0),'999999999') Budget,
Sum(Wsh.SHIPPED_QUANTITY) Qte,  
Sum(Wsh.REQUESTED_QUANTITY) Total_Qte


From 
Mtl_System_Items Mtli,
Fnd_Flex_Values_Vl Flx,
Wsh_Deliverables_V Wsh--,




Where 
 Mtli.Segment2=Flx.Flex_Value
 And Mtli.Inventory_Item_Id=Wsh.Inventory_Item_Id
 And Mtli.Organization_Id= 85
 and Wsh.ORGANIZATION_ID = Mtli.Organization_Id
 and wsh.Released_Status_Name in ('Expédiée','Transféré')
 and Wsh.INV_INTERFACED_FLAG = 'Y'
 -- And Wsh.DATE_SCHEDULED Between To_Date('01/01/'||:P_Year,'dd/MM/yyyy') And To_Date('31/12/'||:P_Year,'dd/MM/yyyy')
 And Wsh.DATE_REQUESTED Between To_Date('01/01/'||:P_Year,'dd/MM/yyyy') And To_Date('31/12/'||:P_Year,'dd/MM/yyyy')
 GROUP BY Mtli.Segment1||'.'||Mtli.Segment2||'.'||Mtli.Segment4, 
 Flx.Description, 
 mtli.Description, 
 Mtli.Attribute1,
 Wsh.Inventory_Item_Id,
 wsh.Released_Status_Name