nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Home
Oracle Analytics and AI
Oracle Analytics and AI Forums
More Solutions
Oracle Business Intelligence Applications Forum

w_AP_INV_DIST_F/PRODUCT_WID values are zero's

7688438

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

Find more posts tagged with

Accepted answers

All comments

There are no accepted answers yet