Home » Developer & Programmer » Forms » FNDSCAUS LoV Personalization Error FRM-41826
FNDSCAUS LoV Personalization Error FRM-41826 [message #379187] Mon, 05 January 2009 05:24 Go to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 20895
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.
Re: FNDSCAUS LoV Personalization Error FRM-41826 [message #379573 is a reply to message #379250] Wed, 07 January 2009 02:08 Go to previous messageGo to next message
daniloviz
Messages: 6
Registered: August 2008
Junior Member
Thank you for your reply.
I was suspecting the same.
Now the problem is... how can I get the right list of attributes to be specified in the SELECT statement?

Thank you
BR
DV
Re: FNDSCAUS LoV Personalization Error FRM-41826 [message #379577 is a reply to message #379573] Wed, 07 January 2009 02:17 Go to previous message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Find this List of Values in the Object Navigator; open its Property Palette and check Column Mappings.
Previous Topic: Upload Data from flat File
Next Topic: Popup Menu with Push Button
Goto Forum:
  


Current Time: Mon Dec 05 19:01:23 CST 2016

Total time taken to generate the page: 0.10713 seconds