Hi guys,

First post on here! I work with Corbon262, and he recommended you guys as being very helpful!

I am currently investigating an issue with a form designed in 'Forms Configurator'. The form is used for a remote team to simply update a 'user id' field in a Descriptive Flexfield on the Person Form, and save it.

Unfortunately the form broke as part of a new multi org setup that was created, and im struggling to get it working again! I would really appreciate a fresh pair of eyes (or more!) on it as its driven me to insanity!

I think the best way of explaining it, is by showing you pictures aswell as text. Forgive me for blanking out the names and stuff, as my audit team will go nuts otherwise!

Right first things first, this is the error i'm getting. Simply update the 'User ID' field, and save:


Click here for full size pic!

And if you 'Ok' that, you get a message at the bottom:


Click here for full size pic!

FRM-40105: Unable to resolve reference to item $PROFILES$.PER_BUSINESS_GROUP_ID

Now heres a look at the setup of the item in question on the form, and the function registration:


Click here for full size pic!


Click here for full size pic!

Now at this point, its worth noting that if i disable the 'User ID' field which is causing the error, i can update another field on the form (non DFF field!) and it saves fine. So its directly linked to updating the item in the DFF.

Now to explain the setup of the DFF. There are 2 'organisations' using the instance, and the DFF is setup with different fields for each, using the Business Group ID as a context. See below:


Click here for full size pic!


Click here for full size pic!

As you can see above, the middle entry is the context we are using, this looks at the business group id of the profile options (set at responsibility level) - $PROFILES$.PER_BUSINESS_GROUP_ID. Then when you look at the segments, you can see its got no validation on it, its just a 6 character field. There are contexts setup for the 2 different organisations we are using, and a global one. The field we are trying to update is in the middle context.

Now, im pretty sure the error is in relation to the context on the field in the form setup (it has none!). So if i add a context to the item, for the 'correct' context setup, as per below:


Click here for full size pic!


Click here for full size pic!

I still get the same error:


Click here for full size pic!

I have absolutely no idea what to do next? Can anyone help/advise/point me in the right direction?

Much appreciated!

Gary

Hello Gary, and a warm welcome to the forum.

I am not entirely sure why this problem is occurring, but I was wondering what would the effect be of you changing the context value of the descriptive flexfield from '$PROFILES$.PER_BUSINESS_GROUP_ID' to just 'BUSINESS_GROUP_ID' - ie inherit the value from the form/block directly rather than via a system profile option value.

Disclaimer: I am not a funky so it is possible I am talking garbage (again)

Thanks CT, much appreciated!



My problem with this, is it has been setup as it is as part of the design principles for our true multi-org setup (2 seperate local gov. authorities). I'm reluctant to 'tinker' as it will no doubt break it somewhere else!

I'm really struggling to get to the bottom of this! If you set the context to 'BUSINESS_GROUP_ID' without the '$PROFILES$.' on it, where does it then get the ID from if not the profile option (at resp level in this case)?



Any help is better than no help, its really appreciated :-)

Cheers,
Gary

My thinking was around the possibility of there being an issue with Forms Configurator and system profile options. In theory, the business_group_id, being a column on the person table, also exists as a field on the form, which might well be pre-loaded with the system profile option as part of some new-form-instance thing (I will apologise now for sounding like I know what I am talking about where Oracle Forms is concerned!)

The other thing worth checking is, how does that system profile option value work out for your user/responsibility, i.e. is it set to the correct BG? Are you able, for example, to see the descriptive flexfield segments when viewed through the normal person/assignment form?

One thing i have just tried, is i went into the form where i get the error.

I went to help -> diagnostics -> examine.

And under $PROFILES$ -> Business_Group_ID it returns the correct value, i.e 0. So the session recognises the value from the profile option. Starting to wonder if its a bug i'm experiencing?

Ooo, interesting... (I need to get out more, I know)

That'll be the Setup Business group you're using then? For some reason as yet unknown, I am experiencing a certain nervousness about that. Is it possible to assign your user/responsibility to the other (non-zero) BG, and try again?

I never really picked up on that fact it was the setup business group.

I just tested it on the other business group (8052) with an item from that DFF context, and all the profile options switched over etc (what a mission!).

I get exactly the same error, but for that DFF attribute now.

OK that's ruled that out then!

Only thing I can suggest at this stage is to apply a trace to the session that's running the form. I suspect that the Support boys will ask for one anyway

Right! Long time no post!

I've resurrected this, and finally raised it with our provider (it might goto Oracle! )

I tried a few more tricks with security etc and function security with no luck, so i'll keep you posted with the outcome!

Feel a bit annoyed that i've given up on it, but thats how it goes i guess!

Gary :-)

I think that's question number 3 in their list of standard replies to any SR raised

We try to pre-empt as much of this kind of stalling as possible by gathering everything up proir to raising an SR with Oracle (traces, screen-dumps, PIS-script output etc).