Skip to main content
Solved

Custom Field- Default Value using pl/sql expression

  • May 4, 2021
  • 2 replies
  • 1285 views

Forum|alt.badge.img+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))

 

Best answer by Astewart

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!

 

This topic has been closed for replies.

2 replies

Kelum Pradeep Kumara
Superhero (Employee)
Forum|alt.badge.img+18

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

Best Regards


Forum|alt.badge.img+4
  • Author
  • Do Gooder (Customer)
  • Answer
  • May 4, 2021

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!