Wednesday, August 21, 2013

(M)obile responsibilities

When users were assigned responsibilities and they did not show up in the Navigator or "pick list" within the Financials application, it was a strange phenomenon which took some investigating to figure out.  We have had some experience with several tables getting out of sync with what the assigned responsibility tables show, but a quick glance at these problem tables told us that we were okay from that aspect so I was quickly running out of ideas.  I even went to the end users to make sure the responsibility wasn't showing up, and sure enough it wasn't there.  I mentioned this to a co-worker to bounce ideas off of and he reminded me that we had some problems a year or two back with a report or responsibility not showing the right information because they had some table level details mixed up.  Thinking it was worth a shot, I then looked at the FND_RESPONSIBILITY_VL table for the problem child in question and was puzzled by the fact that in the VERSION column there was an 'M'.

Versions for most things are numbers and when I compared it against other responsibilities they had the number '4' listed, so I looked at the form and couldn't see anything out of the ordinary.  Back to the table to run a query looking for other items marked with an M and I found several other responsibilities listed with almost all of them having "Field" or "Mobile" in the name of the responsibility, which did not seem to make sense because this responsibility wasn't part of some Field or Mobile installation of Oracle Apps.  Well back to the form I go and there is the answer staring me straight in the face this time: there is an option to pick what responsibilities are "Available From."  At some point an individual accidentally picked Oracle Mobile Applications when they were trying to make another change (likely a menu change since this is right above the Menu entry field) and didn't notice the radio box selection change when they miss-clicked so they saved this bad change with the changes they were planning on making.  After changing the radio box selection back to Oracle Applications, life was good as the users could once again access the responsibility.

No comments:

Post a Comment