In my previous post (which you can find here), I covered what it takes to store attachments submitted via self-service transactions. In that post, we covered that attachments submitted via "Education and Qualification" and "Other Professional Qualifications" self-service transactions will be stored on the Qualifications form.
However, unlike other windows, the Qualifications form does not come with attachments enabled out-of-the-box. To be able to enable attachments on Qualifications window, please follow these steps:
1) (Navigate to) Application Developer --> Attachments --> Document Entities
Use this form to define document entities for Qualifications.
Table: PER_QUALIFICATIONS
Entity ID: PER_QUALIFICATIONS
Entity Name: PER_QUALIFICATIONS
Prompt: QUALIFICATIONS
Application: Human Resources
2) (Navigate to) Application Developer --> Attachments --> Attachment Functions
Use this form to define attachment functions.
Type : Form
Name: PERWSQUA
User Name: Qualifications
Session Context Field: Leave Blank
Enabled: Yes
3) Open Button - Categories
Click on the ‘Categories’ button of ‘Attachment Functions’ form and select ‘Miscellaneous’ as the category. Close this sub-form.
4) Open Button - Blocks
Click on the ‘Blocks’ button of ‘Attachment Functions’ form:
However, unlike other windows, the Qualifications form does not come with attachments enabled out-of-the-box. To be able to enable attachments on Qualifications window, please follow these steps:
1) (Navigate to) Application Developer --> Attachments --> Document Entities
Use this form to define document entities for Qualifications.
Table: PER_QUALIFICATIONS
Entity ID: PER_QUALIFICATIONS
Entity Name: PER_QUALIFICATIONS
Prompt: QUALIFICATIONS
Application: Human Resources
2) (Navigate to) Application Developer --> Attachments --> Attachment Functions
Use this form to define attachment functions.
Type : Form
Name: PERWSQUA
User Name: Qualifications
Session Context Field: Leave Blank
Enabled: Yes
3) Open Button - Categories
Click on the ‘Categories’ button of ‘Attachment Functions’ form and select ‘Miscellaneous’ as the category. Close this sub-form.
4) Open Button - Blocks
Click on the ‘Blocks’ button of ‘Attachment Functions’ form:
Block Name: QUALIFICATIONS
Method: PERWSQUA
Secured By: Organization
All other columns: Leave Blank
5) Open Button - Entities
Click on the ‘Entities’ button of ’Blocks’ form:
Entity: PER_QUALIFICATIONS
Display Method: Main Entity
Include in Indicator: Checked
Indicator in View: Leave Blank
Priviledges: Query, Insert, Update, Delete: Always
Primary Key Fields: Key 1: QUALIFICATIONS.QUALIFICATION_ID
That should do it.
Good One Samir Sir!!
ReplyDeleteThank you sameer for sharing Information. I need to create attachments for the "previous employments" screen, but it is also not out of the box (The attachments icon is disabled). How could I get the "Table", "Entity Id","Method","Primary Key", etc... and all the required information needed to enable the functionality for the previous employment or any other functionality.
ReplyDeleteThank you
Hi Khalid,
DeleteI would advise you enlist the help of a technical consultant. Once they go through my original post, a technical consultant will be able to give you the details you are after.
Thanks,
Sameer
Thank you Sameer,
DeleteI used Help->Diagnostics->Item and was able to get the required information, then I followed your steps, and finally the attachments was enabled for the previous employment form.
Hi Khalid,
DeleteHave you enabled Attachment for the same function but from Self Service Page?! if yes, then how could you restrict Attachment Category to only the categories that you want?
Thanks,
Yaqoob
Yaqoob, I suspect that is going to be a OAF extension requiring technical input.
DeleteThank you Sameer,
DeleteWe thought the same.
Hi Sameer ,
ReplyDeleteKindly advice how to add new category in the attachment of Documents of records
Hi, have a look at this blog, which gives some more details around categories in attachment: http://www.centroid.com/blog/how-enable-attachments-oracle-e-business-suite-release-12
DeleteCheers!
thanks
ReplyDeleteHi Sameer,
ReplyDeleteCan you please let me know how to make attachment mandatory while employee updates his education qualification in employee self service. At present it is just moves on to next submit screen even if employee doesnt attach his certificate soft copy. user wants this attachment functionality to be mandatory.