Page 1 of 1
Attachments in SSHR as mandatory
Posted: Wed Sep 01, 2010 3:18 pm
by Alihsyed
Can we make attachments mandatory in SSHR e.g. for a seeded function like Qualifications etc. (If any employee does not attach any file then system should thorw an error) Any one has got the steps for setups. I think it will be done by personalization on OA framework Page.
Posted: Mon Sep 06, 2010 6:03 pm
by eng_ahmad_2007
Dear Alihsyed,
I also think it can be done through user hooks. Have you come at a solution yet?
Regards,
Ahmad Ghanem
Posted: Sun Sep 12, 2010 4:52 pm
by Alihsyed
Yes Ahmad i have done this through a user hook, i also got the following steps which will be helpful for this type of requirement
1. Extend the controller on that page
2. In this extended controller, create a VO dynamically to check if attachment exists against the invoice using an SQL similar to below
select 'x' from fnd_attached_documents where ENTITY_NAME ='INVOICE_OR_WHATEVER' and pk1_value='invoice_id_here'
3. Personalize the attachment region to ensure Auto-Commit is True
This will ensure that data is available in fnd_attached_documents as soon as user enters the attachment
4. Throw an error message exception when dynamic VO of step 2 does not return any record
Thanks,
Ali