Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

w_AP_INV_DIST_F/PRODUCT_WID values are zero's

Question
1
Views
0
Comments

Hi All, w_AP_INV_DIST_F/PRODUCT_WID was populated as zeros for most of the records Because of this the product categories spend counts data is not matching with EBS source. select COUNT(*) FROM W_AP_INV_DIST_F T596283 WHERE TO_CHAR(TO_DATE(POSTED_ON_DT_WID,'YYYYMMDD'),'YYYY')='2015' AND T596283.PRODUCT_WID=0; --1,754,949 ODI out of the box formula:-

Any Changes or customization on this code???

13.PNG

Thanks

R