Friday 12 July 2013

How to enable attachments on Qualifications Form

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




11 comments:

  1. Thank 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.
    Thank you

    ReplyDelete
    Replies
    1. Hi Khalid,
      I 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

      Delete
    2. Thank you Sameer,
      I 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.

      Delete
    3. Hi Khalid,
      Have 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

      Delete
    4. Yaqoob, I suspect that is going to be a OAF extension requiring technical input.

      Delete
    5. Thank you Sameer,
      We thought the same.

      Delete
  2. Hi Sameer ,
    Kindly advice how to add new category in the attachment of Documents of records

    ReplyDelete
    Replies
    1. 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

      Cheers!

      Delete
  3. Hi Sameer,
    Can 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.

    ReplyDelete