Solved

Custom Field- Default Value using pl/sql expression


Userlevel 2
Badge +4

We are trying to load a custom field with the value of another custom field. I am trying to use two apis to pull the appropriate information but keep getting an invalid identifier message. Would anyone know the proper way to use the PL/SQL Expression method to set a default value. If nothing else point me to a location where I can find documentation on using this in a custom field. Below I have included the expression that I am trying to use, a screen shot of the custom field properties and the error that I am receiving. Any help would be much appreciated. 

expression:

SALES_PART_CFP.GET_CF$_JPC_SALES_PART_NOTE(SALES_PART_CFP.GET_objkey(contract,catalog_no))

 

icon

Best answer by Astewart 5 May 2021, 00:01

View original

This topic has been closed for comments

2 replies

Userlevel 7
Badge +18

Hi,
You can find the documentation from the below link
Custom Objects (ifsworld.com)

Best Regards

Userlevel 2
Badge +4

It takes me to a log in window and doesn't take me anywhere. I did find it in a help section showing that you cannot pass parameters to the PL/SQL expression. Thanks for the help!