How to enable attachments in flexfield valueset value form?

1. Get the form function for flexfield value set value form:
N--> Application Developer--> Application--> Function
FND_FNDFFMSV is the function name for Flexfield valueset value form.

2. Create a Document Entity:
N--> Application Developer--> Attachments--> Document Entities
Table: - FND_FLEX_VALUES
Entity ID: - FND_FLEX_VALUES
Entity Name: - "Any Name"
Prompt: - "Any Prompt"
Application: - Application Object Library

3. Create Attachment Function:
N--> Application Developer--> Attachments--> Attachment Functions
Type: - Function
Name: - FND_FNDFFMSV
User Name: - Flexfield Values
Enabled: - Yes

Remember FND_FNDFFMSV is the form function name which we queried from Step1

After entering above details click on "Blocks" button. This will take you to block declaration screen. Give the block name, for which the attachments needs to be enabled.

Block Name: - VALUE
Method: - Allow Method

VALUE is the name of block in flex value form

Click on "Entities" button after entering above details. This will navigate to the Entity Declaration screen, here give the entity name created on step 2
Entity: - Name given on Step2
Display Method: - Main Entity
Include in Indicator: - Yes

After defining those, navigate to Primary Key Fields and define keys for capturing in PK1_value and PK2_value of fnd_attached_documents table.
we can give flex_value_set_id and flex_value_id for these 2 columns.
Key1: - VSET.flex_value_set_id
Key2: - VALUE.flex_value_id


Now, you can navigate to Application Developer--> Application--> Validattion--> Values to see the attachment feature enabled for all the flex values.

This is the method, you have to use for enabling attachments on any form.

How to make a concurrent program to run for a single operating unit in R12?

N--> System Administration --> Concurrent --> Program
a) Enter Program Name/Program Short Name and click on "Go" button
b) Click on Update Pencilbar
c) Go to Request Tab
d) Select the Operating Unit Mode "Single" from List
e) Click on "Apply" button

By doing this you will be asked to enter the Operating unit, while submitting the program. Whatever operating unit you select here will be set as global organization and would be accessible through routine "FND_GLOBAL.Org_ID" If you have any value sets based on Table, which need to access only global org specific value, you need to give "Org_ID = FND_GLOBAL.Org_ID" condition in SQL used for value sets. Also, when you are submitting the request from back end, you need to set the org for this request by calling the routing "FND_REQUEST.SET_ORG_ID('')"