Oracle Attachments

About Attachments:

Attachment feature enables users to link files like images, word files, emails, e.t.c to a particular form/function/record. Once you link a file to a form in oracle it will be saved on your server so that you can retrieve it easily whenever you want it.

Supported Formats:

You can link the following types.

• File (word, pdf, excel, images)
  
• Short Text (Notes)
  
• Long Text (emails and long descriptions)
  
• Webpage (intranet or internet pages)
  

Related Tables:

• FND_ATTACHED_DOCS_FORM_VL
  
• FND_ATTACHED_DOCUMENTS
  
• FND_ATTACHMENT_BLK_ENTITIES
  
• FND_ATTACHMENT_BLOCKS
  
• FND_ATTACHMENT_FUNCTIONS
  
• FND_ATTACHMENT_REPLICATION
  
• FND_DM_FOLDERATTACHMENTEXT
  

Enable Attachments

It can be better explained using an example so follow the below example to enable the attachment link in Payments Bank Screen from Account Payables

• Collect the information of the form where you want to enable attachments
  
• Define Entities
  
• Define Categories or use Miscellaneous category provided by oracle
  
• Define Attachment Functions
  
• Using Attachments
  

Form Information

Navigation: Payables Manager > Setup > Payments Banks

Short Name: APXSUMBA

Form Name: Set Up Bank Information

Block Name: BRANCHES

Primary Key: BANK_BRANCH_ID

Table Name: AP_BANK_BRANCHES

Define Entities:

Navigation: Application Developer > Responsibility > Attachments > Document Entities



Create the new record

Table: AP_BANK_BRANCHES

Entity ID: AP_BANK_BRANCHES

Entity Name: AP_BANK_BRANCHES

Prompt: Banks

Application: Payables



Close the form.

Navigation: Application Developer > Attachments > Attachment Functions



Enter the following

Type: Form

Name: APXSUMBA

User Name: Set Up Bank Information

Session Context Field:

Enabled: Check



Save.

Click on Categories and assign Miscellaneous



Save.

Close Categories Form.



Click on Blocks

Block Name: BRANCHES

Method: Allow Change

Secured By: None

Context 1: BRANCHES.BANK_NAME

Context 2: BRANCHES.BANK_BRANCH_ID



Save Now.

Click Entities

Entity: AP_BANK_BRANCHES

Display Method: Main Entity

Privileges: Always

Primary Key Fields: BRANCHES.BANK_BRANCH_ID

Save and Close.

Use Attachments:

Navigation: Payable Manager >> Setup >> Banks



Click to open



Now Query any record. If you click on attachments now it will ask you to query any record. This is because attachments are stored at record level and not at form level. Of course you can attach documents at form level also for that while defining your Block you should not give your context fields and primary key.

Press F11 and then CTL+F11



Now click on attachments ICON 



Enter Category as Miscellaneous and Data Type as Short Text. You can choose the data type as you need and finally enter some text in the yellow area.

Save and Close the Attachments Form.

Now Query the same record in Banks Screen

You should see that paper clip icon changes to 

Click on it to see your attached Text.



Note: The attachments you saved for this bank cannot be accessed when you query another bank which means all your attachments are saved at record level. You can restrict this level to form, function or record level.