4 Replies Latest reply on Feb 7, 2017 11:05 AM by Sanjay Desai EBS

    Problem facing in personalization

    Sanjay Desai EBS

      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}||''',

      '''||${item.LINE.ORDERED_ITEM_ID.value}||''',

      '''||${item.LINE.SHIP_FROM_ORG_ID.value}||''') from dual

       

       

       

       

      PL/SQL FUCTION  : XX_BENZLER_DEFAULT_LINE_TYPE

       

      CREATE OR REPLACE FUNCTION APPS.XX_BENZLER_DEFAULT_LINE_TYPE (p_ord_type_id VARCHAR2, p_item_id VARCHAR2, p_ship_from_org_id VARCHAR2) RETURN VARCHAR2 IS

      BEGIN

         RETURN 'Series M M01-08 ABS Prod L/S';

      END XX_BENZLER_DEFAULT_LINE_TYPE;

       

      Please help me to resolve the problem.

       

      Thanks in advance

      regards

      sd