For quite some time I was thinking about publishing an article about forms personalization in Oracle HRMS.
The Metalink note on Forms Personalization is helpful, but what it lacks is a pictorial approach to implementing
Forms Personalizations. I am a visual animal, so I like to explain in that manner too.
My first article in the series of Forms Personalization is in response to a question raised in Oracle Forum under Oracle Human Resources (HRMS ). As per the Oracle forum request, If the Person Type is Employee, their clients wants Person Title field to become Mandatory ( lets assume it is the title field for now). When the Person Type field changes to a value that is anything but Employee, the person title field should then toggle back to become optional.
Please note that when Person type Employee is selected, value in field
PERSON.D_PTU_USER_PERSON_TYPE is assigned a value of “Employee”
Now the requirement is that for “Employee” field PERSON.D_TITLE must be made mandatory.
There are two possible ways the Person Type can change.
Either by picking a dropdown list of Action (e.g. Create Employee) or by directly picking up a value from LOV on field “Person Type for Action”. Whenever the person type changes, WHEN-NEW-ITEM-INSTANCE is fired for one for the below fields(depending upon how its changed). Hence forms personalization must check conditions for below three fields
PERWSHRG.PERSON.PTU_ACTION_TYPE
PERWSHRG.PERSON.D_PTU_USER_PERSON_TYPE
PERWSHRG.PERSON.SHOW_NUMBER
The demo below contains conditional check on “WHEN-NEW-ITEM-INSTANCE” of PERSON.PTU_ACTION_TYPE
When implementing this, you will have to replicate the steps in the demo for WNII on both PERWSHRG.PERSON.D_PTU_USER_PERSON_TYPE & PERWSHRG.PERSON.SHOW_NUMBER
I have tested the steps below myself, and they appear to work.
OK, here we go.....
STEP 1
Create Personalization as below( to make Title field mandatory)
Sequence: 50
Description: Make Person Title Mandatory when Person Type is Employee.
Trigger Event: WHEN-NEW-ITEM-INSTANCE
Trigger Object: PERSON.PTU_ACTION_TYPE
Condition: ${item.person.d_ptu_user_person_type.value} = 'Employee
Check if Person Type is Employee in When New Item Instance
Action Sequence: 10
Action Type: Property
Action Object Type: Item
Action Target Object: PERSON.D_TITLE
Action Property Name: REQUIRED
Action Value: TRUE
Make Title mandatory when Person Type is Employee
STEP 2
Create another Personalization as below ( to make Title field Optional)
Sequence: 51
Description: Make Person Title Mandatory when Person Type is Employee.
Trigger Event: WHEN-NEW-ITEM-INSTANCE
Trigger Object: PERSON.PTU_ACTION_TYPE
Condition: NVL(${item.person.d_ptu_user_person_type.value},'xxyyzz') != 'Employee'
Check if Person Type is anything other than Employee in When New Item Instance
Action Sequence: 10
Action Type: Property
Action Object Type: Item
Action Target Object: PERSON.D_TITLE
Action Property Name: REQUIRED
Action Value: FALSE
Make Title option when Person Type is not Employee
Comments
In valid Character can be caused due to various reasons. Please email me the screenshot.
You can also trace the Forms session, and see the last executed SQL when eorror occured.
How ever, this error may not always occur from SQL, this can also be raised if you assign character value to a Numeric form field.
Thank s,
Anil Passi
In valid Character can be caused due to various reasons. Please email me the screenshot.
You can also trace the Forms session, and see the last executed SQL when eorror occured.
How ever, this error may not always occur from SQL, this can also be raised if you assign character value to a Numeric form field.
Thank s,
Anil Passi
You can have this segment in context sensitive for this responsibility by following guidelines in this link below.
http://www.google.com/search?q=site:apps2fusion.com+smart-descriptive-flexfields
for the responsibility specific context, you can attach a table type value set which reads the values of that column itself from the same table. Hence, although user will be able to edit the Flexfield BUT value set will enforce the selection of current value within the field itself. You valueset will look like select attribute1 from tablenameofDFF where rowid=:block.ro w_id
thanks
ani l passi
I started seeing this from 11.5.10
So, 11.5.10 it is !
Thanks
An il
CUSTOM.p ll and FP can both be disabled for a session by turning Custom Code off, from Help Menu.
I do not think that applies to you though.
Plea se close the form and re-open after clicking on APPLY.
I have tried this on Lookup screen, and data is indeed getting saved from WVR trigger
Than ks
Anil
You are doing an awesome job.
Didnt know where exactly to post my question, hence posting it in this section as it seems to be more relevant.
I need to display a message whenever a record is fetched on the People Form in HR. For this purpose, I have configured the "Maintain Pop Up Messages" form (in UK Super HRMS Menu) as below:
Function: Authenticate the person
Block : Person Region
Event : When Record fetched
Message : A user defined message, which was configured in the application dev responsibility.
Formula : I have not used any Formula. The message should display without any further criteria
After configuring the form this way, I expect the Message to throw up when I navigate to the People Form. But it wouldnt happen. Could you please let me know the reason for the same? Are there any profile options which need to be enabled for this purpose?
Pleas e advise.
Thank you,
Sashi.
I am working in oracle HRMS as technical person, I want to Know about the Forms Personalization in Oracle HRMS, Sir Can you send me any documents in Forms Personalization in Oracle HRMS. I am very much thankful to you.
i am currently customizing the HR Employee Self service module(leave of absence screen).
apps version 11.5.10.2
the user puts in a leave application(EG Annual leave). once it gets approved by supervisor
the user can view the details through Navigation Path: HR employee self service -> Leave of Absence->
view ->current and planned absence.
there is a delete button available in the screen. i need to customise it in a way that whenever user
deletes an approved leave the supervisor should be notified via an email. how to achieve
this. Any pointers will be highly appreciated
Tha nks Anil
regards
k umar
Can you provide me information regarding Integration of Punch card timming details and absentees details,leave details with Oracle HRMS module. What modules are requuired inorder to integrate. what are the field which can be Integrated like Name, Timmings,etc
Wh at are the features in Oracle Apps HRMS module. Does any other module other than core HRMS required inorder to integrate.is OTL module required for this. Can i have any doc or ppt on this maodule regarding the features init. If any ppt describing the features which benifit or represent the module details.
Thank s
Anita
I tried out the example that you have written above.
The only issue I faced was that I too was getting ORA-00911 error for the conditions.
I changed the condition to :person.d_ptu_p erson_type = 'Employee' instead of the $item and it worked. Just an FYI.
Secondly I have a WIP form which does not save but instead has a 'Continue' button to perform job completion. I want to validate the value of a job and prevent user from Continuing. Now since I dont have Save I cannot use WVR. I will have to rely on WNI on the subsequent items, but that would be unreliable if the user navigates through mouse.
Can I use WVI or some other trigger?
Thanks
Runa
I have read your few materials, they are really very useful and easy too.
I would like to build a new form, I have not developed any forms before, It would be great if you could send me some documents or materials or interactive assignment which explains the steps in creating the form
Thanks
Blanket Purchase Agreements
Blan ket Releases (should default from the BPA)
Standard PO
*HOW CAN WE DO THIS TASK..
CAN U EXPLAIN ME BRIEFLY VTH NAVIGATION AND THE SCREEN SHOTS
PANDU..
I am trying to hide text fields in from PERWSHRG through from personalization , but getting these errors.
Frm-410 34-A call to SET_ITEM_PROPER TY attempted to set the Navigable attribute of a non-displayed item.
Frm-4101 7-Application design error. A SET_ITEM packaged procedure tried to turn on the Update Allowed property of a non-enterable item.
Frm-4131 6-Cannot set DISPLAYED attribute of the current item".
Can u guide me why these errors are coming, one more thing, one of the text items, I want to hide is the first item in the tab page.
Thanks and Regards,
Roshan
Thanks a lot.
Need your help.
We have a requirement of limiting the date track functionality (say sysdate-30) days for few responsibilitie s, and with the super user responsibility, the user can date track to ANY previous date. We have SSHR(Self Service HR), and I was not sure as to how tp proceed on this one(If it is from CORE HRMS, we could do it throught custom/pll, but I was not sure of changing anything on OAF).
Any help please.
Thanks In Advance,
Vamsi.
I have done personalization in payroll field and made payroll field mandatory.till now it is working fine ,now there are two problems :
1:after applying personalization ,when ever i m opening assignment form one msg pops up and says that : [FRM-40202:Fiel d must be entered].i dont want this msg to come .how to do that.
2: In some responsibility above mentioned problem is nt coming but I am able to close assignment form without entering payroll field,as payroll field is mandatory here .
please suggust me the solutions.
Rgar ds
saurabh
This happens because you might be changing the value of a database based field.
You will need to change the logic via FP, such that DB based fields are changed only under certain conditions.
Th ese conditions can be entered in Condition field of Condition Tab
Thanks
Ani l
When it comes to creating a new record the default value is displayed but as soon as tab into the field , the default value disapears immediatly, which shouldnt be the case. I want the default value to show, but be updatable if required. Could someone please please please share some light on this.!!!
I have to conceal certains fields on Sales order form. But this data should be visible to couple of users. I have a value set for these users. I'm not sure if I can use where user not exists in this value set using forms personlization. Can you please help me. Thanks a lot in advance.
- Swetha
I have done one personalization in Receipt form but when iam clicking the FIND button its saying that FRM-40202: Field must be entered.There are fields are mandatory.I understand that if iam changing those field programatically so its giving error.So,how to change condition in COndition tab.Because i have already having some condition.
pls suggest me.
Regards,
T ony
I would like to know how to limit LOV when I create a new job title.
our HR people want to create new job title intead of asking us to create each time.
I enabled HR to create new title.
But I would like to restrict to only one LOV XX_JOB_TITLE when system administratoor> application> values
check box value set and search for XX_JOB_TITLE and find.... Now they can create new title.
When the search for XX_JOB_TITLE, the should be only see this one in LOV instead of all others.
Please advise how to do this.
Thanks.
Srini
I have a requirement.
1) First part is to mask the first 5 digits of the SSN field on the people screen. Example : If SSN retrieved is 123-45-6789 then the SSN displayed should be ***-**-6789.
2) Second part of the same requirement is : If a change is required to the SSN value then it should be allowed and the user should now enter the SSN twice like the way it is done on the password field on the User creation screen. Example : User enters the SSN and he sees only ***-**-1234 on entry and then on exiting from the field he is prompted to enter it again and again he sees only ***-**-1234. If the 2 entries match then the entry is considered valid and the record is saved.
Any idea how to get this done on the People screen using Personalization or any other method ?
-DD
i am trying to use the Effective start date in the personalization
for example
i want to change window title as follow statement and worked
= (
select tt.h_date||' ' from kfu_hijra tt
where to_date(g_date, 'dd/mm/rrrr') = to_date(sysdate ,'dd/mm/rrrr')
)
my question is how to change SYSDATE to use session date.
thanks in advanced
regards
In the Enter and Maintain CWK form, I need to add a condition NOT to diplay person_type ='Contact'. Can you please let me know how this could be done.
Thanks
L eonard
In requisition and vacancy form, i got a requirement to change Name field to Requisition number and to generate it automatically. Req. No should get generated sequentially.
Thanks in Advance
I have one form which name was ICQTYED this form doen't containt .pll file. So I want create a separate .pll file on form based when I try to create a new .pll from it will create like LID_148 which does not create own my custom name.
Please let me how to create .pll file on form based for particular form.
im ahmed
i have problem that i have 2 person types A , B the 2 person types on one System Type S
the proble that i want to change person Employee Person Type from A to B
but i didn't find B person type in Person type usage screen so i can't change the person type
Even if i follow the same approach I can able to save the form without entering anything to title field.Please help me out.
Can anyone help me regarding the issue that why trigger fires twice?Is there any way that it fires only once.I'm doing AR form transaction.
F unction Name:AR_ARXTWMA I_HEADER
Form Name : ARXTWMAI
Trigg er Event: WHEN-NEW-ITEM-I NSTANCE
Trigger object :TACC_ACC_ASSGN .COMMENTS
condi tion : 1=1
ACTIONS
Se q :10
Type :Message
Langua ge :All
Message type : show
Message Text : Text Message
My question is why it pops the message type.
our requirement is to pop up the message only once.
Thanks & Regards,
Neha
Need help For DFF level form personalization.
Currently DFF sttribute is not required .
i want to make in Required conditionally depending on other value from form .
Ex > Misc. transactions Form if TRANSACTION_TYP E='Issue to Contractor - Chargeable' then i want to make DFF Required .
I tried Form Personalization but it haven't worked .
Any Idea about Form CustuM
Dear DD,
Did you get the answer?
in fact enjoying by these.
так держать! Я сделаю закладку на ваш веб-сайт, чтобы вернуться в будущем.
Большое спасибо
Does managing a well-establishe d blog like yours take a massive amount work?
I'm brand new to blogging however I do write in my diary on a daily basis.
I'd like to start a blog so I will be able to share my personal experience and views online.
Please let me know if you have any kind of suggestions or tips for brand new aspiring bloggers.
Appreciate it!
I'm looking to start my own blog soon but I'm having a hard time choosing between BlogEngine/Word press/B2evoluti on and Drupal.
The reason I ask is because your design seems different then most blogs and I'm looking for something unique.
P.S My apologies for being off-topic but I had to ask!
with it!
Is anyone else having this issue or is it a
issue on my end? I'll check back later and see if the problem still exists.
subscription link or newsletter service. Do you have any?
Kindly let me know so that I may subscribe.
Thanks.
code with HTML. I'm starting a blog soon but have no coding experience so I wanted to get advice
from someone with experience. Any help would be greatly appreciated!
it helped me out a lot. I hope to give something back and help others like you aided me.
I have always disliked the idea because of the costs.
But he's tryiong none the less. I've been using WordPress on a
variety of websites for about a year and am anxious about switching to another platform.
I have heard good things about blogengine.net. Is there a
way I can import all my wordpress content into it? Any kind of help would be really appreciated!
Your web site provided us with valuable info to work on. You
have done an impressive job and our whole community will be grateful to you.
on your page at proper place and other person will also do similar
for you.
out a lot. I hope to give something back and aid others like you aided me.
What may you suggest about your put up that you just made a few days ago?
Any certain?
fully explained, keep it up all the time.
Here is my blog slot: http://set.ua/bitrix/rk.php?goto=https://www.insert-bookmark.win/8-videos-about-joker215-that-ll-make-you-cry
comments are added- checkbox and from now on every time a
comment is added I get 4 emails with the exact same comment.
Is there a means you are able to remove me from that service?
Thanks a lot!
My site slot: https://www.nav-bookmarks.win/is-tech-making-joker123-slot-better-or-worse
I'll bookmark your blog and test once more right here regularly.
I am quite certain I'll be told many new stuff proper here!
Best of luck for the next!
Stop by my page ... judi casino: https://www.argfx1.com/user/msj2153738538dz
Also visit my web-site - judi casino
online: http://talaja.rackons.com/user/profile/341777
You know so much its almost tough to argue with you (not that I actually would want to...HaHa).
You certainly put a new spin on a topic that has
been discussed for ages. Wonderful stuff, just great!
my web-site :: situs casino: https://original-films.com/user/msj2158382223ec
Does operating a well-establishe d website such as yours require a lot of work?
I am completely new to blogging but I do write in my journal on a daily basis.
I'd like to start a blog so I can share my personal experience and thoughts online.
Please let me know if you have any kind of suggestions or tips for new aspiring blog owners.
Thankyou!
Review my page :: joker215: https://www.nav-bookmarks.win/how-to-outsmart-your-peers-on-slot-joker123-deposit-pulsa
I think that you could do with some pics to drive the message home a bit,
but instead of that, this is excellent blog. A great read.
I will definitely be back.
Also visit my web site situs poker terbaru: http://clicgo.ru/user/tmpbnprofilesergey5312961jq
would like to find out about this topic. You realize so much its almost tough to argue with you (not that I really will need
to?HaHa). You definitely put a new spin on a topic that has been written about for years.
Great stuff, just wonderful!
Here is my webpage: judi domino: http://member.8090.com/exit.php?url=https://communities.bentley.com/members/ea8109f5_2d00_7a38_2d00_459b_2d00_a758_2d00_c4e6ef4da0ed
My blog post ... joker215: http://mylekis.wip.lt/redirect.php?url=https://independent.academia.edu/ReneaShofner22
are you using? Can I get your affiliate link to your host?
I wish my website loaded up as fast as yours lol
Also visit my web site; domino: https://golocalclassified.com/user/profile/560894
I mean, Yes, it was my choice to read through, however
I genuinely thought you'd have something
helpful to say. All I hear is a bunch of complaining about something you could possibly fix
if you were not too busy searching for attention.
my web-site - situs poker: https://setiweb.ssl.berkeley.edu/beta/show_user.php?userid=9302452
from. Many thanks for posting when you've got the opportunity,
Guess I will just bookmark this web site.
My web blog :: slot joker123: https://forums.talktaiwan.org/smf/index.php?action=profile;area=forumprofile;u=760621
be shared around the web. Disgrace on Google for now
not positioning this submit higher! Come on over and
talk over with my site . Thank you =)
Also visit my page; agen slot online: http://www.rohitab.com/discuss/user/280092-dmj2157949264hk/
Thanks for posting when you've got the opportunity,
Guess I'll just book mark this site.
My web blog judi slot online: http://netsport.ge/user/dmj2156616266di
about that.
Here is my website; slot demo indonesia: https://www.icon.edu.mx/profile/slot-demo-indonesia-gratis-pragmatic-play-anti-bungsrud/profile
Anyway I will be subscribing to your feeds and even I success
you get entry to constantly quickly.
Feel free to visit my blog post - bonanza88 royal: https://www.jameypricephoto.com/profile/bonanza88-royal-link-login-slot-anti-bungsrud/profile
publish is just cool and i could think you are a professional in this
subject. Fine together with your permission let me to grab your RSS feed to stay updated with approaching post.
Thanks one million and please keep up the gratifying work.
Also visit my web-site: game slot online: https://www.icon.edu.mx/profile/game-slot-online-deposit-pulsa-tanpa-potongan-anti-bungsrud/profile
a little research on that. And he actually bought me lunch because
I found it for him smile Therefore let me rephrase that: Thank you for lunch!
Here is my web-site: antikbet: https://capitalkhabar.in/index.php/news/ck-news/8831-sc-ends-centuries-old-ban-on-entry-of-women-of-menstruating-age-into-sabarimala-temple
Here is my site antik bet: http://pesticidov.net/ru/chem/bayer-kropsaens/3808-luna-ekspiriens-400/
is time to be happy. I've read this post and if I could I wish
to suggest you some interesting things or suggestions.
Maybe you can write next articles referring to
this article. I desire to read even more things about it!
Review my blog post; antik bet: http://ajts.ae/2016/09/06/quality-training/
it up what I submitted and say, I'm thoroughly enjoying your blog.
I as well am an aspiring blog writer but I'm still new to everything.
Do you have any helpful hints for beginner blog writers? I'd definitely
appreciate it.
I love all of the points you've made.
information you present. It's great to come across a blog every once in a while that isn't the same old rehashed material.
Great read! I've bookmarked your site and I'm adding your RSS feeds to my Google account.
RSS feed for comments to this post