2 Replies Latest reply on Apr 19, 2017 3:50 PM by 3401357

    How to call function using oracle ebs personnalisation?

    3401357

      Hi,

      I have a function n sqldevelopper and i want to call it using oracle ebs personnalisation how i can do it?

      thank you.

        • 1. Re: How to call function using oracle ebs personnalisation?
          anasazii

          You just put it in your personalization....You will need to grant execute privilege on the function/package for APPS. 

          If you are passing any parameters that can get tricky, but just use the Insert Item Value or Insert 'Get' Expression buttons to find the complete name of that field on the form. Use the Validate form to check your syntax.

           

          So if you are calling it as a condition:

          my_schema.my_package_name.my_function(function_parameters)

           

          If you are calling it as an action

          Target Object - the field you want calculated by your function

          Property Name = property being changed by function (usually VALUE)

          Value = Call to your function: (MUST have the '=')

          =my_schema.my_package.my_function(function_parameters)

          1 person found this helpful
          • 2. Re: How to call function using oracle ebs personnalisation?
            3401357

            I MAKE THIS AND IT WORK thank you

            RES.PNG