Register to the Data Intelligence Summit Mexico City Register today to the Oracle Analytics Data Intelligence Summit in Mexico City on April 8th
Oracle Analytics was named as a Leader Oracle Analytics was named as a Leader in the 2024 Gartner® Magic Quadrant for Analytics and BI Platforms
New Oracle Analytics Release March 2025 New Oracle Analytics March 2025 release for Oracle Analytics Cloud and Analytics Server
Oracle Analytics Product Satisfaction Survey Share your experience and satisfaction with Oracle Analytics Product with our Product Satisfaction Survey

Oracle Business Intelligence Applications

w_AP_INV_DIST_F/PRODUCT_WID values are zero's

Question

Views

Comments

7688438 Rank 5 - Community Champion

March 2016 in Oracle Business Intelligence Applications

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???

Thanks

Oracle Business Intelligence Applications

Categories

w_AP_INV_DIST_F/PRODUCT_WID values are zero's