Demantra Solutions - EBS (MOSC)

MOSC Banner

ORA-00904: "SAFE_DIVISION": invalid identifier - how to get a workaround ?

edited May 15, 2014 1:59PM in Demantra Solutions - EBS (MOSC) 3 commentsAnswered ✓


Hi all,

In TOAD, I am running the SQL provied by someone and it is giving error."ORA-00904: "SAFE_DIVISION": invalid identifier"   Is there a alternate way to write this SQL. Please comment off the last two statements to run in your environment.  There must some simple way to run this SQL. Thanks

SELECT ROUND(SAFE_DIVISION((DEMAND - FORECAST), DEMAND, 0), 4) * 100 AS BIAS FROM (SELECT SUM(NVL(FORE_3,0)) AS FORECAST, SUM(NVL(greatest(nvl(pseudo_sale,nvl(actual_quantity, src_actual_quantity))*(1 + nvl(demand_fact,0)),0), 0)) AS DEMAND

FROM

Dem7302.MDP_MATRIX, dem7302.SALES_DATA BRANCH_DATA WHERE

MDP_MATRIX.ITEM_ID = BRANCH_DATA.ITEM_ID AND MDP_MATRIX.LOCATION_ID = BRANCH_DATA.LOCATION_ID AND MDP_MATRIX.PREDICTION_STATUS = 1

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Demantra Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center