Enabling Attachments in Oracle Forms
By Manoj Madhusoodanan-Oracle on Jun 04, 2014
In this blog I will demonstrate how we can enable attachments in Oracle Form. The user ask is to capture a job description which will be a
long text. Oracle Apps has a feature called attachments, through some easy setup we can enable attachments in forms. We will be going to address
customer ask through this feature.
Step 1 : Identify Form Name
First thing you have to do is to identify the form to enable attachment. In this scenario form will be PERWSDJT ( Job form in HRMS ).
Step 2 : Identify Document Entity exists or not. If exists then do nothing otherwise create new.
Step 3 : Create Document Categories.
Here I will create a category Job Description with Default Data Type Long Text and Application Human Resources.Once
it is done I will assign this to Create Job form.
Step: 3 Query Attachment Functions for PERWSDJT. Click on Categories and add Job Description.Make sure enabled check box is checked.
Step 4 : Turn off HR:Use Standard Attachments profile option.
Go to Work Structures > Job > Description