Attachment Functionality

Attachment Functionality

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 when ever 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. ofcourse 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 can not 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.