Technology Stack - EBS (MOSC)

MOSC Banner

Problem facing in Persoanlization

edited Feb 24, 2017 4:38PM in Technology Stack - EBS (MOSC) 2 commentsAnswered

Hi Experts.

we have EBS R12.1.3.

we are going to personlization to populate the Line Type with default value on sales order line in Order Management. but At the entry time it's giving an

error : ORA-00907 MISSING RIGHT PARENTHESIS.

Personalization steps are as follows:

TRIGGER EVENT  :      WHEN-VALIDATE-RECORD

TRIGGER OBJECT :    LINE

CONDITION             :   :ORDER.ORDER_TYPE_ID IS NOT NULL AND :LINE.ORDERED_ITEM_ID IS NOT NULL AND :LINE.SHIP_FROM_ORG_ID IS NOT NULL

ACTION :

TYPE                       --    PROPERTY

OBJECT TYPE       --   ITEM

TARGER OBJECT  -- LINE.LINE_TYPE

PROPERTY NAME  --  VALUE

VALUE --

=select XX_BENZLER_DEFAULT_LINE_TYPE('''||${item.ORDER.ORDER_TYPE_ID.value}||''',

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center