Demantra Solutions - EBS (MOSC)

MOSC Banner

Ep load main is failing in Demantra 12.2.6 - ORA-00936: missing expression Error in PROCEDURE line

edited Oct 10, 2018 5:00AM in Demantra Solutions - EBS (MOSC) 5 commentsAnswered

Hi,

I have one question.

EP load is failing with the failing with below error :

ORA-00936: missing expression Error in PROCEDURE  line 1088

         dynamic_ddl( 'UPDATE MDP_MATRIX

                     SET    p1  = 0,

                            p2  = 0,

                            p3  = 0,

                            p4  = 0,

                            p5  = 0,

                            p6  = 0,

                            p7  = 0,

                            p8  = 0,

                            p9  = 0,

                            p10 = 0,

                            p11 = 0,

                            p12 = 0,

                            glob_prop         = 0,

                            prediction_status = '99',

                            level_id          = 0,

                            item_node         = ,

                            loc_node          = ,

                            prop_changes      = 0,

                            new_member        = 0

                     WHERE 1 = 1

                     AND    item_id     = 12

                     AND    location_id = 687')

2.

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

ORA-06512: at "DEMANTRA122.DYN_PROPORT_SALES_1", line 1424

ORA-20002: -936 ORA-00936: missing expression Error in PROCEDURE  line 1088

         dynamic_ddl( 'UPDATE MDP_MATRIX

                     SET    p1  = 0,

                            p2  = 0,

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