Attachments in SSHR as mandatory

[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.

[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

[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