Chris Haase — Oracle Analytics

Welcome to the Oracle Analytics Community

Home› Chris Haase› Comments
Default Avatar
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Chris Haase Rank 2 - Community Beginner

Comments

  • Apologies for the small font. This is the SQL for the component out of FDI count(nvl(T1149.GLOBAL_PUOM_UNIT_COST , 0.0)) as c6 sum(nvl(T1149.GLOBAL_PUOM_UNIT_COST , 0.0)) as c7 sum(D1.c7) over () / sum(D1.c6) over () as c1 So, counting the individual rows, regardless if there is even stock on hand for that item. Summing up…
    in Add Actual OnHand Amount to Facts - Analytics Currency Comment by Chris Haase Mar 6, 2025 7:09PM
  • The document I am referencing for the calculations is from here Metric Calculation Spreadsheet - 25R1_SCM_Metric_Calculation_Logic in this spreadsheet row 283 the calculation is: SCM - Inventory Turns Unit Cost Avg(Global Puom Unit Cost) This premise is the wrong approach to take for getting a total unit of cost on hand…
    in Add Actual OnHand Amount to Facts - Analytics Currency Comment by Chris Haase Mar 6, 2025 4:21PM
  • Ramamurthy, The inventory value shown in the Fusion UI inventory valuation is correct. The problem is the design of the FDI Inventory valuation is using average(Unit Cost) across the unit of measure. I logged an SR and was told this was by design. But that is the problem, Fusion does not match FDI because of how FDI was…
    in Add Actual OnHand Amount to Facts - Analytics Currency Comment by Chris Haase Mar 6, 2025 4:06PM