Who's Online
0 registered (), 1 Guest and 0 Spiders online.
Key: Admin, Global Mod, Mod
Recent Posts
Irecruitment
by spiro
18/03/10 03:21 PM
Appraisal Session Timeout
by spiro
17/03/10 07:48 PM
Heres a simple question on Workflow then ..
by bcooper
17/03/10 09:54 AM
Defaulting PO Information on assignment screen
by bcooper
17/03/10 09:52 AM
Creating an Attachment Table or Attachment Link
by Sahir
16/03/10 02:35 PM
OLM - Custom Role based on the 'Data Security'
by Geoff_Dixon
15/03/10 03:28 PM
E-Bus Configuration and Management
by PeterP
11/03/10 01:28 PM
UMX : Oracle User Management Application
by natkins
11/03/10 12:58 PM
HRMS organization structures
by Geoff_Dixon
11/03/10 11:53 AM
HR_PF.K RUP4
by bcooper
10/03/10 06:50 PM
Top Posters (30 Days)
CT 19
bcooper 18
natkins 16
delboy 16
MarinaH 12
SBi 10
gaztorres 8
Geoff_Dixon 8
kp_rapolu 4
Gus 4
(Views)Popular Topics
Family Pack K issues thread 5207
Review of my Release 12 laptop 3134
CREATE_GRADE api returns:PLS-00306: wrong number o 3123
Log-on problems for existing users 3014
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 2392
October UK-OUG? 1998
Viewing Output of another user 1924
uploading bank branches to PAYROLL 1877
Still trying to locate... 1855
Family Pack K 1841
Topic Options
Rate This Topic
#5121 - 03/02/10 10:34 AM Forms Personalization on functions
bcooper Offline
veteran
*****

Registered: 11/03/05
Posts: 890
Loc: Earth, Europe, England, here
Hello

I need to create a view-only version of a form, and then personalize out some of the fields.
I can create a new Function for this form in the Define Functions screen and then use the QUERY_ONLY="YES" to make it view only.
EG Existing form is called MYFORM1
My new function is called MYFORM1_VO (for view only).

I add this to my menu and it all seems hunky-dory.

However, when in this new version of the form i call up the personalization form, the function name at the top of the screen is the original form function (MYFORM1), not my new ready only version (MYFORM1_VO).
This means i cannot attach personalizations just to the function.

Is there a bug with this, or is there some devious configuration step that i have missed?

Curiously, i added some function level personalizations whilst in this screen and saved them.
When i go back into my view-only screen the personalizations do not fire, but when i go into the standard screen they do - proving that they are only attached to the original function.
As a further experimental step, i extracted the personalizations using FNDLOAD, edited the LDT file to change all references of function MYFORM1 to MYFORM1_VO and then uploaded them back in.
After this, the personalizations worked on my custom form but not the standard, but it still would not show them to me in the personalization screen!

Help!
_________________________
I'm blogging again - albeit sporadically
Also my random musings courtesy of Twitter

Top
#5122 - 03/02/10 10:51 AM Re: Forms Personalization on functions [Re: bcooper]
CT Offline
veteran
*****

Registered: 11/03/05
Posts: 752
Loc: Back at Fort Apache, Gosport!
Did the ldt upload work?

I ask because I have very recently been a victim of FNDLOAD's tendancy to withhold errors/warnings unless explicitly instructed to report them.

I found myself doing, for a concurrent program upload:

FNDLOAD <do-be-do-be-do> DETAIL_LOG=TRUE

wherupon some interesting issues were revealed, involving last_update_date comparisons of some things which were not expected to fail, but did! As an aside, this was fixed in the short term by adding the command line argument CUSTOM_MODE=FORCE (as recommended by Oracle Support)
_________________________
L&K
CT

Top
#5125 - 03/02/10 12:20 PM Re: Forms Personalization on functions [Re: CT]
bcooper Offline
veteran
*****

Registered: 11/03/05
Posts: 890
Loc: Earth, Europe, England, here
The FNDLOAD is not the issue (which worked perfectly fine thank you for asking).
I did the FNDLOAD upload to test that you could hold personalizations at custom-function level - which you can.

Its just i cannot get the personalization form to show me the correct function name.

As a PS to the FNDLOAD (and not wanting to send this thread down another alley) i find the combination of UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE to do the trick in any situation
_________________________
I'm blogging again - albeit sporadically
Also my random musings courtesy of Twitter

Top


Moderator:  Administrator, Geoff_Dixon 
March
Su M Tu W Th F Sa
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31
Forum Stats
422 Members
48 Forums
1129 Topics
5248 Posts

Max Online: 15 @ 20/10/09 02:30 PM
Today's Birthdays
No Birthdays
Recent vacancies
Oracle HRMS Consultants needed! Perm £70k!
by Shaylan
18/03/10 11:33 AM
Developer - Permanent - based in Bracknell
by Geoff_Dixon
11/03/10 11:59 AM
Perm Positions 1 x HR and 1 x Payroll
by bfrost
10/03/10 05:35 PM
Top Posters
bcooper 890
CT 752
Geoff_Dixon 343
delboy 255
SBi 249
vkumar 223
kp_rapolu 203
cbrookes 197
Gavin Harris 101
jhatten 95