Skip to main content
Solved

Custom Field- Default Value using pl/sql expression


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!

 

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

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)
  • 3 replies
  • 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!

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings