Home » Applications » Oracle Fusion Apps & E-Business Suite » Forms personalization: Restrict JE Category LOV (Oracle GL 11.5.10.2)
Forms personalization: Restrict JE Category LOV [message #316521] Fri, 25 April 2008 08:51 Go to next message
roandgeo
Messages: 4
Registered: March 2008
Junior Member
We are trying to restricted the values that an end user can select, in the Journal Category field, when they are manually entering a journal. We do not want to restrict them to only 1 value but a subset of the Category LOV. Can any anyone provide examples of ow to do this?

thanks

George
Re: Forms personalization: Restrict JE Category LOV [message #317502 is a reply to message #316521] Thu, 01 May 2008 12:57 Go to previous message
roandgeo
Messages: 4
Registered: March 2008
Junior Member
Just for reference, here is the solution:

Just for everyones information, we were able to solve this issue in this manner:



Function Name: GLXJEENT_A

Form Name: GLXEENT

Level: Form



Condition



Trigger Event: WHEN-NEW-BLOCK INSTANCE

Trigger Object: Header

Condition: Null

Context: Site



Actions:

Seq: 1

Type: Builtin
Builtin Type: Create Record Group from Query

Argument: Select Je_Category_Name, User_Je_Category_Name, Description

From gl_je_categories

where user_je_category_name in ('a', 'b',...)

order by user_je_category_name

Group Name: XX Je Category (Can be any name)



Seq: 2

Type: Property

Object Type: LOV

Target Object: User_je_category_name

Property Name: Group Name

Value: XX Je Category (must match group name in seq 1)



Previous Topic: Booking of Loan in AP Module
Next Topic: clonning or duplicate
Goto Forum:
  


Current Time: Sun Dec 04 20:53:04 CST 2016

Total time taken to generate the page: 0.06363 seconds