| FNDSCAUS LoV Personalization Error FRM-41826 [message #379187] |
Mon, 05 January 2009 05:24  |
daniloviz
Messages: 6
Registered: August 2008
|
Junior Member |
|
|
Hello and happy new year.
I'm personalizing the form FNDSCAUS so when a user is using the function FND_FNDSCAUS (Users) to add a responsibility, he wont access the full list of responsibilities but only the ones without administration access that have been already defined.
The personalization I was thinking about
1) Creates a new record group
2) Associates the record group with the LOV.
The personalization has the following details.
Triggering Event :- WHEN-NEW-BLOCK-INSTANCE
Processing Mode :- Both
Actions
Seq :- 10
Type :- Built in
Builtin Type :- Create Record Group from query
Arguement :-
SELECT R.RESPONSIBILITY_NAME, A.APPLICATION_NAME, R.DESCRIPTION, R.RESPONSIBILITY_ID, R.APPLICATION_ID
FROM FND_APPLICATION_VL A, FND_RESPONSIBILITY_VL R
WHERE R.APPLICATION_ID = A.APPLICATION_ID
AND (R.VERSION = '4' OR R.VERSION = 'W' OR R.VERSION= 'M')
AND (R.END_DATE IS NULL OR (TRUNC(SYSDATE) BETWEEN R.START_DATE AND R.END_DATE))
AND R.RESPONSIBILITY_NAME NOT LIKE '%Admin%'
Group Name :- XXUPO_RESP_LIST_RESTRICTED_LOV
Seq :- 20
Type :- Property
Object Type :- LOV
Target Object :- RESPONSIBILITY
Property Name :- Group Name
Value :- XXUPO_RESP_LIST_RESTRICTED_LOV
Now when I click Apply Now, I have the error FRM-41826: Cannot replace group; columns don't match LOV.
The argument in Seq 10 was obteined using the forms builder tool but it seems something is wrong with this personalization.
I would appreciate if somebody could identify what.
Thank you
BR
DV
|
|
|
|
| Re: FNDSCAUS LoV Personalization Error FRM-41826 [message #379250 is a reply to message #379187] |
Mon, 05 January 2009 12:21  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
I don't know anything about "form personalization", but here's why this error might have happened.
For example, when you first created a record group (which contains SELECT statement), there's certain number of columns you have selected. In order to use list of values, you have then created a List of Values, based it on previously created Record Group. Finally, you have set column mappings (which item value maps to which LoV column value).
So far, so good.
Then you have decided to change record group dynamically. OK, no problem - just make sure that "new" record group's SELECT statement contains the same columns as you have named them while creating List of Values form object.
In other words, old and new record group's SELECT statements, as well as List of Values should contain| Quote: |
RESPONSIBILITY_NAME,
APPLICATION_NAME,
DESCRIPTION,
RESPONSIBILITY_ID,
APPLICATION_ID
|
I hope that this makes sense.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
