Who's Online
2 registered (spiro, CT), 2 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Recent Posts
Heres a simple question on Workflow then ..
by natkins
Today at 09:53 AM
Defaulting PO Information on assignment screen
by SBi
Yesterday at 02:24 PM
E-Bus Configuration and Management
by PeterP
Yesterday at 01:28 PM
UMX : Oracle User Management Application
by natkins
Yesterday at 12:58 PM
HRMS organization structures
by Geoff_Dixon
Yesterday at 11:53 AM
HR_PF.K RUP4
by bcooper
10/03/10 06:50 PM
Pay_Action_Parameter
s

by John Akinyode
09/03/10 11:05 AM
Error ORA-01002: fetch out of sequence
by delboy
03/03/10 04:46 PM
Multiple html sessions opening
by MarinaH
03/03/10 12:16 AM
Tories to revamp PAYE system
by Geoff_Dixon
26/02/10 01:48 PM
Top Posters (30 Days)
CT 20
delboy 19
natkins 15
bcooper 14
MarinaH 14
SBi 10
gaztorres 8
Geoff_Dixon 7
Gus 4
Simon_Mc 3
(Views)Popular Topics
Family Pack K issues thread 5181
Review of my Release 12 laptop 3118
CREATE_GRADE api returns:PLS-00306: wrong number o 3089
Log-on problems for existing users 3003
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 2348
October UK-OUG? 1967
Viewing Output of another user 1912
uploading bank branches to PAYROLL 1861
Still trying to locate... 1842
Family Pack K 1824
Topic Options
Rate This Topic
#5121 - 03/02/10 10:34 AM Forms Personalization on functions
bcooper Offline
veteran
*****

Registered: 11/03/05
Posts: 886
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 Online   content
veteran
*****

Registered: 11/03/05
Posts: 751
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: 886
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
421 Members
48 Forums
1123 Topics
5227 Posts

Max Online: 15 @ 20/10/09 02:30 PM
Today's Birthdays
No Birthdays
Recent vacancies
Developer - Permanent - based in Bracknell
by Geoff_Dixon
Yesterday at 11:59 AM
Top Posters
bcooper 886
CT 751
Geoff_Dixon 340
delboy 255
SBi 249
vkumar 223
kp_rapolu 200
cbrookes 197
Gavin Harris 101
jhatten 95